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));
}
