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