public static List<DBTeacher> GetTeachers()
{
DBTeacher[] t = new DBTeacher[26];
t[0] = new DBTeacher(0, "Козлова Л.Г.");
t[1] = new DBTeacher(1, "Абабурко В.Н");
t[2] = new DBTeacher(2, "Борисов В.И.");
t[3] = new DBTeacher(3, "Вайнилович Ю.В.");
t[4] = new DBTeacher(4, "Довженко Г.В.");
t[5] = new DBTeacher(5, "Другая Л.В.");
t[6] = new DBTeacher(6, "Зайченко Е.А.");
t[7] = new DBTeacher(7, "Кто Т.О.");
t[8] = new DBTeacher(8, "Мисник А.Е.");
t[9] = new DBTeacher(9, "МНО Г.О.");
t[10] = new DBTeacher(10, "Наркевич Л.В.");
t[11] = new DBTeacher(11, "Незнаю");
t[12] = new DBTeacher(12, "Крутолевич С.К.");
t[13] = new DBTeacher(13, "НеПрудников В.М.");
t[14] = new DBTeacher(14, "Обидина О.В");
t[15] = new DBTeacher(15, "Парфенович О.Н.");
t[16] = new DBTeacher(16, "Поздняков В.Ф");
t[17] = new DBTeacher(17, "Прудников А.М.");
t[18] = new DBTeacher(18, "Селиванов В.А.");
t[19] = new DBTeacher(19, "Сергеев С.С.");
t[20] = new DBTeacher(20, "Ситников В.Н.");
t[21] = new DBTeacher(21, "Скарыно Б.Б.");
t[22] = new DBTeacher(22, "Столяров Ю.Д.");
t[23] = new DBTeacher(23, "Черная Н.Г.");
t[24] = new DBTeacher(24, "Якимов А.И");
t[25] = new DBTeacher(25, "Прудников В.М");
return t.ToList();
}
public static List<DBTeacher> GetTeachers(SqlConnection connection)
{
string commandText = "select IDTeachers,LName,FName,SName from Teachers order by IDTeachers Asc";
SqlCommand command = new SqlCommand(commandText, connection);
DataTable dtTeachers = FilingDT(command);
DBTeacher[] teachers = new DBTeacher[dtTeachers.Rows.Count];
for (int rowIndex = 0; rowIndex < dtTeachers.Rows.Count; rowIndex++)
{
string fullnameteacher = dtTeachers.Rows[rowIndex][1].ToString().ToUpper() + " "
+ dtTeachers.Rows[rowIndex][2].ToString().ToUpper()[0] + "."
+ dtTeachers.Rows[rowIndex][3].ToString().ToUpper()[0] + ".";
teachers[rowIndex] = new DBTeacher(Convert.ToInt32(dtTeachers.Rows[rowIndex][0].ToString()),
fullnameteacher);
}
return teachers.ToList();
}
