protected void Page_Load(object sender, EventArgs e) { string orderId = Session[Constant.Session.CURRENT_ORDER] + ""; orderDT = OrderDAO.getOrder(orderId); orderDetailsDT = OrderDAO.getOrderDetails(orderId); shippingDT = ShippingDAO.getShipping(orderDT.Rows[0]["SHIPPING_ID"] + ""); }
internal static void AddNewShippingInformationToUser(Shipping address, Customer customer, P1Context _context) { var DB = _context; ShippingDAO.AddShippingInformation(address, DB); CustomerShipping CS = new CustomerShipping { CustomerID = customer.CustomerID, ShippingID = address.ShippingID }; CustomerShippingDAO.AddCustomerShipping(CS, DB); }
public override void load(object sender, EventArgs e) { addressDT = ShippingDAO.getShippinByUserID(Session[Constant.Session.LOGED_IN_USER_ID] + ""); if (addressDT == null) { addressDT = new DataTable(); } userDT = RegisterDAO.getUser(Session[Constant.Session.LOGED_IN_EMAIL] + ""); if (userDT == null) { userDT = new DataTable(); } }
public int countPayOrder() { ShippingDAO sDao = new ShippingDAO(); int cnt = 0; var datas = dao.getOrders().Where(m => m.isActive == true && m.isPay == false && m.isFinish == false); foreach (var d in datas) { if (sDao.getShippings().Where(m => m.orderCode == d.code).Any()) { cnt++; } } return(cnt); }
internal static List <Order> GetPastOrdersFromCustomer(Customer customer, P1Context _context) { List <Order> OrdersByCustomer = new List <Order>(); var DB = _context; OrderDAO.LoadOrdersList(DB); OrderProductsDAO.LoadOrderProductsList(DB); ProductDAO.LoadProductsList(DB); LocationDAO.LoadLocationsList(DB); BillingDAO.LoadBillingList(DB); CustomerDAO.LoadCustomersList(DB); ShippingDAO.LoadShippingInfomrationList(DB); OrdersByCustomer = DB.OrdersList.Where(o => o.CustomerID == customer.CustomerID).ToList(); for (int i = 0; i < OrdersByCustomer.Count; i++) { Order o = OrdersByCustomer[i]; List <ProductInStock> prodsOrdered = new List <ProductInStock>(); List <OrderProducts> prodIDsAndQuantityInOrder = DB.OrderProductsList.Where(op => op.OrderID == OrdersByCustomer[i].OrderID).ToList(); foreach (OrderProducts OP in prodIDsAndQuantityInOrder) { ProductInStock prodOrdered = new ProductInStock(); Product p = DB.ProductsList.First(p => p.ProductID == OP.ProductID); prodOrdered.Name = p.Name; prodOrdered.Price = p.Price; prodOrdered.Description = p.Description; prodOrdered.Quantity = OP.Quantity; prodsOrdered.Add(prodOrdered); } o.ShoppingCart = prodsOrdered; o.Billing = DB.BillingInformationList.First(b => b.BillingID == OrdersByCustomer[i].BillingID); o.Shipping = DB.ShippingInformation.First(s => s.ShippingID == OrdersByCustomer[i].ShippingID); o.Location = DB.LocationList.First(l => l.LocationID == OrdersByCustomer[i].LocationID); o.Customer = DB.CustomersList.First(c => c.CustomerID == OrdersByCustomer[i].CustomerID); OrdersByCustomer[i] = o; } return(OrdersByCustomer); }
public static Shipping GetAddress(int ShippingID, P1Context _context) { Shipping addy = new Shipping(); var DB = _context; ShippingDAO.LoadShippingInfomrationList(DB); foreach (Shipping a in DB.ShippingInformationList) { if (a.ShippingID == ShippingID) { addy = a; break; } } return(addy); }
protected void Page_Load(object sender, EventArgs e) { try { cartDT = HomeService.getCartDT(Session.SessionID); subTotal = HomeService.getTotal(); total = (float.Parse(HomeService.getTotal()) + 49).ToString(); invDic = AjaxService.checkInventory(cartDT, Session.SessionID); String userId = Session[Constant.Session.LOGED_IN_USER_ID] + ""; if (!StringUtil.isNullOrEmpty(userId)) { shipDT = ShippingDAO.getShippinByUserID(userId); } } catch { cartDT = new DataTable(); } }
protected void Page_Load(object sender, EventArgs e) { try { cartDT = HomeService.getCartDT(Session.SessionID); String userId = Session[Constant.Session.LOGED_IN_USER_ID] + ""; if (!StringUtil.isNullOrEmpty(userId)) { shipDT = ShippingDAO.getShippinByUserID(userId); } else { shipDT = ShippingDAO.getShippinByEmailID(Session[Constant.Session.SHIPING_EMAIL] + ""); } } catch { cartDT = new DataTable(); shipDT = new DataTable(); } }
public override void load(object sender, EventArgs e) { this.isEnalbleCache = false; string email = Session[Constant.Session.LOGED_IN_EMAIL] + ""; addressDT = ShippingDAO.getShippinByUserID(Session[Constant.Session.LOGED_IN_USER_ID] + ""); if (addressDT == null) { addressDT = new DataTable(); } userDT = RegisterDAO.getUser(email); if (userDT == null) { userDT = new DataTable(); } orderDT = OrderDAO.getOrderByEmail(email); if (orderDT == null) { orderDT = new DataTable(); } }
internal static void AddNewShippingInformationToUser(Billing card, Customer customer, P1Context _context) { Shipping S = new Shipping { AddressNum = card.AddressNum, AddressStreet = card.AddressStreet, AddressCity = card.AddressCity, AddressState = card.AddressState, AddressZipCode = card.AddressZipCode, }; var DB = _context; ShippingDAO.AddShippingInformation(S, DB); CustomerShipping CS = new CustomerShipping { CustomerID = customer.CustomerID, ShippingID = S.ShippingID }; CustomerShippingDAO.AddCustomerShipping(CS, DB); }
public static string createOrder(string sessionID, string shippingEmail, string payMode, string userID) { DataTable carDT = HomeService.getCartDT(sessionID); string total = HomeService.getTotal(); string shippingId = ""; if (StringUtil.isNullOrEmpty(userID)) { shippingId = ShippingDAO.getShippinIDByEmail(shippingEmail); } else { shippingId = ShippingDAO.getShippinIDByUserID(userID); } int orderID = OrderDAO.createOrder(total, payMode, shippingId); OrderDAO.createOrderStatus(orderID); OrderDAO.createOrderDetails(carDT, orderID.ToString()); return(orderID + ""); }
internal static List <Shipping> GetShippingAddresssesOnFileForCustomer(Customer customer, P1Context _context) { List <Shipping> ships = new List <Shipping>(); var DB = _context; CustomerShippingDAO.LoadCustomersShippingList(DB); ShippingDAO.LoadShippingInfomrationList(DB); foreach (CustomerShipping cs in DB.CustomerShippingList) { if (cs.CustomerID == customer.CustomerID) { foreach (Shipping s in DB.ShippingInformationList) { if (cs.ShippingID == s.ShippingID) { ships.Add(s); } } } } return(ships); }
public ShippingBO() { dao = new ShippingDAO(); }
public static void sendOrderPlacedEmail() { Logger.Info("START EmailTemplateService.sendOrderPlacedEmail()"); try { string orderId = HttpContext.Current.Session[Constant.Session.CURRENT_ORDER] + ""; Logger.Debug("orderId" + orderId); DataTable orderDT = OrderDAO.getOrder(orderId); DataTable orderDetailsDT = OrderDAO.getOrderDetails(orderId); DataTable shippingDT = ShippingDAO.getShipping(orderDT.Rows[0]["SHIPPING_ID"] + ""); String emailSendTo = shippingDT.Rows[0]["EMAIL"] + ""; Logger.Debug("emailSendTo" + emailSendTo); if (!CommonUtil.DT.isEmptyOrNull(orderDT)) { IDictionary context = new Hashtable(); context.Add("CUSTOMER", shippingDT.Rows[0]["NAME"] + ""); context.Add("ORDER_DATE", DateTime.Now + ""); context.Add("ORDER_NO", orderDT.Rows[0]["ORDER_NO"] + ""); context.Add("PAYMINT_MODE", orderDT.Rows[0]["PAYMINT_METHOD"]); context.Add("EMAIL", emailSendTo); context.Add("MOBILE", shippingDT.Rows[0]["MOBILE"] + ""); context.Add("ADDRESS", shippingDT.Rows[0]["ADDRESS"] + ""); context.Add("CITY", shippingDT.Rows[0]["CITY"] + ""); context.Add("STATE", shippingDT.Rows[0]["STATE"] + ""); context.Add("PIN", shippingDT.Rows[0]["PIN"] + ""); context.Add("COUNTRY", "India."); context.Add("CC_NO ", ConfigUtil.CC_NO); context.Add("CC_EMAIL ", ConfigUtil.CC_Email); Logger.Debug("CustomerCareNo = " + ConfigUtil.CC_NO); Logger.Debug("CustomerCareEmail = " + ConfigUtil.CC_Email); Logger.Debug("context.CUSTOMER_CARE_NO = " + context["CC_NO"]); Logger.Debug("context.CUSTOMER_CARE_EMAIL = " + context["CC_EMAIL"]); Logger.Debug("context.PIN = " + context["PIN"]); context.Add("SHIPPING_CHARGE", ConfigUtil.getValue("ShippigCharge")); context.Add("SUBTOTAL", Decimal.Parse(orderDT.Rows[0]["AMOUNT"] + "").ToString("#.00")); context.Add("VAT", orderDT.Rows[0]["VAT"]); context.Add("TOTAL", Decimal.Parse(orderDT.Rows[0]["TOTAL_AMOUNT"] + "").ToString("#.00")); List <object> orderList = new List <object>(); foreach (DataRow orderRow in orderDetailsDT.Rows) { orderList.Add(new { NAME = orderRow["SKUName"], BRAND = orderRow["SKUBrand"], QTY = orderRow["QTY"], COLOR = orderRow["Color"], SIZE = orderRow["Size"], TOTAL = Decimal.Parse(orderRow["TOTAL"] + "").ToString("#.00"), SKU = orderRow["SKU"], UNIT_PRICE = Decimal.Parse(orderRow["UNIT_PRICE"] + "").ToString("#.00"), IMG = ConfigUtil.getServerPath() + "" + orderRow["PathInternaldetailsSmallImage"], }); } context.Add("ALL_PRODUCT", orderList); Logger.Debug("orderList:- " + orderList.Count); String html = CommonUtil.readTemlate("orderPlaced.vm", context); Logger.Debug("template file:- " + html); EmailService.SendMail(ConfigUtil.MailFrom, emailSendTo, "Order Confirmation - Order ID - " + orderDT.Rows[0]["ORDER_NO"], html); EmailService.SendMail(ConfigUtil.MailFrom, ConfigUtil.getValue("OrderTrakerEmail"), "Order Confirmation - Order ID - " + orderDT.Rows[0]["ORDER_NO"], html); sendSMS(shippingDT.Rows[0]["NAME"] + "", orderDT.Rows[0]["ORDER_NO"] + "", Decimal.Parse(orderDT.Rows[0]["TOTAL_AMOUNT"] + "").ToString("#.00"), shippingDT.Rows[0]["MOBILE"] + "", emailSendTo); sendSMSCustCare(shippingDT.Rows[0]["NAME"] + "", orderDT.Rows[0]["ORDER_NO"] + "", Decimal.Parse(orderDT.Rows[0]["TOTAL_AMOUNT"] + "").ToString("#.00"), shippingDT.Rows[0]["MOBILE"] + "", emailSendTo); } } catch (Exception e) { Logger.Info("error occur " + e); Logger.Error(e); } Logger.Info("End EmailTemplateService.sendOrderPlacedEmail()"); }
public static bool addShipping(string email, string name, string phone, string pin, string city, string state, string address, string sessionId, string userId) { return(ShippingDAO.addOrUpdate(email, name, phone, pin, city, state, address, sessionId, userId)); }