public DataSet Select(BOL.ticketattachment obj, MySqlConnection conn, MySqlTransaction trans) { if (obj != null) { StringBuilder qry = new System.Text.StringBuilder(); qry.Append(@"SELECT tatt.ticketattachmentid, tatt.ticketid, tatt.link, tatt.isdeleted, c.mobile AS customermobile FROM ticketattachment tatt INNER JOIN tickets t ON t.ticketid = tatt.ticketid INNER JOIN customers c ON c.customerid = t.customerid WHERE "); if (obj.Ticketattachmentid > 0) { qry.Append("tatt.ticketattachmentid = " + obj.Ticketattachmentid + " AND"); } if (obj.Ticketid > 0) { qry.Append("tatt.ticketid = " + obj.Ticketid + " AND"); } if (!string.IsNullOrEmpty(obj.Link)) { qry.Append("tatt.link = '" + obj.Link + "' AND"); } qry = qry.Remove(qry.Length - 3, 3); return(dbconnect.GetDataset(conn, trans, qry.ToString())); } return(null); }
public Int32 Insert(BOL.ticketattachment obj) { if (obj != null) { try { conn = new MySqlConnection(ConnectionString); conn.Open(); trans = conn.BeginTransaction(); bll_ticketattachment.Insert(obj, conn, trans); Int32 ticketattachment = bll_utility.GetMaxId("ticketattachment", "Ticketattachmentid", conn, trans); trans.Commit(); conn.Close(); return(ticketattachment); } catch { trans.Rollback(); conn.Close(); } } 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 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.ticketattachment obj, MySqlConnection conn, MySqlTransaction trans) { if (obj != null) { try { string qry = @"DELETE FROM `ticketattachment` WHERE `ticketattachmentid`= " + obj.Ticketattachmentid; dbconnect.ExecuteNonQuery(conn, trans, qry, null); return(1); } catch { } } return(0); }
public Int32 Update(BOL.ticketattachment obj, MySqlConnection conn, MySqlTransaction trans) { if (obj != null) { try { string qry = @"UPDATE `ticketattachment` SET `ticketid` = " + obj.Ticketid + ",`link`='" + obj.Link + "',isdeleted`='" + obj.Isdeleted + "' WHERE `ticketattachmentid` = " + obj.Ticketattachmentid; dbconnect.GetScalar(conn, trans, qry, null); return(1); } catch { } } return(0); }
public Int32 Insert(BOL.ticketattachment obj, MySqlConnection conn, MySqlTransaction trans) { if (obj != null) { try { string qry = @"INSERT INTO `ticketattachment`(`ticketid`, `link`, `isdeleted`) VALUES (" + obj.Ticketid + ",'" + obj.Link + "','F')"; dbconnect.GetScalar(conn, trans, qry, null); return(1); } catch { } } 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 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.ticketattachment obj) { if (obj != null) { try { conn = new MySqlConnection(ConnectionString); conn.Open(); trans = conn.BeginTransaction(); bll_ticketattachment.Delete(obj, conn, trans); trans.Commit(); conn.Close(); return(obj.Ticketattachmentid); } catch { trans.Rollback(); conn.Close(); } } return(0); }
public List <BOL.ticketattachment> Select(BOL.ticketattachment obj) { if (obj != null) { conn = new MySqlConnection(ConnectionString); conn.Open(); trans = conn.BeginTransaction(); DataSet ds = bll_ticketattachment.Select(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.ticketattachment> ticketattachmentes = new List <BOL.ticketattachment>(); foreach (DataRow dr in ds.Tables[0].Rows) { BOL.ticketattachment c = new BOL.ticketattachment(); if (dr["Ticketattachmentid"] != null && Convert.ToInt32(dr["Ticketattachmentid"]) > 0) { c.Ticketattachmentid = Convert.ToInt32(Convert.ToString(dr["Ticketattachmentid"])); } if (dr["Link"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Link"]))) { c.Link = Convert.ToString(dr["Link"]); } if (dr["Ticketid"] != null && Convert.ToInt32(dr["Ticketid"]) > 0) { c.Ticketid = Convert.ToInt32(Convert.ToString(dr["Ticketid"])); } if (ds.Tables[0].Columns.Contains("customermobile") && dr["customermobile"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["customermobile"]))) { c.Customers = new BOL.customers(); c.Customers.Mobile = Convert.ToString(dr["customermobile"]) + "/"; } //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["Modifyby"] != null && Convert.ToInt32(dr["Modifyby"]) > 0) //{ // c.Modifiedby = Convert.ToInt32(Convert.ToString(dr["Modifyby"])); //} //if (dr["Modifyon"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Modifyon"]))) //{ // c.Modifiedon = Convert.ToDateTime(Convert.ToString(dr["Modifyon"])); //} ticketattachmentes.Add(c); } return(ticketattachmentes); } return(null); } return(null); }