// thuc hien tra sach
public bool thucHienTraSach(string machitiet, string mahoadon)
{
// lay so luong muon
string soluongmuon = (from a in qltv.QL_ChiTietHoaDons
where a.MaCTHD == int.Parse(machitiet)
select a.SoLuong).FirstOrDefault().ToString();
string matailieu = (from b in qltv.QL_ChiTietHoaDons
where b.MaCTHD == int.Parse(machitiet)
select b.MaTaiLieu).FirstOrDefault().ToString();
string soluongtailieu = (from c in qltv.QL_ChiTietTaiLieus
where c.MaCTTL == int.Parse(matailieu)
select c.SoLuong).FirstOrDefault().ToString();
int soluongmoi = int.Parse(soluongmuon) + int.Parse(soluongtailieu);
QL_ChiTietTaiLieu edit = qltv.QL_ChiTietTaiLieus.Where(d => d.MaCTTL.Equals(matailieu)).SingleOrDefault();
edit.SoLuong = soluongmoi;
QL_HoaDon edit2 = qltv.QL_HoaDons.Where(d => d.MaHD.Equals(mahoadon)).SingleOrDefault();
edit2.TrangThai = "Đã trả";
qltv.SubmitChanges();
return(true);
}
// cap nhat trang thai hoa don khi tra thanh cong
public bool capNhatTrangThaiHoaDon(int mahoadon)
{
QL_HoaDon edit = qltv.QL_HoaDons.Where(d => d.MaHD == mahoadon).SingleOrDefault();
edit.TrangThai = "Đã trả";
qltv.SubmitChanges();
return(true);
}
// cap nhat hoa don
public bool thayDoitongSoSach(int mahoadon)
{
string tongsoluong = (qltv.QL_ChiTietHoaDons.Where(a => a.MaHD == mahoadon).Sum(d => d.SoLuong)).ToString();
QL_HoaDon edit = qltv.QL_HoaDons.Where(d => d.MaHD.Equals(mahoadon)).SingleOrDefault();
edit.TongSoLuong = int.Parse(tongsoluong);
qltv.SubmitChanges();
return(true);
}
public bool themHoaDon(int mahoadon, string nguoilap, string madocgia, string ngaymuon, string ngaytra, int tongsoluong, string trangthai)
{
try
{
QL_HoaDon insert = new QL_HoaDon();
insert.MaHD = mahoadon;
insert.NguoiLap = nguoilap;
insert.MaDocGia = madocgia;
insert.NgayMuon = DateTime.Parse(ngaymuon);
insert.NgayHenTra = DateTime.Parse(ngaytra);
insert.TongSoLuong = tongsoluong;
insert.TrangThai = trangthai;
qltv.QL_HoaDons.InsertOnSubmit(insert);
qltv.SubmitChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
