public void getitemcount(int productid, int quantity, string grateid, string itemid) { HttpContext.Current.Response.Clear(); HttpContext.Current.Response.AddHeader("Content-Type", "text/html"); // HttpContext.Current.Response.Write("bhushan"); using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { if (quantity != 0) { // int custid = int.Parse(HttpContext.Current.Session["CustId"].ToString()); // int? regid = (int?)HttpContext.Current.Session["RegId"]; int?custid = (int?)HttpContext.Current.Session["CustId"]; int?id = (int?)HttpContext.Current.Session["ProdId"]; var check = (from s in db.tbl_CartDtls where s.GrocerRateID == int.Parse(grateid.ToString()) && s.ItemId == int.Parse(itemid.ToString()) && s.CustomerId == custid && s.PaymentStatus == false select s).FirstOrDefault(); if (check == null) { tbl_CartDtl tb = new tbl_CartDtl(); tb.CustomerId = custid; tb.GrocerRateID = int.Parse(grateid.ToString()); tb.Quantity = int.Parse(quantity.ToString()); tb.ItemId = int.Parse(itemid.ToString()); tb.PaymentStatus = false; tb.IsDelete = false; db.tbl_CartDtls.InsertOnSubmit(tb); db.SubmitChanges(); // Response.Redirect("~/frmAddContentToCart.aspx?ProdId=" + id); // string message = ""; // return message; Console.Write("Item added to cart Successfully"); //Server.Transfer("~/frmAddContentToCart.aspx"); // HttpContext.Current.Response.Redirect("~/frmAddContentToCart.aspx"); } else { //check.CustomerId = int.Parse(Session["CustID"].ToString()); //check.GrocerRateID = int.Parse(grocerrate.ToString()); //check.Quantity = int.Parse(FinalCount.ToString()); //check.ItemId = int.Parse(abc.ToString()); int a = int.Parse(check.Quantity.ToString()); check.Quantity = a + quantity; check.PaymentStatus = false; check.IsDelete = false; db.SubmitChanges(); Console.Write("Item added to cart Successfully"); // System.Web.UI.ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Inserted Successfully')", true); //Server.Transfer("~/frmAddContentToCart.aspx"); // HttpContext.Current.Response.Redirect("~/frmAddContentToCart.aspx"); } } else { HttpContext.Current.Response.Write("Please Select Quantity of Product"); //return (" "); //count++; } } }
protected void btnPlaceOrder_Click(object sender, EventArgs e) { if (Page.IsValid) { if (Session["CustId"] != null) { int CustID = int.Parse(Session["CustId"].ToString()); var k = DateTime.Today.ToString("ddMMyy"); //string OderID = k + CustID + CustOdr; string OderID = CustID + k; using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { string j = ""; int rowcount = 1; foreach (GridViewRow row in GvCardDtl.Rows) //Running all lines of grid { int CartId = int.Parse(((Label)row.FindControl("lblItemID")).Text.ToString()); int Quantity = int.Parse(((Label)row.FindControl("txtQunatity")).Text.ToString()); int MRP = int.Parse(((Label)row.FindControl("lblMRP")).Text.ToString()); string Size = (((Label)row.FindControl("lblSize")).Text.ToString()); int grocerid = int.Parse(((Label)row.FindControl("lblGrocerId")).Text.ToString()); if (rowcount < 2) { //var da = (from s in db.tbl_orderConfirms where s.ConfirmOdrID == j && s.GrocerId == grocerid select s).FirstOrDefault(); //if (da == null) //{ tbl_orderConfirm h = new tbl_orderConfirm(); h.ConfirmOdrID = OderID; db.tbl_orderConfirms.InsertOnSubmit(h); db.SubmitChanges(); h.CustId = CustID; h.OrderAmount = lblSubTotal.Text; //if (rbtDelivertype.SelectedItem != null) //{ // t.DeliType = rbtDelivertype.SelectedItem.Text; //} //else //{ // t.DeliType = "Standard Delivery"; //} h.Time_Date = DateTime.Now; //t.PaymentMode = h.Toatal_price = lblGrandTotal.Text; h.isDelete = false; //if (rbtDelivertype.SelectedItem != null) //{ // t.Deliver_Charge = rbtDelivertype.SelectedItem.Value; //} //else //{ // t.Deliver_Charge = "FREE"; //} h.Deliver_Charge = lblShoppingCost.Text; h.Odr_status = true; h.Complt_Odr = "S"; h.GrocerId = grocerid; h.ConfirmOdrID = OderID + h.CustOrdId; // db.tbl_orderConfirms.InsertOnSubmit(t); db.SubmitChanges(); rowcount++; j = h.ConfirmOdrID; //} } var daa = (from s in db.tbl_orderConfirms where s.ConfirmOdrID == j && s.GrocerId == grocerid select s).FirstOrDefault(); if (daa == null) { tbl_orderConfirm b = new tbl_orderConfirm(); b.GrocerId = grocerid; b.CustId = CustID; b.OrderAmount = lblSubTotal.Text; //if (rbtDelivertype.SelectedItem != null) //{ // t.DeliType = rbtDelivertype.SelectedItem.Text; //} //else //{ // t.DeliType = "Standard Delivery"; //} b.Time_Date = DateTime.Now; //t.PaymentMode = b.Toatal_price = lblGrandTotal.Text; b.isDelete = false; //if (rbtDelivertype.SelectedItem != null) //{ // t.Deliver_Charge = rbtDelivertype.SelectedItem.Value; //} //else //{ // t.Deliver_Charge = "FREE"; //} b.Odr_status = true; b.Complt_Odr = "S"; b.ConfirmOdrID = j; db.tbl_orderConfirms.InsertOnSubmit(b); db.SubmitChanges(); } tbl_CartDtl m = new tbl_CartDtl(); var a = (from s in db.tbl_CartDtls where s.cartID == CartId select s).FirstOrDefault(); //a.Quantity = int.Parse(Quantity.ToString()); m.ItemId = CartId; m.Quantity = Quantity; m.GrocerRateID = MRP; m.CustomerId = CustID; m.Size = Size; m.GrocerId = grocerid; m.PaymentStatus = false; m.IsDelete = false; m.CustmerOdrId = j; db.tbl_CartDtls.InsertOnSubmit(m); db.SubmitChanges(); } Tbl_CustDeliveryAddressDtl c = new Tbl_CustDeliveryAddressDtl(); c.CustId = CustID; c.CustFullName = txtFName.Text; c.CustLName = txtLName.Text; c.MobileNo = txtMobileNo.Text; c.AltMobileNo = txtALTMobile.Text; c.EmailId = txtEMail.Text; if (ddlState.SelectedItem.Value != "-----Select-----") { c.StateId = int.Parse(ddlState.SelectedItem.Value); } if (ddlCity.SelectedItem.Value != "-----Select-----") { c.CityId = int.Parse(ddlCity.SelectedItem.Value); } c.Address = txtAddress.Text; //if (rbtDelivertype.SelectedItem != null) //{ // c.Deliverytype = rbtDelivertype.SelectedItem.Value; //} //else //{ // c.Deliverytype = "FREE"; //} c.Odr_Status = true; c.CustOrdId = j; c.isdelete = false; if (txtZip.Text != "") { c.ZipCode = int.Parse(txtZip.Text); } db.Tbl_CustDeliveryAddressDtls.InsertOnSubmit(c); db.SubmitChanges(); txtFName.Text = ""; txtLName.Text = ""; txtMobileNo.Text = ""; txtAddress.Text = ""; txtALTMobile.Text = ""; txtCreDitCardNumber.Text = ""; txtCVV.Text = ""; txtEMail.Text = ""; txtExperyDate.Text = ""; txtNameOnCard.Text = ""; txtZip.Text = ""; ddlState.Items.Clear(); ddlCity.Items.Clear(); //rbtDelivertype.SelectedItem.Value = "FREE"; GvCardDtl.DataSource = null; GvCardDtl.DataBind(); lblSubTotal.Text = ""; if (Request.Cookies["ShoppingCart"] != null) { //Session.Abandon(); //Session.Clear(); Response.Cookies.Clear(); Response.Cookies["ShoppingCart"].Value = null; Request.Cookies["ShoppingCart"].Value = null; Response.Cookies["ShoppingCart"].Expires = DateTime.Now.AddDays(-30); Session["ShoppingCart"] = null; //Response.Cookies.Add(Response.Cookies["ShoppingCart"]); } ((Site1)Master).BindGvCardDtl(); Response.Redirect("Default.aspx"); //var a = (from s in db.tbl_CartDtls where s.CustomerId == CustID && s.PaymentStatus == false && s.IsDelete == false select s).ToList(); // var c = (from s in db.Tbl_CustDeliveryAddressDtls where s.CustId == CustID & s.Odr_Status == false select s).FirstOrDefault(); //var d = (from s in db.tbl_orderConfirms where s.CustOrdId == CustOdr select s).FirstOrDefault(); //foreach (tbl_CartDtl s in a) //{ // s.CustmerOdrId = Convert.ToInt64(OderID); // s.CustmerOdrId = CustOdr; // s.PaymentStatus = true; // db.SubmitChanges(); //} //c.CustOrdId = int.Parse(CustOdr.ToString()); //c.Odr_Status = true; //db.SubmitChanges(); //d.Complt_Odr = false; //d.Odr_status = true; //d.ConfirmOdrID = int.Parse(OderID.ToString()); //db.SubmitChanges(); //if (Session["OnlinePayment"] != null) //{ // Response.Redirect("~/m.app/PaytmPaymentGateway.aspx"); //} //API api = new API(); //var Customer = (from s in db.mstCustomerDtls where s.CustId == CustID select s).FirstOrDefault(); //var Grocer = (from s in db.mstGrocerDtls where s.GrocerId == GrocerID select s).FirstOrDefault(); //string _CustomerName = Customer.CustName; //string _MOBNO = Customer.MobileNo; //string _OderNo = d.ConfirmOdrID.ToString(); //string _msg = "Thanks Mr. " + _CustomerName + "<br>" + " your order list has been submitted successfully." + " Order ID :" + ' ' + _OderNo + " for future reference. your order will be process soon. " + "<br>" + "KITCHEN BASKET"; //sendsms(_MOBNO, _msg); //string _GrocerName = Grocer.ShopName; //string _MOBILENO = Grocer.MobNo; //string _MESSAGE = "MR. " + _CustomerName + " has Submited Order list Order ID " + ' ' + _OderNo + " For Future reference" + "<br>" + "KITCHEN BASKET"; //sendsms(_MOBILENO, _MESSAGE); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "str", "alert('Your Order Place Successfully...!.' );", true); } } else { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "str", "alert('Please Login First');", true); } } }