private void student_mod_form_Load(object sender, EventArgs e)
{
DBConnection con = new DBConnection();
string query = "SELECT room.room_id, IF((room.capacity - count(student.name) = 0) , (\"FULL\"),(\"Not FULL\")) AS 'Room State' FROM student RIGHT OUTER JOIN room ON room.room_id = student.room_id GROUP BY student.room_id";
con.roomCheck(query, "room_id", room_combx);
/*
* for (int i = 0; i < room_combx.Items.Count; i++)
* {
* if (con.Counter($"SELECT student_id FROM student WHERE room_id ='{room_combx.Items[i]}'")
* .ToString() == con.Reader($"SELECT * FROM room WHERE room_id =" +
* $"'{room_combx.Items[i]}'", "capacity"))
* {
* room_combx.Items.RemoveAt(i);
* if (i != room_combx.Items.Count)
* {
* i--;
* }
* }
* }*/
query = "SELECT * FROM department";
con.Reader(query, "name", dep_combx);
id_txtbx.Text = id;
if (id != "-1")
{
id_txtbx.Text = id;
string myQuery = $"SELECT * FROM student WHERE student_id = '{id}'";
name_txtbx.Text = con.Reader(myQuery, "name");
surname_txtbx.Text = con.Reader(myQuery, "surname");
tc_txtbx.Text = con.Reader(myQuery, "tc");
address_txtbx.Text = con.Reader(myQuery, "address");
tel_txtbx.Text = con.Reader(myQuery, "tel");
sclass_combx.SelectedItem = con.Reader(myQuery, "class");
email_txtbx.Text = con.Reader(myQuery, "email");
if (room_combx.Items.Contains(con.Reader(myQuery, "room_id")))
{
//do nothing
}
else
{
room_combx.Items.Add(con.Reader(myQuery, "room_id"));
}
room_combx.SelectedItem = con.Reader(myQuery, "room_id");
string dep_id = con.Reader(myQuery, "dep_id");
//myQuery = $"SELECT name FROM department WHERE dep_id = (SELECT dep_id FROM student WHERE student_id = {id})";
myQuery = $"SELECT name FROM department WHERE dep_id = '{dep_id}'";
dep_combx.SelectedItem = con.Reader(myQuery, "name");
myQuery = $"SELECT DATE_FORMAT(reg_date, '%Y/%m/%d') AS reg_date FROM student WHERE student_id = {id}";
string myDate = con.Reader(myQuery, "reg_date");
DateTime Date = Convert.ToDateTime(myDate);
this.reg_date_dtp.Value = Date;
}
else
{
id_txtbx.Text = "";
this.reg_date_dtp.Value = DateTime.Now;
}
}