public ActionResult CodeRetrival()
{
try
{
if (Session["UserID"] == null)
{
return(RedirectToAction("Index", "Home"));
}
Chatpata_dabbaEntities1 Entity = new Chatpata_dabbaEntities1();
DailyOrder DO = new DailyOrder();
var dbcode = Entity.DailyStatusChange().LastOrDefault();
var orderdetails = Entity.DailyOrders.Where(q => q.Date.Day == DateTime.Now.Day && q.Date.Month == DateTime.Now.Month).ToList();
var code = orderdetails.Where(q => Convert.ToDecimal(q.Code) == Convert.ToDecimal(dbcode.rcode) && q.OrderId == dbcode.OrderId).ToList();
if (code.Count == 0)
{
var Orders = Entity.DailyOrderData().Where(q => q.Date.Day == DateTime.Now.Day && q.Date.Month == DateTime.Now.Month).OrderBy(q => q.Status).ToList();
return(View(Orders));
}
else
{
code[0].Status = "Delivered";
Entity.Entry(code[0]).State = System.Data.Entity.EntityState.Modified;
Entity.SaveChanges();
var Orders = Entity.DailyOrderData().Where(q => q.Date.Day == DateTime.Now.Day && q.Date.Month == DateTime.Now.Month).OrderBy(q => q.Status).ToList();
return(View(Orders));
}
}
catch (Exception e)
{
throw e;
}
}
public ActionResult CodeRetrival(FormCollection frm)
{
var code = Convert.ToString(frm["code"]);
Chatpata_dabbaEntities1 Entity = new Chatpata_dabbaEntities1();
DailyOrder DO = new DailyOrder();
var cid = Convert.ToInt32(Session["UserID"]);
// var dbcode = Entity.DailyOrders.Where(q => q.CustId == cid && q.Code == code).Count();
var dbcode = Entity.DailyStatusChange().LastOrDefault();
if (dbcode != null)
{
// var dbcode1 = Entity.DailyOrders.Where(q => q.CustId == cid && q.Code == code).ToList();
// var orderstatus=Entity.
// dbcode1[0].Status = "Delivered";
var orderdetails = Entity.DailyOrders.Where(q => q.Date.Day == DateTime.Now.Day && q.Date.Month == DateTime.Now.Month).ToList();
var data = orderdetails.Where(q => Convert.ToDecimal(q.Code) == Convert.ToDecimal(dbcode.rcode) && q.OrderId == dbcode.OrderId).ToList();
// var orderdetails = Entity.DailyOrderData().Where(q => q.CustId == dbcode.CustId).FirstOrDefault();
//var orderchange = Entity.DailyOrders.Where(q => q.CustId == orderdetails.CustId).ToList();
data[0].Status = "Delivered";
Entity.Entry(data[0]).State = System.Data.Entity.EntityState.Modified;
Entity.SaveChanges();
return(RedirectToAction("ThankYouPage"));
}
else
{
return(RedirectToAction("CodeRetrival"));
}
}
