public int Assign(CourseToTeacherModel courseToTeacher)
{
query = "update TeacherTable set RemainingCredit=RemainingCredit+'" + courseToTeacher.CourseCredit +
"' where id=" + courseToTeacher.TeacherId;
Command = new SqlCommand(query, Connection);
Connection.Open();
int rowEffect = Command.ExecuteNonQuery();
Connection.Close();
query = "INSERT INTO CourseToTeacher VALUES('" + courseToTeacher.TeacherId + "', '" + courseToTeacher.CourseId + "',1)";
Command = new SqlCommand(query, Connection);
if (rowEffect > 0)
{
Connection.Open();
rowEffect = Command.ExecuteNonQuery();
Connection.Close();
}
return(rowEffect);
}
public string Assign(CourseToTeacherModel courseToTeacher)
{
int rowEffect = courseToTeacherGateway.Assign(courseToTeacher);
if (rowEffect > 0)
{
return("Sace Success");
}
else
{
return("Sace Faild");
}
}
public ActionResult Save(CourseToTeacherModel courseToTeacher)
{
ViewBag.Title = "Course To Teacher ";
ViewBag.departments = courseToTeacherManager.DepartmentDropdownlist();
if (courseToTeacherManager.IsCoursAssigned(courseToTeacher.CourseId) == false)
{
ViewBag.message = courseToTeacherManager.Assign(courseToTeacher);
}
else
{
ViewBag.message = "Course is not available";
}
return(View());
}