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