public bool SuaTaiLieu(string machitiet, string tenchitiet, string ncc, string nxb, string tacgia, string vitri, string soluong, string link, string sotrang, byte[] anhQR, byte[] anhTaiLieu, string giabia, string gianhap)
{
QLTVDataContext qltv = new QLTVDataContext();
string manxb = (from a in qltv.QL_NhaXuatBans
where a.TenNXB == nxb
select a.MaNXB).FirstOrDefault();
string matg = (from b in qltv.QL_TacGias
where b.TenTacGia == tacgia
select b.MaTacGia).FirstOrDefault();
string mavitri = (from c in qltv.QL_ViTris
where c.TenViTri == vitri
select c.MaViTri).FirstOrDefault();
string mancc = (from d in qltv.QL_NhaCungCaps
where d.TenNCC == ncc
select d.MaNCC).FirstOrDefault();
QL_ChiTietTaiLieu edit = qltv.QL_ChiTietTaiLieus.Where(p => p.MaCTTL.Equals(machitiet)).SingleOrDefault();
edit.TenChiTiet = tenchitiet;
edit.MaNCC = mancc;
edit.MaNXB = manxb;
edit.MaTG = matg;
edit.MaViTri = mavitri;
edit.SoLuong = int.Parse(soluong);
edit.Link = link;
edit.SoTrang = sotrang;
edit.AnhTaiLieu = anhTaiLieu;
edit.AnhQR = anhQR;
edit.GiaBia = decimal.Parse(giabia);
edit.GiaNhap = decimal.Parse(gianhap);
qltv.SubmitChanges();
return(true);
}
// 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);
}
public bool xoaTaiLieu(string machitiet)
{
QLTVDataContext qltv = new QLTVDataContext();
QL_ChiTietTaiLieu delete = qltv.QL_ChiTietTaiLieus.Where(p => p.MaCTTL.Equals(machitiet)).SingleOrDefault();
qltv.QL_ChiTietTaiLieus.DeleteOnSubmit(delete);
qltv.SubmitChanges();
return(true);
}
// thay doi so luong sach khi muon
public bool thayDoiSoLuongSach(string matailieu, int soluong)
{
string soluongtailieu = (from tl in qltv.QL_ChiTietTaiLieus
where tl.MaCTTL == int.Parse(matailieu)
select tl.SoLuong).FirstOrDefault().ToString();
QL_ChiTietTaiLieu edit = qltv.QL_ChiTietTaiLieus.Where(d => d.MaCTTL.Equals(matailieu)).SingleOrDefault();
int soluongmoi = int.Parse(soluongtailieu) - soluong;
edit.SoLuong = soluongmoi;
qltv.SubmitChanges();
return(true);
}
public bool themTaiLieu(string machitiet, string matailieu, string ncc, string nxb, string tacgia, string vitri, string soluong, string link, string sotrang, byte[] anh, byte[] anhQR, string giabia, string gianhap, string ngaynhap, string nguoinhap, string tenchitiet)
{
QLTVDataContext qltv = new QLTVDataContext();
string mancc = (from e in qltv.QL_NhaCungCaps
where e.TenNCC == ncc
select e.MaNCC).FirstOrDefault();
string manxb = (from a in qltv.QL_NhaXuatBans
where a.TenNXB == nxb
select a.MaNXB).FirstOrDefault();
string matg = (from b in qltv.QL_TacGias
where b.TenTacGia == tacgia
select b.MaTacGia).FirstOrDefault();
string mavitri = (from c in qltv.QL_ViTris
where c.TenViTri == vitri
select c.MaViTri).FirstOrDefault();
QL_ChiTietTaiLieu insert = new QL_ChiTietTaiLieu();
insert.MaCTTL = int.Parse(machitiet);
insert.MaTaiLieu = matailieu;
insert.MaNCC = mancc;
insert.MaNXB = manxb;
insert.MaTG = matg;
insert.MaViTri = mavitri;
insert.SoLuong = int.Parse(soluong);
insert.Link = link;
insert.SoTrang = sotrang;
insert.AnhTaiLieu = anh;
insert.AnhQR = anhQR;
insert.GiaBia = decimal.Parse(giabia);
insert.GiaNhap = decimal.Parse(gianhap);
insert.NgayNhap = DateTime.Parse(ngaynhap);
insert.NguoiNhap = nguoinhap;
insert.TenChiTiet = tenchitiet;
qltv.QL_ChiTietTaiLieus.InsertOnSubmit(insert);
qltv.SubmitChanges();
return(true);
}
