public bool AddProductsToRequest(Emp_Request request, string Item_Num, int Quantity) { if (Quantity == 0) { return(true); } //check if existing records are there or not if (db.emp_Request_Details.Any(x => x.Emp_Req_Id == request.Emp_Req_Id && x.Item_Num == Item_Num)) { Emp_Request_Details temp = db.emp_Request_Details.Where(x => x.Emp_Req_Id == request.Emp_Req_Id && x.Item_Num == Item_Num).FirstOrDefault(); temp.Quantity += Quantity; db.emp_Request_Details.AddOrUpdate(temp); db.SaveChanges(); return(true); } //creating new Record Emp_Request_Details NewItem = new Emp_Request_Details(); NewItem.Emp_Req_Id = request.Emp_Req_Id; NewItem.Item_Num = Item_Num; Catalogue item = db.catalogues.Where(x => x.Item_Num == Item_Num).FirstOrDefault(); NewItem.Emp_Request = request; NewItem.Product = item; NewItem.Quantity = Quantity; db.emp_Request_Details.Add(NewItem); db.SaveChanges(); return(true); throw new NotImplementedException(); }
public ActionResult CheckOut(string sessionId) { ViewData["SessionId"] = sessionId; ViewData["USER"] = LoginServices.GetUserBySessionId(sessionId); ViewData["Emp_Req_Id"] = -1; List <Emp_Request_Details> list2 = requestService.GetEmp_Request_Details_Temporary(sessionId); Emp_Request_Details temp = list2.FirstOrDefault(); if (temp != null) { ViewData["Emp_Req_Id"] = temp.Emp_Req_Id; } return(View(list2)); }
public bool UpdateReqForm(int Emp_Req_Details_Id, int Quantity) { Emp_Request_Details temp = db.emp_Request_Details.Where(x => x.Emp_Req_Details_Id == Emp_Req_Details_Id).FirstOrDefault(); if (Quantity == 0) { db.emp_Request_Details.Remove(temp); db.SaveChanges(); return(true); } temp.Quantity = Quantity; db.emp_Request_Details.AddOrUpdate(temp); db.SaveChanges(); return(true); throw new NotImplementedException(); }
public ActionResult UpdateMain(string sessionId, int id, int Quantity) { ViewData["SessionId"] = sessionId; ViewData["USER"] = LoginServices.GetUserBySessionId(sessionId); requestService.UpdateReqForm(id, Quantity); Emp_Request_Details temp = db.emp_Request_Details.Where(x => x.Emp_Req_Details_Id == id).FirstOrDefault(); if (temp == null) { //Emp_Request request=db.emp_Requests.Where(x=>x.Emp_Req_Id==) return(RedirectToAction("ViewRequests", new { sessionId })); } id = temp.Emp_Req_Id; return(RedirectToAction("Details", new { sessionId, id })); }