public ActionResult Create(Course_Ent course_Ent, string TeacherName)
{
Course_DAL course_DAL = new Course_DAL();
//Teacher_DAL teacher_DAL = new Teacher_DAL();
if (!course_DAL.Check_Exist(course_Ent.CourseID))
{
Teacher_DAL teacher_DAL = new Teacher_DAL();
ViewBag.Teachers = teacher_DAL.GetTeachers();
ViewBag.Message = "ID Tồn Tại !";
return(View());
}
Teacher_Ent teacher = new Teacher_Ent();
teacher.TeacherID = int.Parse(TeacherName);
//teacher.TeacherName = teacher_DAL.GetName(teacher.TeacherID);
course_Ent.Teacher = teacher;
if (!(course_DAL.Add_Course(course_Ent)))
{
Teacher_DAL teacher_DAL = new Teacher_DAL();
ViewBag.Teachers = teacher_DAL.GetTeachers();
ViewBag.Message = "Có Lỗi Xảy Ra !";
return(View());
}
return(RedirectToAction("Course", "Course"));
}
public Teacher_Ent GetTeacher_Ent(int id)
{
Teacher temp = db.Teachers.Where(t => t.TeacherID == id).FirstOrDefault();
Teacher_Ent teacher_Ent = new Teacher_Ent();
if (temp != null)
{
teacher_Ent.TeacherID = temp.TeacherID;
teacher_Ent.TeacherName = temp.TeacherName;
}
return(teacher_Ent);
}
public ActionResult Edit(Teacher_Ent teacher_Ent)
{
if (ModelState.IsValid)
{
Teacher_DAL teacher_DAL = new Teacher_DAL();
if (!(teacher_DAL.Edit(teacher_Ent)))
{
ViewBag.Message = "Có Lỗi Xảy Ra !";
return(View());
}
}
return(RedirectToAction("Teacher", "Teacher"));
}
public Course_Ent GetCourse_Ent(int id)
{
Course course = db.Courses.Where(c => c.CourseID == id).FirstOrDefault();
Course_Ent course_Ent = new Course_Ent();
Teacher_DAL teacher_DAL = new Teacher_DAL();
Teacher_Ent teacher_Ent = new Teacher_Ent();
course_Ent.CourseID = course.CourseID;
course_Ent.CourseName = course.CourseName;
course_Ent.Location = course.Location;
teacher_Ent.TeacherID = course.TeacherID;
teacher_Ent.TeacherName = teacher_DAL.GetName(course.TeacherID);
course_Ent.Teacher = teacher_Ent;
return(course_Ent);
}
public List <Teacher_Ent> GetTeachers()
{
List <Teacher_Ent> teachers = new List <Teacher_Ent>();
foreach (Teacher teacher in db.Teachers)
{
Teacher_Ent teacher_Ent = new Teacher_Ent();
teacher_Ent.TeacherID = teacher.TeacherID;
teacher_Ent.TeacherName = teacher.TeacherName;
teachers.Add(teacher_Ent);
}
return(teachers);
}
public Boolean Add(Teacher_Ent teacher_ent)
{
try
{
Teacher teacher = new Teacher();
teacher.TeacherID = teacher_ent.TeacherID;
teacher.TeacherName = teacher_ent.TeacherName;
db.Teachers.Add(teacher);
db.SaveChanges();
}
catch
{
return(false);
}
return(true);
}
public ActionResult Create(Teacher_Ent teacher_Ent)
{
if (ModelState.IsValid)
{
Teacher_DAL teacher_DAL = new Teacher_DAL();
if (!(teacher_DAL.Check_Exist(teacher_Ent.TeacherID)))
{
ViewBag.Message = "ID Tồn Tại !";
return(View());
}
if (!(teacher_DAL.Add(teacher_Ent)))
{
ViewBag.Message = "Có Lỗi Xảy Ra !";
return(View());
}
}
return(RedirectToAction("Teacher", "Teacher"));
}
public Boolean Edit(Teacher_Ent teacher_ent)
{
Teacher temp = db.Teachers.Where(t => t.TeacherID == teacher_ent.TeacherID).FirstOrDefault();
if (temp == null)
{
return(false);
}
try
{
temp.TeacherName = teacher_ent.TeacherName;
db.SaveChanges();
}
catch
{
return(false);
}
return(true);
}
public ActionResult Edit(Course_Ent course_Ent, string TeacherName)
{
Course_DAL course_DAL = new Course_DAL();
//Teacher_DAL teacher_DAL = new Teacher_DAL();
Teacher_Ent teacher = new Teacher_Ent();
teacher.TeacherID = int.Parse(TeacherName);
//teacher.TeacherName = teacher_DAL.GetName(teacher.TeacherID);
course_Ent.Teacher = teacher;
if (!(course_DAL.Edit(course_Ent)))
{
Teacher_DAL teacher_DAL = new Teacher_DAL();
ViewBag.Teachers = teacher_DAL.GetTeachers();
ViewBag.Message = "Có Lỗi Xảy Ra !";
return(View());
}
return(RedirectToAction("Course", "Course"));
}
public List <Course_Ent> GetCourses()
{
Teacher_DAL teacher_DAL = new Teacher_DAL();
List <Course_Ent> courses = new List <Course_Ent>();
foreach (Course course in db.Courses.ToList())
{
Course_Ent course_ent = new Course_Ent();
course_ent.CourseID = course.CourseID;
course_ent.CourseName = course.CourseName;
course_ent.Location = course.Location;
Teacher_Ent teacher_Ent = new Teacher_Ent();
teacher_Ent.TeacherID = course.TeacherID;
teacher_Ent.TeacherName = teacher_DAL.GetName(course.TeacherID);
course_ent.Teacher = teacher_Ent;
courses.Add(course_ent);
}
return(courses);
}
