public Int32 Insert(BOL.tickets obj) { if (obj != null) { try { conn = new MySqlConnection(ConnectionString); conn.Open(); trans = conn.BeginTransaction(); bll_tickets.Insert(obj, conn, trans); Int32 tickets = bll_utility.GetMaxId("tickets", "Ticketid", conn, trans); trans.Commit(); conn.Close(); return(tickets); } catch { trans.Rollback(); conn.Close(); } } return(0); }
public Int32 Update() { if (Session["bol.ticket"] != null) { BOL.tickets _ticket = (BOL.tickets)Session["bol.ticket"]; bol_ticketfeedback = new BOL.ticketfeedback(); manager_tickets = new Manager.tickets(); manager_ticketfeedback = new Manager.ticketfeedback(); if (_ticket != null) { _ticket.Title = txtTickettitle.Text; _ticket.Description = txtTicketDescription.Text; _ticket.Modifiedby = Convert.ToInt32(Session["userid"]); _ticket.Modifiedon = DateTime.Now; _ticket.Ticketstatusid = Convert.ToInt32(ddlTicketStatus.SelectedValue); manager_tickets.Update(_ticket); bol_ticketfeedback.Ticketid = _ticket.Ticketid; bol_ticketfeedback.Feedback = txtfeedback.Text; bol_ticketfeedback.Isdeleted = "F"; bol_ticketfeedback.Userid = _ticket.Modifiedby; manager_ticketfeedback.Insert(bol_ticketfeedback); } } return(0); }
public void FetchLatestUploadData() { Initialize(); // Create a new XmlDocument XmlDocument doc = new XmlDocument(); System.Text.StringBuilder sb = new System.Text.StringBuilder(); // Load data doc.Load("http://techupgraded.info/andriod/xmltest.php"); // Set up namespace manager for XPath XmlNamespaceManager ns = new XmlNamespaceManager(doc.NameTable); ns.AddNamespace("tickets", "http://techupgraded.info/andriod/xmltest.php"); // Get forecast with XPath XmlNodeList nodes = doc.SelectNodes("data/Ticket", ns); // You can also get elements based on their tag name and namespace, // though this isn't recommended //XmlNodeList nodes = doc.GetElementsByTagName("forecast", // "http://xml.weather.yahoo.com/ns/rss/1.0"); foreach (XmlNode node in nodes) { //Response.Write(node.ChildNodes.Count.ToString()); if (node != null && node.ChildNodes.Count > 0) { bol_customer = new BOL.customers(); bol_customer.Ticketses = new List <BOL.tickets>(); bol_ticket = new BOL.tickets(); bol_ticket.Ticketattachments = new List <BOL.ticketattachment>(); foreach (XmlNode inner in node.ChildNodes) { if (inner.Name == "mobile") { sb.Append("mobile: " + inner.InnerText + "<br/>"); bol_customer.Mobile = inner.InnerText; } if (inner.Name == "link") { sb.Append("link: " + inner.InnerText + "<br/>"); bol_ticketattach = new BOL.ticketattachment(); bol_ticketattach.Link = inner.InnerText; bol_ticket.Ticketattachments.Add(bol_ticketattach); } } bol_customer.Ticketses.Add(bol_ticket); bol_customerses.Add(bol_customer); sb.Append("<br/>"); } } divMain.InnerHtml = sb.ToString(); Session["bol.customerslist"] = bol_customerses; }
public void Initialize() { bol_ticket = new BOL.tickets(); bol_customer = new BOL.customers(); bol_ticketattach = new BOL.ticketattachment(); bol_ticketses = new List <BOL.tickets>(); bol_customerses = new List <BOL.customers>(); }
public void LoadUserAnonymousTickets() { manager_dashboard = new Manager.dashboard(); bol_ticket = new BOL.tickets(); bol_ticket.Ticketstatusid = Manager.TicketStatusEnum.Anonymous.GetHashCode(); bol_ticket.Userid = Convert.ToInt32(Session["userid"]); bol_ticketses = manager_dashboard.TicketsbyUserid(bol_ticket); if (bol_ticketses != null && bol_ticketses.Count > 0) { grdAnonymousTickets.DataSource = bol_ticketses; grdAnonymousTickets.DataBind(); } }
public List <BOL.tickets> TicketsbyUserid(BOL.tickets _ticket) { manager_tickets = new Manager.tickets(); if (manager_tickets != null && _ticket != null && _ticket.Userid > 0) { List <BOL.tickets> _ticketses = manager_tickets.Select(_ticket); if (_ticketses != null && _ticketses.Count > 0) { return(_ticketses); } } return(new List <BOL.tickets>()); }
public void Initialize() { //manager_customer = new customer(); //manager_customer_address = new Manager.customer_address(); //manager_tickets = new Manager.tickets(); //manager_tattach = new Manager.ticketattachment(); //_enums = new Manager.Enums(); //utility = new Utility(); bol_ticket = new BOL.tickets(); bol_customer = new BOL.customers(); bol_ticketattach = new BOL.ticketattachment(); bol_ticketses = new List <BOL.tickets>(); bol_customerses = new List <BOL.customers>(); }
public Int32 Delete(BOL.tickets obj, MySqlConnection conn, MySqlTransaction trans) { if (obj != null) { try { string qry = @"DELETE FROM `tickets` WHERE `ticketid`= " + obj.Ticketid; dbconnect.ExecuteNonQuery(conn, trans, qry, null); return(1); } catch { } } return(0); }
public Int32 VerifyOpenAnonymousTicketbyCustomerid(BOL.tickets _ticket) { if (manager_tickets != null && _ticket != null && _ticket.Customerid > 0) { List <BOL.tickets> _ticketses = manager_tickets.GetTicketsByStatus(TicketStatusEnum.Open.GetHashCode().ToString() + "," + TicketStatusEnum.Anonymous.GetHashCode().ToString(), _ticket); if (_ticketses != null && _ticketses.Count > 0 && _ticketses[0] != null && _ticketses[0].Ticketid > 0) { _ticket.Customerid = _ticketses[0].Customerid; _ticket.Ticketid = _ticketses[0].Ticketid; return(_ticket.Ticketid); } } return(0); }
public void LoadTicket() { if (Request.QueryString["id"] != null && Convert.ToInt32(Convert.ToString(Request.QueryString["id"])) > 0) { manager_tickets = new Manager.tickets(); manager_ticketfeedback = new Manager.ticketfeedback(); manager_ticketattachment = new Manager.ticketattachment(); bol_tickets = new BOL.tickets(); bol_ticketfeedback = new BOL.ticketfeedback(); bol_ticketattachment = new BOL.ticketattachment(); bol_tickets.Ticketid = Convert.ToInt32(Convert.ToString(Request.QueryString["id"])); List <BOL.tickets> _ticketses = manager_tickets.Select(bol_tickets); if (_ticketses != null && _ticketses.Count > 0 && _ticketses[0].Ticketid > 0) { txtTickettitle.Text = _ticketses[0].Title; txtTicketDescription.Text = _ticketses[0].Description; ddlTicketStatus.SelectedValue = _ticketses[0].Ticketstatusid.ToString(); bol_ticketfeedback.Ticketid = _ticketses[0].Ticketid; bol_ticketattachment.Ticketid = _ticketses[0].Ticketid; _ticketses[0].Ticketfeedbacks = manager_ticketfeedback.GetAllFeedbacksByTicket(bol_ticketfeedback); _ticketses[0].Ticketattachments = manager_ticketattachment.Select(bol_ticketattachment); if (_ticketses[0].Ticketfeedbacks != null && _ticketses[0].Ticketfeedbacks.Count > 0) { _ticketses[0].Ticketfeedbacks.OrderByDescending(t => t.Ticketfeedbackid); txtfeedback.Text = _ticketses[0].Ticketfeedbacks[0].Feedback; repFeedbackHistory.DataSource = _ticketses[0].Ticketfeedbacks.OrderByDescending(t => t.Ticketfeedbackid); repFeedbackHistory.DataBind(); } repAttachment.DataSource = _ticketses[0].Ticketattachments.OrderByDescending(t => t.Ticketattachmentid); repAttachment.DataBind(); Session["bol.ticket"] = _ticketses[0]; } } }
public Int32 Insert(BOL.tickets obj, MySqlConnection conn, MySqlTransaction trans) { if (obj != null) { try { string qry = @"INSERT INTO `tickets`(`title`, `description`, `ticketstatusid`, `userid`, `customerid`, `isdeleted` , `createdby`, `createdon`, `modifiedby`, `modifiedon`) VALUES ('" + obj.Title + "','" + obj.Description + "'," + obj.Ticketstatusid + "," + obj.Userid + "," + obj.Customerid + ",'F'," + obj.Createdby + ",STR_TO_DATE('" + obj.Createdon + "', '%c/%e/%Y %r')," + obj.Modifiedby + ",STR_TO_DATE('" + obj.Modifiedon + "', '%c/%e/%Y %r'))"; dbconnect.GetScalar(conn, trans, qry, null); return(1); } catch { } } return(0); }
public Int32 Update(BOL.tickets obj, MySqlConnection conn, MySqlTransaction trans) { if (obj != null) { try { string qry = @"UPDATE `tickets` SET `title` = '" + obj.Title + "',`description`='" + obj.Description + "',`ticketstatusid`=" + obj.Ticketstatusid + ",`userid`=" + obj.Userid + ",`customerid`=" + obj.Customerid + ",`isdeleted`='" + obj.Isdeleted + "',`createdby`=" + obj.Createdby + ",`createdon`=STR_TO_DATE('" + obj.Createdon + "', '%c/%e/%Y %r'),`modifiedby`=" + obj.Modifiedby + ",`modifiedon` = STR_TO_DATE('" + obj.Modifiedon + "', '%c/%e/%Y %r') WHERE `ticketid`=" + obj.Ticketid; dbconnect.GetScalar(conn, trans, qry, null); return(1); } catch { } } return(0); }
public DataSet Select(BOL.tickets obj, MySqlConnection conn, MySqlTransaction trans) { if (obj != null) { StringBuilder qry = new System.Text.StringBuilder(); qry.Append(@"SELECT `ticketid`, `title`, `description`, `ticketstatusid`, `userid`, `customerid`, `isdeleted`, `createdby`, `createdon`, `modifiedby`, `modifiedon` FROM `tickets` WHERE "); if (obj.Ticketid > 0) { qry.Append("`ticketid` = " + obj.Ticketid + " AND"); } if (!string.IsNullOrEmpty(obj.Title)) { qry.Append("`title` = '" + obj.Title + "' AND"); } if (!string.IsNullOrEmpty(obj.Description)) { qry.Append("`description` = '" + obj.Description + "' AND"); } if (obj.Ticketstatusid > 0) { qry.Append("`ticketstatusid` = " + obj.Ticketstatusid + " AND"); } if (obj.Userid > 0) { qry.Append("`userid` = " + obj.Userid + " AND"); } if (obj.Customerid > 0) { qry.Append("`customerid` = " + obj.Customerid + " AND"); } else { qry.Append(" 1 AND"); } qry = qry.Remove(qry.Length - 3, 3); return(dbconnect.GetDataset(conn, trans, qry.ToString())); } return(null); }
public void Initialize() { manager_customer = new customer(); manager_customer_address = new Manager.customer_address(); manager_tickets = new Manager.tickets(); manager_tattach = new Manager.ticketattachment(); _enums = new Manager.Enums(); //utility = new Utility(); bol_ticket = new BOL.tickets(); bol_customer = new BOL.customers(); bol_ticketattach = new BOL.ticketattachment(); bol_ticketses = new List <BOL.tickets>(); bol_customerses = new List <BOL.customers>(); bll_customer = new BLL.hunaidBLL(); bll_tickets = new BLL.tickets(); bll_ticketattach = new BLL.ticketattachment(); bll_utility = new BLL.Utility(); ConnectionString = Utility.GetConnectionString(); }
public Int32 Delete(BOL.tickets obj) { if (obj != null) { try { conn = new MySqlConnection(ConnectionString); conn.Open(); trans = conn.BeginTransaction(); bll_tickets.Delete(obj, conn, trans); trans.Commit(); conn.Close(); return(obj.Ticketid); } catch { trans.Rollback(); conn.Close(); } } return(0); }
public List <BOL.tickets> GetTicketsByStatus(string ticketStatuses, BOL.tickets obj) { if (!string.IsNullOrEmpty(ticketStatuses)) { conn = new MySqlConnection(ConnectionString); conn.Open(); trans = conn.BeginTransaction(); DataSet ds = bll_tickets.GetTicketsByStatus(ticketStatuses, 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.tickets> ticketses = new List <BOL.tickets>(); foreach (DataRow dr in ds.Tables[0].Rows) { BOL.tickets c = new BOL.tickets(); if (dr["Ticketid"] != null && Convert.ToInt32(dr["Ticketid"]) > 0) { c.Ticketid = Convert.ToInt32(Convert.ToString(dr["Ticketid"])); } if (dr["Customerid"] != null && Convert.ToInt32(dr["Customerid"]) > 0) { c.Customerid = Convert.ToInt32(Convert.ToString(dr["Customerid"])); } if (dr["Description"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Description"]))) { c.Description = Convert.ToString(dr["Description"]); } if (dr["Title"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Title"]))) { c.Title = Convert.ToString(dr["Title"]); } if (dr["Ticketstatusid"] != null && Convert.ToInt32(dr["Ticketstatusid"]) > 0) { c.Ticketstatusid = Convert.ToInt32(Convert.ToString(dr["Ticketstatusid"])); } if (dr["Userid"] != null && Convert.ToInt32(dr["Userid"]) > 0) { c.Userid = Convert.ToInt32(Convert.ToString(dr["Userid"])); } 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"])); } ticketses.Add(c); } return(ticketses); } return(null); } return(null); }