public async Task <IEnumerable <dynamic> > SaveOrUpdate(FailureReportViewModel frvm) { string sql = "dbo.EAppSaveFailureReport"; //string Header = "{\"FailureReportList\":"; //string Footer = "}"; var FailureDetailJson = (frvm.FailureReportList != null ? JsonConvert.SerializeObject(frvm.FailureReportList) : null); using (var conn = util.MasterCon()) { try { return(await(conn.QueryAsync <dynamic>(sql, new { frvm.FailureReportHeaderId, frvm.ReportType, frvm.ClientsiteId, frvm.EquipmentId, frvm.ReportDate, frvm.Active, frvm.UserId, FailureDetailJson }, commandType: CommandType.StoredProcedure))); } catch (Exception ex) { throw new CustomException("Unable to Save Or Update, Please Contact Support!!!", "Error", true, ex); } } }
public async Task <IActionResult> Update([FromBody] FailureReportViewModel frvm) { try { CurrentUser cUser = new CurrentUser(HttpContext, _configuration); frvm.UserId = cUser.UserId; return(Ok(await failurereportRepo.SaveOrUpdate(frvm))); } catch (CustomException cex) { var returnObj = new EmaintenanceMessage(cex.Message, cex.Type, cex.IsException, cex.Exception?.ToString()); return(StatusCode(StatusCodes.Status500InternalServerError, returnObj)); } catch (Exception ex) { return(StatusCode(StatusCodes.Status500InternalServerError, new EmaintenanceMessage(ex.Message))); } }
public async Task <IActionResult> Update([FromBody] FailureReportViewModel frvm) { try { CurrentUser cUser = new CurrentUser(HttpContext, _configuration); frvm.UserId = cUser.UserId; var result = await avoidPlannedMaintRepo.SaveOrUpdate(frvm); await auditLogService.LogActivity(cUser.UserId, cUser.HostIP, cUser.SessionId, "Avoided Planned Maintenence", "AvoidPlanned Maintenance Modified."); return(Ok(result)); } catch (CustomException cex) { var returnObj = new EmaintenanceMessage(cex.Message, cex.Type, cex.IsException, cex.Exception?.ToString()); return(StatusCode(StatusCodes.Status500InternalServerError, returnObj)); } catch (Exception ex) { return(StatusCode(StatusCodes.Status500InternalServerError, new EmaintenanceMessage(ex.Message))); } }