public List <TeacherModel> GetAllTeachers()
{
List <TeacherModel> teachers = new List <TeacherModel>();
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM teacher_tbl";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
DepartmentManager aDepartmentManager = new DepartmentManager();
DesignationManager aDesignationManager = new DesignationManager();
TeacherModel aTeacherModel = new TeacherModel();
aTeacherModel.TeacherId = Convert.ToInt32(reader["teacherId"].ToString());
aTeacherModel.TeacherName = reader["teacherName"].ToString();
aTeacherModel.TeacherAddress = reader["teacherAddress"].ToString();
aTeacherModel.TeacherEmail = reader["teacherEmail"].ToString();
aTeacherModel.TeacherNumber = reader["teacherNumber"].ToString();
aTeacherModel.DesignationId = int.Parse(reader["designationId"].ToString());
aTeacherModel.Designation = aDesignationManager.GetDesignationById(aTeacherModel.DesignationId);
aTeacherModel.DepartmentId = int.Parse(reader["departmentId"].ToString());
aTeacherModel.Department = aDepartmentManager.GetDepartmentById(aTeacherModel.DepartmentId);
aTeacherModel.TeacherCreditToBeTaken = Convert.ToInt32(reader["teacherCreditToBeTaken"].ToString());
teachers.Add(aTeacherModel);
}
connection.Close();
return(teachers);
}
public ActionResult Edit(int?id)
{
if (Session["UserRoleId"] == null)
{
return(RedirectToAction("Login", "Login"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Designation designation = designationManager.GetDesignationById(id);
if (designation == null)
{
return(HttpNotFound());
}
return(View(designation));
}
