public async Task <IQueryable <VCashFlow> > GetVCashFlow(FinancialReportsModel filter)
{
var data = await _cVCashFlowServices.QueryAsync();
if (!string.IsNullOrEmpty(filter.suplier))
{
data = data.Where(a => a.Person.FirstName.Contains(filter.suplier) || a.Person.LastName.Contains(filter.suplier));
}
if (!string.IsNullOrEmpty(filter.name))
{
data = data.Where(a => a.Name.Contains(filter.name));
}
if (!string.IsNullOrEmpty(filter.ExpenseNumber))
{
data = data.Where(a => a.CashFlowNumber.Contains(filter.ExpenseNumber));
}
if ((filter.dueDateStart.HasValue))
{
data = data.Where(a => a.DueDate.Value.Date >= filter.dueDateStart.Value.Date);
}
if ((filter.dueDateEnd.HasValue))
{
data = data.Where(a => a.DueDate.Value.Date <= filter.dueDateEnd.Value.Date);
}
if ((filter.duePayStart.HasValue))
{
data = data.Where(a => a.DuePayment.Value.Date >= filter.duePayStart.Value.Date);
}
if ((filter.duePayEnd.HasValue))
{
data = data.Where(a => a.DuePayment.Value.Date <= filter.duePayEnd.Value.Date);
}
if ((filter.createDateStart.HasValue))
{
data = data.Where(a => a.CreateDate.Value.Date >= filter.createDateStart.Value.Date);
}
if ((filter.createDateEnd.HasValue))
{
data = data.Where(a => a.CreateDate.Value.Date <= filter.createDateEnd.Value.Date);
}
if ((filter.value.HasValue))
{
data = data.Where(a => a.Total == filter.value.Value);
}
return(data);
}
public async Task <IActionResult> BankCash(FinancialReportsModel filter, string trahs)
{
LoadViewData();
IQueryable <BankTrans> data = await _financialExtension.GetBankTans(filter);
filter.BankTrans = data;
return(View(filter));
}
public async Task <IActionResult> Revenue(FinancialReportsModel filter, string name)
{
LoadViewData();
IQueryable <VRevenue> data = await _financialExtension.GetVRevenue(filter);
filter.VRevenue = data.Include(a => a.Revenue).ThenInclude(a => a.Person);
return(View(filter));
}
public async Task <IActionResult> Expense(FinancialReportsModel filter, string trash)
{
LoadViewData();
IQueryable <VExpense> data = await _financialExtension.GetVExpense(filter);
filter.VExpense = data.Include(a => a.Expense).ThenInclude(a => a.Person);
return(View(filter));
}
public async Task <IActionResult> CashflowReports(FinancialReportsModel filter, string trahs)
{
LoadViewData();
IQueryable <VCashFlow> data = await _financialExtension.GetVCashFlow(filter);
filter.VCashFlow = data;
return(View(filter));
}
public async Task <IQueryable <BankTrans> > GetBankTans(FinancialReportsModel filter)
{
var data = await _bankTransServices.QueryAsync(a => a.Deleted == false);
if (!string.IsNullOrEmpty(filter.suplier))
{
data = data.Where(a => a.Description.Contains(filter.suplier));
}
if ((filter.createDateStart.HasValue))
{
data = data.Where(a => a.CreateDate.Date >= filter.createDateStart.Value.Date);
}
if ((filter.createDateEnd.HasValue))
{
data = data.Where(a => a.CreateDate.Date <= filter.createDateEnd.Value.Date);
}
if ((filter.dueDateStart.HasValue))
{
data = data.Where(a => a.DueDate.Value.Date >= filter.dueDateStart.Value.Date);
}
if ((filter.dueDateEnd.HasValue))
{
data = data.Where(a => a.DueDate.Value.Date <= filter.dueDateEnd.Value.Date);
}
if ((filter.CategoryId.HasValue))
{
data = data.Where(a => a.ChartAccountId == filter.CategoryId);
}
if ((filter.AccountBankId.HasValue))
{
data = data.Where(a => a.AccountBankId == filter.AccountBankId);
}
if ((filter.value.HasValue))
{
data = data.Where(a => a.Total == filter.value.Value);
}
return(data);
}
public IActionResult BankCash(FinancialReportsModel filter)
{
LoadViewData();
return(View(filter));
}
public IActionResult Revenue(FinancialReportsModel filter)
{
return(View(filter));
}
public IActionResult Expense(FinancialReportsModel filter)
{
return(View(filter));
}