Beispiel #1
0
 public async Task <IActionResult> GetSummaryReportDateRangeToDownload([FromBody] SearchSummaryReportViewModel scmvm)
 {
     try
     {
         return(Ok(await summaryReportRepo.GetSummaryReportDateRangeToExport(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> > GetSummaryReportList(SearchSummaryReportViewModel ssrvm)
        {
            string sql = "dbo.EAppListJobSummaryReport";

            using (var conn = util.MasterCon())
            {
                try
                {
                    return(await(conn.QueryAsync <dynamic>(sql, new { ssrvm.ClientSiteId, ssrvm.ReportFromDate, ssrvm.ReportToDate, ssrvm.LanguageId }, commandType: CommandType.StoredProcedure)));
                }
                catch (Exception ex)
                {
                    throw new CustomException("Unable to Load Data, Please Contact Support!!!", "Error", true, ex);
                }
            }
        }
Beispiel #3
0
 public async Task <IActionResult> GetSummaryReportList([FromBody] SearchSummaryReportViewModel scmvm)
 {
     try
     {
         CurrentUser cUser = new CurrentUser(HttpContext, _configuration);
         return(Ok(await summaryReportRepo.GetSummaryReportList(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)));
     }
 }