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 <OutcomesViewModel> Get(int ProjectId, OutcomesearchViewModel search)
{
using (var db = new ShlekenEntities3())
{
return(db.Outcomes
.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 <Outcomes, OutcomesViewModel>();
item.ApproverName = i.Users.Name;
return item;
})
.ToList());
}
}
