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()); }