public ActionResult AssignTeacher(CourseAssignVM aCourseAssignVm)
{
ViewBag.department = aDepartmentManager.GetAllDepartment();
if (ModelState.IsValid)
{
ViewBag.Message = aTeacherManager.AssignTeacher(aCourseAssignVm);
}
return(View());
}
public string AssignTeacher(CourseAssignVM aCourseAssignVm)
{
bool CourseAssigned = aTeacherGateway.CheckCourse(aCourseAssignVm);
if (CourseAssigned)
{
return("This Course already Assigned to a Teacher");
}
else
{
int rowAffected = aTeacherGateway.AssignTeacher(aCourseAssignVm);
if (rowAffected > 0)
{
return("Course Assign Successfull");
}
return("Course Assign Failed");
}
}
public bool CheckCourse(CourseAssignVM aCourseAssignVm)
{
Query = "SELECT *FROM Course WHERE Id='" + aCourseAssignVm.CourseID + "' AND Assignment_Status='Assigned' ";
Command = new SqlCommand(Query, Connection);
Connection.Open();
SqlDataReader reader = Command.ExecuteReader();
bool hasRow = false;
if (reader.HasRows)
{
hasRow = true;
}
reader.Close();
Connection.Close();
return(hasRow);
}
public int AssignTeacher(CourseAssignVM aCourseAssignVm)
{
Query = "UPDATE Teacher SET Remaining_credit= Remaining_credit-'" + aCourseAssignVm.Credit + "' WHERE Id='" + aCourseAssignVm.TeacherID + "'";
Command = new SqlCommand(Query, Connection);
//Command.Parameters.Clear();
//Command.Parameters.Add("Credit", SqlDbType.Decimal);
//Command.Parameters["Credit"].Value = aCourseAssignVm.Credit;
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
if (rowAffected > 0)
{
Query = "UPDATE Course SET TeacherID='" + aCourseAssignVm.TeacherID + "' ,Assignment_Status='Assigned' where Id='" + aCourseAssignVm.CourseID + "'";
Command = new SqlCommand(Query, Connection);
rowAffected = Command.ExecuteNonQuery();
}
Connection.Close();
return(rowAffected);
}
public ActionResult ViewCourseStat(CourseAssignVM acCourseAssignVm)
{
ViewBag.department = aDepartmentManager.GetAllDepartment();
return(View());
}
