public CourseAssignToTeacherModel GetSingleCourseAssignToTeacherModel(int courseAssignId) { SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT * FROM courseAssignToTeacher_tbl WHERE id='" + courseAssignId + "'"; SqlCommand command = new SqlCommand(query, connection); // command.Parameters.AddWithValue("@deptId", DeptId); connection.Open(); SqlDataReader reader = command.ExecuteReader(); CourseAssignToTeacherModel aCourseAssignToTeacherModel = new CourseAssignToTeacherModel(); while (reader.Read()) { aCourseAssignToTeacherModel.CourseAssignToTeacherId = Convert.ToInt32(reader["id"].ToString()); aCourseAssignToTeacherModel.DepartmentId = int.Parse(reader["departmentId"].ToString()); aCourseAssignToTeacherModel.CourseId = Convert.ToInt32(reader["courseId"].ToString()); aCourseAssignToTeacherModel.TeacherId = int.Parse(reader["teacherId"].ToString()); } aCourseAssignToTeacherModel.Department = aCourseAssignManager.GetSingleDepartmentByDeptId(aCourseAssignToTeacherModel.DepartmentId); aCourseAssignToTeacherModel.Teacher = aCourseAssignManager.GetSingleTeacherByTeacherId(aCourseAssignToTeacherModel.TeacherId); aCourseAssignToTeacherModel.Course = aCourseAssignManager.GetSingleCourseByCourseId(aCourseAssignToTeacherModel.CourseId); connection.Close(); return(aCourseAssignToTeacherModel); }
/* * public bool IsCourseExist(int courseID) * { * bool isCourseExists = false; * * SqlConnection connection = new SqlConnection(connectionString); * * string query = "SELECT CourseID FROM courseAssignToTeacher_tbl WHERE CourseID= @CourseID"; * SqlCommand command = new SqlCommand(query, connection); * * command.Parameters.Clear(); * * // command.Parameters.Add("DeptCode", SqlDbType.NVarChar); * // command.Parameters["DeptCode"].Value = DeptCode; * command.Parameters.AddWithValue("@CourseID", courseID); * * connection.Open(); * SqlDataReader reader = command.ExecuteReader(); * if (reader.Read()) * { * isCourseExists = true; * } * connection.Close(); * * return isCourseExists; * } */ /// <summary> /// to get all courseAssignedToTeacherData /// </summary> /// <returns>returns all courseAssignedToTeacherData</returns> public List <CourseAssignToTeacherModel> GetAllCourseAssignedTeachers() { List <CourseAssignToTeacherModel> coursesAssignToTeacher = new List <CourseAssignToTeacherModel>(); SqlConnection con = new SqlConnection(connectionString); string query = "SELECT * FROM courseAssignToTeacher_tbl"; SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.Clear(); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { CourseAssignToTeacherModel aCourseAssignToTeacherModel = new CourseAssignToTeacherModel(); aCourseAssignToTeacherModel.CourseAssignToTeacherId = Convert.ToInt32(reader["id"].ToString()); aCourseAssignToTeacherModel.DepartmentId = Convert.ToInt32(reader["departmentID"].ToString()); aCourseAssignToTeacherModel.TeacherId = Convert.ToInt32(reader["teacherID"].ToString()); aCourseAssignToTeacherModel.CourseId = Convert.ToInt32(reader["courseID"].ToString()); aCourseAssignToTeacherModel.Department = aCourseAssignManager.GetSingleDepartmentByDeptId(aCourseAssignToTeacherModel.DepartmentId); aCourseAssignToTeacherModel.Teacher = aCourseAssignManager.GetSingleTeacherByTeacherId(aCourseAssignToTeacherModel.TeacherId); aCourseAssignToTeacherModel.Course = aCourseAssignManager.GetSingleCourseByCourseId(aCourseAssignToTeacherModel.CourseId); aCourseAssignToTeacherModel.TeacherRemainingCredit = aCourseAssignManager.GetRemainingCreditFromAssignedTeachers(aCourseAssignToTeacherModel.TeacherId); coursesAssignToTeacher.Add(aCourseAssignToTeacherModel); } con.Close(); return(coursesAssignToTeacher); }
public ActionResult AssignTeacher(CourseAssignToTeacherModel courseAssignToTeacherModel) { CourseAssignManager aCourseAssignManager = new CourseAssignManager(); ViewBag.Departments = aCourseAssignManager.GetAllDepartments(); ViewBag.Teachers = aCourseAssignManager.GetAllTeachers(); ViewBag.CourseCodeList = aCourseAssignManager.GetAllCourseCodes(); //do the code to store in the database if (aCourseAssignManager.IsCourseExist(courseAssignToTeacherModel.CourseId)) { ViewBag.Message = ("Course is already assigned"); } else { int stored = aCourseAssignManager.SaveCourseAssignToTeacher(courseAssignToTeacherModel); if (stored == 1) { ViewBag.Message = ("Course Assign to Teacher done successfully"); } else { ViewBag.Message = ("Course Assign to Teacher Error"); } } return(View()); /* * 1. one course should be assigned to one teacher only-done * 2. if teacher credit exceed, an dialog box with yes/no pop up and work accordingly * 3. remaining credit returning false count--done */ }
public CourseAssignToTeacherModel GetAssignedCourseToTeacherModelById(int assignedCourseId) { //TeacherManager aTeacherManager = new TeacherManager(); //DepartmentManager aDepartmentManager = new DepartmentManager(); //CourseManager aCourseManager = new CourseManager(); CourseAssignGateway aCourseAssignGateway = new CourseAssignGateway(); CourseAssignToTeacherModel aCourseAssignToTeacherModel = aCourseAssignGateway.GetSingleCourseAssignToTeacherModel(assignedCourseId); return(aCourseAssignToTeacherModel); }
public int SaveCourseAssignToTeacher(CourseAssignToTeacherModel courseAssignToTeacherModel) { //TeacherManager aTeacherManager = new TeacherManager(); //DepartmentManager aDepartmentManager = new DepartmentManager(); //CourseManager aCourseManager = new CourseManager(); CourseAssignGateway aCourseAssignGateway = new CourseAssignGateway(); int input = aCourseAssignGateway.SaveCourseAssignToTeacher(courseAssignToTeacherModel); return(input); }
public int UpdateAssignedCourseToTeacherModel(CourseAssignToTeacherModel aCourseAssignToTeacherModel) { { //TeacherManager aTeacherManager = new TeacherManager(); //DepartmentManager aDepartmentManager = new DepartmentManager(); //CourseManager aCourseManager = new CourseManager(); CourseAssignGateway aCourseAssignGateway = new CourseAssignGateway(); int rowAffected = aCourseAssignGateway.UpdateCourseAssign(aCourseAssignToTeacherModel); return(rowAffected); } }
public int SaveCourseAssignToTeacher(CourseAssignToTeacherModel courseAssignToTeacherModel) { SqlConnection connection = new SqlConnection(connectionString); string query = "INSERT INTO courseAssignToTeacher_tbl(departmentId,teacherId,courseId) VALUES (@departmentId,@teacherId,@courseId)"; SqlCommand cmd = new SqlCommand(query, connection); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@departmentId", courseAssignToTeacherModel.DepartmentId); cmd.Parameters.AddWithValue("@teacherId", courseAssignToTeacherModel.TeacherId); cmd.Parameters.AddWithValue("@courseId", courseAssignToTeacherModel.CourseId); int rowAffected = 0; try { connection.Open(); rowAffected = cmd.ExecuteNonQuery(); connection.Close(); } catch (Exception e) { } return(rowAffected); }
public int UpdateCourseAssign(CourseAssignToTeacherModel aCourseAssignToTeacherModel) { SqlConnection connection = new SqlConnection(connectionString); string query = "UPDATE courseAssignToTeacher_tbl SET departmentId=@departmentId,teacherId=@teacherId,courseId=@courseId WHERE id=@id"; SqlCommand cmd = new SqlCommand(query, connection); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@departmentId", aCourseAssignToTeacherModel.DepartmentId); cmd.Parameters.AddWithValue("@teacherId", aCourseAssignToTeacherModel.TeacherId); cmd.Parameters.AddWithValue("@courseId", aCourseAssignToTeacherModel.CourseId); cmd.Parameters.AddWithValue("@id", aCourseAssignToTeacherModel.CourseAssignToTeacherId); int rowAffected = 0; try { connection.Open(); rowAffected = cmd.ExecuteNonQuery(); connection.Close(); } catch (Exception e) { } return(rowAffected); }
public ActionResult EditAssignedTeacher(int id, int?message) { if (message != null) { if (message == 0) { ViewBag.Message = "Sorry! Course Assign Update Failed !!"; } else if (message == 5) { ViewBag.Message = "Sorry! Course Code Exists !!"; } else if (message == 6) { ViewBag.Message = "Sorry! Course Name Exists !!"; } } CourseAssignManager aCourseAssignManager = new CourseAssignManager(); ViewBag.Departments = aCourseAssignManager.GetAllDepartments(); ViewBag.Teachers = aCourseAssignManager.GetAllTeachers(); ViewBag.CourseCodeList = aCourseAssignManager.GetAllCourseCodes(); CourseAssignToTeacherModel aCourseAssignToTeacherModel = new CourseAssignToTeacherModel(); aCourseAssignToTeacherModel = aCourseAssignManager.GetAssignedCourseToTeacherModelById(id); /*ViewBag.Departments = aCourseAssignManager.GetAllDepartments(); * ViewBag.Teachers = aCourseAssignManager.GetAllTeachers(); * ViewBag.CourseCodeList = aCourseAssignManager.GetAllCourseCodes();*/ return(View(aCourseAssignToTeacherModel)); }
public ActionResult EditAssignedTeacher(CourseAssignToTeacherModel courseAssignToTeacherModel) { return(View()); }