public ActionResult Index(RequirementSearchViewModel vm)
{
var firstDay = DateTime.UtcNow.AddDays(-31);
var lastDay = DateTime.UtcNow;
ViewBag.CategoryId = new SelectList(_requirementCategoryRepository.GetAll(), "Id", "Title", vm.CategoryId);
ViewBag.SourceId = new SelectList(_crmLeadSourceRepository.GetAll(), "Id", "Title", vm.SourceId);
Func <IQueryable <Requirement>, IQueryable <Requirement> > requirementFilter = q =>
{
if (vm.SourceId.HasValue)
{
q = q.Where(r => r.SourceId == vm.SourceId.Value);
}
if (vm.CategoryId.HasValue)
{
q = q.Where(r => r.CategoryId == vm.CategoryId.Value);
}
if (vm.Status.HasValue)
{
q = q.Where(r => r.RequirementStatus == vm.Status.Value);
}
if (vm.StartDate.HasValue)
{
q = q.Where(r => r.CreatedOn >= vm.StartDate.Value);
firstDay = vm.StartDate.Value;
}
if (vm.EndDate.HasValue)
{
q = q.Where(r => r.CreatedOn <= vm.EndDate.Value);
lastDay = vm.EndDate.Value;
}
return(q);
};
vm.Total = _requirementRepository.Count();
Func <IQueryable <Requirement>, IQueryable <Requirement> > postedRequirementFilter = q =>
{
q = q.Where(r => r.CreatedOn >= firstDay && r.PostedOn != null);
return(requirementFilter(q));
};
Func <IQueryable <Requirement>, IQueryable <Requirement> > closedRequirementFilter = q =>
{
q = q.Where(r => r.CreatedOn >= firstDay && r.RequirementStatus == RequirementStatus.Won);
return(requirementFilter(q));
};
Func <IQueryable <Requirement>, IQueryable <Requirement> > lostRequirementFilter = q =>
{
q = q.Where(r => r.CreatedOn >= firstDay && r.RequirementStatus == RequirementStatus.Lost);
return(requirementFilter(q));
};
var postedRequirements = _requirementRepository.Search(postedRequirementFilter)
.ToList()
.GroupBy(r => r.CreatedOn.ToShortDateString())
.Select(r => new { Day = r.Key, Total = r.Count() });
var closedRequirements = _requirementRepository.Search(closedRequirementFilter)
.ToList()
.GroupBy(r => r.CreatedOn.ToShortDateString())
.Select(r => new { Day = r.Key, Total = r.Count() });
var lostRequirements = _requirementRepository.Search(lostRequirementFilter)
.ToList()
.GroupBy(r => r.CreatedOn.ToShortDateString())
.Select(r => new { Day = r.Key, Total = r.Count() });
var dateArray = new List <string> {
"x"
};
var postedArray = new List <string> {
"new"
};
var closedArray = new List <string> {
"won"
};
var lostArray = new List <string> {
"lost"
};
var counter = firstDay;
while (counter <= lastDay)
{
var selectedDay = counter.ToShortDateString();
dateArray.Add(selectedDay);
var selectedPost = postedRequirements.FirstOrDefault(p => p.Day == selectedDay);
postedArray.Add(selectedPost?.Total.ToString() ?? "0");
var selectedClosed = closedRequirements.FirstOrDefault(p => p.Day == selectedDay);
closedArray.Add(selectedClosed != null ? selectedClosed.Total.ToString() : "0");
var selectedLost = lostRequirements.FirstOrDefault(p => p.Day == selectedDay);
lostArray.Add(selectedLost != null ? selectedLost.Total.ToString() : "0");
counter = counter.AddDays(1);
}
ViewBag.Dates = dateArray;
ViewBag.Posts = postedArray;
ViewBag.Closed = closedArray;
ViewBag.Lost = lostArray;
return(View(vm));
}