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