public ActionResult DeleteConfirmed(int id)
{
tb_SemesterTaught tb_SemesterTaught = db.tb_SemesterTaught.Find(id);
db.tb_SemesterTaught.Remove(tb_SemesterTaught);
db.SaveChanges();
return(RedirectToAction("Index"));
}
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 Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tb_SemesterTaught tb_SemesterTaught = db.tb_SemesterTaught.Find(id);
if (tb_SemesterTaught == null)
{
return(HttpNotFound());
}
return(View(tb_SemesterTaught));
}
public ActionResult Edit([Bind(Include = "SemesterTaughtID,SemesterRecID,MemberID,RoomID,ClassID,ClassStart,ClassEnd,ClassWeekDayID")] tb_SemesterTaught tb_SemesterTaught)
{
if (ModelState.IsValid)
{
db.Entry(tb_SemesterTaught).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
//ViewBag.ClassID = new SelectList(db.tb_Class, "ClassID", "ClassName", tb_SemesterTaught.ClassID);
ViewBag.SemesterRecID = new SelectList(db.tb_Semesters, "SemesterRecID", "FiscalYear", tb_SemesterTaught.SemesterRecID);
//ViewBag.RoomID = new SelectList(db.tb_Room, "RoomID", "RoomName", tb_SemesterTaught.RoomID);
ViewBag.ClassWeekDayID = new SelectList(db.tb_WeekDay, "ClassWeekDayID", "WeekDayName", tb_SemesterTaught.ClassWeekDayID);
ViewBag.MemberID = new SelectList(db.tb_MemberMaster, "MemberID", "MemberIDNumber", tb_SemesterTaught.MemberID);
return(View(tb_SemesterTaught));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tb_SemesterTaught tb_SemesterTaught = db.tb_SemesterTaught.Find(id);
if (tb_SemesterTaught == null)
{
return(HttpNotFound());
}
//ViewBag.ClassID = new SelectList(db.tb_Class, "ClassID", "ClassName", tb_SemesterTaught.ClassID);
ViewBag.SemesterRecID = new SelectList(db.tb_Semesters, "SemesterRecID", "FiscalYear", tb_SemesterTaught.SemesterRecID);
//ViewBag.RoomID = new SelectList(db.tb_Room, "RoomID", "RoomName", tb_SemesterTaught.RoomID);
ViewBag.ClassWeekDayID = new SelectList(db.tb_WeekDay, "ClassWeekDayID", "WeekDayName", tb_SemesterTaught.ClassWeekDayID);
ViewBag.MemberID = new SelectList(db.tb_MemberMaster, "MemberID", "MemberIDNumber", tb_SemesterTaught.MemberID);
return(View(tb_SemesterTaught));
}
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));
}
