public async Task <IEnumerable <dynamic> > SaveOrUpdate([FromBody] FailureCauseViewModel fcvm)
{
string sql = "dbo.EAppSaveFailureCause";
using (var conn = util.MasterCon())
{
try
{
return(await(conn.QueryAsync <dynamic>(sql, new
{
fcvm.FailureCauseId,
fcvm.LanguageId,
fcvm.FailureCauseCode,
fcvm.FailureCauseName,
fcvm.Descriptions,
fcvm.Active,
fcvm.UserId
}, commandType: CommandType.StoredProcedure)));
}
catch (Exception ex)
{
throw new CustomException("Unable to Save Or Update, Please Contact Support!!!", "Error", true, ex);
}
}
}
public async Task <IActionResult> Search([FromBody] FailureCauseViewModel fcvm)
{
try
{
return(Ok(await failureCauseRepo.GetFailureCauseByParams(fcvm)));
}
catch (CustomException cex)
{
var responseObj = new EmaintenanceMessage(cex.Message, cex.Type, cex.IsException, cex.Exception?.ToString());
return(StatusCode(StatusCodes.Status500InternalServerError, responseObj));
}
catch (Exception ex)
{
return(Ok(new EmaintenanceMessage(ex.Message)));
}
}
public async Task <IEnumerable <dynamic> > GetFailureCauseByParams(FailureCauseViewModel fcvm)
{
string sql = "dbo.EAppListFailureCause";
using (var conn = util.MasterCon())
{
try
{
return(await(conn.QueryAsync <dynamic>(sql, new
{ fcvm.LanguageId, fcvm.Status },
commandType: CommandType.StoredProcedure)));
}
catch (Exception ex)
{
throw new CustomException("Unable to Load Data, Please Contact Support!!!", "Error", true, ex);
}
}
}
public async Task <IActionResult> Create([FromBody] FailureCauseViewModel fcvm)
{
try
{
CurrentUser cUser = new CurrentUser(HttpContext, _configuration);
fcvm.UserId = cUser.UserId;
fcvm.FailureCauseId = 0;
fcvm.Active = "Y";
return(Ok(await failureCauseRepo.SaveOrUpdate(fcvm)));
}
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)));
}
}
