/// <summary> /// Deletes the asynchronous. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public async Task<SaveResult> DeleteAsync(LOGHistoryDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { var assembly = context.LOG_FARHistory.Single(x => x.Id == entity.Id && x.IsDeleted == false); assembly.IsDeleted = true; context.Entry<LOG_FARHistory>(assembly).State = System.Data.Entity.EntityState.Modified; result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Adds the asynchronous. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public async Task<SaveResult> AddAsync(LOGHistoryDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { LOG_FARHistory add = context.LOG_FARHistory.Create(); add.StatusId = entity.StatusId; add.MasterId = entity.MasterId; add.ReasonId = entity.ReasonId; add.LogDate = entity.LogDate; add.IsDeleted = entity.IsDeleted; add.LastUpdatedBy = entity.LastUpdatedBy; add.LastUpdate = DateTime.Now; context.Entry<LOG_FARHistory>(add).State = System.Data.Entity.EntityState.Added; result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
/// <summary> /// Updates the specified entity. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public SaveResult Update(LOGHistoryDto entity) { SaveResult result = SaveResult.FAILURE; try { using (FailureAnalysisEntities context = new FailureAnalysisEntities()) { var assembly = context.LOG_FARHistory.Single(x => x.Id == entity.Id && x.IsDeleted == false); assembly.StatusId = entity.StatusId; assembly.MasterId = entity.MasterId; assembly.ReasonId = entity.ReasonId; assembly.IsDeleted = entity.IsDeleted; assembly.LogDate = entity.LogDate; assembly.ReasonId = entity.ReasonId; assembly.LastUpdatedBy = entity.LastUpdatedBy; assembly.LastUpdate = DateTime.Now; context.Entry<LOG_FARHistory>(assembly).State = System.Data.Entity.EntityState.Modified; result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return result; }
public async Task<ActionResult> ReOpenFA(int id, LogViewModel viewmodel) { ViewBag.RedMessage = null; viewmodel.Reason = ReasonRepository.GetAll(); if (!ModelState.IsValid) return View(viewmodel); LOGHistoryDto hrl = new LOGHistoryDto(); hrl.MasterId = id; hrl.ReasonId = viewmodel.ReasonId; hrl.StatusId = (int)StatusType.OPEN;// "O"; hrl.LogDate = DateTime.Now; hrl.LastUpdatedBy = this.CurrentName; var result = await LogHisRep.AddAsync(hrl); if (result == Model.SaveResult.SUCCESS) { //Update Master is Open var master = await MasterRepository.SingleAsync(id); master.StatusId = (int)StatusType.OPEN; master.LastUpdatedBy = this.CurrentName; await MasterRepository.UpdateAsync(master); } else { ViewBag.RedMessage = "Has error while ReOpened FA!"; return View(viewmodel); } return RedirectToAction("Index", "ReOpen", new { id = id }); }
public async Task<ActionResult> AnaReleaseFA(int id, LogViewModel log) { ViewBag.RedMessage = null; log.Reason = ReasonRepository.GetAll(); if (!ModelState.IsValid) return View(log); LOGHistoryDto hrl = new LOGHistoryDto(); hrl.MasterId = id; hrl.ReasonId = log.ReasonId; hrl.StatusId = (int)StatusType.ONGOING;// "G"; hrl.LastUpdatedBy = this.CurrentName; hrl.LogDate = DateTime.Now; var result = await LogHisRep.AddAsync(hrl); if (result == Model.SaveResult.SUCCESS) { //Upate master field status is Ongoing var master = await MasterRepository.SingleAsync(id); if (master != null) { master.StatusId = (int)StatusType.RELEASE; await MasterRepository.UpdateAsync(master); } } else { ViewBag.RedMessage = "Has error while Release FA!"; return View(log); } return RedirectToAction("AnaEditFA", "Dashboard", new { id = id }); }
public async Task<JsonResult> Onhold(LogViewModel log) { LOGHistoryDto hrl = new LOGHistoryDto(); hrl.MasterId = log.MasterId; hrl.ReasonId = log.ReasonId; hrl.StatusId = (int)StatusType.HOLD; //"H"; hrl.LastUpdatedBy = this.CurrentName; hrl.LogDate = DateTime.Now; var result = await LogHisRep.AddAsync(hrl); if (result == Model.SaveResult.SUCCESS) { //Update status Master is Hold var master = await MasterRepository.SingleAsync(hrl.MasterId); if (master == null) { Response.StatusCode = (int)HttpStatusCode.NotFound; return new JsonResult { JsonRequestBehavior = JsonRequestBehavior.AllowGet, Data = new { code = "OH02" } }; } if (master != null) { master.StatusId = (int)StatusType.HOLD; result = await MasterRepository.UpdateAsync(master); if (result == Model.SaveResult.SUCCESS) { Response.StatusCode = (int)HttpStatusCode.OK; return new JsonResult { JsonRequestBehavior = JsonRequestBehavior.AllowGet, Data = new { code = "OH01" } }; } else { Response.StatusCode = (int)HttpStatusCode.BadGateway; return new JsonResult { JsonRequestBehavior = JsonRequestBehavior.AllowGet, Data = new { code = "OH02" } }; } } } Response.StatusCode = (int)HttpStatusCode.BadGateway; return new JsonResult { JsonRequestBehavior = JsonRequestBehavior.AllowGet, Data = new { code = "OH02" } }; }