public void ddlSubCategory_SelectedIndexChanged(object sender, EventArgs e) { using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { var pro = (from a in db.tbl_ProductListDtls where a.IsDelete == false & a.SubCatId == int.Parse(ddlSubCategory.SelectedItem.Value) select new { a.ProductId, a.ProductName }).ToList(); ddlProduct.DataSource = pro; ddlProduct.DataTextField = "ProductName"; ddlProduct.DataValueField = "ProductId"; ddlProduct.DataBind(); db.Dispose(); ddlProduct.Items.Insert(0, new ListItem("--Select Product--", "0")); //var value = int.Parse(ddlProduct.SelectedItem.Value); //var value = int.Parse(ddlSubCategory.SelectedItem.Value); //var getData = (from s in db.stockItemList(value) select s).ToList(); //gvItemList.DataSource = getData; //gvItemList.DataBind(); //gvItemList.Visible = true; } }
protected void btnPrepared_click(object sender, EventArgs e) { using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { string OderID = ((Label)((Button)sender).Parent.Parent.FindControl("lblConfirmorderId")).Text.ToString(); int lblGrocerId = Convert.ToInt32(((Label)((Button)sender).Parent.Parent.FindControl("lblGrocerId")).Text.ToString()); int lblCustID = Convert.ToInt32(((Label)((Button)sender).Parent.Parent.FindControl("lblCustID")).Text.ToString()); Tbl_DeliveryAction t = new Tbl_DeliveryAction(); var ft = (from d in db.Tbl_DeliveryActions where d.OrderId == OderID && d.ActFlag == "A" && d.Status == "A" && d.Type == "G" select d).FirstOrDefault(); if (ft != null) { ft.Status = "P"; db.SubmitChanges(); } t.OrderId = OderID; t.GrocerId = lblGrocerId; t.CustId = lblCustID; t.ActFlag = "P"; t.Status = "P"; t.ActByCategory = int.Parse(Session["CategoryId"].ToString()); t.ActDate = DateTime.Now; t.Isdelete = false; t.Type = "G"; db.Tbl_DeliveryActions.InsertOnSubmit(t); db.SubmitChanges(); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "str", "alert('Order is Prepared......');", true); BindData(); } }
protected void btnFreez_Click(object sender, EventArgs e) { using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { Button clickedButton = (Button)sender; if (clickedButton.Text == "Freez") { clickedButton.BackColor = Color.Red; var lblItemId = ((Label)(((Button)sender).Parent.Parent.FindControl("lblItemID"))).Text; var a = (from s in db.tbl_ItemQtyDtls where s.ItemQtyId == int.Parse(lblItemId.ToString()) select s).FirstOrDefault(); a.IsShow = false; db.SubmitChanges(); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "str", "alert('Item Freezed');", true); Button clickedButton1 = (Button)sender; clickedButton1.Text = "Show"; clickedButton1.Enabled = true; } else if (clickedButton.Text == "Show") { clickedButton.BackColor = Color.Green; var lblItemId = ((Label)(((Button)sender).Parent.Parent.FindControl("lblItemID"))).Text; var a = (from s in db.tbl_ItemQtyDtls where s.ItemQtyId == int.Parse(lblItemId.ToString()) select s).FirstOrDefault(); a.IsShow = true; db.SubmitChanges(); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "str", "alert('Item Shows');", true); Button clickedButton1 = (Button)sender; clickedButton1.Text = "Freez"; clickedButton1.Enabled = true; } } }
protected void BindGrid() { using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { var Subcat = (from s in db.tbl_SubCategoryDtls where s.IsDelete == false & s.CatId == int.Parse(ddlCate.SelectedItem.Value) select new { s.SubCatId, s.SubCatName, s.Image }).ToList(); if (Subcat.Count != 0) { Gvsubcategory.DataSource = Subcat; Gvsubcategory.DataBind(); Gvsubcategory.Visible = true; } else { lblnorecordfound.Visible = true; } } }
protected void btnAddSubcat_Click(Object sender, EventArgs e) { using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { string imgpath = System.IO.Path.GetFileName(FileUploadSubcat.PostedFile.FileName); // FileUploadSubcat.SaveAs("D:/Project/GrocerApplication/GrocerApplication/Images/Sub_catimg/" + (imgpath)); // FileUploadSubcat.SaveAs("D:/WIUMS PROJECT/GrocerApplication_Vesion2012/Images/Sub_catimg/" + (imgpath)); if (imgpath != "") { FileUploadSubcat.SaveAs(Server.MapPath("~/Images/Sub_catimg/" + (imgpath))); } tbl_SubCategoryDtl a = new tbl_SubCategoryDtl(); a.SubCatName = txtSubcate.Text; if (imgpath != "") { a.Image = ("/Images/Sub_catimg/" + (imgpath)); } a.CatId = Convert.ToInt32(ddlCate.Text); a.IsDelete = false; if (chkRegular.Checked == true) { a.RegularItems = true; } else { a.RegularItems = false; } db.tbl_SubCategoryDtls.InsertOnSubmit(a); db.SubmitChanges(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Sub-Category Added Successfully.....!')", true); BindGrid(); chkRegular.Checked = false; } }
protected void txtsearchproduct_TextChanged(object sender, EventArgs e) { // List<tbl_ItemListDtl> clientsList = new List<tbl_ItemListDtl>(); using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { // var data = db.tbl_ItemListDtls.Where(c => (c.BrandName.ToString() + " ( " + c.Details + ") ").Contains(txtSearchProduct.Text)).OrderBy(c => c.BrandName).FirstOrDefault(); //int Productidbytxt = int.Parse(data.ProductId.ToString()); var data = db.tbl_ItemListDtls.Where(c => (c.BrandName.ToString() + " ( " + c.Details + ") ").Contains(txtSearchProduct.Text)).OrderBy(c => c.BrandName).FirstOrDefault(); int Productidbytxt = int.Parse(data.ItemId.ToString()); var get = (from s in db.tbl_GrocerRateDtls join a in db.tbl_ItemQtyDtls on s.ItemQtyId equals a.ItemQtyId join b in db.tbl_ItemListDtls on a.ItemId equals b.ItemId join c in db.tbl_ProductListDtls on b.ProductId equals c.ProductId where b.ItemId == int.Parse(Productidbytxt.ToString()) select new { ItemName = (b.BrandName + " " + c.ProductName), a.MRP, s.GrocerRateId, b.Image, Qty = (a.Quantity + " " + a.Unit), s.OfferRate, s.Discount }).ToList(); gvItemRate.DataSource = get; gvItemRate.DataBind(); //Response.Redirect("~/frmAddContentToCart.aspx?ProdId=" + Productidbytxt); } }
protected void ddlproducts_SelectedIndexChanged(object sender, EventArgs e) { using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { if (ddlProduct.SelectedItem.Text == "--Select-Products---") { } else { int grocer = int.Parse(Session["GrocId"].ToString()); var item = (from s in db.tbl_GrocerRateDtls join a in db.tbl_ItemQtyDtls on s.ItemQtyId equals a.ItemQtyId join b in db.tbl_ItemListDtls on a.ItemId equals b.ItemId join c in db.tbl_ProductListDtls on b.ProductId equals c.ProductId where b.IsDelete == false // & s.OfferRate == null & b.ProductId == int.Parse(ddlProduct.SelectedItem.Value) & s.GrocerId == int.Parse(grocer.ToString()) select new { ItemName = (b.BrandName + " " + c.ProductName), a.MRP, s.GrocerRateId, b.Image, Qty = (a.Quantity + " " + a.Unit), s.OfferRate, s.Discount }).ToList(); gvItemRate.DataSource = item; gvItemRate.DataBind(); Panel1.Visible = true; } } }
protected void showItemRateGrid() { using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { if (Session["GrocId"] != null) { int grocer = int.Parse(Session["GrocId"].ToString()); var get = (from s in db.tbl_GrocerRateDtls join a in db.tbl_ItemQtyDtls on s.ItemQtyId equals a.ItemQtyId join b in db.tbl_ItemListDtls on a.ItemId equals b.ItemId join c in db.tbl_ProductListDtls on b.ProductId equals c.ProductId where s.GrocerId == int.Parse(grocer.ToString()) select new { ItemName = (b.BrandName + " " + c.ProductName), a.MRP, s.GrocerRateId, b.Image, Qty = (a.Quantity + " " + a.Unit), s.OfferRate, s.Discount }).ToList(); if (get.Count != 0) { gvItemRate.DataSource = get; gvItemRate.DataBind(); } else { lblnorecordfound.Visible = true; } } } }
protected void ddlproducts_SelectedIndexChanged(object sender, EventArgs e) { using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { var value = int.Parse(ddlProduct.SelectedItem.Value); //var getData = (from s in db.stockItemList(value) select s).ToList(); var getData = (from s in db.stockItemList(value) select s).ToList(); if (getData.Count != 0) { gvItemList.DataSource = getData; gvItemList.DataBind(); gvItemList.Visible = true; PnlShowGrid.Visible = true; } else { gvItemList.DataSource = null; gvItemList.DataBind(); lblnorecordfound.Visible = true; PnlShowGrid.Visible = false; } } }
protected void lbtnUpdateAddress_Click(object sender, EventArgs e) { using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { int custid = int.Parse(Session["CustId"].ToString()); var adrress = (from s in db.Tbl_CustDeliveryAddressDtls where s.CustId == custid select s).FirstOrDefault(); adrress.CustFullName = txtFName.Text; adrress.CustLName = txtLName.Text; adrress.MobileNo = txtMobileNo.Text; adrress.AltMobileNo = txtALTMobile.Text; adrress.EmailId = txtEMail.Text; if (ddlState.SelectedItem.Value != "-----Select-----") { adrress.StateId = int.Parse(ddlState.SelectedItem.Value); } if (ddlCity.SelectedItem.Value != "-----Select-----") { adrress.CityId = int.Parse(ddlCity.SelectedItem.Value); } adrress.Address = txtAddress.Text; adrress.ZipCode = int.Parse(txtZip.Text); db.SubmitChanges(); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "str", "alert('Address Updated Successfully');", true); } }
protected void btnHomeDelivery_click(object sender, EventArgs e) { using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { var chkd = (from s in db.tbl_HomeDelChrgs where s.GrocerId == int.Parse(Session["GrocId"].ToString()) && s.IsDelete == false select s).FirstOrDefault(); if (chkd != null) { chkd.HomeDelCrhg = txtHomedelChrg.Text; chkd.GrocerId = int.Parse(Session["GrocId"].ToString()); chkd.IsDelete = false; db.SubmitChanges(); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "str", "alert('Home Delivery Charges Updated');", true); BindHomeDelChages(); } else { tbl_HomeDelChrg tb = new tbl_HomeDelChrg(); //tb.HomeDelCrhg = Convert.ToInt16(txtHomedelChrg.Text); tb.HomeDelCrhg = txtHomedelChrg.Text; tb.GrocerId = int.Parse(Session["GrocId"].ToString()); tb.IsDelete = false; db.tbl_HomeDelChrgs.InsertOnSubmit(tb); db.SubmitChanges(); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "str", "alert('Home Delivery Charges Saved Successfully');", true); BindHomeDelChages(); } } }
protected void btnAddItem_Click(Object sender, EventArgs e) { using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { string imgpath = System.IO.Path.GetFileName(FileUploaditem.PostedFile.FileName); //FileUploaditem.SaveAs("D:/Project/GrocerApplication/GrocerApplication/Images/Itemimg/" + (imgpath)); //FileUploaditem.SaveAs("D:/WIUMS PROJECT/GrocerApplication_Vesion2012/Images/Itemimg/" + (imgpath)); FileUploaditem.SaveAs(Server.MapPath("~/Images/Itemimg/" + (imgpath))); tbl_ItemListDtl z = new tbl_ItemListDtl(); z.BrandName = txtbrandNm.Text; z.Details = txtDetails.Text; z.Image = ("/Images/Itemimg/" + (imgpath)); z.ProductId = Convert.ToInt32(ddlProduct.Text); z.IsDelete = false; z.RegularItems = true; db.tbl_ItemListDtls.InsertOnSubmit(z); db.SubmitChanges(); //ScriptManager.(Page, Page.GetType(), "str", "alert(Items Added Successfully!);", true); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Items Added Successfully.....!')", true); Bindgrid(); } }
protected void btnAddcat_Click(Object sender, EventArgs e) { using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { string imgpath = System.IO.Path.GetFileName(FileUploadCat.PostedFile.FileName); //FileUploadCat.SaveAs("D:/Project/GrocerApplication/GrocerApplication/Images/Categoryimg/" + (imgpath)); // FileUploadCat.SaveAs("D:/WIUMS PROJECT/GrocerApplication_Vesion2012/Images/Categoryimg/" + (imgpath)); if (imgpath != "") { FileUploadCat.SaveAs(Server.MapPath("~/Images/HeaderImage/" + (imgpath))); } tbl_HeaderImage s = new tbl_HeaderImage(); //s.CategoryName = txtAddCat.Text; if (imgpath != "") { s.HeaderImage = ("/Images/HeaderImage/" + (imgpath)); } s.IsDelete = false; //s.MarathiCatagory = txtMarathicat.Text; db.tbl_HeaderImages.InsertOnSubmit(s); db.SubmitChanges(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Header Image Added Successfully.....!')", true); BindCategory(); } }
protected void Discount_click(object sender, EventArgs e) { using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { if (gvItemRate.Rows.Count > 0) { for (int i = 0; i < gvItemRate.Rows.Count; i++) { string OfferRate = (((TextBox)gvItemRate.Rows[i].FindControl("txtFinalOfferRate")).Text.ToString()); if (OfferRate != "") { string Discount = (((TextBox)gvItemRate.Rows[i].FindControl("txtDiscount")).Text.ToString()); if (Discount != "") { int grocerRateID = int.Parse(((Label)gvItemRate.Rows[i].FindControl("lblGrocerId")).Text.ToString()); var check = (from s in db.tbl_GrocerRateDtls where s.GrocerRateId == int.Parse(grocerRateID.ToString()) select s).FirstOrDefault(); check.OfferRate = Convert.ToInt32(OfferRate.ToString()); check.Discount = Convert.ToInt32(Discount.ToString()); check.IsDelete = false; db.SubmitChanges(); } } } } ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Item Rate Added Successfully.....!')", true); } }
protected void Bind() { //int RegID = Convert.ToInt32(Session["RegId"]); int RegID = Convert.ToInt32(Session["DeliBoyID"]); using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { //var z = (from s in db.RegistrationInfos where s.RegId == RegID select s).FirstOrDefault(); //int DeliveryBoyID = Convert.ToInt32(z.UserID); var get = (from s in db.tbl_DeliveryBoy_Odrs where s.IsDelete == false && s.IsPick == true && s.Deli_BoyID == RegID select new { s.Cust_Address, s.Cust_Mob, s.Paymet_Method, s.Total_Amount, s.Cust_Name, s.Deli_ID, s.ConfirmOdrID }).ToList(); if (get.Count != 0) { DlDeliveryBoy.DataSource = get; DlDeliveryBoy.DataBind(); } else { lblnorecordfound.Visible = true; Label4.Visible = false; } } }
protected void ddlproducts_SelectedIndexChanged(object sender, EventArgs e) { using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { var value = int.Parse(ddlProduct.SelectedItem.Value); var get = (from s in db.tbl_GrocerRateDtls join a in db.tbl_ItemQtyDtls on s.ItemQtyId equals a.ItemQtyId join b in db.tbl_ItemListDtls on a.ItemId equals b.ItemId join c in db.tbl_ProductListDtls on b.ProductId equals c.ProductId where b.ProductId == int.Parse(value.ToString()) && s.GrocerId == int.Parse(Session["GrocId"].ToString()) select new // s.OfferRate != null && s.Discount == null { ItemName = (b.BrandName + " " + c.ProductName), a.MRP, s.GrocerRateId, b.Image, //Qty = (a.Quantity + " " + a.Unit), a.Quantity, s.OfferRate }).ToList(); if (get.Count != 0) { gvItemRate.DataSource = get; gvItemRate.DataBind(); PnlShowGrid.Visible = true; } else { gvItemRate.DataSource = null; gvItemRate.DataBind(); lblnorecordfound.Visible = true; } } }
protected void BindData() { if (Session["GrocId"] != null) { int GrocerID = int.Parse((Session["GrocId"]).ToString()); using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { var get = (from s in db.SPPendingOdr(GrocerID) join p in db.Tbl_DeliveryActions on s.ConfirmOdrID equals p.OrderId where p.ActFlag == "C" && p.Status == "C" && s.GrocerId == GrocerID && p.Type == "G" select new { s.CustId, s.ConfirmOdrID, s.name, s.Address, s.MobileNo, s.EmailId, s.Toatal_price }).ToList(); if (get.Count != 0) { gvCompleteorders.DataSource = get; gvCompleteorders.DataBind(); } else { gvCompleteorders.DataSource = null; gvCompleteorders.DataBind(); lblnorecordfound.Visible = true; } } } }
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; //} } }
protected void showdata() { using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { var check = (from s in db.RegistrationInfos join a in db.mstGrocerDtls on s.UserID equals a.GrocerId where s.CategoryId == 2 && a.IsDelete == false select new { a.Email, a.MobNo, a.ShopName, a.ShopOwnAdhar, a.ShopOwnName, a.ShopRegNo, a.ShopAddr, a.AreaCode, a.GrocerId, a.image }).ToList(); if (check != null) { gvShop.DataSource = check; gvShop.DataBind(); } else { lblnorecordfound.Visible = true; } //if (check != null) //{ // txtEmailId.Text = check.Email; // txtMobNo.Text = check.MobNo; // txtSName.Text = check.ShopName; // txtOwnAdhar.Text = check.ShopOwnAdhar; // txtOwnNm.Text = check.ShopOwnAdhar; // txtShopAddr.Text = check.ShopAddr; // txtSRegNo.Text = check.ShopRegNo; // //bindArea(); // ddlArea.SelectedIndex = ddlArea.Items.IndexOf(ddlArea.Items.FindByValue(check.AreaCode.ToString())); //} } }
protected void btnDelivered_Click(object sender, EventArgs e) { using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { int DeliBoyID = int.Parse((Session["DeliBoyID"]).ToString()); string OderID = ((Label)((Button)sender).Parent.Parent.FindControl("lblConfirmorderId")).Text.ToString(); int lblGrocerId = Convert.ToInt32(((Label)((Button)sender).Parent.Parent.FindControl("lblGrocerId")).Text.ToString()); //int lblCustID = Convert.ToInt32(((Label)((Button)sender).Parent.Parent.FindControl("lblCustID")).Text.ToString()); var so = (from s in db.tbl_DeliveryBoy_Odrs where s.ConfirmOdrID == OderID && s.GrocerId == lblGrocerId && s.Flag == "P" select s).FirstOrDefault(); if (so != null) { so.Flag = "C"; db.SubmitChanges(); } var ft = (from d in db.Tbl_DeliveryActions where d.OrderId == OderID && d.ActFlag == "A" && d.Status == "P" && d.GrocerId == DeliBoyID select d).FirstOrDefault(); if (ft != null) { ft.Status = "C"; db.SubmitChanges(); } var tb = (from d in db.Tbl_DeliveryActions where d.OrderId == OderID && d.ActFlag == "P" && d.Status == "P" && d.GrocerId == DeliBoyID select d).FirstOrDefault(); if (tb != null) { tb.Status = "C"; db.SubmitChanges(); } var charges = (from s in db.mst_DeliveryBoyCharges where s.IsDelete == false orderby s.Date descending select s).FirstOrDefault(); var tbt = (from d in db.Tbl_DeliveryActions where d.OrderId == OderID && d.ActFlag == "C" && d.Status == "C" && d.GrocerId == DeliBoyID select d).FirstOrDefault(); //if (tbt == null) //{ Tbl_DeliveryAction t = new Tbl_DeliveryAction(); t.OrderId = OderID; t.GrocerId = DeliBoyID; //t.CustId = lblCustID; t.ActFlag = "C"; t.Status = "C"; t.ActByCategory = int.Parse(Session["CategoryId"].ToString()); t.ActDate = DateTime.Now; t.Type = "D "; t.Isdelete = false; if (charges != null) { t.drDeliCharges = charges.Rate; } db.Tbl_DeliveryActions.InsertOnSubmit(t); db.SubmitChanges(); //} PanelDetail.Visible = false; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "str", "alert('Order Accept.);", true); BindData(); } }
private void MyAddress() { using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { if (Session["CustId"] != null) { int custid = int.Parse(Session["CustId"].ToString()); var adrress = (from s in db.Tbl_CustDeliveryAddressDtls where s.CustId == custid select s).FirstOrDefault(); txtFName.Text = adrress.CustFullName; txtLName.Text = adrress.CustLName; txtMobileNo.Text = adrress.MobileNo; txtALTMobile.Text = adrress.AltMobileNo; txtEMail.Text = adrress.EmailId; txtAddress.Text = adrress.Address; txtZip.Text = adrress.ZipCode.ToString(); if (adrress.StateId != null) { ddlState.SelectedValue = adrress.StateId.ToString(); } if (adrress.CityId != null) { ddlCity.SelectedValue = adrress.CityId.ToString(); } } } }
protected void BindCategory() { using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { var getData = (from s in db.mstCategories where s.IsDelete == false select new { s.CatId, CategoryName = s.CategoryName, s.Image, s.MarathiCatagory }).ToList(); if (getData.Count != 0) { Gvcategory.DataSource = getData; Gvcategory.DataBind(); Gvcategory.Visible = true; } else { lblnorecordfound.Visible = true; } } }
private void BindHomeDelChages() { using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { var a = (from s in db.tbl_HomeDelChrgs where s.GrocerId == 9 && s.IsDelete == false select new { s.Id, s.HomeDelCrhg }).ToList(); if (a.Count != 0) { //gvHomeDel.DataSource = a; //gvHomeDel.DataBind(); //GridView1.DataSource = a; //GridView1.DataBind(); //GridView2.DataSource = a; //GridView2.DataBind(); //GridView3.DataSource = a; //GridView3.DataBind(); GridView4.DataSource = a; GridView4.DataBind(); //GridView5.DataSource = a; //GridView5.DataBind(); } } }
private void BindInformation() { //if (Request.QueryString["CustId"] != null) if (Session["CustId"] != null) { using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { int custid = int.Parse(Session["CustId"].ToString()); var name = (from s in db.mstCustomerDtls join a in db.Tbl_CustDeliveryAddressDtls on s.CustId equals a.CustId where s.CustId == custid select new { s.CustName, s.CustLName, a.MobileNo, a.AltMobileNo, a.Address, a.ZipCode, a.CityId, a.StateId, a.EmailId }).FirstOrDefault(); if (name != null) { txtFName.Text = name.CustName; txtLName.Text = name.CustLName; txtMobileNo.Text = name.MobileNo; txtALTMobile.Text = name.AltMobileNo; txtAddress.Text = name.Address; txtZip.Text = name.ZipCode.ToString(); txtEMail.Text = name.EmailId; ddlState.SelectedValue = name.StateId.ToString(); ddlCity.SelectedValue = name.CityId.ToString(); } } } }
protected void btnDone_Click(object sender, EventArgs e) { if (true) { using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { foreach (GridViewRow gr in gvAcceptordersList.Rows) { //int custordid = int.Parse(Request.QueryString["custeOrdId"]); CheckBox chk = gr.FindControl("Check") as CheckBox; //Label lblcartID = gr.FindControl("lblcartID") as Label; Label lblGrocerId = gr.FindControl("lblGrocerId") as Label; Label lblCustOrdId = gr.FindControl("lblConfirmorderId") as Label; Label lblCustID = gr.FindControl("lblCustID") as Label; if (chk.Checked == true) { int GrocerID = int.Parse((Session["GrocId"]).ToString()); var so = (from s in db.tbl_orderConfirms where s.ConfirmOdrID == lblCustOrdId.Text && s.GrocerId == GrocerID select s).FirstOrDefault(); if (so != null) { so.Complt_Odr = "A"; db.SubmitChanges(); } AcceptItemList ac = new AcceptItemList(); ac.GrocerId = int.Parse(lblGrocerId.Text); ac.CustorderId = lblCustOrdId.Text; ac.CustomerId = int.Parse(lblCustID.Text); ac.Isdelete = false; db.AcceptItemLists.InsertOnSubmit(ac); db.SubmitChanges(); // var b = (from s in db.tbl_orderConfirms where s.ConfirmOdrID == lblCustOrdId.Text select new { s.CustOrdId}).FirstOrDefault(); Tbl_DeliveryAction t = new Tbl_DeliveryAction(); t.OrderId = lblCustOrdId.Text; t.GrocerId = int.Parse(lblGrocerId.Text); t.CustId = int.Parse(lblCustID.Text); t.ActFlag = "A"; t.Status = "A"; t.ActByCategory = int.Parse(Session["CategoryId"].ToString()); t.ActDate = DateTime.Now; t.Isdelete = false; t.Type = "G"; db.Tbl_DeliveryActions.InsertOnSubmit(t); db.SubmitChanges(); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "str", "alert('Items Verified......');", true); } } } } BindData(); }
protected void bindGrandTotal(string CustId) { using (dbDatabaseDataDataContext db1 = new dbDatabaseDataDataContext()) { var GrandTotal = (from s in db1.spCartGTotal(int.Parse(CustId.ToString())) select new { s.Total }).FirstOrDefault(); lblSubTotal.Text = GrandTotal.Total.ToString(); } }
protected void gvItemRate_RowEditing(object sender, GridViewEditEventArgs e) { using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { if (ddlProduct.SelectedItem.Text == "--Select-Products---") { if (this.gvItemRate.EditIndex == -1) { this.gvItemRate.EditIndex = e.NewEditIndex; GridViewRow currentRow = this.gvItemRate.Rows[e.NewEditIndex]; Label gocerid = currentRow.FindControl("lblGrocerId") as Label; int grocer = int.Parse(Session["GrocId"].ToString()); gvItemRate.EditIndex = e.NewEditIndex; var item = (from s in db.tbl_GrocerRateDtls join a in db.tbl_ItemQtyDtls on s.ItemQtyId equals a.ItemQtyId join b in db.tbl_ItemListDtls on a.ItemId equals b.ItemId join c in db.tbl_ProductListDtls on b.ProductId equals c.ProductId where b.IsDelete == false & s.OfferRate == null // & b.ProductId == int.Parse(ddlProduct.SelectedItem.Value) & s.GrocerId == int.Parse(grocer.ToString()) //& s.GrocerRateId == int.Parse(gocerid.Text) select new { ItemName = (b.BrandName + " " + c.ProductName), a.MRP, s.GrocerRateId, b.Image, Qty = (a.Quantity + " " + a.Unit), s.OfferRate, s.Discount }).ToList(); gvItemRate.DataSource = item; gvItemRate.DataBind(); } } else { int grocer = int.Parse(Session["GrocId"].ToString()); //NewEditIndex property used to determine the index of the row being edited. gvItemRate.EditIndex = e.NewEditIndex; var item = (from s in db.tbl_GrocerRateDtls join a in db.tbl_ItemQtyDtls on s.ItemQtyId equals a.ItemQtyId join b in db.tbl_ItemListDtls on a.ItemId equals b.ItemId join c in db.tbl_ProductListDtls on b.ProductId equals c.ProductId where b.IsDelete == false // & s.OfferRate == null & b.ProductId == int.Parse(ddlProduct.SelectedItem.Value) & s.GrocerId == int.Parse(grocer.ToString()) select new { ItemName = (b.BrandName + " " + c.ProductName), a.MRP, s.GrocerRateId, b.Image, Qty = (a.Quantity + " " + a.Unit), s.OfferRate, s.Discount }).ToList(); gvItemRate.DataSource = item; gvItemRate.DataBind(); } } }
protected void BindData() { if (Session["DeliBoyID"] != null) { int DeliBoyID = int.Parse((Session["DeliBoyID"]).ToString()); using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { //var get = (from s in db.SPPendingOdr(DeliBoyID) // join p in db.Tbl_DeliveryActions on s.ConfirmOdrID equals p.OrderId // where p.ActFlag == "P" && p.Status == "P" && p.GrocerId == DeliBoyID && p.Type == "D" // select new // { // s.CustId, // s.ConfirmOdrID, // s.name, // s.Address, // s.MobileNo, // s.EmailId, // s.Toatal_price, // s.GrocerId // }).ToList(); //if (get.Count != 0) //{ // gvCordersList.DataSource = get; // gvCordersList.DataBind(); //} //else //{ // gvCordersList.DataSource = null; // gvCordersList.DataBind(); // lblnorecordfound.Visible = true; //} var gtf = (from s in db.tbl_DeliveryBoy_Odrs where s.Flag == "P" && s.Deli_BoyID == DeliBoyID select new { s.ConfirmOdrID, s.Cust_Address, s.Cust_Mob, s.Cust_Name, s.CustOdr_ID, s.Deli_ID, s.GrocerId, s.Paymet_Method, s.Total_Amount }).ToList(); if (gtf.Count != 0) { gvAcceptordersList.DataSource = gtf; gvAcceptordersList.DataBind(); } else { gvAcceptordersList.DataSource = null; gvAcceptordersList.DataBind(); lblnorecordfound.Visible = true; } } } }
protected void btnRegister_click(Object sender, EventArgs e) { using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { if (FileUpload1.PostedFile != null) { string imgpath = System.IO.Path.GetFileName(FileUpload1.PostedFile.FileName); //string imgpath = Server.MapPath("/rImg"); if (imgpath != "") { FileUpload1.SaveAs(Server.MapPath("~/Images/GrocerImage/" + (imgpath))); } //FileUpload1.SaveAs(imgpath + "/" + FileUpload1.FileName); mstGrocerDtl g = new mstGrocerDtl(); //var g = (from s in db.mstGrocerDtls where s.GrocerId == int.Parse(Session["GrocId"].ToString()) select s).FirstOrDefault(); if (imgpath != "") { g.image = ("/Images/GrocerImage/" + (imgpath)); } g.AreaCode = int.Parse(ddlArea.Text); g.ShopName = txtSName.Text; g.ShopRegNo = txtSRegNo.Text; g.ShopAddr = txtShopAddr.Text; g.ShopOwnName = txtOwnNm.Text; g.MobNo = txtMobNo.Text; g.Email = txtEmailId.Text; g.ShopOwnAdhar = txtOwnAdhar.Text; g.BankAccNumber = txtAccountNo.Text; g.IFSCcode = txtIFSCcode.Text; // g.image = ("GrocerImg/" + FileUpload1.FileName); g.IsDelete = false; // g.Lattitude = null; //g.Longitude = null; //db.mstGrocerDtls.InsertOnSubmit(g); db.SubmitChanges(); RegistrationInfo d = new RegistrationInfo(); d.RegistrationDateTime = DateTime.Now; d.CategoryId = 2; d.MobileNo = txtMobNo.Text; d.Password = txtpass.Text; d.UserID = g.GrocerId; d.Isdelete = false; //db.RegistrationInfos.InsertOnSubmit(d); db.SubmitChanges(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Registration Successfully')", true); //Response.Redirect("GrocerProfile.aspx"); pnlAddShop.Visible = false; Panel2.Visible = true; showdata(); } } }
protected void btnRegister_click(Object sender, EventArgs e) { using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { if (FileUpload1.PostedFile != null) { string imgpath = System.IO.Path.GetFileName(FileUpload1.PostedFile.FileName); //string imgpath = Server.MapPath("/rImg"); if (imgpath != "") { FileUpload1.SaveAs(Server.MapPath("~/Images/DeliveryBoyImage/" + (imgpath))); } //FileUpload1.SaveAs(imgpath + "/" + FileUpload1.FileName); mstDeliveryBoyDtl g = new mstDeliveryBoyDtl(); if (imgpath != "") { g.image = ("/Images/GrocerImage/" + (imgpath)); } g.AreaCode = int.Parse(ddlArea.Text); g.DeliverBoyName = txtSName.Text; g.DeliverBoyRegNo = txtSRegNo.Text; g.DeliverBoyAddr = txtShopAddr.Text; //g. = txtOwnNm.Text; g.MobNo = txtMobNo.Text; g.Email = txtEmailId.Text; g.DeliverBoyOwnAdhar = txtOwnAdhar.Text; g.BankAccNo = txtAccountNo.Text; g.IFSCcode = txtIFSCcode.Text; // g.image = ("GrocerImg/" + FileUpload1.FileName); g.IsDelete = false; // g.Lattitude = null; //g.Longitude = null; db.mstDeliveryBoyDtls.InsertOnSubmit(g); db.SubmitChanges(); RegistrationInfo d = new RegistrationInfo(); d.RegistrationDateTime = DateTime.Now; d.CategoryId = 4; d.MobileNo = txtMobNo.Text; d.Password = txtpass.Text; d.UserID = g.DeliveryBoyId; d.Isdelete = false; db.RegistrationInfos.InsertOnSubmit(d); db.SubmitChanges(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Registration Successfully')", true); pnlAddShop.Visible = false; pnlgrid.Visible = true; showdata(); } } }