// GET: Orders public ActionResult Index() { int UserId = 0; List <OrderPlacedModel> orderedProducts = new List <OrderPlacedModel>(); if (Session["UserID"] == null) { return(RedirectToAction("Login", "Login")); } else { UserId = Convert.ToInt32(Session["UserID"]); } var orders = db.Orders.Include(o => o.orderPlacedProduct).Where(i => i.userid == UserId).ToList(); foreach (var item in orders) { OrderPlacedModel orderedProduct = new OrderPlacedModel(); orderedProduct.HealthProducts = new List <Product>(); orderedProduct.PharmacyProducts = new List <PharmacyProduct>(); orderedProduct.Address = new Address(); orderedProduct.Order = new Order(); var hpProductsIds = new List <string>(); var pharmProductsIds = new List <string>(); if (!string.IsNullOrEmpty(item.orderPlacedProduct.orderPlacedHealthProducts)) { hpProductsIds = item.orderPlacedProduct.orderPlacedHealthProducts.Split('|').ToList(); } if (!string.IsNullOrEmpty(item.orderPlacedProduct.orderPlacedPharmacyProducts)) { pharmProductsIds = item.orderPlacedProduct.orderPlacedPharmacyProducts.Split('|').ToList(); } foreach (var hpId in hpProductsIds) { var id = Convert.ToInt32(hpId); var prod = db.Products.Where(i => i.Product_Id == id).FirstOrDefault(); orderedProduct.HealthProducts.Add(prod); } foreach (var pharmId in pharmProductsIds) { var id = Convert.ToInt32(pharmId); var prod = db.PharmacyProducts.Where(i => i.ProductId == id).FirstOrDefault(); orderedProduct.PharmacyProducts.Add(prod); } orderedProduct.Address = db.Addresses.Where(i => i.AddressId == item.addressid).FirstOrDefault(); orderedProduct.Order = item; orderedProducts.Add(orderedProduct); } return(View(orderedProducts)); }
public ActionResult OrderSummry() { string uname = Session["UserName"].ToString(); var ob = new OrderPlacedModel(); ob.CartInfo = (from x in db.CustomerShoppingCarts where x.CustomerUserName == uname select x).OrderByDescending(z => z.DateTime).ToList(); ob.PaymentSystem = db.PaymentSystemTables.ToList(); ob.CustAdress = db.CustomerAddresses.Where(x => x.UserName == uname).ToList(); return(View(ob)); }
public ActionResult Order(OrderPlacedModel ob) { string Uname = Session["UserName"].ToString(); var cartinfo = db.CustomerShoppingCarts.Where(x => x.CustomerUserName == Uname).ToList(); var addressId = db.CustomerAddresses.Where(x => x.id == ob.CustAddressId).SingleOrDefault(); var TypeofPayment = db.PaymentSystemTables.Where(x => x.PaymentMethodsId == ob.PaymentTypeId).Select(x => x.PaymentMethods).SingleOrDefault(); foreach (var n in cartinfo) { OrderAddress orad = new OrderAddress(); OrderTable ortable = new OrderTable(); Thread.Sleep(100); orad.OrderId = ortable.OrderId = DateTime.Now.Ticks; ortable.Price = n.ItemPrice; ortable.NoOfItem = n.NoOfItem; ortable.UserName = Uname; orad.Address = addressId.Address; orad.City = addressId.City; orad.State = addressId.State; var ad = (decimal)addressId.PinCode; orad.PinCode = ad; orad.UserName = Uname; ortable.OrderAddress = "" + addressId.AddressType + "," + addressId.Address + "," + addressId.City + "," + addressId.State + "," + addressId.PinCode; ortable.TypeOfPaymentMethod = TypeofPayment; ortable.ItemId = n.ItemId; db.OrderTables.Add(ortable); db.OrderAddresses.Add(orad); var EmailAddress = db.UserRegistrations.Where(x => x.UserName == Uname).Select(x => x.EmailId).SingleOrDefault(); string Mailbody = this.createEmailBody(n.ItemName, n.ItemPrice.ToString(), orad.OrderId.ToString(), n.NoOfItem.ToString()); db.SaveChanges(); try { this.MailSend(EmailAddress, Mailbody); } catch (Exception) { } } var deletedata = db.CustomerShoppingCarts.Where(x => x.CustomerUserName == Uname).ToList(); foreach (var n in deletedata) { db.CustomerShoppingCarts.Remove(n); db.SaveChanges(); } return(RedirectToAction("YourOrder", "Account")); }