public ActionResult AddCourse([Bind(Include = "Course_code,Course_title,Credit_hour,Semester,UnderFaculty,UnderDepartment,CourseTeacherID")] Course course)
{
if (!HasSession()) return RedirectToAction("Index", "Home");
course.Course_code = course.Course_code.Trim().Replace(" ", "_").Replace("-", "_").ToUpper();
Course crs = db.Courses.Where(a => a.Course_code == course.Course_code).FirstOrDefault();
string message = course.Course_code + " Course Already Exsist.";
if (crs == null)
{
CreateDatabaseAndTable cdt = new CreateDatabaseAndTable(course.UnderFaculty);
message = cdt.AddCourse(course.Course_code, course.Semester);
Teacher tcr = db.Teacher.Where(dp => dp.TeacherID == course.CourseTeacherID).FirstOrDefault();
if (tcr != null)
{
course.CourseTeacherName = tcr.Name;
course.CourseTeacherDepartment = tcr.Department;
course.CourseTeacherFaculty = tcr.Faculty;
}
db.Courses.Add(course);
db.SaveChanges();
}
ViewBag.Message = message + " Under "
+ course.UnderFaculty + " faculty, under " + course.UnderDepartment + " department.";
//ViewBag.Message = course.Course_code + " added failed or already exists.";
ViewBag.faculties = db.Faculty.ToList();
return View();
}
public ActionResult AddFaculty([Bind(Include = "FacultyName,ShortForm")] Faculty faculty)
{
if (!HasSession())
{
return(RedirectToAction("Index", "Home"));
}
faculty.ShortForm = faculty.ShortForm.ToUpper();
if (db.Faculty.Where(a => a.ShortForm == faculty.ShortForm || a.FacultyName == faculty.FacultyName).FirstOrDefault() == null)
{
CreateDatabaseAndTable cdt = new CreateDatabaseAndTable(faculty.ShortForm);
cdt.CreateDatabase(faculty.ShortForm);
db.Faculty.Add(faculty);
db.SaveChanges();
ViewBag.Message = "Successfully Faculty Added..! ";
}
else
{
ViewBag.ErrorMessage = "Faculty Already Exists..!";
}
return(View());
}
public ActionResult EditCourse([Bind(Include = "id,Course_code,Course_title,Credit_hour,Semester,UnderFaculty,CourseTeacherID")] Course course)
{
if (!HasSession()) return RedirectToAction("Index", "Home");
Course crs = db.Courses.Find(course.id);
db.Entry(crs).State = EntityState.Detached;
course.Course_code = course.Course_code.Trim().Replace(" ", "_").Replace("-", "_").ToUpper();
if (!crs.Course_code.Equals(course.Course_code))
{
CreateDatabaseAndTable cdt = new CreateDatabaseAndTable(crs.UnderFaculty);
cdt.AlterCourseTable(crs.Course_code, course.Course_code);
string table = (course.Semester % 2 == 1) ? "JanEnrollment" : "JulEnrollment";
cdt.RenameTableColumn(table, crs.Course_code, course.Course_code);
}
if (ModelState.IsValid)
{
Teacher tcr = db.Teacher.Where(dp => dp.TeacherID == course.CourseTeacherID).FirstOrDefault();
if (tcr != null)
{
course.CourseTeacherName = tcr.Name;
course.CourseTeacherDepartment = tcr.Department;
course.CourseTeacherFaculty = tcr.Faculty;
}
db.Entry(course).State = EntityState.Modified;
db.SaveChanges();
ViewBag.Message = course.Course_code + " Updated!";
}
else ViewBag.Error = course.Course_code + " Not Updated!";
return RedirectToAction("ManageCourse", "Course");
}
public ActionResult EditFaculties([Bind(Include = "id,FacultyName,ShortForm")] Faculty faculty)
{
if (!HasSession())
{
return(RedirectToAction("Index", "Home"));
}
faculty.ShortForm = faculty.ShortForm.ToUpper();
Faculty oldFaculty = db.Faculty.Find(faculty.id);
db.Entry(oldFaculty).State = EntityState.Detached;
Boolean ck = false;
if (!faculty.ShortForm.Equals(oldFaculty.ShortForm))
{
CreateDatabaseAndTable cdt = new CreateDatabaseAndTable(oldFaculty.ShortForm);
ck = cdt.AlterDatabase(oldFaculty.ShortForm, faculty.ShortForm);
}
if (ck == false)
{
return(View(db.Faculty.Find(faculty.id)));
}
if (ModelState.IsValid)
{
db.Entry(faculty).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("ManageFaculty", "Faculty"));
}
