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