private void loadDuLieu()
{
DataTable dt = VatTuControl.layThongTin(MaVT);
txtTenCu.Text = dt.Rows[0]["TenVT"].ToString();
txtDVDCu.Text = dt.Rows[0]["DonVi"].ToString();
txtSoLuongCu.Text = dt.Rows[0]["SoLuong"].ToString();
}
private void loadDuLieu()
{
dgvDanhSach.Rows.Clear();
DataTable dt = VatTuControl.layDanhSach();
for (int i = 0; i < dt.Rows.Count; ++i)
{
dgvDanhSach.Rows.Add(dt.Rows[i]["MaVT"], dt.Rows[i]["TenVT"], dt.Rows[i]["DonVi"], dt.Rows[i]["SoLuong"]);
}
}
private void btnThem_Click(object sender, EventArgs e)
{
string ten = txtTen.Text;
string dvd = txtDVD.Text;
int sl = Convert.ToInt32(txtSoLuong.Text);
if (kiemTraDuLieu(ten, dvd, sl))
{
int ketqua = VatTuControl.themDuLieu(ten, dvd, sl);
if (ketqua > 0)
{
this.Close();
}
}
}
private void timKiem()
{
string value = txtTimKiem.Text;
if (value.Length == 0)
{
loadDuLieu();
return;
}
dgvDanhSach.Rows.Clear();
DataTable dt = VatTuControl.timKiem(value);
for (int i = 0; i < dt.Rows.Count; ++i)
{
dgvDanhSach.Rows.Add(dt.Rows[i]["MaVT"], dt.Rows[i]["TenVT"], dt.Rows[i]["DonVi"], dt.Rows[i]["SoLuong"]);
}
}
private void btnXacNhan_Click(object sender, EventArgs e)
{
string ten = txtTenMoi.Text;
string donvi = txtDVDMoi.Text;
int soluong = 0;
if (txtSoLuongMoi.Text.Length > 0)
{
soluong = Convert.ToInt32(txtSoLuongMoi.Text);
}
int ketqua = VatTuControl.suaDuLieu(MaVT, ten, donvi, soluong);
if (ketqua > 0)
{
this.Close();
}
}
private void dgvDanhSach_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex == -1)
{
return;
}
int maVT = Convert.ToInt32(dgvDanhSach.Rows[e.RowIndex].Cells["colMa"].Value.ToString());
if (e.ColumnIndex == dgvDanhSach.Columns["colSua"].Index)
{
frmSuaVT frm = new frmSuaVT(maVT);
frm.ShowDialog();
loadDuLieu();
}
else if (e.ColumnIndex == dgvDanhSach.Columns["colXoa"].Index)
{
int ketqua = VatTuControl.xoaDuLieu(maVT);
if (ketqua > 0)
{
loadDuLieu();
}
}
}
