private void LoadPhieuMuon()
{
var dtgv = dtgvPhieuMuon;
dtgv.Tag = 0;
clsMuonTraSach cls = new clsMuonTraSach();
dtgv.DataSource = cls.Select_MainForm();
dtgv.Columns["ID_MuonSach"].Visible = false;
dtgv.Columns["ID_DocGia"].Visible = false;
dtgv.Rows[dtgv.Rows.Count - 1].Selected = true;
dtgv.Tag = 1;
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (cbDocGia.SelectedValue == null)
{
MessageBox.Show("Chưa chọn độc giả.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
clsMuonTraSach cls = new clsMuonTraSach();
cls.ID_MuonSach = m_iID_MuonSach;
cls.SelectOne();
cls.ID_DocGia = int.Parse(cbDocGia.SelectedValue.ToString());
cls.NgayMuon = dtpNgayMuon.Value;
cls.NgayTra = dtpNgayTra.Value;
cls.NgayTra_ThucTe = dtpNgayTra_ThucTe.Checked ? dtpNgayTra_ThucTe.Value : SqlDateTime.Null;
cls.TonTai = true;
if (m_iID_MuonSach == 0)
{
cls.Insert();
}
else
{
cls.Update();
}
clsMuonTraSach_ChiTiet clsCT = new clsMuonTraSach_ChiTiet();
clsCT.ID_MuonSach = cls.ID_MuonSach;
clsCT.DeleteWID_MuonSachLogic();
for (int i = 0; i < dgvChiTiet.Rows.Count - 1; i++)
{
clsCT.ID_Sach = int.Parse(dgvChiTiet.Rows[i].Cells[0].Value.ToString());
clsCT.SoLuong = int.Parse(dgvChiTiet.Rows[i].Cells[2].Value.ToString());
clsCT.Insert();
}
clsDM_Sach clsSach = new clsDM_Sach();
clsSach.UpdateSoLuongConLai();
MessageBox.Show("Lưu thành công.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (dtgvPhieuMuon.CurrentRow.Index == dtgvPhieuMuon.Rows.Count - 1)
{
return;
}
clsMuonTraSach cls = new clsMuonTraSach();
cls.ID_MuonSach = int.Parse(dtgvPhieuMuon.Rows[dtgvPhieuMuon.CurrentRow.Index].Cells["ID_MuonSach"].Value.ToString());
cls.SelectOne();
cls.TonTai = false;
cls.Update();
clsDM_Sach clsSach = new clsDM_Sach();
clsSach.UpdateSoLuongConLai();
LoadPhieuMuon();
}
private void LoadForm()
{
LoadCmbDocGia();
LoadCmbSach();
dgvChiTiet.Rows.Clear();
if (m_iID_MuonSach > 0)
{
clsMuonTraSach cls = new clsMuonTraSach();
cls.ID_MuonSach = m_iID_MuonSach;
DataRow dr = cls.SelectOne().Rows[0];
cbDocGia.SelectedValue = dr["ID_DocGia"];
dtpNgayMuon.Value = dr.Field <DateTime>("NgayMuon");
dtpNgayTra.Value = dr.Field <DateTime>("NgayTra");
if (dr.IsNull("NgayTra_ThucTe"))
{
dtpNgayTra_ThucTe.Checked = false;
}
else
{
dtpNgayTra_ThucTe.Checked = true;
dtpNgayTra_ThucTe.Value = dr.Field <DateTime>("NgayTra_ThucTe");
}
clsMuonTraSach_ChiTiet clsCT = new clsMuonTraSach_ChiTiet();
clsCT.ID_MuonSach = m_iID_MuonSach;
DataTable dtCT = clsCT.Select_wID_MuonSach();
foreach (DataRow drCT in dtCT.Rows)
{
DataGridViewRow row = (DataGridViewRow)dgvChiTiet.Rows[0].Clone();
row.Cells[0].Value = drCT["ID_Sach"];
row.Cells[1].Value = drCT["Ten_Sach"];
row.Cells[2].Value = drCT["SoLuong"];
dgvChiTiet.Rows.Add(row);
}
}
}
