protected void cmdnext_Click(object sender, EventArgs e) { int orderid = Convert.ToInt32(Session["OrderId"]); int userid = Convert.ToInt32(Session["UserId"]); var delivaryDate = DateTime.Today.AddDays(7); order.Insert(new Order { OrderDate = DateTime.Today, UserId = userid, TotalPrice = Convert.ToSingle(lbltotal.Text), IsProcessedOrNot = 0, DeliveryDate = delivaryDate, }); Session["CartId"] = order.GetMaxId(); var Maxorderid = order.GetMaxId(); var ProductDetails = _checkout.GetAllData(userid); int i = 0; foreach (var item in ProductDetails) { _productOrder.insert(new ProductOrder { _Size12 = item.Size, OrderId = Maxorderid, ProductId = item.ColorId, Quantity = item.Quantity, Status = "false" }); var ss = _size.SearchData(item.ColorId, item.Size); int quantity = ss.Quantity - Convert.ToInt32(item.Size); _size.updateQuantity(ss.SizeId, quantity); } Session["TotalAmount"] = lbltotal.Text; lbl_total.Text = lbltotal.Text; int total = Convert.ToInt32(lbltotal.Text); if (total > 500) { lbl_deliveryCharge.Text = "0"; } else { lbl_deliveryCharge.Text = "100"; } var discountItems = from c in _discount.GetallData() select c; foreach (var item in discountItems) { if (item.Price <= total) { var date1 = DateTime.Compare(DateTime.Today, DateTime.Parse(item.ValidityFrom)); var date2 = DateTime.Compare(DateTime.Today, DateTime.Parse(item.ValidityTo)); if (date1 > 0 && date2 < 0) { lbl_Discount.Text = item.DiscountPercentage; } else { lbl_Discount.Text = "0"; } } else { lbl_Discount.Text = "0"; } } int GTotal = total + Convert.ToInt32(lbl_deliveryCharge.Text); float discount = (total * Convert.ToInt32(lbl_Discount.Text)) / 100; float GrandTotal = GTotal - discount; lbl_GrandTotal.Text = GrandTotal.ToString(); MultiView1.ActiveViewIndex = 2; }