public async Task <IActionResult> InvoiceDisplay2(DataSourceRequest command,
InvoiceDisplayListModel model)
{
var(invoiceDisplayListModel, totalCount) = await _vendorManagementService.PrepareinvoiceDisplaytListModel(model, command.Page, command.PageSize);
var gridModel = new DataSourceResult
{
Data = invoiceDisplayListModel,
Total = totalCount
};
return(Json(gridModel));
}
public async Task <(IEnumerable <InvoiceDisplay2> invoiceDisplayListModel, int totalCount)> PrepareinvoiceDisplaytListModel(InvoiceDisplayListModel model, int pageIndex, int pageSize)
{
var invoiceDisplay2 = new List <InvoiceDisplay2>();
try
{
SqlParameter[] pr = new SqlParameter[]
{
new SqlParameter("@intClientID", (int)_workcontext.CurrentCustomer.ClientId),
new SqlParameter("@strInvoice", string.IsNullOrEmpty(model.strInvoice)?DBNull.Value.ToString():model.strInvoice),
new SqlParameter("@strVendor", string.IsNullOrEmpty(model.strVendor)?DBNull.Value.ToString():model.strVendor),
new SqlParameter("@strPO", string.IsNullOrEmpty(model.strPO)?DBNull.Value.ToString():model.strPO),
new SqlParameter("@strItem", string.IsNullOrEmpty(model.strItem)?DBNull.Value.ToString():model.strItem),
new SqlParameter("@strCostCenter", string.IsNullOrEmpty(model.strCostCenter)?DBNull.Value.ToString():model.strCostCenter),
new SqlParameter("@intVariance", model.intVariance)
};
var query = await _dbContext.Set <InvoiceDisplay2>().FromSqlRaw("exec InvoiceDisplay2 @intClientID,@strInvoice,@strVendor,@strPO,@strItem,@strCostCenter,@intVariance", pr).ToListAsync();
int totalCount = query.Count;
int pageOffSet = (Convert.ToInt32(pageIndex) - 1) * 10;
query = query.Skip(pageOffSet).Take(Convert.ToInt32(pageSize)).ToList();
return(query.ToList(), totalCount);
}
catch (Exception ex)
{
}
return(invoiceDisplay2, 0);
}
