private void LoadDSSach()
{
DataTable dt = Sach_DAO.LoadDuLieu();
DataTable dtg = ChuDe_DAO.LoadDuLieu();
AutoCompleteStringCollection ac = new AutoCompleteStringCollection();
for (int i = 0; i < dtg.Rows.Count; i++)
{
ListViewGroup lvg = new ListViewGroup(dtg.Rows[i][0].ToString(), dtg.Rows[i][1].ToString());
lsvSach.Groups.Add(lvg);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
ListViewItem lvi = new ListViewItem(dt.Rows[i][1].ToString()); // ten mon
lvi.SubItems.Add(dt.Rows[i][2].ToString()); // Don gia
lvi.SubItems.Add(dt.Rows[i][4].ToString()); //So luong
DataTable nxb = NhaXuatBan_DAO.LoadDuLieuNXB(dt.Rows[i][6].ToString());
lvi.SubItems.Add(nxb.Rows[0][1].ToString()); //NXB
lvi.SubItems.Add(dt.Rows[i][7].ToString()); //id chu de
lvi.SubItems.Add(dt.Rows[i][0].ToString()); // id mon
lvi.Group = lsvSach.Groups[lvi.SubItems[4].Text];
lsvSach.Items.Add(lvi);
ac.Add(lvi.SubItems[0].Text);
}
txtTenSach.AutoCompleteCustomSource = ac;
}
private void FrmThemDS_Load(object sender, EventArgs e)
{
cboMaCD.DataSource = ChuDe_DAO.LoadDuLieu();
cboMaCD.DisplayMember = "TenCD";
cboMaCD.ValueMember = "MaCD";
cboNhaNXB.DataSource = NhaXuatBan_DAO.LoadDuLieu();
dgvDausach.DataSource = Sach_DAO.LoadDuLieu();
cboNhaNXB.DisplayMember = "TenNXB";
cboNhaNXB.ValueMember = "MaNXB";
txtMasach.ReadOnly = true;
}
private void btnLuu_Click(object sender, EventArgs e)
{
try
{
//enty_sach.MaSach = int.Parse(txtMasach.Text);
enty_sach.TenSach = txtTensach.Text;
enty_sach.GiaBan = int.Parse(txtGiaban.Text);
enty_sach.MaCD = int.Parse(cboMaCD.SelectedValue.ToString());
enty_sach.MaNXB = int.Parse(cboNhaNXB.SelectedValue.ToString());
enty_sach.SoLuong = int.Parse(txtSoluong.Text);
enty_sach.NgayNhap = Convert.ToDateTime(txtNgaynhap.Text);
enty_sach.MoTa = txtMota.Text;
Sach_DAO.Them(enty_sach);
dgvDausach.DataSource = Sach_DAO.LoadDuLieu();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void FrmThemChiTietPM_Load(object sender, EventArgs e)
{
cboTenSach.DataSource = Sach_DAO.LoadDuLieu();
}