public List <RenewalReportViewModel> Get_RenewalReport(RenewalReportRequestModel renewalReport) { using (var con = new SqlConnection(_configuration.GetConnectionString("DatabaseConnection"))) { var para = new DynamicParameters(); para.Add("@Paymentfromdt", renewalReport.Paymentfromdate); para.Add("@Paymenttodt", renewalReport.Paymentfromto); return(con.Query <RenewalReportViewModel>("Usp_GetAllRenwalrecordsFromBetweenDate", para, null, true, 0, commandType: CommandType.StoredProcedure).ToList()); } }
public List <RenewalReportViewModel> Post([FromBody] RenewalReportRequestModel value) { try { return(_reports.Get_RenewalReport(value)); } catch (Exception) { throw; } }