public static List <TimSachDTO> GetDSSachTheoTheLoai(string strTheLoai) { List <TimSachDTO> DsSachTTL = new List <TimSachDTO>(); using (dbMainDataContext dbMain = new dbMainDataContext()) { // var timKiem = dbMain.Saches.Where(p => p.TheLoai == (strTheLoai)).ToList(); ; var lst = from tk in dbMain.Saches where tk.TheLoai.Contains(strTheLoai) select tk; //from tk in dbMain.Saches where tk.TheLoai.Contains(strTheLoai) select tk; foreach (var row in lst) { TimSachDTO sach = new TimSachDTO(); sach.MaSach = row.MaSach; sach.TenSach = row.TenSach; sach.TheLoai = row.TheLoai; sach.TacGia = row.TacGia; sach.DonGia = row.DonGia.ToString("###,###,###' 'VNĐ"); sach.Luongton = row.TonCuoi.ToString(); DsSachTTL.Add(sach); } } return(DsSachTTL); }
public static List <ThuTienDTO> GetDS() { List <ThuTienDTO> DS = new List <ThuTienDTO>(); using (dbMainDataContext dbMain = new dbMainDataContext()) { var query = from p in dbMain.PhieuThus select p; foreach (var row in query) { ThuTienDTO tt = new ThuTienDTO(); tt.Maphieu = row.MaPhieuThu; tt.Ngaythu = row.NgayThu.ToString(); tt.Sotienthu = row.SoTienThu.ToString(); tt.Makh = row.MaKH; var getKH = from h in dbMain.KhachHangs where h.MaKh == row.MaKH select h; foreach (var row2 in getKH) { tt.Tenkh = row2.HoTen; tt.Email = row2.Email; tt.Diachi = row2.DiaChi; tt.Sdt = row2.SDT; // tt.Sotienno = row2.TongNo; } DS.Add(tt); } } return(DS); }
public static List <PhieuNhapDTO> GetDSPN() { List <PhieuNhapDTO> DSPN = new List <PhieuNhapDTO>(); using (dbMainDataContext dbMain = new dbMainDataContext()) { var query = from p in dbMain.PhieuNhaps select p; foreach (var row in query) { PhieuNhapDTO pn = new PhieuNhapDTO(); pn.Maphieunhap = row.MaPhieuNhap; pn.Ngaynhap = row.NgayNhap.ToString(); if (row.TongTien == 0) { pn.Tongtien = "0"; } else { pn.Tongtien = row.TongTien.ToString("###,###,###' 'VNĐ"); } DSPN.Add(pn); } } return(DSPN); }
public static List <BanSachDTO> GetDSHD(string maphieu) { List <BanSachDTO> DSHoaDon = new List <BanSachDTO>(); using (dbMainDataContext dbMain = new dbMainDataContext()) { var query = from p in dbMain.PhieuBans where p.MaPhieuBan == maphieu select p; foreach (var row in query) { BanSachDTO hd = new BanSachDTO(); hd.Soluong = row.SoLuong.ToString(); hd.Masach = row.MaSach; var getSach = from d in dbMain.Saches where d.MaSach == row.MaSach select d; foreach (var row3 in getSach) { hd.Tensach = row3.TenSach; hd.Dongia = row3.DonGia.ToString(); } DSHoaDon.Add(hd); } } return(DSHoaDon); }
public static List <CTPhieuNhapDTO> GetCTPN(string mapn) { List <CTPhieuNhapDTO> CTPN = new List <CTPhieuNhapDTO>(); using (dbMainDataContext dbMain = new dbMainDataContext()) { var query = from p in dbMain.ChiTietPhieuNhaps where p.MaPhieuNhap == mapn select p; foreach (var row in query) { CTPhieuNhapDTO ctpn = new CTPhieuNhapDTO(); ctpn.Mapn = row.MaPhieuNhap; ctpn.Masachnhap = row.MaSach; var getSach = from d in dbMain.Saches where d.MaSach == row.MaSach select d; foreach (var row3 in getSach) { ctpn.Tensach = row3.TenSach; } ctpn.Soluongnhap = row.SoLuong.ToString(); ctpn.Dongianhap = row.DonGia.ToString(); ctpn.Tongtien = row.TongTien.ToString(); CTPN.Add(ctpn); } } return(CTPN); }
public static void UpdateTongtien(string mapn, int soluong) { using (dbMainDataContext dbMain = new dbMainDataContext()) { PhieuNhap pn = dbMain.PhieuNhaps.SingleOrDefault(p => p.MaPhieuNhap == mapn); pn.TongTien = soluong; dbMain.SubmitChanges(); } }
public static void UpdateTongtien(string mahd, int soluong) { using (dbMainDataContext dbMain = new dbMainDataContext()) { HoaDon hd = dbMain.HoaDons.SingleOrDefault(p => p.MaHD == mahd); hd.TongTien = soluong; dbMain.SubmitChanges(); } }
public static void DeleteNhanVien(string email) { using (dbMainDataContext dbMain = new dbMainDataContext()) { NhanVien nv = dbMain.NhanViens.Where(p => p.Email == email).FirstOrDefault(); dbMain.NhanViens.DeleteOnSubmit(nv); dbMain.SubmitChanges(); } }
public static void UpdatePhieuNhap(string mapn, DateTime ngaynhap) { using (dbMainDataContext dbMain = new dbMainDataContext()) { PhieuNhap pn = dbMain.PhieuNhaps.SingleOrDefault(p => p.MaPhieuNhap == mapn); pn.MaPhieuNhap = mapn; pn.NgayNhap = ngaynhap; dbMain.SubmitChanges(); } }
public static void DeletePhieuNhap(string mapn) { using (dbMainDataContext dbMain = new dbMainDataContext()) { PhieuNhap pn = dbMain.PhieuNhaps.SingleOrDefault(p => p.MaPhieuNhap == mapn); dbMain.PhieuNhaps.DeleteOnSubmit(pn); dbMain.SubmitChanges(); } }
public static void DeleteHoaDon(string mahd, string masach) { using (dbMainDataContext dbMain = new dbMainDataContext()) { var query = from h in dbMain.PhieuBans where h.MaPhieuBan == mahd && h.MaSach == masach select h; PhieuBan pb = query.SingleOrDefault(); dbMain.PhieuBans.DeleteOnSubmit(pb); dbMain.SubmitChanges(); } }
public static void DeletePhieuThu(string mapt) { using (dbMainDataContext dbMain = new dbMainDataContext()) { PhieuThu pt = dbMain.PhieuThus.SingleOrDefault(p => p.MaPhieuThu == mapt); dbMain.PhieuThus.DeleteOnSubmit(pt); dbMain.SubmitChanges(); } }
public static void DeleteKhachHang(string makh) { using (dbMainDataContext dbMain = new dbMainDataContext()) { KhachHang kh = dbMain.KhachHangs.SingleOrDefault(p => p.MaKh == makh); dbMain.KhachHangs.DeleteOnSubmit(kh); dbMain.SubmitChanges(); } }
public static void DeleteSach(string masach) { using (dbMainDataContext dbMain = new dbMainDataContext()) { Sach s = dbMain.Saches.SingleOrDefault(p => p.MaSach == masach); dbMain.Saches.DeleteOnSubmit(s); dbMain.SubmitChanges(); } }
public static void DeleteHoaDon(string mahd) { using (dbMainDataContext dbMain = new dbMainDataContext()) { HoaDon hd = dbMain.HoaDons.SingleOrDefault(p => p.MaHD == mahd); dbMain.HoaDons.DeleteOnSubmit(hd); dbMain.SubmitChanges(); } }
public static void UpdateQuyDinh(string luongsach, int KHno, string tonNhap, string tonBan) { dbMainDataContext dbMain = new dbMainDataContext(); QuyDinh qd = dbMain.QuyDinhs.Where(p => p.MaQuyDinh == "1").FirstOrDefault(); qd.NhapToiThieu = luongsach; qd.KHNoToiThieu = KHno; qd.TonBanToiThieu = tonBan; qd.TonNhapToiThieu = tonNhap; dbMain.SubmitChanges(); }
public static bool checkTrung(string makh) { using (dbMainDataContext dbMain = new dbMainDataContext()) { var query = from p in dbMain.KhachHangs where p.MaKh == makh select p; if (query.Count() > 0) { return(false); } } return(true); }
public static bool checkTrung(string email) { using (dbMainDataContext dbMain = new dbMainDataContext()) { var query = from p in dbMain.NhanViens where p.Email == email select p; if (query.Count() > 0) { return(false); } } return(true); }
public static bool checkTrung(string mahd, string masach) { using (dbMainDataContext dbMain = new dbMainDataContext()) { var query = from h in dbMain.PhieuBans where h.MaPhieuBan == mahd && h.MaSach == masach select h; if (query.Count() > 0) { return(false); } } return(true); }
public static bool checkTrung(string mapn) { using (dbMainDataContext dbMain = new dbMainDataContext()) { var query = from p in dbMain.PhieuNhaps where p.MaPhieuNhap == mapn select p; if (query.Count() > 0) { return(false); } } return(true); }
public static void InsertPhieuNhap(string mapn, DateTime ngaynhap) { using (dbMainDataContext dbMain = new dbMainDataContext()) { PhieuNhap pn = new PhieuNhap(); pn.MaPhieuNhap = mapn; pn.NgayNhap = ngaynhap; pn.TongTien = 0; dbMain.PhieuNhaps.InsertOnSubmit(pn); dbMain.SubmitChanges(); } }
public static void DeleteCTPhieuNhap(string mapn, string masach) { using (dbMainDataContext dbMain = new dbMainDataContext()) { var query = from h in dbMain.ChiTietPhieuNhaps where h.MaPhieuNhap == mapn && h.MaSach == masach select h; //ChiTietPhieuNhap ctpn = dbMain.ChiTietPhieuNhaps.SingleOrDefault(p => p.MaPhieuNhap == //mapn and p=> p.MaSach == masach); ChiTietPhieuNhap ctpn = query.SingleOrDefault(); dbMain.ChiTietPhieuNhaps.DeleteOnSubmit(ctpn); dbMain.SubmitChanges(); } }
public static bool checkTrung(string mahd) { using (dbMainDataContext dbMain = new dbMainDataContext()) { var query = from p in dbMain.HoaDons where p.MaHD == mahd select p; if (query.Count() > 0) { return(false); } } return(true); }
public static void InsertHoaDon(string mahd, string masach, int soluong) { using (dbMainDataContext dbMain = new dbMainDataContext()) { PhieuBan pb = new PhieuBan(); pb.MaPhieuBan = mahd; pb.MaSach = masach; pb.SoLuong = soluong; dbMain.PhieuBans.InsertOnSubmit(pb); dbMain.SubmitChanges(); } }
public static void UpdateHD(string mahd, string makh, string tenkh, DateTime ngaynhap) { using (dbMainDataContext dbMain = new dbMainDataContext()) { HoaDon hd = dbMain.HoaDons.SingleOrDefault(p => p.MaHD == mahd); hd.MaKH = makh; hd.TenKH = tenkh; hd.Ngaylap = ngaynhap; dbMain.SubmitChanges(); } }
public static HoaDon getThongTinHD(string mahd) { HoaDon hd = new HoaDon(); using (dbMainDataContext dbMain = new dbMainDataContext()) { var query = from p in dbMain.HoaDons where p.MaHD == mahd select p; foreach (var row in query) { hd.TongTien = row.TongTien; } } return(hd); }
public static void UpdateSoLuongSach(string masach, int soluong, string tondau, string phatsinh, string tongnhap, string tongban) { using (dbMainDataContext dbMain = new dbMainDataContext()) { Sach s = dbMain.Saches.SingleOrDefault(p => p.MaSach == masach); s.TonCuoi = soluong; s.TonDau = tondau; s.TongNhap = tongnhap; s.TongBan = tongban; s.PhatSinh = phatsinh; dbMain.SubmitChanges(); } }
public static PhieuNhap getThongTinPhieuNhap(string mapn) { PhieuNhap pn = new PhieuNhap(); using (dbMainDataContext dbMain = new dbMainDataContext()) { var query = from p in dbMain.PhieuNhaps where p.MaPhieuNhap == mapn select p; foreach (var row in query) { pn.TongTien = row.TongTien; } } return(pn); }
public static void UpdateTongNoKH(string makh, string tongno, string nodau, string phatsinh) { using (dbMainDataContext dbMain = new dbMainDataContext()) { KhachHang kh = dbMain.KhachHangs.SingleOrDefault(p => p.MaKh == makh); kh.MaKh = makh; kh.NoDau = nodau; kh.PhatSinh = phatsinh; kh.TongNo = tongno; dbMain.SubmitChanges(); } }
public static void InsertHD(string mahd, string makh, string tenkh, DateTime ngaynhap, int tongtien) { using (dbMainDataContext dbMain = new dbMainDataContext()) { HoaDon hd = new HoaDon(); hd.MaHD = mahd; hd.MaKH = makh; hd.TenKH = tenkh; hd.Ngaylap = ngaynhap; hd.TongTien = tongtien; dbMain.HoaDons.InsertOnSubmit(hd); dbMain.SubmitChanges(); } }