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"); } } }