public JsonResult ApproveRequestInsert(string RequestGUID)
{
TimeShield_dbEntities db = new TimeShield_dbEntities();
var approve = db.Requests.Where(r => r.RequestGUID == RequestGUID).ToList();
foreach (var ap in approve)
{
ap.Approveflag = 1;
}
db.SaveChanges();
var approved = db.Requests.Where(r => r.Approveflag == 1 && r.RequestGUID == RequestGUID).Select(a => new { a.RequestGUID, a.UserId }).FirstOrDefault();
TrackRequest trackRequest = new TrackRequest
{
RequestGUID = approved.RequestGUID,
ApproveTime = DateTime.Now,
UserId = approved.UserId
};
db.TrackRequests.Add(trackRequest);
db.SaveChanges();
return(Json(new { result = "Redirect", url = Url.Action("NewRequest", "User") }, JsonRequestBehavior.AllowGet));
}
public JsonResult RequestInsert(List <Product> products)
{
User session = System.Web.HttpContext.Current.Session["UserModel"] as User;
TimeShield_dbEntities db = new TimeShield_dbEntities();
Guid guid = Guid.NewGuid();
foreach (Product product in products)
{
Request request = new Request
{
UserId = session.UserId,
ProductId = product.ProductId,
Quantity = product.Quantity,
RequestTime = DateTime.Now,
RequestGUID = guid.ToString()
};
db.Requests.Add(request);
}
int insertedRecords = db.SaveChanges();
return(Json(new { result = "Redirect", url = Url.Action("UserDashBoard", "Account") }));
}
