private void Fill_combo()
{
CRUD.sql = "SELECT * FROM teacher_attendance.teachers";
CRUD.cmd = new MySqlCommand(CRUD.sql, CRUD.con);
Teachers.ValueMember = "id";
Teachers.DisplayMember = "name";
DataTable dt_teacher = CRUD.PreformCRUD(CRUD.cmd);
Teachers.DataSource = dt_teacher;
CRUD.sql = "SELECT * FROM teacher_attendance.courses";
CRUD.cmd = new MySqlCommand(CRUD.sql, CRUD.con);
Courses.ValueMember = "id";
Courses.DisplayMember = "name";
DataTable dt_course = CRUD.PreformCRUD(CRUD.cmd);
Courses.DataSource = dt_course;
CRUD.sql = "SELECT * FROM teacher_attendance.rooms";
CRUD.cmd = new MySqlCommand(CRUD.sql, CRUD.con);
Rooms.ValueMember = "id";
Rooms.DisplayMember = "name";
DataTable dt_room = CRUD.PreformCRUD(CRUD.cmd);
Rooms.DataSource = dt_room;
}
private void LoadData()
{
CRUD.sql = "SELECT * FROM teacher_attendance.courses";
CRUD.cmd = new MySqlCommand(CRUD.sql, CRUD.con);
CRUD.cmd.Parameters.Clear();
DataTable dt = CRUD.PreformCRUD(CRUD.cmd);
dvg1.DataSource = dt;
}
private void ShowTeacher_Click(object sender, EventArgs e)
{
frteacher teacher = new frteacher();
teacher.ShowDialog();
Fill_combo();
CRUD.sql = "DELETE FROM teacher_attendance.attendance_management WHERE teacher_id NOT IN (SELECT teachers.id FROM teacher_attendance.teachers)";
CRUD.cmd = new MySqlCommand(CRUD.sql, CRUD.con);
dvg1.DataSource = CRUD.PreformCRUD(CRUD.cmd);
LoadData();
Reset();
}
private void execute(string mysql, string param)
{
CRUD.cmd = new MySqlCommand(mysql, CRUD.con);
addparameters(param);
DataTable dt = CRUD.PreformCRUD(CRUD.cmd);
}
