public ActionResult Add(CalendarWorkingModel data, string submit) { var model = new CalendarWorking { ID = data.ID, Name_CalendarWorking = data.Name_CalendarWorking, Description = data.Description, DateStart = data.DateStart, DateEnd = data.DateEnd, Address = data.Address, WorkState = data.WorkState, Status = data.Status, Files = data.Files, }; var userLogin = (UserLogin)Session[Managing_Teacher_Work.Common.CommonConstants.USER_SESSION]; var checkCalendar = db.CalendarWorking.Where(x => (model.ID != 0 ? x.ID != model.ID : true)).ToList() .Where(x => x.CalendarWorkingTeacher.Select(n => n.TeacherID).ToArray().Intersect(data.TeachersIDArray).Any() && x.DateStart.Date <= model.DateEnd.Date && x.DateEnd.Date >= model.DateStart.Date); var calendarWorkingTeachers = new List <CalendarWorkingTeacher>(); if (checkCalendar.Count() > 0) { SetAlert("Giảng viên đã có lịch công tác trong thời gian này! :D", "error"); return(RedirectToAction("Index")); } if (submit == "Thêm") { isThemMoi = true; if (model != null) { model.Name_CalendarWorking = model.Name_CalendarWorking.ToString(); model.Description = model.Description.ToString(); model.DateStart = model.DateStart; model.DateEnd = model.DateEnd; model.Address = model.Address != null ? model.Address : ""; model.WorkState = model.WorkState; model.Status = model.Status; model.CreatedDate = model.CreatedDate.GetValueOrDefault(System.DateTime.Now); foreach (var item in data.TeachersIDArray) { calendarWorkingTeachers.Add(new CalendarWorkingTeacher { TeacherID = item, CalendarWorkingID = model.ID, }); } model.CalendarWorkingTeacher = calendarWorkingTeachers; db.CalendarWorking.Add(model); db.CalendarWorkingTeacher.AddRange(calendarWorkingTeachers); db.SaveChanges(); model = null; } SetAlert("Thêm thông tin thành công! :D", "success"); return(RedirectToAction("Index")); } else if (submit == "Cập Nhật") { isThemMoi = false; if (model != null) { db.CalendarWorkingTeacher.RemoveRange(db.CalendarWorkingTeacher.Where(x => x.CalendarWorkingID == model.ID)); db.SaveChanges(); var list = db.CalendarWorking.SingleOrDefault(x => x.ID == model.ID); list.Name_CalendarWorking = model.Name_CalendarWorking; list.Description = model.Description; list.DateStart = model.DateStart; list.DateEnd = model.DateEnd; list.Address = model.Address; list.WorkState = model.WorkState; list.Status = model.Status; list.ModifiedDate = model.CreatedDate.GetValueOrDefault(System.DateTime.Now); foreach (var item in data.TeachersIDArray) { calendarWorkingTeachers.Add(new CalendarWorkingTeacher { TeacherID = item, CalendarWorkingID = model.ID, }); } model.CalendarWorkingTeacher = calendarWorkingTeachers; db.CalendarWorkingTeacher.AddRange(calendarWorkingTeachers); db.SaveChanges(); model = null; } SetAlert("Cập nhật thông tin thành công! :D", "success"); return(RedirectToAction("Index")); } else if (submit == "Tìm") { if (!string.IsNullOrEmpty(model.Name_CalendarWorking)) { List <CalendarWorking> list = GetData().Where(s => s.Name_CalendarWorking.Contains(model.Name_CalendarWorking)).ToList(); return(View("Index", list)); } else { List <CalendarWorking> list = GetData(); return(View("Index", list)); } } else { List <CalendarWorking> list = GetData().OrderBy(s => s.Name_CalendarWorking).ToList(); return(View("Index", list)); } }
public Task <bool> CreateCalendarWorkingAsync(CalendarWorking model) { throw new NotImplementedException(); }
public ActionResult Add(CalendarWorking model, string submit) { if (submit == "Thêm") { isThemMoi = true; if (model != null) { model.Name_CalendarWorking = model.Name_CalendarWorking.ToString(); model.Description = model.Description.ToString(); model.DateStart = model.DateStart; model.DateEnd = model.DateEnd; model.Address = model.Address != null ? model.Address : ""; model.TeacherID = model.TeacherID; model.WorkID = model.WorkID; model.TypeCalendarID = model.TypeCalendarID; model.WorkState = model.WorkState; model.Status = model.Status; model.CreatedDate = model.CreatedDate.GetValueOrDefault(System.DateTime.Now); db.CalendarWorking.Add(model); db.SaveChanges(); model = null; } SetAlert("Thêm thông tin thành công! :D", "success"); return(RedirectToAction("Index")); } else if (submit == "Cập Nhật") { isThemMoi = false; if (model != null) { var list = db.CalendarWorking.SingleOrDefault(x => x.ID == model.ID); list.Name_CalendarWorking = model.Name_CalendarWorking; list.Description = model.Description; list.DateStart = model.DateStart; list.DateEnd = model.DateEnd; list.Address = model.Address.ToString(); list.TeacherID = model.TeacherID; list.WorkID = model.WorkID; list.TypeCalendarID = model.TypeCalendarID; list.WorkState = model.WorkState; list.Status = model.Status; list.ModifiedDate = model.CreatedDate.GetValueOrDefault(System.DateTime.Now); db.SaveChanges(); model = null; } SetAlert("Cập nhật thông tin thành công! :D", "success"); return(RedirectToAction("Index")); } else if (submit == "Tìm") { if (!string.IsNullOrEmpty(model.Name_CalendarWorking)) { List <CalendarWorking> list = GetData().Where(s => s.Name_CalendarWorking.Contains(model.Name_CalendarWorking)).ToList(); return(View("Index", list)); } else { List <CalendarWorking> list = GetData(); return(View("Index", list)); } } else { List <CalendarWorking> list = GetData().OrderBy(s => s.Name_CalendarWorking).ToList(); return(View("Index", list)); } }