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