Ejemplo n.º 1
0
        private void BindGvCardDtl()//string CustId
        {
            using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext())
            {
                int CustId = int.Parse(Session["CustId"].ToString());
                var a      = (from s in db.tbl_ItemListDtls
                              join q in db.tbl_ItemQtyDtls on s.ItemId equals q.ItemId
                              join p in db.tbl_CartDtls on s.ItemId equals p.ItemId
                              join r in db.tbl_GrocerRateDtls on q.ItemQtyId equals r.ItemQtyId
                              //join h in db.tbl_HomeDelChrgs on r.GrocerRateId equals h.GrocerId
                              where p.CustomerId == CustId && p.PaymentStatus == false
                              select new { s.Image, s.BrandName, r.OfferRate, p.Quantity, p.cartID, r.GrocerId }).ToList();

                //var a = (from s in db.ShopCart(int.Parse(CustId)) select s).ToList();

                GvCardDtl.DataSource = a;
                GvCardDtl.DataBind();
                //int quantity1 = 0;
                //int Subtotal = 0;


                //for (int i = 0; i < a.Count; i++)
                //{
                //    quantity1 = quantity1 + int.Parse(a[i].Quantity.ToString());
                //    int total = int.Parse((a[i].Quantity * a[i].OfferRate).ToString());
                //    Subtotal = Subtotal + total;
                //}
            }
        }
Ejemplo n.º 2
0
        private void BindGvCardDtl()//string CustId
        {
            using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext())
            {
                int    quantity1 = 0;
                double Subtotal  = 0;
                double total1    = 0;
                if (Request.Cookies["ShoppingCart"] != null)
                {
                    string   objCartListString      = Request.Cookies["ShoppingCart"].Value.ToString();
                    string[] objCartListStringSplit = objCartListString.Split('|');


                    dt.Columns.Add(new DataColumn("RowNumber", typeof(string)));

                    dt.Columns.Add(new DataColumn("Image", typeof(string)));
                    dt.Columns.Add(new DataColumn("BrandName", typeof(string)));
                    dt.Columns.Add(new DataColumn("Quantity", typeof(string)));
                    dt.Columns.Add(new DataColumn("OfferRate", typeof(string)));
                    dt.Columns.Add(new DataColumn("Size", typeof(string)));
                    dt.Columns.Add(new DataColumn("ItemId", typeof(string)));
                    dt.Columns.Add(new DataColumn("GrocerId", typeof(string)));

                    //dt.Columns.Add(new DataColumn("Column5", typeof(string)));
                    //dt.Columns.Add(new DataColumn("Column6", typeof(string)));

                    //dr = dt.NewRow();
                    ////dr["RowNumber"] = 1;
                    ////dr["Image"] = string.Empty;
                    ////dr["BrandName"] = string.Empty;
                    ////dr["Quantity"] = string.Empty;
                    ////dr["OfferRate"] = string.Empty;
                    ////dr["Column5"] = string.Empty;
                    ////dr["Column6"] = string.Empty;

                    //dt.Rows.Add(dr);

                    //foreach (string s in objCartListStringSplit)
                    //{
                    //string fname = Request.Cookies["ShoppingCart"]["FirstName"];
                    //string lname = Request.Cookies["ShoppingCart"]["LastName"];

                    int ri = 0;

                    foreach (string item in objCartListStringSplit)
                    {
                        ArrayList colCookies1 = new ArrayList();

                        string[] ss        = item.Split(',');
                        var      BrandName = ss[0];
                        var      Quantity  = int.Parse(ss[1]);
                        var      OfferRate = Convert.ToDouble(ss[2]);
                        var      Size      = ss[3];
                        var      groserid  = ss[4];

                        colCookies1.Add(BrandName);
                        colCookies1.Add(Quantity);
                        colCookies1.Add(OfferRate);
                        colCookies1.Add(Size);
                        colCookies1.Add(groserid);

                        var a = (from ssss in
                                 db.tbl_ItemListDtls
                                 join c in db.tbl_ProductListDtls on ssss.ProductId equals c.ProductId
                                 where ssss.ItemId == int.Parse(BrandName.ToString())
                                 select new { ssss.Image, ssss.BrandName, c.ProductName, ssss.ItemId, OfferRate = OfferRate, Quantity = Quantity, Size = Size, groserid = groserid }).FirstOrDefault();

                        if (a != null)
                        {
                            // DataRow drCurrentRow = null;==================

                            //if (dt.Rows.Count > 0)
                            //{
                            //drCurrentRow = dt.NewRow();=======================================
                            dr = dt.NewRow();
                            //drCurrentRow["RowNumber"] = dt.Rows.Count + 1;==============================
                            dr["RowNumber"] = dt.Rows.Count + 1;
                            //add new row to DataTable
                            //dt.Rows.Add(drCurrentRow);==================================
                            dt.Rows.Add(dr);


                            dt.Rows[ri]["Image"]     = a.Image;
                            dt.Rows[ri]["BrandName"] = a.BrandName;
                            dt.Rows[ri]["Quantity"]  = a.Quantity;
                            dt.Rows[ri]["OfferRate"] = a.OfferRate;
                            dt.Rows[ri]["Size"]      = a.Size;
                            dt.Rows[ri]["ItemId"]    = a.ItemId;
                            dt.Rows[ri]["GrocerId"]  = a.groserid;

                            //dt.Rows[ri]["Column5"] = "";
                            //dt.Rows[ri]["Column6"] = DaaieIsDelete.Text;

                            ri        = ri + 1;
                            quantity1 = quantity1 + int.Parse(Quantity.ToString());
                            double total = double.Parse((Quantity * OfferRate).ToString());
                            total1           = total1 + total;
                            Subtotal         = Subtotal + total;
                            lblSubTotal.Text = total1.ToString();
                            lblQuantity.Text = quantity1.ToString();

                            var ship = (from s in db.tbl_HomeDelChrgs where s.DelyType == "SC " select s).FirstOrDefault();
                            if (ship.Amount >= int.Parse(lblSubTotal.Text))
                            {
                                lblShoppingCost.Text = ship.HomeDelCrhg.ToString();
                            }
                            else
                            {
                                lblShoppingCost.Text = "FREE";
                            }
                            if (lblShoppingCost.Text == "FREE")
                            {
                                lblGrandTotal.Text = Subtotal.ToString();
                            }
                            else
                            {
                                lblGrandTotal.Text = (ship.Amount + int.Parse(lblSubTotal.Text)).ToString();
                            }
                        }
                        //}

                        int m = dt.Rows.Count;

                        ViewState["CurrentTreatmentTable"] = dt;
                        if (dt != null)
                        {
                            GvCardDtl.DataSource = dt;
                            GvCardDtl.DataBind();
                        }
                        else
                        {
                        }

                        //ArrayList colCookies = new ArrayList();
                        //for (int i = 0; i < Request.Cookies.Count; i++)
                        //{

                        //    colCookies.Add(Request.Cookies[i]);

                        //    // string[] arr = text.Split('|');

                        //    //return cart;

                        //}
                    }

                    int h = dt.Rows.Count;
                }
                else
                {
                    ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Your Cart is Empty.')", true);
                }



                //ArrayList colCookies = new ArrayList();
                //for (int i = 0; i < Request.Cookies.Count; i++)
                //{

                //    colCookies.Add(Request.Cookies[i]);
                //    GvCardDtl.DataSource = colCookies;
                //    GvCardDtl.DataBind();
                //}


                //var a = (from s in db.tbl_ItemListDtls
                //         join q in db.tbl_ItemQtyDtls on s.ItemId equals q.ItemId
                //         join p in db.tbl_CartDtls on s.ItemId equals p.ItemId
                //         join r in db.tbl_GrocerRateDtls on q.ItemQtyId equals r.ItemQtyId
                //         //join h in db.tbl_HomeDelChrgs on r.GrocerRateId equals h.GrocerId
                //         //where p.CustomerId == int.Parse(CustId) && p.PaymentStatus == false
                //         select new { s.Image, s.BrandName, r.OfferRate, p.Quantity, p.cartID ,r.GrocerId}).ToList();

                ////var a = (from s in db.ShopCart(int.Parse(CustId)) select s).ToList();

                //GvCardDtl.DataSource = a;
                //GvCardDtl.DataBind();
                //int quantity1 = 0;
                //int Subtotal = 0;


                //for (int i = 0; i < a.Count; i++)
                //{
                //    quantity1 = quantity + int.Parse(a[i].Quantity.ToString());
                //    int total = int.Parse((a[i].Quantity * a[i].OfferRate).ToString());
                //    Subtotal = Subtotal + total;
                //}


                //lblQuantity.Text = quantity.ToString();
                //lblSubTotal.Text = Subtotal.ToString();
                //lblShoppingCost.Text = "FREE";
                //if (lblShoppingCost.Text == "FREE")
                //{
                //    lblGrandTotal.Text = Subtotal.ToString();
                //}
                //else
                //{
                //    lblGrandTotal.Text = lblShoppingCost.Text + Subtotal;

                //}
            }
        }
Ejemplo n.º 3
0
        protected void lbtnRemoveFromCart_Click(object sender, EventArgs e)
        {
            using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext())
            {
                LinkButton  lb    = (LinkButton)sender;
                GridViewRow gvRow = (GridViewRow)lb.NamingContainer;
                int         rowID = gvRow.RowIndex;
                if (ViewState["CurrentTreatmentTable"] != null)
                {
                    DataTable dtt = (DataTable)ViewState["CurrentTreatmentTable"];
                    if (dtt.Rows.Count > 0)
                    {
                        if (gvRow.RowIndex < dtt.Rows.Count)
                        {
                            //Remove the Selected Row data and reset row number
                            dtt.Rows.Remove(dtt.Rows[rowID]);
                            ResetRowID(dt);
                        }
                    }
                    //Store the current data in ViewState for future reference
                    ViewState["CurrentTreatmentTable"] = dtt;
                    //Re bind the GridView for the updated data
                    if (dtt.Rows.Count > 0)
                    {
                        GvCardDtl.DataSource = dtt;
                        GvCardDtl.DataBind();
                    }
                    else
                    {
                        GvCardDtl.DataSource = dtt;
                        GvCardDtl.DataBind();
                        lblnorecordfound.Visible = true;
                    }
                    //int quantity1 = 0;
                    //double Subtotal = 0;
                    //double total1 = 0;
                    lblSubTotal.Text = "0";
                    lblQuantity.Text = "0";
                    string dta = "";
                    foreach (DataRow row in dtt.Rows)
                    {
                        //var Image = row["Image"];
                        var BrandName = row["ItemId"];
                        var Quantity  = row["Quantity"];
                        var OfferRate = row["OfferRate"];
                        var Size      = row["Size"];
                        var Grocerid  = row["GrocerId"];


                        if (dta == "")
                        {
                            dta = BrandName + "," + Quantity + "," + OfferRate + "," + Size + "," + Grocerid;
                        }
                        else
                        {
                            dta = dta + "|" + BrandName + "," + Quantity + "," + OfferRate + "," + Size + "," + Grocerid;
                        }


                        lblSubTotal.Text = (int.Parse(lblSubTotal.Text) + int.Parse(OfferRate.ToString())).ToString();
                        lblQuantity.Text = (int.Parse(lblQuantity.Text) + int.Parse(Quantity.ToString())).ToString();

                        var ship = (from s in db.tbl_HomeDelChrgs where s.DelyType == "SC " select s).FirstOrDefault();
                        if (ship.Amount >= int.Parse(lblSubTotal.Text))
                        {
                            lblShoppingCost.Text = ship.HomeDelCrhg.ToString();
                        }
                        else
                        {
                            lblShoppingCost.Text = "FREE";
                        }
                        if (lblShoppingCost.Text == "FREE")
                        {
                            lblGrandTotal.Text = lblSubTotal.Text;
                        }
                        else
                        {
                            lblGrandTotal.Text = (ship.Amount + int.Parse(lblSubTotal.Text)).ToString();
                        }
                    }
                    Response.Cookies["ShoppingCart"].Value = dta;
                    Session["ShoppingCart"] = dta;

                    //lbtnUpadate.Visible = true;
                    //btnBuyNew.Visible = false;



                    //Request.Cookies["ShoppingCart"].Expires = DateTime.Now.AddDays(-30);

                    ((Site1)Master).BindGvCardDtl();

                    // UpadateCook();
                }
            }
        }
Ejemplo n.º 4
0
        public void BindGvCardDtl()//string CustId
        {
            using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext())
            {
                double quantity1 = 0;
                double Subtotal  = 0;
                //if (Request.Cookies["ShoppingCart"] != null)
                if (Session["ShoppingCart"] != null)
                {
                    //string objCartListString = Request.Cookies["ShoppingCart"].Value.ToString();
                    string objCartListString = (Session["ShoppingCart"]).ToString();
                    if (objCartListString == "")
                    {
                        lblCartValue.Text    = "0";
                        GvCardDtl.DataSource = null;
                        GvCardDtl.DataBind();
                    }
                    else
                    {
                        string[] objCartListStringSplit = objCartListString.Split('|');
                        lblCartValue.Text = objCartListStringSplit.Count().ToString();

                        DataTable dt = new DataTable();
                        DataRow   dr = null;
                        dt.Columns.Add(new DataColumn("RowNumber", typeof(string)));
                        dt.Columns.Add(new DataColumn("Image", typeof(string)));
                        dt.Columns.Add(new DataColumn("BrandName", typeof(string)));
                        dt.Columns.Add(new DataColumn("Quantity", typeof(string)));
                        dt.Columns.Add(new DataColumn("OfferRate", typeof(string)));
                        dt.Columns.Add(new DataColumn("Size", typeof(string)));

                        int ri = 0;

                        foreach (string item in objCartListStringSplit)
                        {
                            ArrayList colCookies1 = new ArrayList();

                            string[] ss        = item.Split(',');
                            var      BrandName = ss[0];
                            var      Quantity  = int.Parse(ss[1]);
                            var      OfferRate = Convert.ToDouble(ss[2]);
                            var      Size      = ss[3];


                            colCookies1.Add(BrandName);
                            colCookies1.Add(Quantity);
                            colCookies1.Add(OfferRate);
                            colCookies1.Add(Size);



                            var a = (from ssss in
                                     db.tbl_ItemListDtls
                                     join c in db.tbl_ProductListDtls on ssss.ProductId equals c.ProductId
                                     where ssss.ItemId == int.Parse(BrandName.ToString())
                                     select new { ssss.Image, ssss.BrandName, c.ProductName, ssss.ItemId, OfferRate = (Quantity * OfferRate), Quantity = Quantity }).FirstOrDefault();

                            if (a != null)
                            {
                                DataRow drCurrentRow = null;

                                //if (dt.Rows.Count > 0)
                                //{
                                drCurrentRow = dt.NewRow();
                                drCurrentRow["RowNumber"] = dt.Rows.Count + 1;

                                //add new row to DataTable
                                dt.Rows.Add(drCurrentRow);

                                dt.Rows[ri]["Image"]     = a.Image;
                                dt.Rows[ri]["BrandName"] = a.BrandName;
                                dt.Rows[ri]["Quantity"]  = a.Quantity;
                                dt.Rows[ri]["OfferRate"] = a.OfferRate;

                                //dt.Rows[ri]["Column5"] = "";
                                //dt.Rows[ri]["Column6"] = DaaieIsDelete.Text;

                                ri = ri + 1;
                                //}
                                quantity1 = double.Parse(Quantity.ToString());
                                double total = double.Parse((quantity1 * OfferRate).ToString());
                                Subtotal         = Subtotal + total;
                                lblQunatity.Text = Subtotal.ToString();
                            }
                            //}


                            GvCardDtl.DataSource = dt;
                            GvCardDtl.DataBind();
                        }
                    }
                }
            }
        }
Ejemplo n.º 5
0
        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);
                }
            }
        }
Ejemplo n.º 6
0
        private void BindGvCardDtl()//string CustId
        {
            using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext())
            {
                int    quantity1 = 0;
                double Subtotal  = 0;
                double total1    = 0;
                if (Request.Cookies["ShoppingCart"] != null)
                {
                    string   objCartListString      = Request.Cookies["ShoppingCart"].Value.ToString();
                    string[] objCartListStringSplit = objCartListString.Split('|');

                    DataTable dt = new DataTable();

                    DataRow dr = null;
                    dt.Columns.Add(new DataColumn("RowNumber", typeof(string)));
                    dt.Columns.Add(new DataColumn("ItemId", typeof(string)));
                    dt.Columns.Add(new DataColumn("Image", typeof(string)));
                    dt.Columns.Add(new DataColumn("BrandName", typeof(string)));
                    dt.Columns.Add(new DataColumn("Quantity", typeof(string)));
                    dt.Columns.Add(new DataColumn("OfferRate", typeof(string)));
                    dt.Columns.Add(new DataColumn("Size", typeof(string)));
                    dt.Columns.Add(new DataColumn("GrocerId", typeof(string)));
                    //dt.Columns.Add(new DataColumn("Column5", typeof(string)));
                    //dt.Columns.Add(new DataColumn("Column6", typeof(string)));

                    //dr = dt.NewRow();
                    ////dr["RowNumber"] = 1;
                    ////dr["Image"] = string.Empty;
                    ////dr["BrandName"] = string.Empty;
                    ////dr["Quantity"] = string.Empty;
                    ////dr["OfferRate"] = string.Empty;
                    ////dr["Column5"] = string.Empty;
                    ////dr["Column6"] = string.Empty;

                    //dt.Rows.Add(dr);

                    //foreach (string s in objCartListStringSplit)
                    //{
                    //string fname = Request.Cookies["ShoppingCart"]["FirstName"];
                    //string lname = Request.Cookies["ShoppingCart"]["LastName"];

                    int ri = 0;

                    foreach (string item in objCartListStringSplit)
                    {
                        ArrayList colCookies1 = new ArrayList();

                        string[] ss = item.Split(',');

                        var BrandName = ss[0];
                        var Quantity  = int.Parse(ss[1]);
                        var OfferRate = Convert.ToDouble(ss[2]);
                        var Size      = ss[3];
                        var grocerId  = ss[4];
                        colCookies1.Add(BrandName);
                        colCookies1.Add(Quantity);
                        colCookies1.Add(OfferRate);
                        colCookies1.Add(Size);
                        colCookies1.Add(grocerId);



                        var a = (from ssss in
                                 db.tbl_ItemListDtls
                                 join c in db.tbl_ProductListDtls on ssss.ProductId equals c.ProductId
                                 where ssss.ItemId == int.Parse(BrandName.ToString())
                                 select new { ssss.Image, ssss.BrandName, c.ProductName, ssss.ItemId, OfferRate = OfferRate, Quantity = Quantity, Size = Size, grocerId = grocerId }).FirstOrDefault();

                        if (a != null)
                        {
                            DataRow drCurrentRow = null;

                            //if (dt.Rows.Count > 0)
                            //{
                            drCurrentRow = dt.NewRow();
                            drCurrentRow["RowNumber"] = dt.Rows.Count + 1;

                            //add new row to DataTable
                            dt.Rows.Add(drCurrentRow);

                            dt.Rows[ri]["Image"]     = a.Image;
                            dt.Rows[ri]["ItemId"]    = a.ItemId;
                            dt.Rows[ri]["BrandName"] = a.BrandName;
                            dt.Rows[ri]["Quantity"]  = a.Quantity;
                            dt.Rows[ri]["OfferRate"] = a.OfferRate;
                            dt.Rows[ri]["Size"]      = a.Size;
                            dt.Rows[ri]["GrocerId"]  = a.grocerId;

                            //dt.Rows[ri]["Column5"] = "";
                            //dt.Rows[ri]["Column6"] = DaaieIsDelete.Text;

                            ri        = ri + 1;
                            quantity1 = quantity1 + int.Parse(Quantity.ToString());
                            double total = double.Parse((Quantity * OfferRate).ToString());
                            total1           = total1 + total;
                            Subtotal         = Subtotal + total;
                            lblSubTotal.Text = total1.ToString();
                            lblQuantity.Text = quantity1.ToString();

                            var ship = (from s in db.tbl_HomeDelChrgs where s.DelyType == "SC " select s).FirstOrDefault();
                            if (ship.Amount >= int.Parse(lblSubTotal.Text))
                            {
                                lblShoppingCost.Text = ship.Amount.ToString();
                            }
                            else
                            {
                                lblShoppingCost.Text = "FREE";
                            }
                            if (lblShoppingCost.Text == "FREE")
                            {
                                lblGrandTotal.Text = Subtotal.ToString();
                            }
                            else
                            {
                                lblGrandTotal.Text = (ship.Amount + int.Parse(lblSubTotal.Text)).ToString();
                            }
                        }
                        //}


                        GvCardDtl.DataSource = dt;
                        GvCardDtl.DataBind();
                    }
                }
            }
        }