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