public ActionResult SaveAssignedTeacher(CourseAssignedToTeacher aCourseAssignedToTeacher)
{
List <Department> departments = aManager.GetAllDepartments();
ViewBag.Departments = departments;
ViewBag.Message = aManager.SaveCourseAssigned(aCourseAssignedToTeacher);
return(View());
}
public int UpdateCourseAssigned(CourseAssignedToTeacher aCourseAssignedToTeacher)
{
Query = "UPDATE Teacher SET RemainingCredit=(SELECT RemainingCredit FROM Teacher WHERE Id='" + aCourseAssignedToTeacher.TeacherId + "')-(SELECT Credit FROM Courses WHERE Id='" +
aCourseAssignedToTeacher.CourseId + "') WHERE Id='" + aCourseAssignedToTeacher.TeacherId + "'";
Command = new SqlCommand(Query, Connection);
Connection.Open();
int result = Command.ExecuteNonQuery();
Connection.Close();
return(result);
}
public int SaveCourseAssigned(CourseAssignedToTeacher aCourseAssignedToTeacher)
{
Query = "INSERT INTO TeacherAssignedToCourse(DepartmentId,TeacherId,CourseId,AssignFlag) Values ('" +
aCourseAssignedToTeacher.DepartmentId + "', " + aCourseAssignedToTeacher.TeacherId + ", " +
aCourseAssignedToTeacher.CourseId + ", '" + 1 + "')";
Command = new SqlCommand(Query, Connection);
Connection.Open();
int result = Command.ExecuteNonQuery();
Connection.Close();
result = UpdateCourseAssigned(aCourseAssignedToTeacher);
return(result);
}
public string SaveCourseAssigned(CourseAssignedToTeacher aCourseAssignedToTeacher)
{
bool hasCourse = aGateway.IsCourseAssigned(aCourseAssignedToTeacher);
if (hasCourse)
{
return("This course has already been assigned");
}
else
{
int rowsAffected = aGateway.SaveCourseAssigned(aCourseAssignedToTeacher);
if (rowsAffected > 0)
{
return("Course has been assigned successfully");
}
return("An error occured");
}
}
public bool IsCourseAssigned(CourseAssignedToTeacher aCourseToTeacher)
{
Query = "SELECT * FROM TeacherAssignedToCourse WHERE CourseId='" + aCourseToTeacher.CourseId + "' AND AssignFlag ='1'";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
bool hasCourse = false;
if (Reader.HasRows)
{
hasCourse = true;
}
Reader.Close();
Connection.Close();
return(hasCourse);
}
