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 AddToForm(int Quantity_Needed, string Item_Num, string sessionId) { ViewData["SessionId"] = sessionId; ViewData["USER"] = LoginServices.GetUserBySessionId(sessionId); Emp_Request RequestitionForm = requestService.CreateRequestForm(sessionId); requestService.AddProductsToRequest(RequestitionForm, Item_Num, Quantity_Needed); return(RedirectToAction("MakeRequest", new { sessionId })); }
public bool DeleteReqForm(int Emp_Req_Id) { Emp_Request temp = db.emp_Requests.Where(x => x.Emp_Req_Id == Emp_Req_Id).FirstOrDefault(); db.emp_Requests.Remove(temp); db.SaveChanges(); return(true); throw new NotImplementedException(); }
public ActionResult Details(string sessionId, int id) { DelegationServices.ValidateDelegateStatus(sessionId); ViewData["SessionId"] = sessionId; ViewData["USER"] = LoginServices.GetUserBySessionId(sessionId); Emp_Request temp = db.emp_Requests.Where(x => x.Emp_Req_Id == id).FirstOrDefault(); ViewData["FormSubmittedUser"] = temp.Employee; ViewData["Emp_Req_Id"] = temp.Emp_Req_Id; return(View(db.emp_Request_Details.Where(x => x.Emp_Req_Id == id).ToList())); }
public List <Emp_Request_Details> GetEmp_Request_Details_Temporary(string sessionId) { Employee user = LoginServices.GetUserBySessionId(sessionId); Emp_Request temp = db.emp_Requests.Where(x => x.Status == "STATUS_0" && x.Emp_Id == user.Emp_Id).FirstOrDefault(); if (temp != null) { return(db.emp_Request_Details.Where(x => x.Emp_Req_Id == temp.Emp_Req_Id).ToList()); } else { return(new List <Emp_Request_Details>()); } throw new NotImplementedException(); }
public bool SubmitReqForm(int Emp_Req_Id) { Emp_Request temp = db.emp_Requests.Where(x => x.Emp_Req_Id == Emp_Req_Id).FirstOrDefault(); if (temp != null) { temp.Status = "PENDING"; db.emp_Requests.AddOrUpdate(temp); db.SaveChanges(); return(true); } return(false); throw new NotImplementedException(); }
public Emp_Request CreateRequestForm(string sessionId) { //get the temperary request where status is 0 if there is already one ...else will get a new request with status code 0 Employee user = LoginServices.GetUserBySessionId(sessionId); if (db.emp_Requests.Any(x => x.Status == "STATUS_0" && x.Emp_Id == user.Emp_Id)) { return(db.emp_Requests.Where(x => x.Emp_Id == user.Emp_Id && x.Status == "STATUS_0").FirstOrDefault()); } Emp_Request emp_Request = new Emp_Request(); emp_Request.Emp_Id = user.Emp_Id; emp_Request.Status = "STATUS_0"; emp_Request.Employee = db.employees.Where(x => x.Emp_Id == user.Emp_Id).FirstOrDefault(); db.emp_Requests.Add(emp_Request); db.SaveChanges(); return(emp_Request); throw new NotImplementedException(); }
public Emp_Request ManagRequest(int Emp_Req_Id, string Comments, string type, string sessionId) { Employee user = LoginServices.GetUserBySessionId(sessionId); Emp_Request temp = db.emp_Requests.Where(x => x.Emp_Req_Id == Emp_Req_Id).FirstOrDefault(); if (type == "ACCEPT") { temp.Status = "ACCEPTED"; } else { temp.Status = "REJECTED"; } temp.Date_Approved = DateTime.Now; temp.Approved_By = user.Full_Name; temp.Comment = Comments; db.emp_Requests.AddOrUpdate(temp); db.SaveChanges(); return(temp); throw new NotImplementedException(); }