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