public Int32 Insert(BOL.customers obj)
{
if (obj != null)
{
try
{
conn = new MySqlConnection(ConnectionString);
conn.Open();
trans = conn.BeginTransaction();
bll_objCustomer.Insert(obj, conn, trans);
Int32 customerid = bll_utility.GetMaxId("customers", "Customerid", conn, trans);
trans.Commit();
conn.Close();
return(customerid);
}
catch
{
trans.Rollback();
conn.Close();
}
}
return(0);
}
public DataSet Select(BOL.customers c, MySqlConnection conn, MySqlTransaction trans)
{
if (c != null)
{
StringBuilder qry = new System.Text.StringBuilder();
qry.Append(@"SELECT `customerid`, `firstname`, `lastname`, `status`, `email`,
`mobile`, `createdby`, `createdon`, `isdeleted`, `modifyby`, `modifyon` FROM `customers` WHERE ");
if (c.Customerid > 0)
{
qry.Append("`customerid` = " + c.Customerid + " AND");
}
if (!string.IsNullOrEmpty(c.Firstname))
{
qry.Append("`firstname` = '" + c.Firstname + "' AND");
}
if (!string.IsNullOrEmpty(c.Lastname))
{
qry.Append("`Lastname` = '" + c.Lastname + "' AND");
}
if (!string.IsNullOrEmpty(c.Mobile))
{
qry.Append("`Mobile` = '" + c.Mobile + "' AND");
}
else
{
qry.Append(" 1 AND");
}
qry = qry.Remove(qry.Length - 3, 3);
return(dbconnect.GetDataset(conn, trans, qry.ToString()));
}
return(null);
}
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_status = new Manager.status();
utility = new Utility();
bol_statuses = new List <BOL.status>();
bol_customer = new 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 void ClearForm(Control c)
//{
// utility.ClearForm(c);
//}
public BOL.customers VerifyCustomerbyMobile(BOL.customers _customer)
{
if (manager_customer != null && bol_customerses != null && _customer != null &&
!string.IsNullOrEmpty(_customer.Mobile))
{
List <BOL.customers> _customerses = manager_customer.Select(_customer);
if (_customerses != null && _customerses.Count > 0 &&
_customerses[0] != null && _customerses[0].Customerid > 0)
{
_customer.Customerid = _customerses[0].Customerid;
return(_customerses[0]);
}
}
return(new BOL.customers());
}
public Int32 Save()
{
bol_customer = new BOL.customers();
manager_customer = new Manager.customer();
bol_customer.Firstname = txtFirstName.Text;
bol_customer.Lastname = txtLastName.Text;
bol_customer.Email = txtEmail.Text;
bol_customer.Mobile = txtMobile.Text;
bol_customer.Isdeleted = "F";
bol_customer.Status = Convert.ToInt32(ddlStatus.SelectedValue);
bol_customer.Createdby = Convert.ToInt32(Session["userid"]);
bol_customer.Createdon = DateTime.Parse(System.DateTime.Now.ToString("dd/MMM/yyyy"));
bol_customer.Customerid = manager_customer.Insert(bol_customer);
return(bol_customer.Customerid);
}
public Int32 Delete(BOL.customers c, MySqlConnection conn, MySqlTransaction trans)
{
if (c != null)
{
try
{
string qry = @"DELETE FROM `customers` WHERE `customerid`= " + c.Customerid;
dbconnect.ExecuteNonQuery(conn, trans, qry, null);
return(1);
}
catch
{
}
}
return(0);
}
public Int32 Update(BOL.customers c, MySqlConnection conn, MySqlTransaction trans)
{
if (c != null)
{
try
{
string qry = @"UPDATE `customers` SET `firstname` ='" + c.Firstname + "',`lastname`='" + c.Lastname +
"',status`=" + c.Status + ",`email`='" + c.Email + "',`mobile`='" + c.Mobile + "',`createdby`=" + c.Createdby +
",`createdon`= STR_TO_DATE('" + c.Createdon + "', '%c/%e/%Y %r'),`isdeleted`='" + c.Isdeleted + "',`modifyby`=" + c.Modifyby +
",`modifyon`=STR_TO_DATE('" + c.Modifyon + "', '%c/%e/%Y %r') WHERE `customerid` =" + c.Customerid;
dbconnect.GetScalar(conn, trans, qry, null);
return(1);
}
catch
{
}
}
return(0);
}
public Int32 Insert(BOL.customers c, MySqlConnection conn, MySqlTransaction trans)
{
if (c != null)
{
try
{
string qry = @"INSERT INTO `customers`( `firstname`, `lastname`, `status`, `email`, `mobile`,
`createdby`, `createdon`, `isdeleted`, `modifyby`, `modifyon`)
VALUES ('" + c.Firstname + "','" + c.Lastname + "'," + c.Status + ",'" + c.Email + "','" + c.Mobile +
"'," + c.Createdby + ",STR_TO_DATE('" + c.Createdon + "', '%c/%e/%Y %r')" +
",'F','',STR_TO_DATE('" + c.Modifyon + "', '%c/%e/%Y %r'))";
dbconnect.GetScalar(conn, trans, qry, null);
return(1);
}
catch
{
}
}
return(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.customers obj)
{
if (obj != null)
{
try
{
conn = new MySqlConnection(ConnectionString);
conn.Open();
trans = conn.BeginTransaction();
bll_objCustomer.Delete(obj, conn, trans);
trans.Commit();
conn.Close();
return(obj.Customerid);
}
catch
{
trans.Rollback();
conn.Close();
}
}
return(0);
}
public Int32 ProcessTickets(List <BOL.customers> customersList, Int32 userid)
{
try
{
Initialize();
conn = new MySqlConnection(ConnectionString);
conn.Open();
trans = conn.BeginTransaction();
//bll_objCustomer.Insert(obj, conn, trans);
//Int32 customerid = bll_utility.GetMaxId("customers", "Customerid", conn, trans);
if (customersList != null && customersList.Count > 0)
{
this.bol_customerses = customersList;
if (this.bol_customerses != null && this.bol_customerses.Count > 0)
{
foreach (BOL.customers c in this.bol_customerses)
{
if (!string.IsNullOrEmpty(c.Mobile))
{
bol_customer = VerifyCustomerbyMobile(c);
if (bol_customer.Customerid == 0)
{
bol_customer.Status = StatusEnum.firstcall.GetHashCode();
bol_customer.Isdeleted = "F";
bol_customer.Createdby = userid;
bol_customer.Createdon = DateTime.Now;
bol_customer.Modifyby = userid;
bol_customer.Modifyon = DateTime.Now;
bll_customer.Insert(c, conn, trans);
bol_customer.Customerid = bll_utility.GetMaxId("customers", "Customerid", conn, trans);
}
if (c.Ticketses != null && c.Ticketses[0].Ticketattachments != null)
{
bol_ticket.Customerid = bol_customer.Customerid;
bol_ticket.Ticketid = VerifyOpenAnonymousTicketbyCustomerid(bol_ticket);
}
if (bol_ticket.Ticketid == 0)
{
bol_ticket.Ticketstatusid = TicketStatusEnum.Open.GetHashCode();
bol_ticket.Description = "Open ticket";
bol_ticket.Title = "Open ticket";
if (bol_customer.Status == StatusEnum.firstcall.GetHashCode())
{
bol_ticket.Ticketstatusid = TicketStatusEnum.Anonymous.GetHashCode();
bol_ticket.Description = "Anonymous ticket";
bol_ticket.Title = "Anonymous ticket";
}
bol_ticket.Customerid = bol_customer.Customerid;
bol_ticket.Isdeleted = "F";
bol_ticket.Createdby = userid;
bol_ticket.Createdon = DateTime.Now;
bol_ticket.Modifiedby = userid;
bol_ticket.Modifiedon = DateTime.Now;
bol_ticket.Userid = userid;
bll_tickets.Insert(bol_ticket, conn, trans);
bol_ticket.Ticketid = bll_utility.GetMaxId("tickets", "Ticketid", conn, trans);
}
if (c.Ticketses != null && c.Ticketses[0].Ticketattachments != null &&
c.Ticketses.Count > 0)
{
foreach (BOL.ticketattachment tattch in c.Ticketses[0].Ticketattachments)
{
if (!string.IsNullOrEmpty(tattch.Link))
{
tattch.Isdeleted = "F";
tattch.Ticketid = bol_ticket.Ticketid;
tattch.Ticketattachmentid = bll_ticketattach.Insert(tattch, conn, trans);
}
}
}
}
}
}
}
trans.Commit();
conn.Close();
return(1);
}
catch (Exception ex)
{
string message = ex.Message;
if (trans != null)
{
trans.Rollback();
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(0);
}
public List <BOL.customers> Select(BOL.customers obj)
{
if (obj != null)
{
conn = new MySqlConnection(ConnectionString);
conn.Open();
trans = conn.BeginTransaction();
DataSet ds = bll_objCustomer.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.customers> customers = new List <BOL.customers>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
BOL.customers c = new BOL.customers();
if (dr["Customerid"] != null && Convert.ToInt32(dr["Customerid"]) > 0)
{
c.Customerid = Convert.ToInt32(Convert.ToString(dr["Customerid"]));
}
if (dr["Firstname"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Firstname"])))
{
c.Firstname = Convert.ToString(dr["Firstname"]);
}
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["Email"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Email"])))
{
c.Email = Convert.ToString(dr["Email"]);
}
if (dr["Isdeleted"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Isdeleted"])))
{
c.Isdeleted = Convert.ToString(dr["Isdeleted"]);
}
if (dr["Lastname"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Lastname"])))
{
c.Lastname = Convert.ToString(dr["Lastname"]);
}
if (dr["Mobile"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Mobile"])))
{
c.Mobile = Convert.ToString(dr["Mobile"]);
}
if (dr["Modifyby"] != null && Convert.ToInt32(dr["Modifyby"]) > 0)
{
c.Modifyby = Convert.ToInt32(Convert.ToString(dr["Modifyby"]));
}
if (dr["Modifyon"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Modifyon"])))
{
c.Modifyon = Convert.ToDateTime(Convert.ToString(dr["Modifyon"]));
}
if (dr["Status"] != null && Convert.ToInt32(dr["Status"]) > 0)
{
c.Status = Convert.ToInt32(Convert.ToString(dr["Status"]));
}
customers.Add(c);
}
return(customers);
}
return(null);
}
return(null);
}
