public ActionResult Create(int id, WorkCountViewModel collection) { try { using (OnlineShopDbContext db = new OnlineShopDbContext()) { WorkCountViewModel model = new WorkCountViewModel(); model.Thiet_Bi = db.Thiet_Bis.OrderBy(m => m.ID).ToList(); model.ProjectAll = new List <SelectListItem>(); var items = new List <SelectListItem>(); foreach (var project in model.Thiet_Bi) { items.Add(new SelectListItem() { Value = project.Ten_Thiet_Bi, Text = project.Ten_Thiet_Bi, }); } model.ProjectAll = items; var Check = model.Thiet_Bi[0].Ten_Thiet_Bi; model.Catelory_Project = db.Catelories.Where(i => i.Prj_Name == Check).ToList(); model.Number_Team_2 = model.Catelory_Project.Count(); model.SelectedProject = null; int j = 0; model.WorkCount = db.WorkCounts.Where(i => i.CreateDate == collection.SelectedWorkCount.CreateDate).ToList(); if (model.WorkCount.Count() != 0) { return(View("Index", model)); } foreach (var item in collection.Count_Number) { WorkCount obj = new WorkCount(); model.WorkCount = db.WorkCounts.Where(i => i.CreateDate == collection.SelectedWorkCount.CreateDate).ToList(); obj.Ten_Thiet_Bi = Check; obj.Unit_Name = model.Catelory_Project[j].Unit_Name; obj.CreateDate = collection.SelectedWorkCount.CreateDate; obj.Unit_Number = item; db.WorkCounts.Add(obj); db.SaveChanges(); j = j + 1; } return(View("Index", model)); } } catch { return(View()); } }
// // GET: /Admin/WorkCount/ public ActionResult Index() { using (OnlineShopDbContext db = new OnlineShopDbContext()) { WorkCountViewModel model = new WorkCountViewModel(); model.Thiet_Bi = db.Thiet_Bis.OrderBy(m => m.ID).ToList(); model.ProjectAll = new List <SelectListItem>(); var items = new List <SelectListItem>(); foreach (var project in model.Thiet_Bi) { items.Add(new SelectListItem() { Value = project.Ten_Thiet_Bi, Text = project.Ten_Thiet_Bi, }); } model.ProjectAll = items; var Check = model.Thiet_Bi[0].Ten_Thiet_Bi; model.Catelory_Project = db.Catelories.Where(i => i.Prj_Name == Check).ToList(); model.Number_Team_2 = model.Catelory_Project.Count(); model.WorkCount = null; return(View(model)); } }
public ActionResult Edit(int id, WorkCountViewModel collection) { try { using (OnlineShopDbContext db = new OnlineShopDbContext()) { WorkCountViewModel model = new WorkCountViewModel(); model.Thiet_Bi = db.Thiet_Bis.OrderBy(m => m.ID).ToList(); model.ProjectAll = new List <SelectListItem>(); var items = new List <SelectListItem>(); foreach (var project in model.Thiet_Bi) { items.Add(new SelectListItem() { Value = project.Ten_Thiet_Bi, Text = project.Ten_Thiet_Bi, }); } model.ProjectAll = items; var Check = model.Thiet_Bi[0].Ten_Thiet_Bi; model.Catelory_Project = db.Catelories.Where(i => i.Prj_Name == Check).ToList(); model.Number_Team_2 = model.Catelory_Project.Count(); model.SelectedProject = null; model.WorkCount = db.WorkCounts.Where(i => i.Ten_Thiet_Bi == collection.SelectedProject.Ten_Thiet_Bi && i.CreateDate >= collection.StartDate && i.CreateDate <= collection.EndDate).ToList(); var dates = new List <DateTime>(); for (var dt = collection.StartDate; dt <= collection.EndDate; dt = dt.AddDays(1)) { dates.Add(dt); } model.SelectDate = dates; return(View("Index", model)); } } catch { return(View()); } }
public ActionResult Edit(int id, WorkCountViewModel collection) { try { using (OnlineShopDbContext db = new OnlineShopDbContext()) { WorkCountViewModel model = new WorkCountViewModel(); model.Thiet_Bi = db.Thiet_Bis.OrderBy(m => m.ID).ToList(); model.ProjectAll = new List <SelectListItem>(); var items = new List <SelectListItem>(); foreach (var project in model.Thiet_Bi) { items.Add(new SelectListItem() { Value = project.Ten_Thiet_Bi, Text = project.Ten_Thiet_Bi, }); } model.ProjectAll = items; var Check = model.Thiet_Bi[0].Ten_Thiet_Bi; model.Catelory_Project = db.Catelories.Where(i => i.Prj_Name == Check).ToList(); model.Number_Team_2 = model.Catelory_Project.Count(); model.SelectedProject = null; collection.Catelory_Project = model.Catelory_Project; var dates = new List <DateTime>(); var all_number = new List <int>(); var all_job_number_temp = new List <int>(); var all_job_number = new List <List <int> >(); var Date = db.WorkCounts.Where(i => i.CreateDate >= collection.StartDate && i.CreateDate <= collection.EndDate).Select(i => i.CreateDate).Distinct().ToList(); var Date_Count = db.WorkCounts.Where(i => i.CreateDate >= collection.StartDate && i.CreateDate <= collection.EndDate).Select(i => i.CreateDate).Distinct().Count(); model.List_Job = db.WorkCounts.Where(i => i.CreateDate >= collection.StartDate && i.CreateDate <= collection.EndDate).Select(i => i.Unit_Job).Distinct().ToList(); model.Number_Job = db.WorkCounts.Where(i => i.CreateDate >= collection.StartDate && i.CreateDate <= collection.EndDate).Select(i => i.Unit_Job).Distinct().Count(); DateTime Date_te = Convert.ToDateTime(Date[0]); var dt = Date_te; List <List <WorkCount> > myList = new List <List <WorkCount> >(); for (var temp_test = 0; temp_test < Date_Count; dt = dt.AddDays(1), temp_test++) { DateTime Date_Temp_Test = Convert.ToDateTime(Date[temp_test]); dates.Add(Date_Temp_Test); model.WorkCount = db.WorkCounts.Where(i => i.Ten_Thiet_Bi == collection.SelectedProject.Ten_Thiet_Bi && i.CreateDate == Date_Temp_Test).ToList(); myList.Add(model.WorkCount); int temp_all_number = 0; for (var j = 0; j < model.WorkCount.Count(); j++) { temp_all_number = temp_all_number + (int)model.WorkCount[j].Unit_Number; } all_number.Add(temp_all_number); for (var j = 0; j < model.Number_Job; j++) { int temp_job_all_number = 0; int temp_job = 0; for (var i = 0; i < model.WorkCount.Count(); i++) { if (model.WorkCount[i].Unit_Job == model.List_Job[j]) { temp_job_all_number = temp_job_all_number + (int)model.WorkCount[i].Unit_Number; } temp_job = i; } all_job_number_temp.Add(temp_job_all_number); } } List <List <WorkCount> > myList_2 = new List <List <WorkCount> >(); foreach (var item in collection.Catelory_Project) { model.WorkCount_Temp_2 = db.WorkCounts.Where(i => i.Ten_Thiet_Bi == collection.SelectedProject.Ten_Thiet_Bi && i.Unit_Name == item.Unit_Name && i.CreateDate >= collection.StartDate && i.CreateDate <= collection.EndDate).OrderBy(i => i.CreateDate).ToList(); myList_2.Add(model.WorkCount_Temp_2); } model.WorkCount_List = myList; model.WorkCount_List_2 = myList_2; model.SelectDate = dates; model.Total_number = all_number; model.Total_Job_number_2 = all_job_number_temp; return(View("Index", model)); } } catch { return(View()); } }