public ActionResult DeleteConfirmed(int id) { try { TempRoutine temproutine = db.TempRoutines.Find(id); if (User.Identity.Name == temproutine.UserName) { BackupHelper aBackupHelper = new BackupHelper(); db.TempRoutineBackupModels.Add(aBackupHelper.GetTempRoputineBackupData(temproutine)); db.Routines.Remove(temproutine); db.SaveChanges(); return(RedirectToAction("Index")); } else { ViewBag.message = "You are not the creator of this Routine So You can not Delete It"; return(View("Delete", temproutine)); } } catch { ViewBag.M1 = "Unable to load DeleteConfirmed TempRoutineController"; return(View("Delete")); } }
private bool checkPossibilitywithDate(TempRoutine temproutine) { //temproutine.TempRoutineDate.TimeOfDay = temproutine.Time_From.TimeOfDay; var currentDay = DateTime.Now; //var CurrentTime=DateTime.Now.TimeOfDay; if (DateTime.Compare(temproutine.TempRoutineDate, currentDay) == 1) { return(true); } //var testDay = DateTime.Now.ToString(); var testDay1 = DateTime.Now.Date.ToShortDateString(); //var test1 = DateTime.Compare(testDay, temproutine.TempRoutineDate); //DateTime aDate=Convert.ToDateTime("11/23/2010 09:05:00 PM"); //var test11 = DateTime.Compare(testDay,aDate ); //var test12 = DateTime.Compare(aDate, aDate); //var test2 = DateTime.Today; //var test13 = DateTime.Now.TimeOfDay; //var test14 = DateTime.Now.TimeOfDay.CompareTo(test13); //var test15 = DateTime.Now.TimeOfDay.CompareTo(aDate.TimeOfDay); //var test3 = DateTime.Now.Day.ToString(); //var test4 = DateTime.Now.DayOfWeek.ToString(); //return true; return(false); }
private bool CheckPossibilityWithUser(TempRoutine temproutine) { var name = User.Identity.Name; // //To test with today //DateTime day = DateTime.Now; //To test with given date //DateTime day = temproutine.TempRoutineDate; //try //{ // DateTime FromDate =GetFromDate(day); // DateTime ToDate = GetToDate(day); // int countchk = db.TempRoutines.Where(a => a.UserName == name).Where(a => a.TempRoutineDate >= FromDate && a.TempRoutineDate <= ToDate).Count(); //} //catch { } int count = db.TempRoutines.Where(a => a.UserName == name).Where(a => a.TempRoutineDate == temproutine.TempRoutineDate).Count(); if (count > 0) { return(false); } return(true); }
public ActionResult Create(int?id) { try { if (User.IsInRole("Admin") || User.IsInRole("Teacher")) { TempRoutine aTempRoutine = new TempRoutine(); if (id != null) { Routine aRoutine = db.Routines.Where(a => a.RoutineId == id).Select(a => a).FirstOrDefault(); aTempRoutine.Day = aRoutine.Day; aTempRoutine.Department = aRoutine.Department; aTempRoutine.RoutineDepartmentId = aRoutine.RoutineDepartmentId; aTempRoutine.Time_From = aRoutine.Time_From; aTempRoutine.Time_To = aRoutine.Time_To; aTempRoutine.ClassRoom = aRoutine.ClassRoom; aTempRoutine.RoutineClassroomId = aRoutine.RoutineClassroomId; aTempRoutine.RoutineType = aRoutine.RoutineType; aTempRoutine.RoutineTypeId = db.RoutineTypes.Where(a => a.TypeName == "Temporary").Select(a => a.RoutineTypeId).FirstOrDefault(); aRoutine.Year = Regex.Replace(aRoutine.Year, @"\0", ""); aTempRoutine.Year = aRoutine.Year; aTempRoutine.Semester = aRoutine.Semester; aTempRoutine.RoutineSemesterId = aRoutine.RoutineSemesterId; aTempRoutine.UserName = User.Identity.Name; aTempRoutine.RoutineTeacherId = db.Routines.Where(a => a.Teacher.Initial == User.Identity.Name).Select(a => a.Teacher.TeacherId).FirstOrDefault(); aTempRoutine.RoutineDepartmentId = db.Routines.Where(a => a.Teacher.Initial == User.Identity.Name).Select(a => a.Teacher.TeacherDeptId).FirstOrDefault(); aTempRoutine.TempRoutineDate = System.DateTime.Now; if (aTempRoutine.RoutineTeacherId == 0 || aTempRoutine.RoutineDepartmentId == 0) { ViewBag.ErrorMsg = "You Do not have any teacher initial in the routine.So you can not assign a make up class."; ViewBag.message = "You Do not have any teacher initial in the routine.So you can not assign a make up class."; return(View("Error")); } } else { aTempRoutine = null; ViewBag.DayName = new SelectList(db.Days, "DayName", "DayName"); ViewBag.RoutineTypeId = new SelectList(db.RoutineTypes, "RoutineTypeId", "TypeName"); ViewBag.RoutineSemesterId = new SelectList(db.Semesters, "SemesterId", "Name"); } ViewBag.RoutineCourseId = new SelectList(db.Routines.Where(a => a.Teacher.Initial == User.Identity.Name).Select(a => a.Course).Distinct(), "CourseId", "Code"); ViewBag.RoutineClassroomId = new SelectList(db.ClassRooms, "ClassRoomId", "RoomNo"); return(View(aTempRoutine)); } ViewBag.message = "Please Contact with the Admin because you are not authorize to do this."; return(View("Error", "Upload")); } catch { ViewBag.M = "Unable to load Create TempRoutineController"; return(View()); } }
private bool CheckPossibilityWithTimeSlot(TempRoutine temproutine) { List <TempRoutine> routineList = db.TempRoutines.Where(a => a.TempRoutineDate == temproutine.TempRoutineDate).Where(a => a.RoutineClassroomId == temproutine.RoutineClassroomId).Where(a => a.Time_From == temproutine.Time_From).Select(a => a).ToList(); if (routineList.Count > 0) { return(false); } //return true; return(true); }
private bool checkPossibilitywithDay(TempRoutine temproutine) { string chosenDay = temproutine.TempRoutineDate.DayOfWeek.ToString(); if (chosenDay == temproutine.Day) { return(true); } return(false); }
public ActionResult Delete(int id) { try { TempRoutine temproutine = db.TempRoutines.Find(id); return(View(temproutine)); } catch { ViewBag.M = "Unable to load Delete TempRoutineController"; return(View()); } }
private bool CheckPossibilityWithUser2(TempRoutine temproutine) { var name = User.Identity.Name; DateTime day = temproutine.TempRoutineDate; DateTime FromDate = GetFromDate(day); DateTime ToDate = GetToDate(day); int countchk = db.TempRoutines.Where(a => a.UserName == name).Where(a => a.TempRoutineDate >= FromDate && a.TempRoutineDate <= ToDate).Count(); if (countchk < 3) { return(true); } return(false); }
public ActionResult Edit(int id) { try { TempRoutine temproutine = db.TempRoutines.Find(id); ViewBag.RoutineCourseId = new SelectList(db.Courses, "CourseId", "Name", temproutine.RoutineCourseId); ViewBag.RoutineDepartmentId = new SelectList(db.Departments, "DepartmentId", "Name", temproutine.RoutineDepartmentId); ViewBag.RoutineClassroomId = new SelectList(db.ClassRooms, "ClassRoomId", "RoomNo", temproutine.RoutineClassroomId); ViewBag.RoutineTeacherId = new SelectList(db.Teachers, "TeacherId", "Name", temproutine.RoutineTeacherId); ViewBag.RoutineSemesterId = new SelectList(db.Semesters, "SemesterId", "Name", temproutine.RoutineSemesterId); ViewBag.RoutineTypeId = new SelectList(db.RoutineTypes, "RoutineTypeId", "TypeName", temproutine.RoutineTypeId); return(View(temproutine)); } catch { ViewBag.M = "Unable to load Edit TempRoutineController"; return(View()); } }
public ActionResult Edit(TempRoutine temproutine) { try { if (ModelState.IsValid) { if (User.Identity.Name == temproutine.UserName) { db.Entry(temproutine).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } else { ViewBag.message = "You are not the creator of this Routine So You can not Edit It"; ViewBag.RoutineCourseId = new SelectList(db.Courses, "CourseId", "Name", temproutine.RoutineCourseId); ViewBag.RoutineDepartmentId = new SelectList(db.Departments, "DepartmentId", "Name", temproutine.RoutineDepartmentId); ViewBag.RoutineClassroomId = new SelectList(db.ClassRooms, "ClassRoomId", "RoomNo", temproutine.RoutineClassroomId); ViewBag.RoutineTeacherId = new SelectList(db.Teachers, "TeacherId", "Name", temproutine.RoutineTeacherId); ViewBag.RoutineSemesterId = new SelectList(db.Semesters, "SemesterId", "Name", temproutine.RoutineSemesterId); ViewBag.RoutineTypeId = new SelectList(db.RoutineTypes, "RoutineTypeId", "TypeName", temproutine.RoutineTypeId); return(View(temproutine)); } } ViewBag.RoutineCourseId = new SelectList(db.Courses, "CourseId", "Name", temproutine.RoutineCourseId); ViewBag.RoutineDepartmentId = new SelectList(db.Departments, "DepartmentId", "Name", temproutine.RoutineDepartmentId); ViewBag.RoutineClassroomId = new SelectList(db.ClassRooms, "ClassRoomId", "RoomNo", temproutine.RoutineClassroomId); ViewBag.RoutineTeacherId = new SelectList(db.Teachers, "TeacherId", "Name", temproutine.RoutineTeacherId); ViewBag.RoutineSemesterId = new SelectList(db.Semesters, "SemesterId", "Name", temproutine.RoutineSemesterId); ViewBag.RoutineTypeId = new SelectList(db.RoutineTypes, "RoutineTypeId", "TypeName", temproutine.RoutineTypeId); return(View(temproutine)); } catch { ViewBag.M = "Unable to load Edit TempRoutineController"; return(View()); } }
public ActionResult Create(TempRoutine temproutine) { try { //temproutine.UserName = User.Identity.Name; if (ModelState.IsValid) { if (checkPossibilitywithDate(temproutine) == true) { if (CheckPossibilityWithUser(temproutine) == true) { if (CheckPossibilityWithUser2(temproutine) == true) { if (checkPossibilitywithDay(temproutine) == true) { if (CheckPossibilityWithTimeSlot(temproutine) == true) { temproutine.RoutineTypeId = db.RoutineTypes.Where(a => a.TypeName == "Temporary").Select(a => a.RoutineTypeId).FirstOrDefault(); db.TempRoutines.Add(temproutine); db.SaveChanges(); return(RedirectToAction("Index")); } else { string ft = temproutine.Time_From.TimeOfDay.ToString(); string tt = temproutine.Time_To.TimeOfDay.ToString(); string room = db.ClassRooms.Where(a => a.ClassRoomId == temproutine.RoutineClassroomId).Select(a => a.RoomNo).FirstOrDefault(); string givendate = temproutine.TempRoutineDate.Date.ToShortDateString(); string chosenDay = temproutine.TempRoutineDate.DayOfWeek.ToString(); string msg = "Room " + room + " is not available at " + givendate + " ( " + chosenDay + " )" + " from " + ft + " to " + tt; ViewBag.message = msg; ViewBag.RoutineCourseId = new SelectList(db.Routines.Where(a => a.Teacher.Initial == User.Identity.Name).Select(a => a.Course).Distinct(), "CourseId", "Code"); ViewBag.RoutineDepartmentId = new SelectList(db.Departments, "DepartmentId", "Code", temproutine.RoutineDepartmentId); ViewBag.RoutineClassroomId = new SelectList(db.ClassRooms, "ClassRoomId", "RoomNo", temproutine.RoutineClassroomId); ViewBag.RoutineTeacherId = new SelectList(db.Teachers, "TeacherId", "Initial", temproutine.RoutineTeacherId); ViewBag.RoutineSemesterId = new SelectList(db.Semesters, "SemesterId", "Name", temproutine.RoutineSemesterId); ViewBag.RoutineTypeId = new SelectList(db.RoutineTypes, "RoutineTypeId", "TypeName", temproutine.RoutineTypeId); ViewBag.DayName = new SelectList(db.Days, "DayName", "DayName"); return(View(temproutine)); } } else { var name = User.Identity.Name; DateTime day = temproutine.TempRoutineDate; DateTime FromDate = GetFromDate(day); DateTime ToDate = GetToDate(day); string msg = "You have already Booked 3 or more classes from ''" + FromDate.GetDateTimeFormats()[3].ToString() + "'' to ''" + ToDate.GetDateTimeFormats()[3].ToString() + "''"; ViewBag.message = msg; ViewBag.RoutineCourseId = new SelectList(db.Routines.Where(a => a.Teacher.Initial == User.Identity.Name).Select(a => a.Course).Distinct(), "CourseId", "Code"); ViewBag.RoutineDepartmentId = new SelectList(db.Departments, "DepartmentId", "Code", temproutine.RoutineDepartmentId); ViewBag.RoutineClassroomId = new SelectList(db.ClassRooms, "ClassRoomId", "RoomNo", temproutine.RoutineClassroomId); ViewBag.RoutineTeacherId = new SelectList(db.Teachers, "TeacherId", "Initial", temproutine.RoutineTeacherId); ViewBag.RoutineSemesterId = new SelectList(db.Semesters, "SemesterId", "Name", temproutine.RoutineSemesterId); ViewBag.RoutineTypeId = new SelectList(db.RoutineTypes, "RoutineTypeId", "TypeName", temproutine.RoutineTypeId); ViewBag.DayName = new SelectList(db.Days, "DayName", "DayName"); return(View(temproutine)); } } else { string chosenDay = temproutine.TempRoutineDate.DayOfWeek.ToString(); string msg = "The Day you choose is " + chosenDay + " which Does not match with make up slot day " + temproutine.Day; ViewBag.message = msg; ViewBag.RoutineCourseId = new SelectList(db.Routines.Where(a => a.Teacher.Initial == User.Identity.Name).Select(a => a.Course).Distinct(), "CourseId", "Code"); ViewBag.RoutineDepartmentId = new SelectList(db.Departments, "DepartmentId", "Code", temproutine.RoutineDepartmentId); ViewBag.RoutineClassroomId = new SelectList(db.ClassRooms, "ClassRoomId", "RoomNo", temproutine.RoutineClassroomId); ViewBag.RoutineTeacherId = new SelectList(db.Teachers, "TeacherId", "Initial", temproutine.RoutineTeacherId); ViewBag.RoutineSemesterId = new SelectList(db.Semesters, "SemesterId", "Name", temproutine.RoutineSemesterId); ViewBag.RoutineTypeId = new SelectList(db.RoutineTypes, "RoutineTypeId", "TypeName", temproutine.RoutineTypeId); ViewBag.DayName = new SelectList(db.Days, "DayName", "DayName"); return(View(temproutine)); } } else { string msg = "You have already Assigned a Class at " + temproutine.TempRoutineDate.Date.ToShortDateString(); ViewBag.message = msg; ViewBag.RoutineCourseId = new SelectList(db.Routines.Where(a => a.Teacher.Initial == User.Identity.Name).Select(a => a.Course).Distinct(), "CourseId", "Code"); ViewBag.RoutineDepartmentId = new SelectList(db.Departments, "DepartmentId", "Code", temproutine.RoutineDepartmentId); ViewBag.RoutineClassroomId = new SelectList(db.ClassRooms, "ClassRoomId", "RoomNo", temproutine.RoutineClassroomId); ViewBag.RoutineTeacherId = new SelectList(db.Teachers, "TeacherId", "Initial", temproutine.RoutineTeacherId); ViewBag.RoutineSemesterId = new SelectList(db.Semesters, "SemesterId", "Name", temproutine.RoutineSemesterId); ViewBag.RoutineTypeId = new SelectList(db.RoutineTypes, "RoutineTypeId", "TypeName", temproutine.RoutineTypeId); ViewBag.DayName = new SelectList(db.Days, "DayName", "DayName"); return(View(temproutine)); } } else { ViewBag.message = "Assigned Date have to be greater than Today"; ViewBag.RoutineCourseId = new SelectList(db.Routines.Where(a => a.Teacher.Initial == User.Identity.Name).Select(a => a.Course).Distinct(), "CourseId", "Code"); ViewBag.RoutineDepartmentId = new SelectList(db.Departments, "DepartmentId", "Code", temproutine.RoutineDepartmentId); ViewBag.RoutineClassroomId = new SelectList(db.ClassRooms, "ClassRoomId", "RoomNo", temproutine.RoutineClassroomId); ViewBag.RoutineTeacherId = new SelectList(db.Teachers, "TeacherId", "Initial", temproutine.RoutineTeacherId); ViewBag.RoutineSemesterId = new SelectList(db.Semesters, "SemesterId", "Name", temproutine.RoutineSemesterId); ViewBag.RoutineTypeId = new SelectList(db.RoutineTypes, "RoutineTypeId", "TypeName", temproutine.RoutineTypeId); ViewBag.DayName = new SelectList(db.Days, "DayName", "DayName"); return(View(temproutine)); } } ViewBag.RoutineCourseId = new SelectList(db.Routines.Where(a => a.Teacher.Initial == User.Identity.Name).Select(a => a.Course).Distinct(), "CourseId", "Code"); ViewBag.RoutineDepartmentId = new SelectList(db.Departments, "DepartmentId", "Code", temproutine.RoutineDepartmentId); ViewBag.RoutineClassroomId = new SelectList(db.ClassRooms, "ClassRoomId", "RoomNo", temproutine.RoutineClassroomId); ViewBag.RoutineTeacherId = new SelectList(db.Teachers, "TeacherId", "Initial", temproutine.RoutineTeacherId); ViewBag.RoutineSemesterId = new SelectList(db.Semesters, "SemesterId", "Name", temproutine.RoutineSemesterId); ViewBag.RoutineTypeId = new SelectList(db.RoutineTypes, "RoutineTypeId", "TypeName", temproutine.RoutineTypeId); ViewBag.DayName = new SelectList(db.Days, "DayName", "DayName"); return(View(temproutine)); } catch { ViewBag.M = "Unable to load Create TempRoutineController"; return(View()); } }
public ViewResult Details(int id) { TempRoutine temproutine = db.TempRoutines.Find(id); return(View(temproutine)); }