public string SaveAssignCourse(AssignCourse assignedCourse) { if (!courseAssignGateway.IsCourseIsAssined(assignedCourse.CourseId)) { if (courseAssignGateway.SaveAssignCourse(assignedCourse)>0) { return "New Course are Assigned Into Teacher's "; } else { return "Course Assigned Failed to Teacher's!!! "; } } else { return "Sorry this Course isn't availeable to Assigned !!! Select Another Course ."; } }
public int SaveAssignCourse(AssignCourse assignCourse) { connection.ConnectionString = connectionString; string sqlQuery = "INSERT INTO assigned_course_tbl VALUES(@teachersId,@courseId,@departmentId,@credit,1)"; SqlCommand command = new SqlCommand(sqlQuery, connection); command.Parameters.Clear(); command.Parameters.Add("teachersId", SqlDbType.Int); command.Parameters["teachersId"].Value = assignCourse.TeachersId; command.Parameters.Add("courseId", SqlDbType.Int); command.Parameters["courseId"].Value = assignCourse.CourseId; command.Parameters.Add("departmentId", SqlDbType.Int); command.Parameters["departmentId"].Value = assignCourse.DepartmentId; command.Parameters.Add("credit", SqlDbType.Decimal); command.Parameters["credit"].Value = assignCourse.CourseCredit; connection.Open(); int isInserted = command.ExecuteNonQuery(); connection.Close(); return isInserted; }
public ActionResult AssignCourseToTeachers(AssignCourse assignCourse) { ViewBag.Message = courseAssignManager.SaveAssignCourse(assignCourse); List<Department> departmentsList = departmentManager.GetDepartmentsList(); return View(departmentsList); }