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