public ActionResult Delete(int id) { string status = ""; string message = ""; try { var mddaf = _context.BicycleEntryHeaders.Find(id); mddaf.Status = "Deleted_" + DateTime.Now.Ticks.ToString(); _context.Update(mddaf); Log log = new Log(); log.Descriptions = "Delete BicycleEntryHeader Id : " + id; log.Action = "Delete"; log.Status = "Success"; log.UserId = User.Identity.GetUserName(); log.CreatedDate = DateTime.Now; _context.Add(log); _context.SaveChanges(); status = "success"; } catch (Exception e) { status = "failed"; message = e.Message; } var model = new { status, message }; return(Json(model)); }
public async Task <IActionResult> Edit(int id, [Bind("ID,Code,Name,Status,CompanyId")] Department department) { if (id != department.ID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(department); await _context.SaveChangesAsync(); Log log = new Log { Descriptions = "Update Department - " + department.ID, Action = "Edit", Status = "success", UserId = User.Identity.GetUserName() }; _context.Add(log); _context.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!DepartmentExists(department.ID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["CompanyId"] = new SelectList(_context.Companies, "ID", "Name", department.CompanyId); return(View(department)); }
public async Task <IActionResult> Edit(int id, Company company) { if (id != company.ID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(company); await _context.SaveChangesAsync(); Log log = new Log { Descriptions = "Update Company - " + company.ID, Action = "Edit", Status = "success", UserId = User.Identity.GetUserName() }; _context.Add(log); _context.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!CompanyExists(company.ID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(company)); }
public JsonResult SubmitDocument(int id, string module) { string message = ""; string status = ""; try { switch (module) { case "FE": var modelFE = _context.FireExtinguisherHeaders.Find(id); int FELocationCnt = _context.LocationFireExtinguishers.Where(a => a.AreaId == modelFE.AreaId) .Where(a => a.Status == "Active") .Count(); int FEDetails = _context.FireExtinguisherDetails.Where(a => a.FireExtinguisherHeaders.AreaId == modelFE.AreaId) .Where(a => a.FireExtinguisherHeaders.Status == "Active") //02282022 .Where(a => a.FireExtinguisherHeaders.DocumentStatus != "Approved") //02282022 .GroupBy(a => a.LocationFireExtinguisherId) .Count(); if (FELocationCnt == FEDetails) { modelFE.DocumentStatus = "For Review"; _context.Update(modelFE); status = "success"; } else { message = "Submit not allowed. Not all locations has been checked"; status = "fail" + "Submit not allowed. Not all locations has been checked"; } break; case "EL": var modelEL = _context.EmergencyLightHeaders.Find(id); int ELLocationCnt = _context.LocationEmergencyLights.Where(a => a.AreaId == modelEL.AreaId).Where(a => a.Status == "Active").Count(); int ELDetails = _context.EmergencyLightDetails.Where(a => a.EmergencyLightHeaders.AreaId == modelEL.AreaId) .Where(a => a.EmergencyLightHeaders.Status == "Active") //02282022 .Where(a => a.EmergencyLightHeaders.DocumentStatus != "Approved") //02282022 .GroupBy(a => a.LocationEmergencyLightId) .Count(); if (ELLocationCnt == ELDetails) { modelEL.DocumentStatus = "For Review"; _context.Update(modelEL); status = "success"; } else { message = "Submit not allowed. Not all locations has been checked"; status = "fail" + "Submit not allowed. Not all locations has been checked"; } break; case "IT": var modelIT = _context.InergenTankHeaders.Find(id); int ITLocationCnt = _context.LocationInergenTanks.Where(a => a.AreaId == modelIT.AreaId).Where(a => a.Status == "Active").Count(); int ITDetails = _context.InergenTankDetails.Where(a => a.InergenTankHeaders.AreaId == modelIT.AreaId) .Where(a => a.InergenTankHeaders.Status == "Active") //02282022 .Where(a => a.InergenTankHeaders.DocumentStatus != "Approved") //02282022 .GroupBy(a => a.LocationInergenTankId) .Count(); if (ITLocationCnt == ITDetails) { modelIT.DocumentStatus = "For Review"; _context.Update(modelIT); status = "success"; } else { message = "Submit not allowed. Not all locations has been checked"; status = "fail" + "Submit not allowed. Not all locations has been checked"; } break; case "FH": var modelFH = _context.FireHydrantHeaders.Find(id); int FHLocationCnt = _context.LocationFireHydrants.Where(a => a.AreaId == modelFH.AreaId).Where(a => a.Status == "Active").Count(); int FHDetails = _context.FireHydrantDetails.Where(a => a.FireHydrantHeaders.AreaId == modelFH.AreaId) .Where(a => a.FireHydrantHeaders.Status == "Active") //02282022 .Where(a => a.FireHydrantHeaders.DocumentStatus != "Approved") //02282022 .GroupBy(a => a.LocationFireHydrantId) .Count(); if (FHLocationCnt == FHDetails) { modelFH.DocumentStatus = "For Review"; _context.Update(modelFH); status = "success"; } else { message = "Submit not allowed. Not all locations has been checked"; status = "fail" + "Submit not allowed. Not all locations has been checked"; } break; case "BC": var modelBC = _context.BicycleEntryHeaders.Find(id); modelBC.DocumentStatus = "For Approval"; _context.Update(modelBC); status = "success"; break; default: break; } string equipmenttype = module.ToLower(); if (status == "success") { if (equipmenttype != "bc") { string stat = new NotifyController(_context).SendNotification("For Review", equipmenttype, id); // send email } else { string stat = new NotifyController(_context).SendNotification("For Approval", equipmenttype, id); // send email } } Log log = new Log { Descriptions = "SubmitDocument ID " + id + " MODULE " + module, Action = "Add", Status = status, }; _context.Add(log); _context.SaveChanges(); } catch (Exception e) { status = "fail"; message = e.Message; } var model = new { status, message }; return(Json(model)); }
public async Task <IActionResult> Edit(int id, Item item, string StatusOldValue, int CompanyId) { //int companyAccess = Convert.ToInt32(User.Identity.GetCompanyAccess());//disabled 01032022 int companyAccess = CompanyId; if (id != item.Id) { return(NotFound()); } if (ModelState.IsValid) { try { item.Status = "Active"; _context.Update(item); await _context.SaveChangesAsync(); if (item.ItemStatus != StatusOldValue) { ItemLog itemLog = new ItemLog { ItemId = item.Id, OldStatus = StatusOldValue, NewStatus = item.ItemStatus, CreatedDate = DateTime.Now, CreatedBy = User.Identity.GetFullName(), Description = "Changes status from " + StatusOldValue + " to " + item.ItemStatus }; _context.Add(itemLog); } Log log = new Log { Descriptions = "Update Item - " + item.Id, Action = "Edit", Status = "success", UserId = User.Identity.GetUserName() }; _context.Add(log); _context.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ItemExists(item.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(item)); }
public IActionResult SaveData(FireExtinguisherViewModel[] item) { int headerId = 0; string status = ""; string message = ""; string series = ""; string refno = ""; //string series_code = "INERGENTANK"; //series = new NoSeriesController(_context).GetNoSeries(series_code); //refno = "IT" + series; try { //var _header = _context.InergenTankHeaders.Where(a => a.Status == "Active") // //.Where(a => a.AreaId == item[0].AreaId) // .Where(a => a.LocationInergenTankId == item[0].LocationInergenTankId) // .Where(a => a.CreatedAt == DateTime.Now.Date); var _header = _context.InergenTankHeaders .Where(a => a.AreaId == item[0].AreaId) .Where(a => a.Status == "Active") .Where(a => a.DocumentStatus != "Approved"); if (_header.Count() == 0) { var comp = _context.LocationInergenTanks.Include(a => a.Areas.Companies).Where(a => a.Id == item[0].LocationInergenTankId) .FirstOrDefault().Areas.Companies.Code; if (comp == "SCPC") { comp = "SC"; } else { comp = "SL"; } string series_code = comp + "INERGENTANK"; series = new NoSeriesController(_context).GetNoSeries(series_code); refno = comp + "IT" + series; InergenTankHeader header = new InergenTankHeader { ReferenceNo = refno, AreaId = item[0].AreaId, CreatedAt = DateTime.Now.Date, CreatedBy = User.Identity.GetFullName() }; _context.Add(header); _context.SaveChanges(); headerId = header.Id; string x = new NoSeriesController(_context).UpdateNoSeries(series, series_code); foreach (var detail in item) { var _detail = new InergenTankDetail { ItemId = detail.ItemId, Cylinder = Convert.ToInt32(detail.Cylinder), Gauge = Convert.ToInt32(detail.Gauge), Hose = Convert.ToInt32(detail.Hose), Pressure = Convert.ToInt32(detail.Pressure), CreatedAt = DateTime.Now.Date, UpdatedAt = DateTime.Now.Date, InergenTankHeaderId = headerId, Remarks = detail.Remarks, InspectedBy = detail.InspectedBy, ReviewedBy = detail.ReviewedBy, NotedBy = detail.NotedBy, LocationInergenTankId = detail.LocationInergenTankId, }; _context.Add(_detail); } } else { //headerId = item[0].ID; headerId = _header.FirstOrDefault().Id; foreach (var detail in item) { var d = _context.InergenTankDetails .Where(a => a.InergenTankHeaderId == headerId) .Where(a => a.LocationInergenTankId == detail.LocationInergenTankId) .Where(a => a.ItemId == detail.ItemId) .FirstOrDefault(); if (d == null) { var _detail = new InergenTankDetail { ItemId = detail.ItemId, Cylinder = Convert.ToInt32(detail.Cylinder), Gauge = Convert.ToInt32(detail.Gauge), Hose = Convert.ToInt32(detail.Hose), Pressure = Convert.ToInt32(detail.Pressure), CreatedAt = DateTime.Now.Date, UpdatedAt = DateTime.Now, InergenTankHeaderId = headerId, Remarks = detail.Remarks, InspectedBy = detail.InspectedBy, ReviewedBy = detail.ReviewedBy, NotedBy = detail.NotedBy, LocationInergenTankId = detail.LocationInergenTankId, }; _context.Add(_detail); } else { d.Cylinder = Convert.ToInt32(detail.Cylinder); d.Gauge = Convert.ToInt32(detail.Gauge); d.Hose = Convert.ToInt32(detail.Hose); d.Pressure = Convert.ToInt32(detail.Pressure); d.UpdatedAt = DateTime.Now; d.UpdatedBy = User.Identity.GetUserName(); d.InergenTankHeaderId = headerId; d.Remarks = detail.Remarks; d.InspectedBy = detail.InspectedBy; d.ReviewedBy = detail.ReviewedBy; d.NotedBy = detail.NotedBy; d.LocationInergenTankId = detail.LocationInergenTankId; _context.Update(d); } _context.SaveChanges(); } } _context.SaveChanges(); status = "success"; } catch (Exception ex) { status = "failed"; message = ex.InnerException.Message; } var model = new { status , message, ReferenceId = headerId }; return(Json(model)); }
public IActionResult SaveData(EmergencyLightViewModel[] item) { int headerId = 0; string status = ""; string message = ""; string series = ""; string refno = ""; //string series_code = "EMERGENCYLIGHT"; //series = new NoSeriesController(_context).GetNoSeries(series_code); //refno = "EL" + series; try { //var _header = _context.EmergencyLightHeaders // .Where(a => a.Status == "Active") // .Where(a => a.LocationEmergencyLightId == item[0].LocationEmergencyLightId) // .Where(a => a.CreatedAt == DateTime.Now.Date); var _header = _context.EmergencyLightHeaders .Where(a => a.AreaId == item[0].AreaId) .Where(a => a.Status == "Active") .Where(a => a.DocumentStatus != "Approved"); if (_header.Count() == 0) { var comp = _context.LocationEmergencyLights.Include(a => a.Areas.Companies).Where(a => a.Id == item[0].LocationEmergencyLightId).FirstOrDefault() .Areas.Companies.Code; if (comp == "SCPC") { comp = "SC"; } else { comp = "SL"; } string series_code = comp + "EMERGENCYLIGHT"; series = new NoSeriesController(_context).GetNoSeries(series_code); refno = comp + "EL" + series; EmergencyLightHeader header = new EmergencyLightHeader { //header.AreaId = item[0].AreaId; ReferenceNo = refno, AreaId = item[0].AreaId, CreatedAt = DateTime.Now.Date, CreatedBy = User.Identity.GetFullName() }; _context.Add(header); _context.SaveChanges(); headerId = header.Id; string x = new NoSeriesController(_context).UpdateNoSeries(series, series_code); foreach (var detail in item) { var _detail = new EmergencyLightDetail { ItemId = detail.ItemId, Battery = Convert.ToInt32(detail.Battery), Bulb = Convert.ToInt32(detail.Bulb), Usable = Convert.ToInt32(detail.Usable), CreatedAt = DateTime.Now.Date, UpdatedAt = DateTime.Now.Date, EmergencyLightHeaderId = headerId, Remarks = detail.Remarks, InspectedBy = detail.InspectedBy, ReviewedBy = detail.ReviewedBy, NotedBy = detail.NotedBy, LocationEmergencyLightId = detail.LocationEmergencyLightId }; _context.Add(_detail); } } else { headerId = _header.FirstOrDefault().Id; foreach (var detail in item) { var d = _context.EmergencyLightDetails .Where(a => a.EmergencyLightHeaderId == headerId) .Where(a => a.LocationEmergencyLightId == detail.LocationEmergencyLightId) .Where(a => a.ItemId == detail.ItemId) .FirstOrDefault(); if (d == null) { var _detail = new EmergencyLightDetail { ItemId = Convert.ToInt32(detail.ItemId), Battery = Convert.ToInt32(detail.Battery), Bulb = Convert.ToInt32(detail.Bulb), Usable = Convert.ToInt32(detail.Usable), CreatedAt = DateTime.Now.Date, UpdatedAt = DateTime.Now, EmergencyLightHeaderId = headerId, Remarks = detail.Remarks, InspectedBy = detail.InspectedBy, ReviewedBy = detail.ReviewedBy, NotedBy = detail.NotedBy, LocationEmergencyLightId = detail.LocationEmergencyLightId, }; _context.Add(_detail); } else { d.Battery = Convert.ToInt32(detail.Battery); d.Bulb = Convert.ToInt32(detail.Bulb); d.Usable = Convert.ToInt32(detail.Usable); d.UpdatedAt = DateTime.Now; d.UpdatedBy = User.Identity.GetUserName(); d.EmergencyLightHeaderId = headerId; d.Remarks = detail.Remarks; d.InspectedBy = detail.InspectedBy; d.ReviewedBy = detail.ReviewedBy; d.NotedBy = detail.NotedBy; d.LocationEmergencyLightId = detail.LocationEmergencyLightId; _context.Update(d); } _context.SaveChanges(); } } _context.SaveChanges(); status = "success"; } catch (Exception ex) { status = "failed"; message = ex.InnerException.Message; } var model = new { status , message, ReferenceId = headerId }; return(Json(model)); }
public IActionResult SaveData(FireHydrantViewModel[] item) { string series = ""; string refno = ""; //string series_code = "FIREHYDRANT"; //series = new NoSeriesController(_context).GetNoSeries(series_code); //refno = "FH" + series; int headerId = 0; string status = ""; string message = ""; try { //var _header = _context.FireHydrantHeaders.Where(a => a.Status == "Active") //// .Where(a => a.AreaId == item[0].AreaId) //.Where(a => a.LocationFireHydrantId == item[0].LocationFireHydrantId) //.Where(a => a.CreatedAt == DateTime.Now.Date); var _header = _context.FireHydrantHeaders .Where(a => a.AreaId == item[0].AreaId) .Where(a => a.Status == "Active") .Where(a => a.DocumentStatus != "Approved"); if (_header.Count() == 0) { var comp = _context.LocationFireHydrants.Include(a => a.Areas.Companies).Where(a => a.Id == item[0].LocationFireHydrantId).FirstOrDefault() .Areas.Companies.Code; if (comp == "SCPC") { comp = "SC"; } else { comp = "SL"; } string series_code = comp + "FIREHYDRANT"; series = new NoSeriesController(_context).GetNoSeries(series_code); refno = comp + "FH" + series; FireHydrantHeader header = new FireHydrantHeader { ReferenceNo = refno, //LocationFireHydrantId = item[0].LocationFireHydrantId, AreaId = item[0].AreaId, CreatedAt = DateTime.Now.Date, CreatedBy = User.Identity.GetFullName() }; _context.Add(header); _context.SaveChanges(); string x = new NoSeriesController(_context).UpdateNoSeries(series, series_code); headerId = header.Id; foreach (var detail in item) { var _detail = new FireHydrantDetail { ItemId = detail.ItemId, GlassCabinet = Convert.ToInt32(detail.GlassCabinet), Hanger = Convert.ToInt32(detail.Hanger), Hose15 = Convert.ToInt32(detail.Hose15), Nozzle15 = Convert.ToInt32(detail.Nozzle15), Hose25 = Convert.ToInt32(detail.Hose25), Nozzle25 = Convert.ToInt32(detail.Nozzle25), SpecialTools = Convert.ToInt32(detail.SpecialTools), InspectedBy = detail.InspectedBy, ReviewedBy = detail.ReviewedBy, NotedBy = detail.NotedBy, CreatedAt = DateTime.Now.Date, UpdatedAt = DateTime.Now.Date, FireHydrantHeaderId = headerId, Remarks = detail.Remarks, LocationFireHydrantId = detail.LocationFireHydrantId, }; _context.Add(_detail); } } else { headerId = _header.FirstOrDefault().Id; foreach (var detail in item) { var d = _context.FireHydrantDetails .Where(a => a.FireHydrantHeaderId == headerId) .Where(a => a.LocationFireHydrantId == item[0].LocationFireHydrantId) .Where(a => a.ItemId == detail.ItemId) .FirstOrDefault(); if (d == null) { var _detail = new FireHydrantDetail { ItemId = detail.ItemId, GlassCabinet = Convert.ToInt32(detail.GlassCabinet), Hanger = Convert.ToInt32(detail.Hanger), Hose15 = Convert.ToInt32(detail.Hose15), Nozzle15 = Convert.ToInt32(detail.Nozzle15), Hose25 = Convert.ToInt32(detail.Hose25), Nozzle25 = Convert.ToInt32(detail.Nozzle25), SpecialTools = Convert.ToInt32(detail.SpecialTools), InspectedBy = detail.InspectedBy, ReviewedBy = detail.ReviewedBy, NotedBy = detail.NotedBy, LocationFireHydrantId = detail.LocationFireHydrantId, CreatedAt = DateTime.Now.Date, UpdatedAt = DateTime.Now, FireHydrantHeaderId = headerId, Remarks = detail.Remarks }; _context.Add(_detail); } else { d.GlassCabinet = Convert.ToInt32(detail.GlassCabinet); d.Hanger = Convert.ToInt32(detail.Hanger); d.Hose15 = Convert.ToInt32(detail.Hose15); d.Nozzle15 = Convert.ToInt32(detail.Nozzle15); d.Hose25 = Convert.ToInt32(detail.Hose25); d.Nozzle25 = Convert.ToInt32(detail.Nozzle25); d.SpecialTools = Convert.ToInt32(detail.SpecialTools); d.InspectedBy = detail.InspectedBy; d.Remarks = detail.Remarks; d.NotedBy = detail.NotedBy; d.LocationFireHydrantId = detail.LocationFireHydrantId; d.UpdatedAt = DateTime.Now; d.UpdatedBy = User.Identity.GetUserName(); d.FireHydrantHeaderId = headerId; d.ReviewedBy = detail.ReviewedBy; _context.Update(d); } _context.SaveChanges(); } } _context.SaveChanges(); status = "success"; } catch (Exception ex) { status = "failed"; message = ex.InnerException.Message; } var model = new { status , message , ReferenceId = headerId }; return(Json(model)); }