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();
}
}
}
