// GET: Invoices/Client/5
public async Task <IActionResult> Client(int?id)
{
var data = new ClientInvoicesViewModel()
{
Client = await _context.Accounts.FirstOrDefaultAsync(m => m.AccountId == id),
Invoices = await _context.Set <ClientInvoicesPayments>()
.FromSql("dbo.ClientStatement @ID = {0}, @From = NULL, @To = NULL", id).ToListAsync() // await _context.Invoices.Include(i => i.InvoiceType).Where(m => m.AccountId == id).ToListAsync()
};
return(View(data));
}
public async Task <IActionResult> SearchClientStatement(int?id, DateTime?from = null, DateTime?to = null)
{
string _from = string.Format("{0:MM/dd/yyyy}", from),
_to = string.Format("{0:MM/dd/yyyy}", to);
_from = string.IsNullOrEmpty(_from) ? "NULL" : "'" + _from + "'";
_to = string.IsNullOrEmpty(_to) ? "NULL" : "'" + _to + "'";
string query = string.Format("EXEC dbo.ClientStatement @ID = {0}, @From={1}, @To={2}", id, _from, _to);
var data = new ClientInvoicesViewModel()
{
Client = await _context.Accounts.FirstOrDefaultAsync(m => m.AccountId == id),
Invoices = await _context.ClientInvoicesPayments.FromSql(query).ToListAsync()
//Invoices = await _context.Set<ClientInvoicesPayments>().FromSql("dbo.ClientStatement @ID = {0}, @From={1}, @To={2}", id, _from, _to).ToListAsync() // await _context.Invoices.Include(i => i.InvoiceType).Where(m => m.AccountId == id).ToListAsync()
};
return(View(nameof(Client), data));
}
