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