public ActionResult AddMemberSchedule(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } List <tb_WeekDay> DaysOfWeek = new List <tb_WeekDay>(); DaysOfWeek = db.tb_WeekDay.ToList(); List <SelectListItem> ScheduleStatuses = new List <SelectListItem>(); ScheduleStatuses.Add(new SelectListItem() { Text = "Inactive", Value = "0" }); ScheduleStatuses.Add(new SelectListItem() { Text = "Active", Value = "1" }); SemesterTaughtModel model = new SemesterTaughtModel() { _MemberID = id ?? 0, _Room = String.Empty, _Class = String.Empty, _StartTime = new DateTime(), _EndTime = new DateTime(), _ClassWeekDayID = 0, _WeekDays = DaysOfWeek, _ScheduleStatusID = 1, _ScheduleStatuses = ScheduleStatuses }; //var colleges = db.tb_College.OrderBy(o => o.CollegeName); //int collegeID = colleges.FirstOrDefault().CollegeID; //ViewBag.Colleges = new SelectList(colleges, "CollegeID", "CollegeName"); //ViewBag.CollegeID = collegeID; var colleges = db.tb_College.ToList(); List <SelectListItem> li = new List <SelectListItem>(); li.Add(new SelectListItem { Text = "--Select College--", Value = "0" }); foreach (var m in colleges) { li.Add(new SelectListItem { Text = m.CollegeName, Value = m.CollegeID.ToString() }); ViewBag.Colleges = li; } return(View(model)); }
public ActionResult AddSchedule(SemesterTaughtModel model, int?Campus, int?Building, int?Blding, FormCollection formCollection) { //var semesterRecID = db.tb_Semesters.Where(t => t.DateFrom >= DateTime.UtcNow && t.DateTo < DateTime.UtcNow).FirstOrDefault().SemesterRecID; bool scheduleStatus = false; if (model._ScheduleStatusID == 1) { scheduleStatus = true; } int semesterRecID = 0; try { // >>check here semesterRecID = db.tb_Semesters.Where(t => t.SemesterYear == DateTime.UtcNow.Year.ToString()) .Where(t => t.SemesterStartDate <= DateTime.UtcNow) .Where(t => t.SemesterEndDate > DateTime.UtcNow).FirstOrDefault().SemesterID; } catch (Exception) { // not good here. situation when DateTime.UtcNow isn't in semester period. taking next semester then // >>check here semesterRecID = db.tb_Semesters.Where(t => t.SemesterStartDate > DateTime.UtcNow).FirstOrDefault().SemesterID; } tb_SemesterTaught newSemesterTaught = new tb_SemesterTaught() { SemesterRecID = semesterRecID, MemberID = model._MemberID, BuildingID = Building ?? 0, //not present on the Knock page Room = model._Room ?? " ", Class = model._Class ?? " ", ClassStart = model._StartTime.TimeOfDay, ClassEnd = model._EndTime.TimeOfDay, ClassWeekDayID = model._ClassWeekDayID, ScheduleStatus = scheduleStatus }; ////if (oldAssessment == null) ////{ //// db.tb_Assessment.Add(AssessActivity._Assessment); ////} if (ModelState.IsValid) { db.tb_SemesterTaught.Add(newSemesterTaught); db.SaveChanges(); return(RedirectToAction("Details", "Home", new { @id = model._MemberID })); } return(View(model)); }
public ActionResult AddSchedule(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } List <tb_WeekDay> DaysOfWeek = new List <tb_WeekDay>(); DaysOfWeek = db.tb_WeekDay.ToList(); List <SelectListItem> ScheduleStatuses = new List <SelectListItem>(); ScheduleStatuses.Add(new SelectListItem() { Text = "Inactive", Value = "0" }); ScheduleStatuses.Add(new SelectListItem() { Text = "Active", Value = "1" }); SemesterTaughtModel model = new SemesterTaughtModel() { _MemberID = id ?? 0, _Room = String.Empty, _Class = String.Empty, _StartTime = new DateTime(), _EndTime = new DateTime(), _ClassWeekDayID = 0, _WeekDays = DaysOfWeek, _ScheduleStatusID = 1, _ScheduleStatuses = ScheduleStatuses }; var colleges = db.tb_College.OrderBy(o => o.CollegeName); int collegeID = colleges.FirstOrDefault().CollegeID; ViewBag.Colleges = new SelectList(colleges, "CollegeID", "CollegeName"); ViewBag.CollegeID = collegeID; var campuses = db.tb_Campus.Where(c => c.CollegeID == collegeID).OrderBy(o => o.CampusName); int campusID = campuses.FirstOrDefault().CampusID; ViewBag.Campuses = new SelectList(campuses, "CampusID", "CampusName"); ViewBag.CampusID = campusID; ViewBag.BuildingID = db.tb_Building.Where(c => c.CampusID == campusID).OrderBy(o => o.BuildingName).FirstOrDefault().BuildingID; return(View(model)); }
public ActionResult AddMemberSchedule(SemesterTaughtModel model, int?building /*, FormCollection formCollection*/) { Error error = new Error(); error.errCode = ErrorDetail.Success; error.errMsg = ErrorDetail.GetMsg(error.errCode); List <string> errs = new List <string>(); List <tb_WeekDay> DaysOfWeek = new List <tb_WeekDay>(); DaysOfWeek = db.tb_WeekDay.ToList(); model._WeekDays = DaysOfWeek; List <SelectListItem> ScheduleStatuses = new List <SelectListItem>(); ScheduleStatuses.Add(new SelectListItem() { Text = "Inactive", Value = "0" }); ScheduleStatuses.Add(new SelectListItem() { Text = "Active", Value = "1" }); model._ScheduleStatuses = ScheduleStatuses; var colleges = db.tb_College.ToList(); List <SelectListItem> li = new List <SelectListItem>(); li.Add(new SelectListItem { Text = "--Select College--", Value = "0" }); foreach (var m in colleges) { li.Add(new SelectListItem { Text = m.CollegeName, Value = m.CollegeID.ToString(), Selected = true }); } ViewBag.Colleges = li; if (model._StartTime.TimeOfDay >= model._EndTime.TimeOfDay) { ModelState.AddModelError("Error", "Enter an End Time that is later than Start time"); return(View(model)); } if (building == null || building <= 0) { ModelState.AddModelError("Required field", "Building was not selected"); return(View(model)); } bool scheduleStatus = false; if (model._ScheduleStatusID == 1) { scheduleStatus = true; } int semesterRecID = 0; try { // >>check here semesterRecID = db.tb_Semesters.Where(t => t.SemesterYear == DateTime.UtcNow.Year.ToString()) .Where(t => t.SemesterStartDate <= DateTime.UtcNow) .Where(t => t.SemesterEndDate > DateTime.UtcNow).FirstOrDefault().SemesterID; } catch (Exception) { // not good here. situation when DateTime.UtcNow isn't in semester period. taking next semester then // >>check here semesterRecID = db.tb_Semesters.Where(t => t.SemesterStartDate > DateTime.UtcNow).FirstOrDefault().SemesterID; } tb_SemesterTaught newSemesterTaught = new tb_SemesterTaught() { SemesterRecID = semesterRecID, MemberID = model._MemberID, BuildingID = building ?? 0, //not present on the Knock page Room = model._Room ?? " ", Class = model._Class ?? " ", ClassStart = model._StartTime.TimeOfDay, ClassEnd = model._EndTime.TimeOfDay, ClassWeekDayID = model._ClassWeekDayID, ScheduleStatus = scheduleStatus }; if (ModelState.IsValid) { db.tb_SemesterTaught.Add(newSemesterTaught); db.SaveChanges(); return(RedirectToAction("Details", "Home", new { @id = model._MemberID })); } return(View(model)); }