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); }