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