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