public IQueryable loadcbbtacgia() { QLTVDataContext qltv = new QLTVDataContext(); return(from a in qltv.QL_TacGias select a.TenTacGia); }
public IQueryable loadcbbnxb() { QLTVDataContext qltv = new QLTVDataContext(); return(from a in qltv.QL_NhaXuatBans select a.TenNXB); }
public IQueryable loadcbbncc() { QLTVDataContext qltv = new QLTVDataContext(); return(from a in qltv.QL_NhaCungCaps select a.TenNCC); }
public IQueryable loadcbbvitri() { QLTVDataContext qltv = new QLTVDataContext(); return(from a in qltv.QL_ViTris select a.TenViTri); }
public IQueryable loadcbbtailieu() { QLTVDataContext qltv = new QLTVDataContext(); return(from a in qltv.QL_TaiLieus select a.TenTaiLieu); }
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); }
public IQueryable loadcbbtentheloai() { QLTVDataContext qltv = new QLTVDataContext(); return(from a in qltv.QL_ChiTietTaiLieus select a.TenChiTiet); }
public string loadTenDanhMuc(string matailieu) { QLTVDataContext qltv = new QLTVDataContext(); return((from a in qltv.QL_TaiLieus where a.MaTaiLieu == matailieu select a.TenTaiLieu).FirstOrDefault()); }
public string laymatailieu(string tentailieu) { QLTVDataContext qltv = new QLTVDataContext(); return((from a in qltv.QL_TaiLieus where a.TenTaiLieu == tentailieu select a.MaTaiLieu).FirstOrDefault()); }
public string loadsoluongtailieu(string tentailieu) { QLTVDataContext qltv = new QLTVDataContext(); return((from r in qltv.QL_ChiTietTaiLieus where r.TenChiTiet == tentailieu select r.SoLuong).FirstOrDefault().ToString()); }
public string layMaDG(string sdt) { QLTVDataContext qltv = new QLTVDataContext(); string ma = (from a in qltv.QL_DocGias where a.SoDienThoai == sdt select a.MaDocGia).FirstOrDefault(); return(ma); }
public bool xoanhom(string manhom, string tennhom) { QLTVDataContext qltv = new QLTVDataContext(); QL_NhomCuaNguoiDung delete = qltv.QL_NhomCuaNguoiDungs.Where(d => d.MaNhom.Equals(manhom)).SingleOrDefault(); qltv.QL_NhomCuaNguoiDungs.DeleteOnSubmit(delete); qltv.SubmitChanges(); return(true); }
public bool suanhom(string manhom, string tennhom) { QLTVDataContext qltv = new QLTVDataContext(); QL_NhomCuaNguoiDung edit = qltv.QL_NhomCuaNguoiDungs.Where(d => d.MaNhom.Equals(manhom)).SingleOrDefault(); edit.TenNhom = tennhom; qltv.SubmitChanges(); return(true); }
public string loadMaChiTietTaiLieu(string tentailieu) { string matailieu; QLTVDataContext qltv = new QLTVDataContext(); return(matailieu = (from a in qltv.QL_ChiTietTaiLieus where a.TenChiTiet == tentailieu select a.MaCTTL).FirstOrDefault().ToString()); }
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); }
public byte[] loadAnhTaiLieu(string tentailieu) { QLTVDataContext qltv = new QLTVDataContext(); var abc = (from tl in qltv.QL_ChiTietTaiLieus where tl.TenChiTiet == tentailieu select tl.AnhTaiLieu).FirstOrDefault(); byte[] anh = abc.ToArray(); return(anh); }
public string loadgiabia(string tentailieu) { QLTVDataContext qltv = new QLTVDataContext(); string giabia; return(giabia = (from f in qltv.QL_ChiTietTaiLieus where f.TenChiTiet == tentailieu select f.GiaBia).FirstOrDefault().ToString()); }
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 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 byte[] loadAnhDocGia(string madocgia) { QLTVDataContext qltv = new QLTVDataContext(); var abc = (from tl in qltv.QL_DocGias where tl.MaDocGia == madocgia select tl.AnhDocGia).FirstOrDefault(); byte[] anhDocGia = abc.ToArray(); return(anhDocGia); }
public bool kiemTra(string tendangnhap) { QLTVDataContext qltv = new QLTVDataContext(); QL_NguoiDung nd = qltv.QL_NguoiDungs.Where(t => t.TenDangNhap == tendangnhap).FirstOrDefault(); if (nd != null) { return(true); } return(false); }
public string taoMaTuDong() { QLTVDataContext qltv = new QLTVDataContext(); var item = qltv.QL_DocGias.Max(d => d.MaDocGia); if (item == null) { item = "0"; } return(item.ToString()); }
public string taoMaTuDong() { QLTVDataContext qltv = new QLTVDataContext(); var item = qltv.QL_ChiTietTaiLieus.Max(d => d.MaCTTL); if (item == null) { item = 0; } return(item.ToString()); }
public bool themnhom(string manhom, string tennhom) { QLTVDataContext qltv = new QLTVDataContext(); QL_NhomCuaNguoiDung insert = new QL_NhomCuaNguoiDung(); insert.MaNhom = manhom; insert.TenNhom = tennhom; qltv.QL_NhomCuaNguoiDungs.InsertOnSubmit(insert); qltv.SubmitChanges(); return(true); }
public string taoMaTuDong() { QLTVDataContext qltv = new QLTVDataContext(); var item = qltv.QL_HoaDons.Max(d => d.MaHD); if (item == null) { item = 0; } return(item.ToString()); }
public string laytenloaidg(string sdt) { QLTVDataContext qltv = new QLTVDataContext(); string maloaidg = (from a in qltv.QL_DocGias where a.SoDienThoai == sdt select a.LoaiDocGia).FirstOrDefault(); string tenloaidg = (from b in qltv.QL_LoaiDocGias where b.MaLoaiDocGia == maloaidg select b.TenLoaiDocGia).FirstOrDefault(); return(tenloaidg); }
public IQueryable kiemTraTenDangNhap(string tendangnhap) { QLTVDataContext qltv = new QLTVDataContext(); return(from a in qltv.QL_NguoiDungs.Where(p => p.TenDangNhap.CompareTo(tendangnhap) == 0) select new { a.TenDangNhap, a.MatKhau, a.MaNhom }); }
public string loadncc(string tentailieu) { QLTVDataContext qltv = new QLTVDataContext(); string mancc = (from tl in qltv.QL_ChiTietTaiLieus where tl.TenChiTiet == tentailieu select tl.MaNCC).FirstOrDefault(); string tenvitri; return(tenvitri = (from f in qltv.QL_NhaCungCaps where f.MaNCC == mancc select f.TenNCC).FirstOrDefault()); }
public string loadtacgia(string tentailieu) { QLTVDataContext qltv = new QLTVDataContext(); string matacgia = (from tl in qltv.QL_ChiTietTaiLieus where tl.TenChiTiet == tentailieu select tl.MaTG).FirstOrDefault(); string tentacgia; return(tentacgia = (from f in qltv.QL_TacGias where f.MaTacGia == matacgia select f.TenTacGia).FirstOrDefault()); }
public string loadvitri(string tentailieu) { QLTVDataContext qltv = new QLTVDataContext(); string mavitri = (from tl in qltv.QL_ChiTietTaiLieus where tl.TenChiTiet == tentailieu select tl.MaViTri).FirstOrDefault(); string tenvitri; return(tenvitri = (from f in qltv.QL_ViTris where f.MaViTri == mavitri select f.TenViTri).FirstOrDefault()); }