public ActionResult Create([Bind(Include = "Id,RoleName,Department,Description")] Role role)
{
if (ModelState.IsValid)
{
db.Roles.Add(role);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(role));
}
public ActionResult Create([Bind(Include = "DepartmentID,DepartmentName,Administrator")] Department department)
{
if (ModelState.IsValid)
{
db.Departments.Add(department);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(department));
}
public ActionResult Create([Bind(Include = "Id,Location,ClassTime")] Schedule schedule)
{
if (ModelState.IsValid)
{
db.Schedules.Add(schedule);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(schedule));
}
public ActionResult Create([Bind(Include = "StudentID,FirstName,LastName,MiddleName,DepartmentID,Password")] Student student)
{
if (ModelState.IsValid)
{
db.Students.Add(student);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DepartmentID = new SelectList(db.Departments, "DepartmentID", "DepartmentName", student.DepartmentID);
return(View(student));
}
public ActionResult Create([Bind(Include = "TeacherID,FirstName,LastName,MiddleName,DepartmentID,Password")] Teacher teacher)
{
if (ModelState.IsValid)
{
db.Teachers.Add(teacher);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DepartmentID = new SelectList(db.Departments, "DepartmentID", "DepartmentName", teacher.DepartmentID);
return(View(teacher));
}
public ActionResult Create([Bind(Include = "Id,DeptName,Adminstrator")] Department department)
{
if (ModelState.IsValid)
{
db.Departments.Add(department);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Adminstrator = new SelectList(db.People, "Id", "FirstName", department.Adminstrator);
return(View(department));
}
public ActionResult Create([Bind(Include = "Id,CourseTitle,DepartmentId,ScheduleId,Assignment,Credit")] Course course)
{
if (ModelState.IsValid)
{
db.Courses.Add(course);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DepartmentId = new SelectList(db.Departments, "Id", "DeptName", course.DepartmentId);
ViewBag.ScheduleId = new SelectList(db.Schedules, "Id", "Location", course.ScheduleId);
return(View(course));
}
public ActionResult Create([Bind(Include = "Id,Major,YearLevel")] Student student)
{
if (ModelState.IsValid)
{
db.Students.Add(student);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Major = new SelectList(db.Departments, "Id", "DeptName", student.Major);
ViewBag.Id = new SelectList(db.People, "Id", "FirstName", student.Id);
return(View(student));
}
public ActionResult Create([Bind(Include = "Id,DepartmentId,Speciality")] Instructor instructor)
{
if (ModelState.IsValid)
{
db.Instructors.Add(instructor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DepartmentId = new SelectList(db.Departments, "Id", "DeptName", instructor.DepartmentId);
ViewBag.Id = new SelectList(db.People, "Id", "FirstName", instructor.Id);
return(View(instructor));
}
public ActionResult Create([Bind(Include = "Id,CourseId,StudentId")] Enrollment enrollment)
{
if (ModelState.IsValid)
{
db.Enrollments.Add(enrollment);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CourseId = new SelectList(db.Courses, "Id", "CourseTitle", enrollment.CourseId);
ViewBag.StudentId = new SelectList(db.Students, "Id", "Major", enrollment.StudentId);
return(View(enrollment));
}
public ActionResult Create([Bind(Include = "Id,FirstName,LastName,MiddleName,Email,Password")] Person person)
{
if (ModelState.IsValid)
{
db.People.Add(person);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Id = new SelectList(db.Instructors, "Id", "Speciality", person.Id);
ViewBag.Id = new SelectList(db.Students, "Id", "Major", person.Id);
return(View(person));
}
public ActionResult Create([Bind(Include = "CourseID,CourseName,DepartmentID,TeacherID,CourseDescription")] Course course)
{
if (ModelState.IsValid)
{
db.Courses.Add(course);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DepartmentID = new SelectList(db.Departments, "DepartmentID", "DepartmentName", course.DepartmentID);
ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "CourseName", course.CourseID);
ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "CourseName", course.CourseID);
ViewBag.TeacherID = new SelectList(db.Teachers, "TeacherID", "FirstName", course.TeacherID);
return(View(course));
}
public void Add(Person obj)
{
using (var context = new TobChatDbContext())
{
context.People.Add(obj);
context.SaveChanges();
}
}
public void Add(Schedule obj)
{
using (var context = new TobChatDbContext())
{
context.Schedules.Add(obj);
context.SaveChanges();
}
}
public void Add(Student obj)
{
using (var context = new TobChatDbContext())
{
context.Students.Add(obj);
context.SaveChanges();
}
}
public void Add(Instructor obj)
{
using (var context = new TobChatDbContext())
{
context.Instructors.Add(obj);
context.SaveChanges();
}
}
public void Add(Course obj)
{
using (var context = new TobChatDbContext())
{
context.Courses.Add(obj);
context.SaveChanges();
}
}
public void Delete(int id)
{
using (var context = new TobChatDbContext())
{
var delete = context.Schedules.First(p => p.Id == id);
context.Schedules.Remove(delete);
context.SaveChanges();
}
}
public void Delete(int id)
{
using (var context = new TobChatDbContext())
{
var delete = context.Students.First(s => s.Id == id);
context.Students.Remove(delete);
context.SaveChanges();
}
}
public void Delete(int id)
{
using (var context = new TobChatDbContext())
{
var delete = context.Instructors.First(i => i.Id == id);
context.Instructors.Remove(delete);
context.SaveChanges();
}
}
public void Update(Schedule obj)
{
using (var context = new TobChatDbContext())
{
var update = context.Schedules.First(p => p.Id == obj.Id);
update.Location = obj.Location;
update.ClassTime = obj.ClassTime;
context.SaveChanges();
}
}
public void Update(Student obj)
{
using (var context = new TobChatDbContext())
{
var update = context.Students.First(s => s.Id == obj.Id);
update.Major = obj.Major;
update.YearLevel = obj.YearLevel;
context.SaveChanges();
}
}
public void Update(Department obj)
{
using (var context = new TobChatDbContext())
{
var update = context.Departments.First(d => d.Id == obj.Id);
update.DeptName = obj.DeptName;
update.Adminstrator = obj.Adminstrator;
context.SaveChanges();
}
}
public void Update(Role obj)
{
using (var context = new TobChatDbContext())
{
var update = context.Roles.First(p => p.Id == obj.Id);
update.RoleName = obj.RoleName;
update.Department = obj.Department;
update.Description = obj.Description;
context.SaveChanges();
}
}
public void Update(Enrollment obj)
{
using (var context = new TobChatDbContext())
{
var update = context.Enrollments.First(s => s.Id == obj.Id);
update.CourseId = obj.CourseId;
update.StudentId = obj.StudentId;
update.Grade = obj.Grade;
context.SaveChanges();
}
}
public void Update(Person obj)
{
using (var context = new TobChatDbContext())
{
var update = context.People.First(p => p.Id == obj.Id);
update.FirstName = obj.FirstName;
update.LastName = obj.LastName;
update.MiddleName = obj.MiddleName;
update.Password = obj.Password;
update.Email = obj.Email;
context.SaveChanges();
}
}
public void Update(Course obj)
{
using (var context = new TobChatDbContext())
{
var update = context.Courses.First(c => c.Id == obj.Id);
update.CourseTitle = obj.CourseTitle;
update.DepartmentId = obj.DepartmentId;
update.ScheduleId = obj.ScheduleId;
update.Assignment = obj.Assignment;
update.Credit = obj.Credit;
context.SaveChanges();
}
}