private static List <Teachers> _GetListOfTeachers()
{
List <Teachers> teachers = new List <Teachers>();
try
{
Command = @" select * from tblTeachers ts join tblEmployees emp
on ts.Employee_ID=emp.Id";
db.cmd.CommandText = Command;
db.con.Open();
SqlDataReader rdr = db.cmd.ExecuteReader();
while (rdr.Read())
{
Teachers singleTeacher = new Teachers();
singleTeacher.Id = (int)rdr[0];
singleTeacher.EmployeesId = (int)rdr[1];
var emp = new Employees();
singleTeacher.Employees = Employees.ListOfEmployees.SingleOrDefault(e => e.Id == singleTeacher.EmployeesId);
teachers.Add(singleTeacher);
}
}
catch (SqlException sqlex)
{
SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling();
rh.GetError(sqlex);
}
finally
{
db.con.Close();
}
return(teachers);
}
public Subjects()
{
Teachers = new Teachers();
Classes = new Classes();
}
