private void classAdd_Click(object sender, EventArgs e)
{
String TenLop = tenlopTxt.Text;
String DiaChi = diachiTxt.Text;
if (TenLop != "" && DiaChi != "")
{
if (model.checkClass(TenLop))
{
MessageBox.Show("Lớp học đã tồn tại !");
}
else
{
LopHoc cls = new LopHoc(TenLop, DiaChi);
if (model.SaveClass(cls))
{
resetFormClass();
resetFormStudent();
MessageBox.Show("Đã Thêm Lớp Học " + TenLop + "");
loadClassName();
loadClass();
}
else
{
MessageBox.Show("Có lỗi xảy ra");
}
}
}
else
{
MessageBox.Show("Hãy nhập đầy đủ thông tin !");
}
}
private void classEdit_Click(object sender, EventArgs e)
{
int ID = Convert.ToInt32(tableClass.CurrentRow.Cells[0].Value.ToString());
String TenLop = tenlopTxt.Text;
String DiaChi = diachiTxt.Text;
if (TenLop != "" && DiaChi != "")
{
LopHoc cls = new LopHoc(ID, TenLop, DiaChi);
if (model.editClass(cls))
{
resetFormClass();
MessageBox.Show("Đã Sửa Lớp Học " + TenLop + "");
loadClass();
}
else
{
MessageBox.Show("Có lỗi xảy ra");
}
}
else
{
MessageBox.Show("Hãy nhập đầy đủ thông tin !");
}
}
public bool SaveClass(LopHoc cls)
{
try
{
string query = "insert into `class` (`TenLop`, `DiaChi`) values ('" + cls.getTenLop() + "','" + cls.getDiaChi() + "')";
MySqlCommand commandDatabase = new MySqlCommand(query, conn);
conn.Open();
commandDatabase.ExecuteReader();
conn.Close();
return(true);
}
catch (Exception e)
{
Console.WriteLine("Error: " + e.Message);
}
conn.Close();
return(false);
}
public bool editClass(LopHoc cls)
{
try
{
string query = "UPDATE class SET TenLop = '" + cls.getTenLop() + "', DiaChi = '" + cls.getDiaChi() + "' WHERE IDClass = '" + cls.getID() + "'";
MySqlCommand commandDatabase = new MySqlCommand(query, conn);
conn.Open();
commandDatabase.ExecuteReader();
conn.Close();
return(true);
}
catch (Exception e)
{
Console.WriteLine("Error: " + e.Message);
}
conn.Close();
return(false);
}
public List <LopHoc> getCLassName()
{
List <LopHoc> listclass = new List <LopHoc>();
try
{
string query = "SELECT TenLop FROM class";
MySqlCommand commandDatabase = new MySqlCommand(query, conn);
conn.Open();
MySqlDataReader rs = commandDatabase.ExecuteReader();
while (rs.Read())
{
String TenLop = rs.GetString("TenLop");
LopHoc cls = new LopHoc(TenLop);
listclass.Add(cls);
}
}
catch (Exception e)
{
Console.WriteLine("Error: " + e.Message);
}
conn.Close();
return(listclass);
}
