<%@ WebHandler Language="C#" Class="CustomMenuSave"    %>

using System;
using System.Collections.Generic;
using System.Web;
using System.Data;
using System.IO;
using eMIS.Data;
using System.Data.Common;
using System.Web.SessionState;
using eMIS;
using System.Text;


public class CustomMenuSave : IHttpHandler, IRequiresSessionState
{
    public void ProcessRequest(HttpContext context)
    {
        DataManager dm = new DataManager();

        string menuid = context.Request.QueryString["id"].ToString();
        string userid = context.Session["userid"].ToString();

        dm.ExecuteNonQuery("delete XT_KJCD where menuid=? and userid=?",menuid,userid);
        //dm.ExecuteNonQuery("insert into XT_KJCD (menuid,userid,menudesc,mark,newwin,ord,winsize) values (" + menuid + "," + userid + ",'" + context.Request["desc"] + "','" + context.Request["mark"] + "'," + context.Request["newwin"] + "," + context.Request["ord"] + ",'" + context.Request["size"] + "')");
        string sql = "insert into XT_Favorite (id,pid,menu_id,user_id,ITEM_DESC,menu_desc,ITEM_ORDER) values ";
        sql += "(next value for seq_id,?,?,?,?,?,?)";

        string ord = context.Request["ord"].ToString();
        if (ord == "") ord = "100";

        dm.ExecuteNonQuery(sql,context.Request["pid"].ToString(),menuid,userid,context.Request["desc"].ToString(),context.Request["mark"].ToString(),ord);

        context.Response.Write("ok");
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}