public static List<DBClassRoom> GetClassRooms(SqlConnection connection)
{
string commandText = "select IDrooms,Housing,Number from ClassRooms order by IDrooms asc";
SqlCommand command = new SqlCommand(commandText, connection);
DataTable dtClassRooms = FilingDT(command);
DBClassRoom[] classRooms = new DBClassRoom[dtClassRooms.Rows.Count];
for (int rowIndexRooms = 0; rowIndexRooms < dtClassRooms.Rows.Count; rowIndexRooms++)
{
//список всех типов для данной аудитории получаем
commandText = "select IDTypes,flag from ClassRoomsTypes where IDrooms=@IDrooms order by IDTypes asc";
command = new SqlCommand(commandText, connection);
command.Parameters.AddWithValue("@IDrooms", Convert.ToInt32(dtClassRooms.Rows[rowIndexRooms][0].ToString()));
DataTable dttypes = FilingDT(command);
int[] ClassRoomsTypesRoom = new int[dttypes.Rows.Count];
BitArray secondTypesMask = new BitArray(dttypes.Rows.Count, false);
for (int rowIndexTypes = 0; rowIndexTypes < dttypes.Rows.Count; rowIndexTypes++)
{
ClassRoomsTypesRoom[rowIndexTypes] = Convert.ToInt32(dttypes.Rows[rowIndexTypes][0].ToString());
if (Convert.ToInt32(dttypes.Rows[rowIndexTypes][1].ToString()) == 1)
{
secondTypesMask[rowIndexTypes] = true;
}
}
classRooms[rowIndexRooms] = new DBClassRoom(Convert.ToInt32(dtClassRooms.Rows[rowIndexRooms][0].ToString()),
Convert.ToInt32(dtClassRooms.Rows[rowIndexRooms][2].ToString()),
Convert.ToInt32(dtClassRooms.Rows[rowIndexRooms][1].ToString()),
ClassRoomsTypesRoom.ToList(),
secondTypesMask);
}
return classRooms.ToList();
}
public static List<DBClassRoom> GetClassRooms()
{
DBClassRoom[] cl = new DBClassRoom[35];
cl[0] = new DBClassRoom(0, 410, 2, new List<int> { 0, 7 }, new System.Collections.BitArray(new bool[] { false, true }));
cl[1] = new DBClassRoom(1, 411, 4, new List<int> { 0 });
cl[2] = new DBClassRoom(2, 409, 2, new List<int> { 0 });
cl[3] = new DBClassRoom(3, 412, 2, new List<int> { 0, 1 });
cl[4] = new DBClassRoom(4, 213, 2, new List<int> { 0 });
cl[5] = new DBClassRoom(5, 202, 2, new List<int> { 0 });
cl[6] = new DBClassRoom(6, 502, 2, new List<int> { 0 });
cl[7] = new DBClassRoom(7, 111, 2, new List<int> { 0, 4 });
cl[8] = new DBClassRoom(8, 301, 2, new List<int> { 0 });
cl[9] = new DBClassRoom(9, 416, 2, new List<int> { 2 });
cl[10] = new DBClassRoom(10, 518, 2, new List<int> { 2 });
cl[11] = new DBClassRoom(11, 517, 2, new List<int> { 2 });
cl[12] = new DBClassRoom(12, 439, 1, new List<int> { 2 });
cl[13] = new DBClassRoom(13, 401, 3, new List<int> { 2 });
cl[14] = new DBClassRoom(14, 203, 1, new List<int> { 2 });
cl[15] = new DBClassRoom(15, 231, 1, new List<int> { 2 });
cl[16] = new DBClassRoom(16, 516, 2, new List<int> { 2 });
cl[17] = new DBClassRoom(17, 511, 2, new List<int> { 2 });
cl[18] = new DBClassRoom(18, 514, 2, new List<int> { 3, 1 });
cl[19] = new DBClassRoom(19, 311, 4, new List<int> { 3 });
cl[20] = new DBClassRoom(20, 405, 2, new List<int> { 1 });
cl[21] = new DBClassRoom(21, 404, 2, new List<int> { 3, 4 });
cl[22] = new DBClassRoom(22, 207, 2, new List<int> { 4 });
cl[23] = new DBClassRoom(23, 204, 2, new List<int> { 1, 4 });
cl[24] = new DBClassRoom(24, 402, 2, new List<int> { 4 });
cl[25] = new DBClassRoom(25, 419, 1, new List<int> { 1 });
cl[26] = new DBClassRoom(26, 216, 2, new List<int> { 4 });
cl[27] = new DBClassRoom(27, 0, 1, new List<int> { 5 });
cl[28] = new DBClassRoom(28, 1, 1, new List<int> { 6 });
cl[29] = new DBClassRoom(29, 254, 1, new List<int> { 1 });
cl[30] = new DBClassRoom(30, 401, 4, new List<int> { 1 });
cl[31] = new DBClassRoom(31, 512, 2, new List<int> { 1 });
cl[32] = new DBClassRoom(32, 527, 1, new List<int> { 1 });
cl[33] = new DBClassRoom(33, 506, 2, new List<int> { 1 });
cl[34] = new DBClassRoom(34, 316, 2, new List<int> { 7 });
return cl.ToList();
}
