public async Task <ReportResults> GetSearchResults(ReportParms reportParms)
{
string sqlcmd = "Reports_SP";
var parmsList = new List <SqlParameter>()
{
new SqlParameter("@Name", SqlDbType.NVarChar)
{
Value = reportParms.Name ?? (object)DBNull.Value
},
new SqlParameter("@Type", SqlDbType.NVarChar)
{
Value = reportParms.Type ?? (object)DBNull.Value
},
new SqlParameter("@PolicyID", SqlDbType.NVarChar)
{
Value = reportParms.PolicyID ?? (object)DBNull.Value
},
new SqlParameter("@Status", SqlDbType.NVarChar)
{
Value = reportParms.Status ?? (object)DBNull.Value
},
};
var results = new List <Dictionary <string, object> >();
using (var connection = GetDBContext())
{
Task open = connection.OpenAsync();
var command = new SqlCommand(sqlcmd, connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddRange(parmsList.ToArray());
await open;
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
int count = reader.FieldCount;
while (await reader.ReadAsync())
{
var rowDict = new Dictionary <string, object>();
for (int i = 0; i < count; i++)
{
object columnVal;
string columnName = reader.GetName(i);
columnVal = reader.IsDBNull(i) ? "" : await reader.GetFieldValueAsync <object>(i);
rowDict.Add(columnName, columnVal);
}
results.Add(rowDict);
}
}
}
return(new ReportResults
{
ResultsList = results,
ItemsCount = results.Count
});
}
public void GetPagoReport()
{
// connection();
ReportParms objReporParams = new ReportParms();
var data = GetPagoInfo();
objReporParams.DataSource = data.Tables[0];
objReporParams.ReportTitle = "Pago Info Report";
objReporParams.RptFileName = "PagoInfoReport.rdlc";
objReporParams.ReportType = "PagoInfoReport";
objReporParams.DataSetName = "dsPagoReport";
this.HttpContext.Session["ReportParam"] = objReporParams;
}
public async Task <IActionResult> Accounts([FromServices] IReportsRepository data, [FromForm] ReportParms parms)
{
if (!ModelState.IsValid)
{
return(new BadRequestResult());
}
ReportResults results = await data.GetAccountSearchResults(parms);
return(Content(JsonConvert.SerializeObject(results), "application/json"));
}