private void addlistviewPM(phieu_muon a)
{
lvi = lvPM.Items.Add(a.Ma_doc_gia);
lvi.SubItems.Add(a.Ma_phieu_muon);
lvi.SubItems.Add(a.Ngay_muon.ToShortDateString());
lvi.SubItems.Add(a.Ngay_hen_tra.ToShortDateString());
lvi.SubItems.Add(a.Ma_sach_1);
lvi.SubItems.Add(a.Ma_sach_2);
}
private void nap_du_lieu_PM()
{
for (int i = ds_PM.count() - 1; i >= 0; i--)
{
ds_PM.removeat(i);
}
var query = from PM in a.PHIEUMUONs
join CTPM in a.CTPMs on PM.MAPHIEUMUON equals CTPM.MAPHIEUMUON
join DG in a.DOCGIAs on PM.MADOCGIA equals DG.MADOCGIA
orderby PM.MAPHIEUMUON ascending
select new
{
MaPM = PM.MAPHIEUMUON,
MaDG = PM.MADOCGIA,
Ngaymuon = PM.NGAYMUON,
NgayHentra = PM.NGAYHENTRA,
ma_sach = CTPM.MASACH,
};
var c = query.Except(from PM in a.PHIEUMUONs
join PT in a.PHIEUTRAs on PM.MAPHIEUMUON equals PT.MAPHIEUMUON
join CTPM in a.CTPMs on PM.MAPHIEUMUON equals CTPM.MAPHIEUMUON
join DG in a.DOCGIAs on PM.MADOCGIA equals DG.MADOCGIA
orderby PM.MAPHIEUMUON ascending
select new
{
MaPM = PM.MAPHIEUMUON,
MaDG = PM.MADOCGIA,
Ngaymuon = PM.NGAYMUON,
NgayHentra = PM.NGAYHENTRA,
ma_sach = CTPM.MASACH,
});
foreach (var tmp in c)
{
phieu_muon a = new phieu_muon(tmp.MaPM, tmp.MaDG, tmp.Ngaymuon, tmp.NgayHentra, tmp.ma_sach, "");
ds_PM.add(a);
}
for (int i = 0; i < ds_PM.count() - 1; i++)
{
if (ds_PM[i].Ma_phieu_muon.Equals(ds_PM[i + 1].Ma_phieu_muon))
{
ds_PM[i].Ma_sach_2 = ds_PM[+1].Ma_sach_1;
ds_PM.removeat(i + 1);
}
}
}
private void btMuon_Click(object sender, EventArgs e)
{
string ngay_hen = dtpkNgay_hen_tra.Value.Date.ToShortDateString();
DateTime ngayhen = Convert.ToDateTime(ngay_hen);
TimeSpan limit = ngayhen - DateTime.Now;
if (DateTime.Now > ngayhen)
{
this.errorProvider1.SetError(dtpkNgay_hen_tra, "Ngay hen tra phai sau ngay cho muon.");
}
else
{
if (limit.Days > 60)
{
this.errorProvider1.SetError(dtpkNgay_hen_tra, "Ngay muon toi da la 60 ngay");
}
else
{
this.errorProvider1.Clear();
if (tbMa_doc_gia.Text != "")
{
var c = from b in a.PHIEUMUONs
orderby b.MAPHIEUMUON descending
select b;
string t = "";
foreach (var tmp1 in c)
{
t = tmp1.MAPHIEUMUON;
break;
}
t = t.Remove(0, 2);
if (tbMa_sach_1.Text != "" || tbMa_sach_2.Text != "")
{
DateTime mm = Convert.ToDateTime(DateTime.Now.ToShortDateString());
string tmp = "PM";
if ((Convert.ToInt32(t) + 1) < 10)
{
tmp += "0";
}
phieu_muon PM = new phieu_muon(tmp + (Convert.ToInt32(t) + 1).ToString(),
tbMa_doc_gia.Text, mm,
ngayhen, tbMa_sach_1.Text, tbMa_sach_2.Text);
ds_PM.add(PM);
loadlistPM();
add_lvSach();
MessageBox.Show("Cho muon thanh cong");
PHIEUMUON PMmoi = new PHIEUMUON();
PMmoi.MAPHIEUMUON = tmp + (Convert.ToInt32(t) + 1).ToString();
PMmoi.MADOCGIA = tbtim_Ma_doc_gia.Text;
PMmoi.NGAYHENTRA = ngayhen;
PMmoi.NGAYMUON = mm;
a.PHIEUMUONs.InsertOnSubmit(PMmoi);
CTPM ctpm_moi1 = new CTPM();
CTPM ctpm_moi2 = new CTPM();
ctpm_moi1.MAPHIEUMUON = tmp + (Convert.ToInt32(t) + 1).ToString();
ctpm_moi2.MAPHIEUMUON = tmp + (Convert.ToInt32(t) + 1).ToString();
if (PM.Ma_sach_1 != "")
{
ctpm_moi1.MASACH = PM.Ma_sach_1;
a.CTPMs.InsertOnSubmit(ctpm_moi1);
a.SubmitChanges();
}
if (PM.Ma_sach_2 != "")
{
ctpm_moi2.MASACH = PM.Ma_sach_2;
a.CTPMs.InsertOnSubmit(ctpm_moi2);
a.SubmitChanges();
}
loadlistPM(); cleardata();
}
else
{
MessageBox.Show("Chua chon sach");
}
}
else
{
MessageBox.Show("Chua nhap ma doc gia");
}
}
}
}
public void add(phieu_muon a)
{
ds.Add(a);
}
