public string GetResourceVerificationByFacilityId(string Id) { var FacilityId = int.Parse(Id); var db = new Context(); var model = new List <ResourceReport>(); var result = db.Report.Where(x => x.Resource.FacilityId == FacilityId).ToList(); foreach (var r in result) { var resource = new ResourceReport(); resource.Verified = r.Verify; resource.Missing = r.Missing; resource.ResourceId = r.ResourceId; resource.Message = r.Message; var res = db.Resource.Where(x => x.Id == r.ResourceId).FirstOrDefault(); if (res != null) { resource.Quantity = res.Quantity; resource.ResourceName = res.Name; } model.Add(resource); } var response = JsonConvert.SerializeObject(model); return(response); }
public ActionResult ProcessReport(ResourceReport resource, int id, string mode) { var dbcontext = new InlaksBIContext(); var d = Request.Form; //schedule.MaxDate = Request.Form["MaxDate"]; switch (mode) { case "create": //resource.Module = dbcontext.Modules.FirstOrDefault(m => m.ModuleID == resource.ModuleID); //dbcontext.Resources.Add(resource); //dbcontext.SaveChanges(); break; case "edit": //var old = dbcontext.Resources.FirstOrDefault(t => t.ResourceID == id); //resource.Module = dbcontext.Modules.FirstOrDefault(m => m.ModuleID == resource.ModuleID); //dbcontext.Resources.Remove(old); //dbcontext.Resources.Add(resource); //dbcontext.SaveChanges(); break; case "delete": //var item = dbcontext.Resources.FirstOrDefault(t => t.ResourceID == id); //dbcontext.Resources.Remove(item); //dbcontext.SaveChanges(); break; } return(RedirectToAction("ResourceSetup", new { id = 0, mode = "list" })); }