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