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