public void Update(NhaCungCap info) { string sqlQuery = "update NhaCungCap" + " set TenNCC=N'" + info.TenNCC + "'," + "DiaChiNCC=N'" + info.DiaChiNCC + "'," + "DienThoai='"+info.DienThoai+"'"+ "where MaNCC='" + info.MaNCC + "'"; ExecuteNonQuery(sqlQuery); }
public void Insert(NhaCungCap info) { string sqlQuery = "insert into NhaCungCap values ('" + info.MaNCC + "',N'" + info.TenNCC + "',N'" + info.DiaChiNCC + "'," + info.DienThoai + ")"; ExecuteNonQuery(sqlQuery); }
private void btSua_Click(object sender, RoutedEventArgs e) { NhaCungCap nhaCungCap = new NhaCungCap() { MaNCC = tbMaNhaCungCap.Text, TenNCC = tbTenNhaCungCap.Text, DiaChiNCC = tbDiaChi.Text, DienThoai = tbSoDienThoai.Text }; NhaCungCapBUS bus = new NhaCungCapBUS(); try { bus.Update(nhaCungCap); 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) { NhaCungCap nhaCungCap = new NhaCungCap() { MaNCC = (++id).ToString(), TenNCC = tbTenNhaCungCap.Text, DiaChiNCC = tbDiaChi.Text, DienThoai = tbSoDienThoai.Text }; NhaCungCapBUS bus = new NhaCungCapBUS(); try { bus.Insert(nhaCungCap); MessageBox.Show("Thêm thành công !"); } catch (Exception) { MessageBox.Show("Thêm thất bại !"); } LoadData(); }
public List<NhaCungCap> GetList() { List<NhaCungCap> list = new List<NhaCungCap>(); string sqlQuery = "select * from NhaCungCap"; reader = ExecuteReader(sqlQuery); while (reader.Read()) { NhaCungCap nhaCungCap = new NhaCungCap(); nhaCungCap.MaNCC = reader["MaNCC"].ToString(); nhaCungCap.TenNCC = reader["TenNCC"].ToString(); nhaCungCap.DiaChiNCC = reader["DiaChiNCC"].ToString(); nhaCungCap.DienThoai = reader["DienThoai"].ToString(); list.Add(nhaCungCap); } return list; }
public void Update(NhaCungCap info) { data.Update(info); }
public void Insert(NhaCungCap info) { data.Insert(info); }