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; } } } }
protected void BindData() { if (Session["GrocId"] != null) { //int GrocerID = int.Parse(Session["GrocId"].ToString()); int GrocerID = int.Parse((Session["GrocId"]).ToString()); using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { var get = (from s in db.SPPendingOdr(GrocerID) select new { s.CustId, s.ConfirmOdrID, s.name, s.Address, s.MobileNo, s.EmailId, s.Toatal_price //s.CustOrdId, //s.CustFullName, //s.Address, //s.Delivery_Date, //s.Odr_status, //s.Toatal_price, //s.GrocerId, //s.CustId, //s.complt_Odr, //s.MobileNo, //s.EmailId }).ToList(); if (get.Count != 0) { gvorders.DataSource = get; gvorders.DataBind(); } else { gvorders.DataSource = null; gvorders.DataBind(); lblnorecordfound.Visible = true; } } } }
protected void BindData() { if (Session["GrocId"] != null) { int GrocerID = int.Parse((Session["GrocId"]).ToString()); using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { var get1 = (from s in db.SPPendingOdr(GrocerID) where s.Complt_Odr == "S" && s.GrocerId == GrocerID select new { s.CustId, s.ConfirmOdrID, s.name, s.Address, s.MobileNo, s.EmailId, s.Toatal_price, s.GrocerId }).ToList(); if (get1.Count != 0) { gvAcceptordersList.DataSource = get1; gvAcceptordersList.DataBind(); } else { gvAcceptordersList.DataSource = null; gvAcceptordersList.DataBind(); lblnorecordfound.Visible = true; btnDone.Visible = false; } } } }