public List <customer> customerdetails(string DeliverTime, string restcode) { try { GetConnectionString getConnectionString = new GetConnectionString(); string ConnectionString = getConnectionString.CustomizeConnectionString(restcode); SqlConnection Conn = new SqlConnection(ConnectionString); Conn.Open(); List <customer> customerdetails = new List <customer>(); if (Conn.State != System.Data.ConnectionState.Open) { Conn.Open(); } SqlCommand cmd = new SqlCommand("searchBycustPhoneAndName", Conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@customerdata", DeliverTime); SqlDataReader _Reader = cmd.ExecuteReader(); while (_Reader.Read()) { customer objCust = new customer(); objCust.phoneNo = _Reader["CustPhoneNumber"].ToString(); objCust.firstname = _Reader["CustomerFName"].ToString(); objCust.lastname = _Reader["CustomerLName"].ToString(); objCust.daddress = _Reader["Delivery_Addresss"].ToString(); objCust.laddress = _Reader["Land_mark"].ToString(); objCust.Deliverylocationlatitude = _Reader["Deliverylocationlatitude"].ToString(); objCust.Deliverylocationlongitude = _Reader["Deliverylocationlongitude"].ToString(); objCust.ModifiedDate = _Reader["ModifiedDate"].ToString(); objCust.CreatedDate = _Reader["CreatedDate"].ToString(); objCust.mobileno2 = _Reader["Mobile2"].ToString(); objCust.mobileno1 = _Reader["Mobile1"].ToString(); // objCust.custTypeId = _Reader["CustomerTypeId"].ToString(); customerdetails.Add(objCust); } return(customerdetails); } catch (Exception ex) { throw ex; } finally { //if (Conn != null) //{ // //if (Conn.State == ConnectionState.Open) // //{ // // Conn.Close(); // // Conn.Dispose(); // //} //} } }
public List <chartline> chartline(string DeliverTime, string restcode) { try { GetConnectionString getConnectionString = new GetConnectionString(); string ConnectionString = getConnectionString.CustomizeConnectionString(restcode); SqlConnection Conn = new SqlConnection(ConnectionString); Conn.Open(); DateTime DeliverTime1 = Convert.ToDateTime(DeliverTime); List <chartline> _chartlines = new List <chartline>(); if (Conn.State != System.Data.ConnectionState.Open) { Conn.Open(); } SqlCommand cmd = new SqlCommand("spchartline", Conn); cmd.Parameters.AddWithValue("@from_date", DeliverTime1); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader _Reader = cmd.ExecuteReader(); while (_Reader.Read()) { chartline chartl = new chartline(); // chartl.OrderDate = DateTime.ParseExact((_Reader["OrderDate"].ToString()), "ddd MMM dd yyyy HH:mm:ss", CultureInfo.InvariantCulture); chartl.OrderDate = Convert.ToDateTime((_Reader["OrderDate"].ToString())); chartl.Orders = _Reader[""].ToString(); _chartlines.Add(chartl); } return(_chartlines); } catch (Exception ex) { throw ex; } finally { //if (Conn != null) //{ // if (Conn.State == ConnectionState.Open) // { // Conn.Close(); // Conn.Dispose(); // } //} } }
public List <reports> custreports(string phoneno, string restcode) { try { GetConnectionString getConnectionString = new GetConnectionString(); string ConnectionString = getConnectionString.CustomizeConnectionString(restcode); SqlConnection Conn = new SqlConnection(ConnectionString); Conn.Open(); List <reports> custreports = new List <reports>(); if (Conn.State != System.Data.ConnectionState.Open) { Conn.Open(); } SqlCommand cmd = new SqlCommand("spviewcustordersforreport", Conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@custphone", phoneno); SqlDataReader _Reader = cmd.ExecuteReader(); while (_Reader.Read()) { reports objCust = new reports(); objCust.OrderId = _Reader["OrderId"].ToString(); objCust.OrderDate = _Reader["OrderDate"].ToString(); objCust.restcode = _Reader["restcode"].ToString(); objCust.OrderType = _Reader["OrderType"].ToString(); objCust.amountPaid = _Reader["AmountPaid"].ToString(); objCust.TotalPrice = _Reader["TotalAmount"].ToString(); objCust.OrderType = _Reader["OrderType"].ToString(); custreports.Add(objCust); } return(custreports); } catch (Exception ex) { throw ex; } finally { //if (Conn != null) //{ // //if (Conn.State == ConnectionState.Open) // //{ // // Conn.Close(); // // Conn.Dispose(); // //} //} } }
public List <chartbar> chartbar(string DeliverTime, string restcode) { try { GetConnectionString getConnectionString = new GetConnectionString(); string ConnectionString = getConnectionString.CustomizeConnectionString(restcode); SqlConnection Conn = new SqlConnection(ConnectionString); Conn.Open(); DateTime DeliverTime1 = Convert.ToDateTime(DeliverTime); List <chartbar> _chartbars = new List <chartbar>(); if (Conn.State != System.Data.ConnectionState.Open) { Conn.Open(); } SqlCommand cmd = new SqlCommand("spchartbar", Conn); cmd.Parameters.AddWithValue("@from_date", DeliverTime1); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader _Reader = cmd.ExecuteReader(); while (_Reader.Read()) { chartbar chartbar = new chartbar(); chartbar.count = _Reader["count"].ToString(); chartbar.month = _Reader["month"].ToString(); _chartbars.Add(chartbar); } return(_chartbars); } catch (Exception ex) { throw ex; } finally { //if (Conn != null) //{ // if (Conn.State == ConnectionState.Open) // { // Conn.Close(); // Conn.Dispose(); // } //} } }
public List <orderdetails> orderdetails(string orderdetails, string restcode) { try { GetConnectionString getConnectionString = new GetConnectionString(); string ConnectionString = getConnectionString.CustomizeConnectionString(restcode); SqlConnection Conn = new SqlConnection(ConnectionString); Conn.Open(); List <orderdetails> ordetails = new List <orderdetails>(); if (Conn.State != System.Data.ConnectionState.Open) { Conn.Open(); } SqlCommand cmd = new SqlCommand("sploadcartforconformpage", Conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Orderid", orderdetails); SqlDataReader _Reader = cmd.ExecuteReader(); while (_Reader.Read()) { orderdetails objCust = new orderdetails(); objCust.Price = Convert.ToInt16(_Reader["price"]); objCust.Quantity = Convert.ToInt16(_Reader["Quantity"]); objCust.ProductName = _Reader["ProductName"].ToString(); //objCust.Image = _Reader["Image"]; ordetails.Add(objCust); } return(ordetails); } catch (Exception ex) { throw ex; } //finally //{ // //if (Conn != null) // //{ // // //if (Conn.State == ConnectionState.Open) // // //{ // // // Conn.Close(); // // // Conn.Dispose(); // // //} // //} //} //} }
public List <discount> custdiscounts(string phoneno, string restcode) { try { GetConnectionString getConnectionString = new GetConnectionString(); string ConnectionString = getConnectionString.CustomizeConnectionString(restcode); SqlConnection Conn = new SqlConnection(ConnectionString); Conn.Open(); List <discount> custdiscount = new List <discount>(); if (Conn.State != System.Data.ConnectionState.Open) { Conn.Open(); } SqlCommand cmd = new SqlCommand("spviewcustdicount", Conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@custphone", phoneno); SqlDataReader _Reader = cmd.ExecuteReader(); while (_Reader.Read()) { discount objCust = new discount(); objCust.Phoneno = _Reader["CustPhoneNumber"].ToString(); objCust.Discount = _Reader["Discount"].ToString(); custdiscount.Add(objCust); } return(custdiscount); } catch (Exception ex) { throw ex; } finally { //if (Conn != null) //{ // //if (Conn.State == ConnectionState.Open) // //{ // // Conn.Close(); // // Conn.Dispose(); // //} //} } }
public List <reports> Weeklyreports(DateTime DeliverTime, string restcode) { try { GetConnectionString getConnectionString = new GetConnectionString(); string ConnectionString = getConnectionString.CustomizeConnectionString(restcode); SqlConnection Conn = new SqlConnection(ConnectionString); Conn.Open(); DateTime DeliverTime1 = Convert.ToDateTime(DeliverTime); List <reports> Monthlyreports = new List <reports>(); if (Conn.State != System.Data.ConnectionState.Open) { Conn.Open(); } SqlCommand cmd = new SqlCommand("rptGetWeeklyReportDT", Conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@from_date", DeliverTime1); SqlDataReader _Reader = cmd.ExecuteReader(); while (_Reader.Read()) { reports objCust = new reports(); objCust.OrderId = _Reader["OrderId"].ToString(); objCust.OrderDate = _Reader["OrderDate"].ToString(); objCust.restcode = _Reader["restcode"].ToString(); objCust.amountPaid = _Reader["amountPaid"].ToString(); objCust.statusdiscription = _Reader["statusdiscription"].ToString(); objCust.customerphone = _Reader["customerphone"].ToString(); objCust.customerfname = _Reader["customerfname"].ToString(); objCust.customerlname = _Reader["customerlname"].ToString(); objCust.Quantity = _Reader["Quantity"].ToString(); objCust.TotalPrice = _Reader["TotalPrice"].ToString(); objCust.Deliverycharges = _Reader["Deliverycharges"].ToString(); objCust.cgstcharges = _Reader["cgstcharges"].ToString(); objCust.sgstcharges = _Reader["sgstcharges"].ToString(); objCust.Discount = _Reader["Discount"].ToString(); objCust.Tip = _Reader["Tip"].ToString(); objCust.Remarks = _Reader["Remarks"].ToString(); objCust.OrderType = _Reader["OrderType"].ToString(); objCust.TransactionId = _Reader["TransactionId"].ToString(); objCust.status = _Reader["statusid"].ToString(); objCust.Orderstatus = _Reader["statusdiscription"].ToString(); objCust.Delivery_Addresss = _Reader["Delivery_Addresss"].ToString(); objCust.empcode = _Reader["empcode"].ToString(); objCust.TotalPrice = _Reader["TotalPrice"].ToString(); objCust.Billing_Address = _Reader["Billing_Address"].ToString(); objCust.TransactionStatus = _Reader["TransactionStatus"].ToString(); Monthlyreports.Add(objCust); } return(Monthlyreports); } catch (Exception ex) { throw ex; } //finally //{ // if (Conn != null) // { // //if (Conn.State == ConnectionState.Open) // //{ // // Conn.Close(); // // Conn.Dispose(); // //} // } //} }