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