コード例 #1
0
        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));
        }
コード例 #2
0
        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));
        }
コード例 #3
0
        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));
        }
コード例 #4
0
        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));
        }