public ActionResult Create([Bind(Include = "ID,EnrollmentDate,FirstName,LastName")] Student student)
{
if (ModelState.IsValid)
{
db.Students.Add(student);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(student));
}
public ActionResult Create([Bind(Include = "InstructorID,Location")] OfficeAssignment officeAssignment)
{
if (ModelState.IsValid)
{
db.OfficeAssigments.Add(officeAssignment);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.InstructorID = new SelectList(db.Instructors, "ID", "FirstName", officeAssignment.InstructorID);
return(View(officeAssignment));
}
public ActionResult Create([Bind(Include = "DepartmentID,Name,Budget,StartDate,InstructorID")] Department department)
{
if (ModelState.IsValid)
{
db.Departments.Add(department);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.InstructorID = new SelectList(db.Instructors, "ID", "FirstName", department.InstructorID);
return(View(department));
}
public ActionResult Create([Bind(Include = "CourseID,Title,Credits,DepartmentID")] Course course)
{
if (ModelState.IsValid)
{
db.Courses.Add(course);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DepartmentID = new SelectList(db.Departments, "DepartmentID", "Name", course.DepartmentID);
return(View(course));
}
public ActionResult Create([Bind(Include = "ID,HireDate,FirstName,LastName")] Instructor instructor)
{
if (ModelState.IsValid)
{
db.Instructors.Add(instructor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ID = new SelectList(db.OfficeAssigments, "InstructorID", "Location", instructor.ID);
return(View(instructor));
}
public ActionResult Create([Bind(Include = "InstructorID,CourseID")] Teaching teaching)
{
if (ModelState.IsValid)
{
db.Teachings.Add(teaching);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "Title", teaching.CourseID);
ViewBag.InstructorID = new SelectList(db.Instructors, "ID", "FirstName", teaching.InstructorID);
return(View(teaching));
}
public ActionResult Create([Bind(Include = "EnrollmentID,StudentID,CourseID,Grade")] Enrollment enrollment)
{
if (ModelState.IsValid)
{
db.Enrollments.Add(enrollment);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "Title", enrollment.CourseID);
ViewBag.StudentID = new SelectList(db.Students, "ID", "FirstName", enrollment.StudentID);
return(View(enrollment));
}
public void CreateStudent(CourseManagementSystemDbContext context)
{
if (!context.Students.Any())
{
var students = new List <Student>
{
new Student
{
FirstName = "Trong An",
LastName = "Nguyen",
EnrollmentDate = DateTime.Parse("2016-01-01")
},
new Student
{
FirstName = "Thien Hieu",
LastName = "Nguyen",
EnrollmentDate = DateTime.Parse("2016-01-02")
},
new Student
{
FirstName = "Tuan Nghia",
LastName = "Tran",
EnrollmentDate = DateTime.Parse("2016-01-03")
},
};
students.ForEach(s => context.Students.Add(s));
context.SaveChanges();
}
}
//Thieu dien departmentn Id cung sinh ra loi, nhung khong do dinh nghia ma do Â
public void CreateCourses(CourseManagementSystemDbContext context)
{
if (!context.Courses.Any())
{
var courses = new List <Course>
{
new Course {
CourseID = 1000, Title = "Submit 2", Credits = 10, DepartmentID = 1
},
new Course {
CourseID = 1001, Title = "Enterprice web software development", Credits = 11, DepartmentID = 2
},
new Course {
CourseID = 1002, Title = "Application development for mobile", Credits = 12, DepartmentID = 2
},
new Course {
CourseID = 1003, Title = "Interaction design", Credits = 13, DepartmentID = 2
},
new Course {
CourseID = 1004, Title = "Development framework", Credits = 14, DepartmentID = 2
},
new Course {
CourseID = 1005, Title = "Programming framework", Credits = 15, DepartmentID = 2
},
new Course {
CourseID = 1006, Title = "Database engineering", Credits = 16, DepartmentID = 2
},
};
courses.ForEach(s => context.Courses.Add(s));
context.SaveChanges();
}
}
public void CreateDepartments(CourseManagementSystemDbContext context)
{
if (!context.Departments.Any())
{
var departments = new List <Department>
{
new Department()
{
Name = "English Faculty",
Budget = 1000,
StartDate = DateTime.Parse("2010-01-01"),
InstructorID = 1
},
new Department()
{
Name = "Information Technology Faculty",
Budget = 1000,
StartDate = DateTime.Parse("2010-01-01"),
InstructorID = 2
}
};
departments.ForEach(d => context.Departments.Add(d));
context.SaveChanges();
}
}
public void CreateTeaching(CourseManagementSystemDbContext context)
{
if (!context.Teachings.Any())
{
var courses = new List <Teaching>
{
new Teaching {
CourseID = 1000, InstructorID = 1
},
};
courses.ForEach(t => context.Teachings.Add(t));
context.SaveChanges();
}
}
public void CreateOfficeOfficeAssigments(CourseManagementSystemDbContext context)
{
if (!context.OfficeAssigments.Any())
{
var officeAssignments = new List <OfficeAssignment>
{
new OfficeAssignment {
InstructorID = 1, Location = "Office A"
},
new OfficeAssignment {
InstructorID = 2, Location = "Office B"
}
};
officeAssignments.ForEach(o => context.OfficeAssigments.Add(o));
context.SaveChanges();
}
}
public void CreateEnrollments(CourseManagementSystemDbContext context)
{
if (!context.Enrollments.Any())
{
var enrollments = new List <Enrollment>
{
new Enrollment {
StudentID = 1, CourseID = 1000, Grade = Grade.Morning
},
new Enrollment {
StudentID = 1, CourseID = 1001, Grade = Grade.Morning
},
new Enrollment {
StudentID = 1, CourseID = 1002, Grade = Grade.Morning
},
new Enrollment {
StudentID = 2, CourseID = 1000
}
};
enrollments.ForEach(s => context.Enrollments.Add(s));
context.SaveChanges();
}
}
public void Createinstructors(CourseManagementSystemDbContext context)
{
if (!context.Instructors.Any())
{
var instructors = new List <Instructor>
{
new Instructor {
FirstName = "Nga", LastName = "Pham", HireDate = DateTime.Parse("2006-01-01")
},
new Instructor
{
FirstName = "Van Vung",
LastName = "Pham",
HireDate = DateTime.Parse("2006-01-02")
},
new Instructor
{
FirstName = "Thuy Duong",
LastName = "Pham",
HireDate = DateTime.Parse("2006-01-03")
},
new Instructor {
FirstName = "Jaya", LastName = "Jaya", HireDate = DateTime.Parse("2006-01-04")
},
new Instructor
{
FirstName = "Tung Son",
LastName = "Ngo",
HireDate = DateTime.Parse("2006-01-05")
},
};
instructors.ForEach(s => context.Instructors.Add(s));
context.SaveChanges();
}
;
}