public bool IsCourseAssigned(AssignCourseToTeacher assign)
{
string query = "SELECT * FROM AssignCourseToTeacher WHERE Status='Assigned' AND CourseId=@id ";
Command = new SqlCommand(query, Connection);
Command.Parameters.AddWithValue("@id", assign.CourseId);
Connection.Open();
Reader = Command.ExecuteReader();
bool isExists = Reader.HasRows;
Connection.Close();
return(isExists);
}
public int Save(AssignCourseToTeacher assign)
{
string query = "INSERT INTO AssignCourseToTeacher VALUES(@departmentId,@teacherId,@courseId,@status)";
Command = new SqlCommand(query, Connection);
Command.Parameters.AddWithValue("@departmentId", assign.DepartmentId);
Command.Parameters.AddWithValue("@teacherId", assign.TeacherId);
Command.Parameters.AddWithValue("@courseId", assign.CourseId);
Command.Parameters.AddWithValue("@status", assign.Status);
Connection.Open();
int rowAffect = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffect);
}
public ActionResult AssignCourseToTeacher(AssignCourseToTeacher assignCourse)
{
if (ModelState.IsValid)
{
ViewBag.Response = teacherManager.CourseAssign(assignCourse);
}
else
{
ViewBag.Response = "Empty";
}
ViewBag.Departments = departmentManager.GetAllDepartmentsForDropDown();
ModelState.Clear();
return(View());
}
//assign course to teacher (Save in AssignCourseTable)
public int CourseAssign(AssignCourseToTeacher assignCourse)
{
Connection.Open();
string query = "INSERT INTO AssignCourseToTeacher VALUES (@teacherId, @courseId, @type)";
Command = new SqlCommand(query, Connection);
Command.Parameters.AddWithValue("@teacherId", assignCourse.TeacherId);
Command.Parameters.AddWithValue("@courseId", assignCourse.CourseId);
Command.Parameters.AddWithValue("@type", "ASSIGNED");
int rowsAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowsAffected);
}
// check course assigned or not
public bool IsAssigned(AssignCourseToTeacher assignCourse)
{
Connection.Open();
string query = "SELECT * FROM AssignCourseToTeacher WHERE CourseId = @courseId AND Type = 'ASSIGNED'";
Command = new SqlCommand(query, Connection);
Command.Parameters.AddWithValue("@courseId", assignCourse.CourseId);
Reader = Command.ExecuteReader();
bool isExists = Reader.HasRows;
Reader.Close();
Connection.Close();
return(isExists);
}
public ActionResult Save(AssignCourseToTeacher assign)
{
if (ModelState.IsValid)
{
assign.Status = "Assigned";
string message = assignCourseToTeacherManager.Save(assign);
ViewBag.Departments = courseManager.GetDepartmentsForDropDown();
ViewBag.Message = message;
}
else
{
ViewBag.Departments = courseManager.GetDepartmentsForDropDown();
ViewBag.Message = "Model State is Invalid";
return(View());
}
return(View());
}
//assign course to teacher (Save in AssignCourseTable)
public string CourseAssign(AssignCourseToTeacher assignCourse)
{
// check course already assigned or not
if (teacherGateway.IsAssigned(assignCourse))
{
return("Exists");
}
else
{
int rowsAffected = teacherGateway.CourseAssign(assignCourse);
if (rowsAffected > 0)
{
return("Success");
}
else
{
return("Failed");
}
}
}
public string Save(AssignCourseToTeacher assign)
{
if (assignGateway.IsCourseAssigned(assign))
{
return "Course Already Assigned";
}
else
{
int rowAffect = assignGateway.Save(assign);
if (rowAffect > 0)
{
return "Save Succesful";
}
else
{
return "Save Failed";
}
}
}
