private List <ShowCalendarDay> planCalendar(CalendarInfo check)
{
var startDate = DateTime.ParseExact(check.FDate, "dd/MM/yyyy", null);
var endDate = DateTime.ParseExact(check.TDate, "dd/MM/yyyy", null);
List <ShowCalendarDay> planTimes = new List <ShowCalendarDay>();
for (DateTime date = startDate; date <= endDate;)
{
ShowCalendarDay data = new ShowCalendarDay()
{
date = date.ToString("dd/MM/yyyy"),
code = date.ToString("ddMMyyyy"),
dayOfWeek = mapDayOfWeeks[date.DayOfWeek],
plan = new List <ShowCalendarAgency>(),
work = new List <ShowCalendarAgency>()
};
var planCode = date.ToString("ddMMyyyy");
var listPlan = db.CalendarPlans.Where(p => p.CalendarId == check.Id && p.CDate == planCode).ToList();
foreach (var item in listPlan)
{
data.plan.Add(new ShowCalendarAgency()
{
id = item.MAgency.Id,
code = item.MAgency.Code,
name = item.MAgency.Store,
target = item.Targets.Value.ToString("C", Util.Cultures.VietNam)
});
}
var listWork = db.CalendarWorks.Where(p => p.StaffId == check.StaffId && p.CDate == planCode && p.Perform == 1).ToList();
foreach (var item in listWork)
{
data.work.Add(new ShowCalendarAgency()
{
id = item.MAgency.Id,
code = item.MAgency.Code,
name = item.MAgency.Store
});
}
planTimes.Add(data);
date = date.AddDays(1);
}
return(planTimes);
}
public ActionResult ShowDetail(string id)
{
AddMenu(0);
var check = db.CalendarInfoes.Find(id);
if (check == null || check.CStatus != 0)
{
return(Redirect("/error"));
}
var startDate = DateTime.ParseExact(check.FDate, "dd/MM/yyyy", null);
var endDate = DateTime.ParseExact(check.TDate, "dd/MM/yyyy", null);
List <ShowCalendarDay> planTimes = new List <ShowCalendarDay>();
for (DateTime date = startDate; date <= endDate;)
{
ShowCalendarDay data = new ShowCalendarDay()
{
date = date.ToString("dd/MM/yyyy"),
code = date.ToString("ddMMyyyy"),
dayOfWeek = mapDayOfWeeks[date.DayOfWeek],
plan = new List <ShowCalendarAgency>(),
work = new List <ShowCalendarAgency>()
};
var planCode = date.ToString("ddMMyyyy");
var listPlan = db.CalendarPlans.Where(p => p.CalendarId == check.Id && p.CDate == planCode).ToList();
foreach (var item in listPlan)
{
data.plan.Add(new ShowCalendarAgency()
{
id = item.MAgency.Id,
code = item.MAgency.Code,
name = item.MAgency.Store,
target = item.Targets.Value.ToString("C", Util.Cultures.VietNam)
});
}
var listWork = db.CalendarWorks.Where(p => p.StaffId == check.StaffId && p.CDate == planCode && p.Perform == 1).ToList();
foreach (var item in listWork)
{
data.work.Add(new ShowCalendarAgency()
{
id = item.MAgency.Id,
code = item.MAgency.Code,
name = item.MAgency.Store
});
}
planTimes.Add(data);
date = date.AddDays(1);
}
ViewBag.PlanTime = planTimes;
return(View(check));
}
