public ActionResult Create(CourseVM model)
{
if (ModelState.IsValid)
{
//String sql = "Insert into Courses (CourseName, CourseCode, CreditHour) values ('" + course.CourseName + "', '" + course.CourseCode + "', '" + course.CreditHour + "')";
//db.Create(sql);
db.Courses.Add(model.Course);
var facSemCouObj = new FacultySemesterCourse();
facSemCouObj = new FacultySemesterCourse()
{
FacultyID = model.FacultyID,
SemesterID = model.SemesterID,
CourseID = model.Course.CourseID
};
db.FacultySemesterCourses.Add(facSemCouObj);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(model.Course));
}
// GET: FacultySemesterCourses
public ActionResult Index()
{
String sql = "SELECT * FROM faculties f, Courses co, semesters s, facultysemestercourses fsc where fsc.courseid = co.courseid and f.facultyid = fsc.facultyid and s.semesterid = fsc.semesterid";
db.List(sql);
var dt = db.List(sql);
var model = new FacultySemesterCourse().List(dt);
return(View(model));
}
