public async Task <IEnumerable <dynamic> > GetWorkNotificationByStatus(WnSearchViewModel wsvm)
{
string sql = "dbo.EAppListWorkNotification";
using (var conn = util.MasterCon())
{
try
{
return(await(conn.QueryAsync <dynamic>(sql, new { wsvm.ClientSiteId, wsvm.LanguageId, wsvm.FromDate, wsvm.ToDate, wsvm.StatusId }, commandType: CommandType.StoredProcedure)));
}
catch (Exception ex)
{
throw new Utils.CustomException("Unable to Load Data, Please Contact Support!!!", "Error", true, ex);
}
}
}
public async Task <IActionResult> WorkNoficationOpenExcelDownload([FromBody] WnSearchViewModel scmvm)
{
try
{
return(Ok(await worknotificationRepo.GetWorkNotificationOpenExportExcel(scmvm)));
}
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> > GetWorkNotificationOpenExportExcel(WnSearchViewModel ssrvm)
{
string sql = "dbo.EAppWorkNotificationExportDetail";
using (var conn = util.MasterCon())
{
try
{
return(await(conn.QueryAsync <dynamic>(sql, new
{
ssrvm.ClientSiteId,
ssrvm.FromDate,
ssrvm.ToDate,
ssrvm.LanguageId,
ssrvm.StatusId
}, commandType: CommandType.StoredProcedure)));
}
catch (Exception ex)
{
throw new CustomException("Unable to Down Export to Excel Data, Please Contact Support!!!", "Error", true, ex);
}
}
}
