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)); }