public ActionResult AssignCourse(AsignCourse asignCourse)
{
ViewBag.AllTeacher = aTeacherManager.GetAllTeacher();
ViewBag.AllDepartment = aDepartmentManager.GetAllDepartment();
ViewBag.Message = aTeacherManager.AssignCourse(asignCourse);
return(View());
}
internal string AssignCourse(AsignCourse asignCourse)
{
try
{
if (aTeacherGateway.IsExistCourseId(asignCourse.CourseId))
{
return("Course already Assigned");
}
else if (aTeacherGateway.AssignCourse(asignCourse) > 0)
{
return("CousreAssigned");
}
else
{
return("Cousre Assigned Failed");
}
}
catch (Exception)
{
return("Cousre Assigned Failed");
}
}
internal int AssignCourse(AsignCourse asignCourse)
{
connection.ConnectionString = connectionString;
string courseStatus = "Assigned";
string query = "INSERT INTO AssignCourse VALUES(@DepartmentId, @TeacherId, @CousreId, @CourseStatus)";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("DepartmentId", asignCourse.DepartmentId);
command.Parameters.AddWithValue("TeacherId", asignCourse.TeacherId);
command.Parameters.AddWithValue("CousreId", asignCourse.CourseId);
command.Parameters.AddWithValue("CourseStatus", courseStatus);
connection.Open();
int rowAffected = command.ExecuteNonQuery();
connection.Close();
return(rowAffected);
}
public ActionResult TestAssignCourse(AsignCourse asignCourse)
{
return(View());
}
