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 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);
}