public static List <OutcomesViewModel> Get(BudgetSearchViewModel search)
{
if (search.ToDate != null)
{
search.ToDate = search.ToDate.Value.AddDays(1);
}
if (search.FromDate != null)
{
search.FromDate = search.FromDate.Value.AddDays(-1);
}
using (var db = new ShlekenEntities3())
{
return(db.Outcomes
.Where(i => i.Projects.AccountId == Userservice.AccountId &&
(search.ProjectId == 0 || i.ProjectId == search.ProjectId) &&
(search.ToDate == null || i.Date < search.ToDate) &&
(search.FromDate == null || i.Date > search.FromDate)
)
.ToList()
.Select(i =>
{
var item = i.Map <Outcomes, OutcomesViewModel>();
item.ApproverName = i.Users.Name;
return item;
})
.ToList());
}
}
public ActionResult Budget(BudgetSearchViewModel search)
{
var Projects = Projectservice.Get();
Projects.Insert(0, new ProjectsViewModel()
{
Id = 0, Name = "All"
});
ViewBag.Projects = Projects;
var inc = new BudgetSearchViewModel();
var outc = new OutcomesearchViewModel();
var incomes = Incomeservice.Get(search);
var Outcomes = Outcomeservice.Get(search);
ViewBag.Search = search;
var items = new BudgetViewModel()
{
Incomes = incomes,
Outcomes = Outcomes,
IncomesTotal = incomes.Sum(i => i.Cost),
OutcomesTotal = Outcomes.Sum(i => i.Cost),
};
return(View(items));
}
public static List <IncomesViewModel> Get(int ProjectId, BudgetSearchViewModel search)
{
using (var db = new ShlekenEntities3())
{
return(db.Incomes
.Where(i => i.Projects.AccountId == Userservice.AccountId && i.ProjectId == ProjectId &&
(search.Cost == 0 || i.Cost == search.Cost) &&
(search.ApproverId == 0 || i.ApproverId == search.ApproverId) &&
(string.IsNullOrEmpty(search.Description) == true || i.Description.ToLower().Contains(search.Description.ToLower()))
)
.ToList()
.Select(i =>
{
var item = i.Map <Incomes, IncomesViewModel>();
item.ApproverName = i.Users.Name;
return item;
})
.ToList());
}
}
