public ActionResult Register(FormCollection frmController)
{
Course_DAL course_DAL = new Course_DAL();
Student_DAL student_DAL = new Student_DAL();
int id_course = int.Parse(frmController["CourseName"]);
string student_name = frmController["txtStudentName"];
Student_Ent student_Ent = new Student_Ent();
student_Ent.StudentName = student_name;
//Add Student to SQL
if (!(student_DAL.Add(student_Ent)))
{
ViewBag.Courses = course_DAL.GetCourses();
ViewBag.Message = "Có Lỗi Xảy Ra !";
return(View());
}
int id_student = student_DAL.GetID_byName(student_name);
if (!course_DAL.Add_Register(id_course, id_student))
{
ViewBag.Courses = course_DAL.GetCourses();
ViewBag.Message = "Có Lỗi Xảy Ra !";
return(View());
}
ViewBag.Courses = course_DAL.GetCourses();
ViewBag.Message = "Successfully !";
return(View());
}
public Student_Ent GetStudent_Ent(int id)
{
Student temp = db.Students.Where(s => s.StudentID == id).FirstOrDefault();
Student_Ent student_Ent = new Student_Ent();
if (temp != null)
{
student_Ent.StudentID = temp.StudentID;
student_Ent.StudentName = temp.StudentName;
}
return(student_Ent);
}
public ActionResult Edit(Student_Ent stu_ent)
{
if (ModelState.IsValid)
{
Student_DAL student_DAL = new Student_DAL();
if (!(student_DAL.Edit(stu_ent)))
{
ViewBag.Message = "Có Lỗi Xảy Ra !";
return(View());
}
}
return(RedirectToAction("Student", "Student"));
}
public List <Student_Ent> GetStudents()
{
List <Student_Ent> students = new List <Student_Ent>();
foreach (Student student in db.Students)
{
Student_Ent student_Ent = new Student_Ent();
student_Ent.StudentID = student.StudentID;
student_Ent.StudentName = student.StudentName;
students.Add(student_Ent);
}
return(students);
}
public Boolean Add(Student_Ent stu_ent)
{
try
{
Student student = new Student();
student.StudentName = stu_ent.StudentName;
db.Students.Add(student);
db.SaveChanges();
}
catch
{
return(false);
}
return(true);
}
public ActionResult Create(Student_Ent stu_ent)
{
Student_DAL student_DAL = new Student_DAL();
if (!(student_DAL.Check_Exist(stu_ent.StudentID)))
{
ViewBag.Message = "ID Tồn Tại !";
return(View());
}
if (!(student_DAL.Add(stu_ent)))
{
ViewBag.Message = "Có Lỗi Xảy Ra !";
return(View());
}
return(RedirectToAction("Student", "Student"));
}
public Boolean Edit(Student_Ent stu_ent)
{
Student temp = db.Students.Where(s => s.StudentID == stu_ent.StudentID).FirstOrDefault();
if (temp == null)
{
return(false);
}
try
{
temp.StudentName = stu_ent.StudentName;
db.SaveChanges();
}
catch
{
return(false);
}
return(true);
}
