public LecWindow(DataBaseConnect obj, string id)
{
InitializeComponent();
try
{
var culs = obj.selectFirstTBL(string.Format("SELECT rooms.room_number, courses.name, courses.hours FROM lecturers INNER JOIN courses_lecturers_tbl ON lecturers.id = courses_lecturers_tbl.id INNER JOIN courses ON courses_lecturers_tbl.course_number = courses.course_number INNER JOIN courses_room_tbl ON courses.course_number = courses_room_tbl.course_number INNER JOIN rooms ON courses_room_tbl.room_number = rooms.room_number WHERE courses_lecturers_tbl.id = '{0}'", id), 3);
dataGridView2.Rows.Clear();
foreach (var item in culs)
{
dataGridView2.Rows.Add(item[0], item[1], item[2]);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public RoomWindow(DataBaseConnect obj, string txt)
{
InitializeComponent();
try
{
var culs = obj.selectRoomWindowTBL(string.Format("SELECT courses.name, lecturers.first_name FROM rooms INNER JOIN courses_room_tbl ON rooms.room_number = courses_room_tbl.room_number INNER JOIN courses ON courses_room_tbl.course_number = courses.course_number INNER JOIN courses_lecturers_tbl ON courses.course_number = courses_lecturers_tbl.course_number INNER JOIN lecturers ON courses_lecturers_tbl.id = lecturers.id WHERE rooms.room_number = {0} ", txt), 2);
dataGridView2.Rows.Clear();
foreach (var item in culs)
{
dataGridView2.Rows.Add(item[0], item[1]);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public DayWindow(DataBaseConnect obj, int[] cb)
{
InitializeComponent();
try
{
var culs = obj.selectDayTBL(String.Format("SELECT a.day, a.hours,a.room_number,c.name FROM schedule AS a INNER JOIN days_tbl AS b ON a.day = b.day INNER JOIN courses AS c ON a.course_number = c.course_number WHERE b.id BETWEEN {0} and {1} AND a.hours IN (SELECT a.hours FROM schedule WHERE a.hours BETWEEN {2} AND {3}) ORDER BY c.name ASC", cb[0], cb[1], cb[2], cb[3]), 4);
dayView.Rows.Clear();
foreach (var item in culs)
{
dayView.Rows.Add(item[0], item[1], item[2], item[3]);
}
}
catch (Exception ex)
{
MessageBox.Show("cant open DayWindow " + ex.Message);
}
}
public dashboard(DataBaseConnect obj)
{
InitializeComponent();
DBobj = obj;
initDB();
}
