// GET: StudentFacultySemesters
public ActionResult Index()
{
String sql = "SELECT * FROM faculties f, students co, semesters s, StudentFacultySemesters fsc where fsc.studentid = co.studentid and f.facultyid = fsc.facultyid and s.semesterid = fsc.semesterid";
db.List(sql);
var dt = db.List(sql);
var model = new StudentFacultySemester().List(dt);
return(View(model));
}
public ActionResult Create(StudentVM studentVMObj)
{
if (ModelState.IsValid)
{
db.Students.Add(studentVMObj.Student);
var stdFacSemObj = new StudentFacultySemester();
stdFacSemObj = new StudentFacultySemester()
{
StudentID = studentVMObj.Student.StudentID,
FacultyID = studentVMObj.FacultyID,
SemesterID = studentVMObj.SemesterID
};
db.StudentFacultySemesters.Add(stdFacSemObj);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(studentVMObj.Student));
}
