<%@ WebHandler Language="C#" Class="program_vote_Handler" %>

using System;
using System.Web;
using System.Data;
using eMIS.Data;


public class program_vote_Handler : IHttpHandler {

	public void ProcessRequest (HttpContext context)
	{
		string userId = context.Request["u"];
		string jmid = context.Request["n"];
		string qid= "903752764";

		const int maxNum = 500;

		if (string.IsNullOrEmpty(userId) || string.IsNullOrEmpty(jmid))
		{
			return;
		}

		eDbManager manager = new eDbManager(WebConfigManager.DefaultDb);
		eDbOperator dbo = manager.CreateDbOperator();

		string sql = "select count(*) from wj_ques_users_items where userid=? and quesid=?";
		object obj = dbo.ExecuteScalar(sql, userId, qid);

		if (Convert.ToInt16(obj) >= maxNum)
		{
			context.Response.ContentType = "text/plain";
			context.Response.Write("over");
		}
		else
		{
			sql = "if exists(select * from wj_ques_users_items where userid={0} and quesid={1} and itemid={2}) " +
					"delete from wj_ques_users_items where userid={0} and quesid={1} and itemid={2};" +
					" else " +
					" insert into wj_ques_users_items(id,pid,userid,quesid,itemid,itemidx) " +
					" values(next value for seq2,0,{0},{1},{2},0)";
			dbo.ExecuteNonQuery(string.Format(sql, userId, qid, jmid));

			context.Response.ContentType = "text/plain";
			context.Response.Write("ok");
		}
	}

	public bool IsReusable {
		get {
			return false;
		}
	}

}