public void ProcessRequest(HttpContext context)
{
HttpRequest Request = context.Request;
context.Response.ContentType = "application/json";
string action = context.Request.Params["action"].ToLower();
int ticketid = 0;
int category = 0;
switch (action)
{
case "removefromcategory":
int.TryParse(Request.Params["ticketid"], out ticketid);
int.TryParse(Request.Params["cagetory"], out category);
bool result = ccApp.RemoveTicketFromCateGory(ticketid, category);
context.Response.Write(result.ToString().ToLower());
break;
case "addtocategory":
int.TryParse(Request.Params["ticketid"], out ticketid);
int.TryParse(Request.Params["cagetory"], out category);
CateGoryTicketEntity model = CateGoryFactory.CreateCateGoryTicketEntity(UserID, ObjectFactory.GetInstance <ISystemDateTime>());
model.TicketID = ticketid;
model.CategoryID = category;
int id = ccApp.AssignTicketToCateGory(model);
context.Response.Write(id > 0 ? "true" : "false");
break;
default:
context.Response.Write("[]");
break;
}
}
/// <summary>
/// Get an object entity
/// </summary>
public CateGoryTicketEntity Get(int CGTID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from CateGoryTicket ");
strSql.Append(" where CGTID=@CGTID ");
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()))
{
db.AddInParameter(dbCommand, "CGTID", DbType.Int32, CGTID);
CateGoryTicketEntity model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
try
{
if (dataReader.Read())
{
model = CateGoryTicketEntity.ReaderBind(dataReader);
}
return(model);
}
catch (Exception ex)
{
WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]",
strSql.ToString(), base.FormatParameters(dbCommand.Parameters), ex.Message));
return(null);
}
}
}
}
public int AssignTicketToCateGory(CateGoryTicketEntity model)
{
this.ClearBrokenRuleMessages();
int id = mgr.AssignTicketToCateGory(model);
this.AddBrokenRuleMessages(mgr.BrokenRuleMessages);
return(id);
}
/// <summary>
/// Update a record
/// </summary>
public bool Update(CateGoryTicketEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CateGoryTicket set ");
strSql.Append("CategoryID=@CategoryID,");
strSql.Append("TicketID=@TicketID,");
strSql.Append("CreatedOn=@CreatedOn");
strSql.Append(" where CGTID=@CGTID ");
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()))
{
try
{
db.AddInParameter(dbCommand, "CGTID", DbType.Int32, model.CGTID);
db.AddInParameter(dbCommand, "CategoryID", DbType.Int32, model.CategoryID);
db.AddInParameter(dbCommand, "TicketID", DbType.Int32, model.TicketID);
db.AddInParameter(dbCommand, "CreatedOn", DbType.DateTime, model.CreatedOn);
int rows = db.ExecuteNonQuery(dbCommand);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]",
strSql.ToString(), base.FormatParameters(dbCommand.Parameters), ex.Message));
return(false);
}
}
}
/// <summary>
/// Add a record
/// </summary>
public int Insert(CateGoryTicketEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("IF not exists (SELECT 1 FROM dbo.CateGoryTicket WHERE CategoryID=@CategoryID AND TicketID=@TicketID) BEGIN ");
strSql.Append("insert into CateGoryTicket(");
strSql.Append("CategoryID,TicketID,CreatedOn)");
strSql.Append(" values (");
strSql.Append("@CategoryID,@TicketID,@CreatedOn)");
strSql.Append(";select ISNULL( SCOPE_IDENTITY(),0);END");
strSql.Append(" else begin select 0 end;");
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()))
{
try
{
db.AddInParameter(dbCommand, "CategoryID", DbType.Int32, model.CategoryID);
db.AddInParameter(dbCommand, "TicketID", DbType.Int32, model.TicketID);
db.AddInParameter(dbCommand, "CreatedOn", DbType.DateTime, model.CreatedOn);
int result;
object obj = db.ExecuteScalar(dbCommand);
if (!int.TryParse(obj.ToString(), out result))
{
return(0);
}
return(result);
}
catch (Exception ex)
{
WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]",
strSql.ToString(), base.FormatParameters(dbCommand.Parameters), ex.Message));
return(0);
}
}
}
public void ProcessRequest(HttpContext context)
{
CateGoryApplication ccApp = new CateGoryApplication();
HttpRequest request = context.Request;
context.Response.ContentType = "text/plain";
if (IdentityContext.UserID <= 0)
{
context.Response.Write("[]");
return;
}
if (string.IsNullOrEmpty(request["type"]))
{
List <CateGoryEntity> listcategories = ccApp.GetCateGroyListByUserID(UserID);
if (listcategories == null || listcategories.Count == 0)
{
context.Response.Write("[]");
}
else
{
string jsonCategories = UtilFactory.Helpers.JSONHelper.GetJson <List <CateGoryEntity> >(listcategories);
context.Response.Write(jsonCategories);
}
}
else
{
int ticketid = 0;
int categoryid = 0;
bool checkinput = (
(!string.IsNullOrEmpty(request["ticketid"])) &&
(!string.IsNullOrEmpty(request["cagetoryid"])) &&
int.TryParse(request["ticketid"], out ticketid) &&
int.TryParse(request["cagetoryid"], out categoryid) &&
ticketid >= 0 &&
categoryid > 0);
if (checkinput)
{
CateGoryTicketEntity model = CateGoryFactory.CreateCateGoryTicketEntity(UserID, ObjectFactory.GetInstance <ISystemDateTime>());
model.TicketID = ticketid;
model.CategoryID = categoryid;
switch (request["type"])
{
case "addtocategory":
int id = ccApp.AssignTicketToCateGory(model);
if (id > 0)
{
context.Response.Write("true");
}
else
{
context.Response.Write("false");
}
break;
case "removefromcategory":
bool result = ccApp.RemoveTicketFromCateGory(ticketid, categoryid);
context.Response.Write(result.ToString().ToLower());
break;
case "deletecategory":
bool result2 = ccApp.DeleteCateGroy(categoryid);
context.Response.Write(result2.ToString().ToLower());
break;
default:
context.Response.Write("null");
break;
}
}
else
{
context.Response.Write("false");
}
}
}
