public Int32 Insert(BOL.ticketstatus obj) { if (obj != null) { try { conn = new MySqlConnection(ConnectionString); conn.Open(); trans = conn.BeginTransaction(); bll_ticketstatus.Insert(obj, conn, trans); Int32 ticketstatus = bll_utility.GetMaxId("ticketstatus", "Ticketstatusid", conn, trans); trans.Commit(); conn.Close(); return(ticketstatus); } catch { trans.Rollback(); conn.Close(); } } return(0); }
//Manager.roles manager_roles; //List<BOL.roles> bol_roles; #endregion #region methods and functions public void Initialize() { manager_ticketstatus = new Manager.ticketstatus(); utility = new Utility(); bol_ticketstatus = new BOL.ticketstatus(); //manager_roles = new Manager.roles(); //bol_roles = new List<BOL.roles>(); }
public void LoadTicketStatuses() { manager_ticketstatus = new Manager.ticketstatus(); bol_ticketstatus = new BOL.ticketstatus(); List <BOL.ticketstatus> _ticketStatuses = manager_ticketstatus.SelectAll(bol_ticketstatus); ddlTicketStatus.DataValueField = "Ticketstatusid"; ddlTicketStatus.DataTextField = "Ticketstatusname"; ddlTicketStatus.DataSource = _ticketStatuses; ddlTicketStatus.DataBind(); }
public DataSet SelectAll(BOL.ticketstatus obj, MySqlConnection conn, MySqlTransaction trans) { if (obj != null) { StringBuilder qry = new System.Text.StringBuilder(); qry.Append(@"SELECT `ticketstatusid`, `ticketstatusname`, `description`, `isdeleted`, `createdby`, `createdon`, `modifiedby`, `modifiedon` FROM `ticketstatus`"); return(dbconnect.GetDataset(conn, trans, qry.ToString())); } return(null); }
//public void LoadRoles() //{ // bol_roles = manager_roles.Select(new BOL.roles(), SearchCriterias.all); // if (bol_roles != null && bol_roles.Count > 0) // { // ddlRoles.DataSource = bol_roles; // ddlRoles.DataTextField = "Rolename"; // ddlRoles.DataValueField = "roleid"; // ddlRoles.DataBind(); // ddlRoles.Items.Insert(0, new ListItem("--Select--", "-1")); // } //} public Int32 Save() { bol_ticketstatus = new BOL.ticketstatus(); manager_ticketstatus = new Manager.ticketstatus(); bol_ticketstatus.Ticketstatusname = txtStatusName.Text; bol_ticketstatus.Description = txtStatusDiscription.Text; bol_ticketstatus.Isdeleted = "F"; bol_ticketstatus.Createdby = Convert.ToInt32(Session["userid"]); bol_ticketstatus.Createdon = DateTime.Parse(System.DateTime.Now.ToString("dd/MMM/yyyy")); bol_ticketstatus.Ticketstatusid = manager_ticketstatus.Insert(bol_ticketstatus); return(bol_ticketstatus.Ticketstatusid); }
public Int32 Delete(BOL.ticketstatus obj, MySqlConnection conn, MySqlTransaction trans) { if (obj != null) { try { string qry = @"DELETE FROM `ticketstatus` WHERE `ticketstatusid`= " + obj.Ticketstatusid; dbconnect.ExecuteNonQuery(conn, trans, qry, null); return(1); } catch { } } return(0); }
public Int32 Update(BOL.ticketstatus obj, MySqlConnection conn, MySqlTransaction trans) { if (obj != null) { try { string qry = @"UPDATE `ticketstatus` SET `ticketstatusname` = '" + obj.Ticketstatusname + "',`description`=" + obj.Description + "',`isdeleted`='" + obj.Isdeleted + "',`createdby`=" + obj.Createdby + ",`createdon`=" + obj.Createdon + ",`modifiedby`=" + obj.Modifiedby + ",`modifiedon` = " + obj.Modifiedon + " WHERE `ticketstatusid`=" + obj.Ticketstatusid; dbconnect.GetScalar(conn, trans, qry, null); return(1); } catch { } } return(0); }
public Int32 Insert(BOL.ticketstatus obj, MySqlConnection conn, MySqlTransaction trans) { if (obj != null) { try { string qry = @"INSERT INTO `ticketstatus`(`ticketstatusname`, `description`, `isdeleted`, `createdby`, `createdon`, `modifiedby`, `modifiedon`) VALUES ('" + obj.Ticketstatusname + "','" + obj.Description + "','F'," + obj.Createdby + ",STR_TO_DATE('" + obj.Createdon + "', '%c/%e/%Y %r')" + ",'','')"; dbconnect.GetScalar(conn, trans, qry, null); return(1); } catch { } } return(0); }
public DataSet Select(BOL.ticketstatus obj, MySqlConnection conn, MySqlTransaction trans) { if (obj != null) { StringBuilder qry = new System.Text.StringBuilder(); qry.Append(@"SELECT `ticketstatusid`, `ticketstatusname`, `description`, `isdeleted`, `createdby`, `createdon`, `modifiedby`, `modifiedon` FROM `ticketstatus` WHERE "); if (obj.Ticketstatusid > 0) { qry.Append("`ticketstatusid` = " + obj.Ticketstatusid + " AND"); } if (!string.IsNullOrEmpty(obj.Ticketstatusname)) { qry.Append("`ticketstatusname` = '" + obj.Ticketstatusname + "' AND"); } if (!string.IsNullOrEmpty(obj.Description)) { qry.Append("`description` = '" + obj.Description + "' AND"); } qry = qry.Remove(qry.Length - 3, qry.Length); return(dbconnect.GetDataset(conn, trans, qry.ToString())); } return(null); }
public Int32 Delete(BOL.ticketstatus obj) { if (obj != null) { try { conn = new MySqlConnection(ConnectionString); conn.Open(); trans = conn.BeginTransaction(); bll_ticketstatus.Delete(obj, conn, trans); trans.Commit(); conn.Close(); return(obj.Ticketstatusid); } catch { trans.Rollback(); conn.Close(); } } return(0); }
public List <BOL.ticketstatus> SelectAll(BOL.ticketstatus obj) { if (obj != null) { conn = new MySqlConnection(ConnectionString); conn.Open(); trans = conn.BeginTransaction(); DataSet ds = bll_ticketstatus.SelectAll(obj, conn, trans); trans.Commit(); conn.Close(); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { List <BOL.ticketstatus> ticketstatuses = new List <BOL.ticketstatus>(); foreach (DataRow dr in ds.Tables[0].Rows) { BOL.ticketstatus c = new BOL.ticketstatus(); if (dr["Ticketstatusid"] != null && Convert.ToInt32(dr["Ticketstatusid"]) > 0) { c.Ticketstatusid = Convert.ToInt32(Convert.ToString(dr["Ticketstatusid"])); } if (dr["Description"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Description"]))) { c.Description = Convert.ToString(dr["Description"]); } if (dr["Ticketstatusname"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Ticketstatusname"]))) { c.Ticketstatusname = Convert.ToString(dr["Ticketstatusname"]); } if (dr["Createdby"] != null && Convert.ToInt32(dr["Createdby"]) > 0) { c.Createdby = Convert.ToInt32(Convert.ToString(dr["Createdby"])); } if (dr["Createdon"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Createdon"]))) { c.Createdon = Convert.ToDateTime(Convert.ToString(dr["Createdon"])); } if (dr["Isdeleted"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Isdeleted"]))) { c.Isdeleted = Convert.ToString(dr["Isdeleted"]); } if (dr["Modifiedby"] != null && Convert.ToInt32(dr["Modifiedby"]) > 0) { c.Modifiedby = Convert.ToInt32(Convert.ToString(dr["Modifiedby"])); } if (dr["Modifiedon"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Modifiedon"]))) { c.Modifiedon = Convert.ToDateTime(Convert.ToString(dr["Modifiedon"])); } ticketstatuses.Add(c); } return(ticketstatuses); } return(null); } return(null); }
public void Initialize() { manager_ticketstatus = new Manager.ticketstatus(); utility = new Utility(); bol_ticketstatus = new BOL.ticketstatus(); }