public PlanningViewModel(JAGToddlerDatabaseContext context, DateTime planDate, int storeId, int classId)
{
SelectedPlanDate = new DateTime(planDate.Year, planDate.Month, 1, 0, 0, 0);
StoreList = context.Stores
.OrderBy(s => s.StoreName)
.AsNoTracking()
.ToList();
SelectedStoreId = storeId;
StoreSelect = new SelectList(StoreList, "StoreId", "StoreName", SelectedStoreId).ToList();
//#TODO
//Should this search StoreList instead even though I would need to use a loop?
int?companyId = context.Stores
.Find(storeId)
.CompanyId;
ClassList = context.Classifications
.Include(c => c.Dept)
.Where(c => c.Dept.CompanyId == companyId)
.Select(c => new Classifications
{
Classes = c.Classes,
ClassId = c.ClassId
})
.OrderBy(c => c.Classes)
.AsNoTracking()
.ToList();
SelectedClassId = classId;
ClassSelect = new SelectList(ClassList, "ClassId", "Classes", SelectedClassId);
PlanningModel = new Planning(context, SelectedPlanDate, SelectedStoreId, SelectedClassId);
}
public Planning(JAGToddlerDatabaseContext context)
{
_context = context;
PlanDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1, 0, 0, 0);
StoreId = 0;
ClassId = 0;
TwoPriorYear = Enumerable.Empty <LogEntries>();
PriorYear = Enumerable.Empty <LogEntries>();
CurrentYear = Enumerable.Empty <LogEntries>();
NextYear = Enumerable.Empty <LogEntries>();
}
public Planning(JAGToddlerDatabaseContext context, DateTime planDate, int storeId, int classId)
{
_context = context;
PlanDate = new DateTime(planDate.Year, planDate.Month, 1, 0, 0, 0);
StoreId = storeId;
ClassId = classId;
//#TODO
//Break out helper function to retrieve log entries for certain time frames.
TwoPriorYear = context.LogEntries
.Where(l => l.ClassId == ClassId)
.Where(l => l.StoreId == StoreId)
.Where(l => l.LogDate >= PlanDate.AddMonths(-36) && l.LogDate < PlanDate.AddMonths(-24))
.OrderBy(l => l.LogDate)
.AsNoTracking()
.ToList();
PriorYear = context.LogEntries
.Where(l => l.ClassId == ClassId)
.Where(l => l.StoreId == StoreId)
.Where(l => l.LogDate >= PlanDate.AddMonths(-24) && l.LogDate < PlanDate.AddMonths(-12))
.OrderBy(l => l.LogDate)
.AsNoTracking()
.ToList();
CurrentYear = context.LogEntries
.Where(l => l.ClassId == ClassId)
.Where(l => l.StoreId == StoreId)
.Where(l => l.LogDate >= PlanDate.AddMonths(-12) && l.LogDate < PlanDate)
.OrderBy(l => l.LogDate)
.AsNoTracking()
.ToList();
//#TODO
//This list should track entities state for forecast updates.
NextYear = context.LogEntries
.Where(l => l.ClassId == ClassId)
.Where(l => l.StoreId == StoreId)
.Where(l => l.LogDate >= PlanDate && l.LogDate < PlanDate.AddMonths(12))
.OrderBy(l => l.LogDate)
.ToList();
}
public PlanningViewModel(JAGToddlerDatabaseContext context)
{
SelectedPlanDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1, 0, 0, 0);
StoreList = context.Stores
.OrderBy(s => s.StoreName)
.AsNoTracking()
.ToList();
SelectedStoreId = 0;
StoreSelect = new SelectList(StoreList, "StoreId", "StoreName", SelectedStoreId).ToList();
StoreSelect.Insert(0, (new SelectListItem {
Text = "Select a Store", Value = "0"
}));
ClassList = new List <Classifications>();
SelectedClassId = 0;
ClassSelect = new SelectList(ClassList, "ClassId", "Classes", SelectedClassId);
PlanningModel = new Planning(context);
}
public PlanningController(JAGToddlerDatabaseContext context)
{
_context = context;
}
