public bool tinhTongGiaNhap(string matailieu) { QLTVDataContext qltv = new QLTVDataContext(); string tongiatien = (qltv.QL_ChiTietTaiLieus.Where(a => a.MaTaiLieu == matailieu).Sum(d => d.GiaNhap)).ToString(); QL_TaiLieu edit = qltv.QL_TaiLieus.Where(d => d.MaTaiLieu.Equals(matailieu)).SingleOrDefault(); edit.TongGiaTien = tongiatien; qltv.SubmitChanges(); return(true); }
public bool tinhTongSoLuongTL(string matailieu) { QLTVDataContext qltv = new QLTVDataContext(); string tongsoluong = (qltv.QL_ChiTietTaiLieus.Where(a => a.MaTaiLieu == matailieu).Sum(d => d.SoLuong)).ToString(); QL_TaiLieu edit = qltv.QL_TaiLieus.Where(d => d.MaTaiLieu.Equals(matailieu)).SingleOrDefault(); edit.TongSoLuong = tongsoluong; qltv.SubmitChanges(); return(true); }
public bool xoatailieu(string matailieu) { try { QLTVDataContext qltv = new QLTVDataContext(); QL_TaiLieu delete = qltv.QL_TaiLieus.Where(p => p.MaTaiLieu.Equals(matailieu)).SingleOrDefault(); qltv.QL_TaiLieus.DeleteOnSubmit(delete); qltv.SubmitChanges(); return(true); } catch (Exception ex) { return(false); } }
public bool suatailieu(string matailieu, string tentheloai) { QLTVDataContext qltv = new QLTVDataContext(); try { QL_TaiLieu edit = qltv.QL_TaiLieus.Where(p => p.MaTaiLieu.Equals(matailieu)).SingleOrDefault(); edit.TenTaiLieu = tentheloai; qltv.SubmitChanges(); return(true); } catch (Exception ex) { return(false); } }
public bool themtailieu(string matailieu, string tentheloai, string tongsoluong, string nguoinhap, string ngaynhap, string tonggiatien) { try { QLTVDataContext qltv = new QLTVDataContext(); QL_TaiLieu insert = new QL_TaiLieu(); insert.MaTaiLieu = matailieu; insert.TenTaiLieu = tentheloai; insert.TongSoLuong = tongsoluong; insert.TongGiaTien = tonggiatien; insert.NgayNhap = DateTime.Parse(ngaynhap); insert.NguoiNhap = nguoinhap; insert.TongGiaTien = tonggiatien; qltv.QL_TaiLieus.InsertOnSubmit(insert); qltv.SubmitChanges(); return(true); } catch (Exception ex) { return(false); } }