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