<%@ WebHandler Language="C#" Class="exesql" debug="true" %>

using System;
using System.Web;
using eMIS;
using System.Data;

public class exesql : IHttpHandler, System.Web.SessionState.IRequiresSessionState
{
    public void ProcessRequest (HttpContext context)
    {



        DataManager dm = new DataManager();
        dm.OpenConnection();

        string id = context.Request.QueryString["id"].ToString();
        string cat = context.Request.QueryString["c"].ToString();


        DateTime n = DateTime.Now;

        string MENU_ID, USER_ID,s,TASK_ID;

        DataTable dt = dm.ExecuteTable("select * from XT_ERR_REPORT where id=?",id);
        dm.CloseConnection();

        MENU_ID = dt.Rows[0]["MENU_ID"].ToString();
        USER_ID = dt.Rows[0]["USER_ID"].ToString();
        TASK_ID = dt.Rows[0]["TASK_ID"].ToString();

        string url="";
        if (cat == "flow")
        {
            url = "/Common6/debug/flow2.aspx?fid=" + dt.Rows[0]["FLOW_ID"].ToString() + "&rid=" + dt.Rows[0]["RECORD_ID"].ToString();
        }
        else if (cat == "menu")
        {


            url = "http://172.28.3.11/if/in_mid_debug.ashx?mid=" + MENU_ID + "&uid=" + USER_ID + "&time=" + n.ToString("yyyy-MM-dd HH:mm:ss").Replace(" ", "%20");
            s = MENU_ID + USER_ID + n.ToString("yyyyMMddHHmmss") + "here.in";

            s = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(s, "MD5");

            url += "&token=" + s;
        }
        else if (cat == "task")
        {

            url = "http://172.28.3.11/if/in_debug.ashx?task=" + TASK_ID + "&time=" + n.ToString("yyyy-MM-dd HH:mm:ss").Replace(" ", "%20");
            s = TASK_ID + n.ToString("yyyyMMddHHmmss") + "here.in";

            s = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(s, "MD5");

            url += "&token=" + s;
        }
        else if (cat == "cond")
        {
            string tourl = DataManager.Encrypt("/common6/debug/menu_cond.aspx?mid=" + MENU_ID + "&uid=" + USER_ID + "&rid="+n.ToString("yyyyMMddHHmmss"));

            url = "http://172.28.3.11/if/in_debug_url.ashx?uid=" + USER_ID + "&url="+tourl+"&time=" + n.ToString("yyyy-MM-dd HH:mm:ss").Replace(" ", "%20");
            s = USER_ID +tourl+ n.ToString("yyyyMMddHHmmss") + "here.in";

            s = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(s, "MD5");

            url += "&token=" + s;
        }



        context.Response.Redirect(url);

    }

    public bool IsReusable {
        get {
            return false;
        }
    }

}