public void Update(TacGia info) { string sqlQuery = "update TacGia" + " set TenTG=N'" + info.TenTG + "'" + "where MaTG='" + info.MaTG + "'"; ExecuteNonQuery(sqlQuery); }
public void Insert(TacGia info) { string sqlQuery = "insert into TacGia values ('" + info.MaTG + "',N'" + info.TenTG + "')"; ExecuteNonQuery(sqlQuery); }
private void btSua_Click(object sender, RoutedEventArgs e) { TacGia tacGia = new TacGia() { MaTG = tbMaTacGia.Text, TenTG = tbTenTacGia.Text }; TacGiaBUS bus = new TacGiaBUS(); try { bus.Update(tacGia); MessageBox.Show("Sửa thành công !"); } catch (Exception) { MessageBox.Show("Sửa thất bại !"); } LoadData(); }
private void btThem_Click(object sender, RoutedEventArgs e) { TacGia tacGia = new TacGia() { MaTG = (++id).ToString(), TenTG = tbTenTacGia.Text }; TacGiaBUS bus = new TacGiaBUS(); try { bus.Insert(tacGia); MessageBox.Show("Thêm thành công !"); } catch (Exception) { MessageBox.Show("Thêm thất bại !"); } LoadData(); }
public List<TacGia> GetList() { List<TacGia> list = new List<TacGia>(); string sqlQuery = "select * from TacGia"; reader = ExecuteReader(sqlQuery); while (reader.Read()) { TacGia tacGia = new TacGia(); tacGia.MaTG = reader["MaTG"].ToString(); tacGia.TenTG = reader["TenTG"].ToString(); list.Add(tacGia); } return list; }
public void Update(TacGia info) { data.Update(info); }
public void Insert(TacGia info) { data.Insert(info); }