public JsonResult UpdateStatus(int id, string st) { try { Chatpata_dabbaEntities1 Entity = new Chatpata_dabbaEntities1(); RequestMaster rm = new RequestMaster(); var details = Entity.RequestMasters.Where(q => q.Id == id).FirstOrDefault(); if (st == "Accept") { details.Status = "Accept"; Entity.Entry(details).State = System.Data.Entity.EntityState.Modified; Entity.SaveChanges(); return(Json("Accept", JsonRequestBehavior.AllowGet)); } else if (st == "Reject") { details.Status = "Reject"; Entity.Entry(details).State = System.Data.Entity.EntityState.Modified; Entity.SaveChanges(); return(Json("Reject", JsonRequestBehavior.AllowGet)); } else { return(Json("Error", JsonRequestBehavior.AllowGet)); } } catch (Exception e) { return(Json("Error", JsonRequestBehavior.AllowGet)); } }
//public ActionResult SortFisrtname(string sortOrder, int rollid) // { // try // { // Chatpata_dabbaEntities1 Entity = new Chatpata_dabbaEntities1(); // ViewBag.firstname = String.IsNullOrEmpty(sortOrder) ? "" : "ase"; // //sortOrder = ViewBag.firstname; // var fname = from s in Entity.CustomerMasters // select s; // fname = fname.Where(s => s.Roleid == rollid); // switch (sortOrder) // { // case "ase": // fname = fname.OrderByDescending(s => s.FirstName); // break; // default: // fname = fname.OrderBy(s => s.FirstName); // break; // } // //if (sortOrder == "ase") // //{ // // fname = fname.OrderBy(s => s.FirstName); // //} // return View(fname.ToList()); // } // catch (Exception ex) // { // return RedirectToAction("customertable", "Admin"); // } // } // public ActionResult Sortarea(string sortOrder, int rollid) // { // try // { // Chatpata_dabbaEntities1 Entity = new Chatpata_dabbaEntities1(); // ViewBag.firstname = String.IsNullOrEmpty(sortOrder) ? "" : "ase"; // //sortOrder = ViewBag.firstname; // var fname = from s in Entity.CustomerMasters // select s; // fname = fname.Where(q => q.Roleid == rollid); // switch (sortOrder) // { // case "ase": // fname = fname.OrderByDescending(s => s.Address3); // break; // default: // fname = fname.OrderBy(s => s.Address3); // break; // } // //if (sortOrder == "ase") // //{ // // fname = fname.OrderBy(s => s.FirstName); // //} // return View(fname.ToList()); // } // catch (Exception ex) // { // return RedirectToAction("customertable", "Admin"); // } // } public ActionResult ViewSampleRequest() { try { if (Session["UserID"] == null) { return(RedirectToAction("Index", "Home")); } Chatpata_dabbaEntities1 Entity = new Chatpata_dabbaEntities1(); RequestMaster rm = new RequestMaster(); var details = Entity.RequestMasters.Where(q => q.Status == "Pending").ToList(); return(View(details)); } catch (Exception ex) { throw ex; } }
public ActionResult ViewSampleRequest() { try { if (Session["UserID"] == null) { return(RedirectToAction("Index", "Home")); } var id = Convert.ToInt32(Session["UserID"]); Chatpata_dabbaEntities1 Entity = new Chatpata_dabbaEntities1(); RequestMaster rm = new RequestMaster(); var details = Entity.RequestMasters.OrderBy(q => q.Date).ToList(); return(View(details)); } catch (Exception ex) { throw ex; } }
public ActionResult SampleOrder(int id) { try { Chatpata_dabbaEntities1 Entity = new Chatpata_dabbaEntities1(); RequestMaster rm = new RequestMaster(); var custid = Convert.ToInt32(Session["UserID"]); var chkOrder = Entity.RequestMasters.Where(q => q.CustId == custid).FirstOrDefault(); var email = Entity.CustomerMasters.Where(q => q.CustId == custid).FirstOrDefault(); if (chkOrder == null) { rm.CustId = Convert.ToInt32(Session["UserID"]); rm.MenuId = id; rm.Status = "Pending"; rm.Date = DateTime.Now; Entity.RequestMasters.Add(rm); Entity.SaveChanges(); int ck = Mail.SendMail("Sample-tiffin", "Your Order for sample tiffin is registered", email.EmailID); TempData["notice"] = "Your Order for sample tiffin is successfully registerd"; Session["ReqmenuId"] = rm.MenuId; return(RedirectToAction("ViewReqStasus")); } else // (chkOrder.Status == "A") { // if (chkOrder.Status == "Accept" || chkOrder.Status == "Reject") //{ TempData["notice"] = "You are alerdy oredred for sample tiffin"; rm.MenuId = id; Session["ReqmenuId"] = rm.MenuId; return(RedirectToAction("ViewReqStasus", "Customer")); // } } } catch (Exception ex) { throw ex; } }