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