private void btnXoa_Click(object sender, EventArgs e)
{
int ma = Convert.ToInt32(txtMa.Text);
if (SachControl.xoaDuLieu(ma) > 0)
{
MessageBox.Show("xoá thành công");
txtTen.Text = txtTacGia.Text = txtNSB.Text = txtGiaTien.Text = txtSoLuong.Text = "";
loadDuLieu();
}
}
private void loadDuLieu()
{
dgvDanhSach.Rows.Clear();
DataTable dt = SachControl.layDanhSach();
for (int i = 0; i < dt.Rows.Count; ++i)
{
//
dgvDanhSach.Rows.Add(new object[] { dt.Rows[i]["MaSach"], dt.Rows[i]["TenSach"], dt.Rows[i]["TenLoai"],
dt.Rows[i]["TenTG"], dt.Rows[i]["NSB"], dt.Rows[i]["GiaTien"], dt.Rows[i]["SoLuong"] });
}
}
public Sach(int id)
{
MaSach = id;
DataTable dt = SachControl.layThongTin(id);
TenSach = dt.Rows[0]["TenSach"].ToString();
Loai = new LoaiSach(Convert.ToInt32(dt.Rows[0]["Loai"].ToString()));
TenTG = dt.Rows[0]["TenTG"].ToString();
NSB = dt.Rows[0]["NSB"].ToString();
GiaTien = double.Parse(dt.Rows[0]["GiaTien"].ToString());
SoLuong = Convert.ToInt32(dt.Rows[0]["SoLuong"].ToString());
}
private void loadLoai()
{
List <LoaiSach> listSach = new List <LoaiSach>();
DataTable dt = SachControl.layDanhSachLoai();
for (int i = 0; i < dt.Rows.Count; ++i)
{
listSach.Add(new LoaiSach()
{
MaLoai = Convert.ToInt32(dt.Rows[i]["MaLoai"].ToString()),
TenLoai = dt.Rows[i]["TenLoai"].ToString()
});
}
cbLoai.DataSource = listSach;
cbLoai.DisplayMember = "TenLoai";
}
private void timKiem()
{
string value = txtTimKiem.Text;
if (value.Length == 0)
{
loadDuLieu();
return;
}
dgvDanhSach.Rows.Clear();
DataTable dt = SachControl.timKiem(value);
for (int i = 0; i < dt.Rows.Count; ++i)
{
//
dgvDanhSach.Rows.Add(new object[] { dt.Rows[i]["MaSach"], dt.Rows[i]["TenSach"], dt.Rows[i]["TenLoai"],
dt.Rows[i]["TenTG"], dt.Rows[i]["NSB"], dt.Rows[i]["GiaTien"], dt.Rows[i]["SoLuong"] });
}
}
private void btnSua_Click(object sender, EventArgs e)
{
int ma = Convert.ToInt32(txtMa.Text);
string ten = txtTen.Text;
LoaiSach loai = cbLoai.SelectedValue as LoaiSach;
string tacgia = txtTacGia.Text;
string nsb = txtNSB.Text;
double gia = double.Parse(txtGiaTien.Text);
int soluong = Convert.ToInt32(txtSoLuong.Text);
if (true)
{
int ketqua = SachControl.suaDuLieu(ma, ten, loai.MaLoai, tacgia, nsb, gia, soluong);
if (ketqua > 0)
{
MessageBox.Show("sửa thành công");
loadDuLieu();
}
}
}
