public IQueryable<BOMenuMon> GetAll(int GroupID, bool IsBanHang, bool IsSoLuongChoPhepTonKho, bool IsSoLuongKhongChoPhepTonKho, bool IsVisual, Transit mTransit) { frmMon.Refresh(); var lsArray = from m in frmMon.Query() join n in frmNhom.Query() on (int)m.NhomID equals (int)n.NhomID select new BOMenuMon { MenuMon = m, MenuNhom = n }; if (GroupID > -1) lsArray = lsArray.Where(s => s.MenuMon.NhomID == GroupID && s.MenuMon.Deleted == false); if (IsBanHang) { if (IsSoLuongChoPhepTonKho && IsSoLuongKhongChoPhepTonKho) lsArray = lsArray.Where(s => s.MenuMon.SLMonKhongChoPhepTonKho > 0 || s.MenuMon.SLMonChoPhepTonKho > 0); else if (IsSoLuongChoPhepTonKho) lsArray = lsArray.Where(s => s.MenuMon.SLMonChoPhepTonKho > 0); else if (IsSoLuongKhongChoPhepTonKho) lsArray = lsArray.Where(s => s.MenuMon.SLMonKhongChoPhepTonKho > 0); } else { if (!IsSoLuongChoPhepTonKho) lsArray = lsArray.Where(s => s.MenuMon.SLMonKhongChoPhepTonKho > 0); if (!IsSoLuongKhongChoPhepTonKho) lsArray = lsArray.Where(s => s.MenuMon.SLMonChoPhepTonKho > 0); } if (IsVisual) lsArray = lsArray.Where(s => s.MenuMon.Visual == true); return lsArray.OrderBy(s => s.MenuMon.SapXep); }
public int Them(BOXuLyKho item, List<BOXuLyKhoChiTiet> lsArray, Transit mTransit) { ThemMoi(item, lsArray, mTransit); frmXuLyKho.AddObject(item.XuLyKho); frmXuLyKho.Commit(); return item.XuLyKho.ChinhKhoID; }
public static int Xoa(int chiTietBanHangId, Transit mTransit) { CHITIETBANHANG item = (from x in mTransit.KaraokeEntities.CHITIETBANHANGs where x.ChiTietBanHangID == chiTietBanHangId select x).First(); mTransit.KaraokeEntities.DeleteObject(item); mTransit.KaraokeEntities.SaveChanges(); return item.ChiTietBanHangID; }
public BOKhachHang(Data.Transit transit) { mTransit = transit; mKaraokeEntities = new KaraokeEntities(); frmKhachHang = new FrameworkRepository<KHACHHANG>(transit.KaraokeEntities, transit.KaraokeEntities.KHACHHANGs); frmLoaiKhachHang = new FrameworkRepository<LOAIKHACHHANG>(transit.KaraokeEntities, transit.KaraokeEntities.LOAIKHACHHANGs); }
public static IQueryable<BAN> GetAllTableInOrderPerArea(KHU khu, Transit transit) { return from a in GetVisual(transit) join b in BOBanHang.GetAllNotCompleted(transit.KaraokeEntities) on a.BanID equals b.BanID where a.KhuID == khu.KhuID select a; }
public static IQueryable<BAN> GetAllTableNotInOrderPerArea(KHU khu, Transit transit) { var listIn = GetAllTableInOrderPerArea(khu, transit); return from a in GetVisual(transit) where !listIn.Contains(a) && a.KhuID == khu.KhuID select a; }
public IQueryable<BOMenuNhom> GetAll(int LoaiNhomID, bool IsBanHang, bool IsSoLuongChoPhepTonKho, bool IsSoLuongKhongChoPhepTonKho, bool IsVisual, Transit mTransit) { var lsArray = from n in frmNhom.Query().Where(o=>o.Deleted==false) select new BOMenuNhom { MenuNhom = n }; if (LoaiNhomID > 0) lsArray = lsArray.Where(s => (s.MenuNhom.LoaiNhomID == LoaiNhomID || LoaiNhomID==0) && s.MenuNhom.Deleted == false); if (IsBanHang) { if (IsSoLuongChoPhepTonKho && IsSoLuongKhongChoPhepTonKho) lsArray = lsArray.Where(s => s.MenuNhom.Visual == true && s.MenuNhom.SLMonChoPhepTonKho > 0 || s.MenuNhom.SLMonKhongChoPhepTonKho > 0); else if (IsSoLuongChoPhepTonKho) lsArray = lsArray.Where(s => s.MenuNhom.Visual == true && s.MenuNhom.SLMonChoPhepTonKho > 0); else if (IsSoLuongKhongChoPhepTonKho) lsArray = lsArray.Where(s => s.MenuNhom.Visual == true && s.MenuNhom.SLMonKhongChoPhepTonKho > 0); } else { if (!IsSoLuongChoPhepTonKho) lsArray = lsArray.Where(s => s.MenuNhom.SLMonKhongChoPhepTonKho > 0); if (!IsSoLuongKhongChoPhepTonKho) lsArray = lsArray.Where(s => s.MenuNhom.SLMonChoPhepTonKho > 0); } if (IsVisual) lsArray = lsArray.Where(s => s.MenuNhom.Visual == true); return lsArray.OrderBy(s => s.MenuNhom.SapXep); }
public int Them(BOMenuNhom item, Transit mTransit) { frmNhom.AddObject(item.MenuNhom); frmNhom.Commit(); SapXep((int)item.MenuNhom.LoaiNhomID, mTransit); return item.MenuNhom.NhomID; }
public BOChiTietChuyenKho(Transit transit) { frmChiTietChuyenKho = new FrameworkRepository<CHITIETCHUYENKHO>(transit.KaraokeEntities, transit.KaraokeEntities.CHITIETCHUYENKHOes); frmMenuMon = new FrameworkRepository<MENUMON>(transit.KaraokeEntities, transit.KaraokeEntities.MENUMONs); frmLoaiBan = new FrameworkRepository<LOAIBAN>(transit.KaraokeEntities, transit.KaraokeEntities.LOAIBANs); frmChuyenKho = new FrameworkRepository<CHUYENKHO>(transit.KaraokeEntities, transit.KaraokeEntities.CHUYENKHOes); frmTonKho = new FrameworkRepository<TONKHO>(transit.KaraokeEntities, transit.KaraokeEntities.TONKHOes); }
public BOXuliTinhTien(Transit transit,BOBanHang banhang) { mTransit = transit; mBanHang = new BANHANG(); Copy(banhang.BANHANG, mBanHang); mBanHang.TongTien = banhang.TongTien(); }
public BOXuLyKhoChiTiet(Transit transit) { frmChiTietXuLyKho = new FrameworkRepository<XULYKHOCHITIET>(transit.KaraokeEntities, transit.KaraokeEntities.XULYKHOCHITIETs); frmMenuMon = new FrameworkRepository<MENUMON>(transit.KaraokeEntities, transit.KaraokeEntities.MENUMONs); frmLoaiBan = new FrameworkRepository<LOAIBAN>(transit.KaraokeEntities, transit.KaraokeEntities.LOAIBANs); frmXyLyKho = new FrameworkRepository<XULYKHO>(transit.KaraokeEntities, transit.KaraokeEntities.XULYKHOes); frmTonKho = new FrameworkRepository<TONKHO>(transit.KaraokeEntities, transit.KaraokeEntities.TONKHOes); }
public int Xoa(BOMenuNhom item, Transit mTransit) { item.MenuNhom.Deleted = true; frmNhom.Update(item.MenuNhom); frmNhom.Commit(); SapXep((int)item.MenuNhom.LoaiNhomID, mTransit); return item.MenuNhom.NhomID; }
public BOChiTietBanHang(CHITIETBANHANG chiTiet, Transit transit) { _ListKhuyenMai = new List<BOChiTietBanHang>(); ChiTietBanHang = chiTiet; MenuKichThuocMon = ChiTietBanHang.MENUKICHTHUOCMON; MenuMon = ChiTietBanHang.MENUKICHTHUOCMON.MENUMON; mTransit = transit; SoLuongBanTam = (int)ChiTietBanHang.SoLuongBan; }
public BOChiTietQuyen(Transit transit) { mTransit = transit; frmChiTietQuyen = new FrameworkRepository<CHITIETQUYEN>(transit.KaraokeEntities, transit.KaraokeEntities.CHITIETQUYENs); frmQuyen = new FrameworkRepository<QUYEN>(transit.KaraokeEntities, transit.KaraokeEntities.QUYENs); frmChucNang = new FrameworkRepository<CHUCNANG>(transit.KaraokeEntities, transit.KaraokeEntities.CHUCNANGs); frmQuyenNhanVien = new FrameworkRepository<QUYENNHANVIEN>(transit.KaraokeEntities, transit.KaraokeEntities.QUYENNHANVIENs); frmNhomChucNang = new FrameworkRepository<NHOMCHUCNANG>(transit.KaraokeEntities, transit.KaraokeEntities.NHOMCHUCNANGs); }
public int Xoa(BOMenuMon item, Transit mTransit) { item.MenuMon.Deleted = true; frmMon.Update(item.MenuMon); SapXep((int)item.MenuMon.NhomID, mTransit); frmMon.Commit(); UpdateSoLuongMon((int)item.MenuMon.NhomID, mTransit); return(item.MenuMon.MonID); }
public BOXuliMayIn(Transit transit) { mTransit = transit; mKaraokeEntities = new KaraokeEntities(); _CAIDATMAYINBEP = BOCaiDatMayInBep.GetQueryNoTracking(mKaraokeEntities); _CAIDATMAYINHOADON = BOCaiDatMayInHoaDon.GetQueryNoTracking(mKaraokeEntities); _ImageLogo = Utilities.ImageHandler.BitmapImage2Bitmap(this._CAIDATMAYINHOADON.Logo); }
public BOChiTietQuyen(Transit transit) { mTransit = transit; frmChiTietQuyen = new FrameworkRepository <CHITIETQUYEN>(transit.KaraokeEntities, transit.KaraokeEntities.CHITIETQUYENs); frmQuyen = new FrameworkRepository <QUYEN>(transit.KaraokeEntities, transit.KaraokeEntities.QUYENs); frmChucNang = new FrameworkRepository <CHUCNANG>(transit.KaraokeEntities, transit.KaraokeEntities.CHUCNANGs); frmQuyenNhanVien = new FrameworkRepository <QUYENNHANVIEN>(transit.KaraokeEntities, transit.KaraokeEntities.QUYENNHANVIENs); frmNhomChucNang = new FrameworkRepository <NHOMCHUCNANG>(transit.KaraokeEntities, transit.KaraokeEntities.NHOMCHUCNANGs); }
public int Sua(BOMenuNhom item, Transit mTransit) { frmNhom.Update(item.MenuNhom); frmNhom.Commit(); if (item.MenuNhom.LoaiNhomID != null) { SapXep((int)item.MenuNhom.LoaiNhomID, mTransit); } return(item.MenuNhom.NhomID); }
public static IQueryable <BOThe> GetAllVisual(Transit mTransit) { return(from x in FrameworkRepository <THE> .QueryNoTracking(mTransit.KaraokeEntities.THEs) where x.Visual == true && x.Deleted == false select new BOThe { TheID = x.TheID, TenThe = x.TenThe }); }
public static IQueryable<BOThe> GetAllVisual(Transit mTransit) { return from x in FrameworkRepository<THE>.QueryNoTracking(mTransit.KaraokeEntities.THEs) where x.Visual == true && x.Deleted == false select new BOThe { TheID = x.TheID, TenThe = x.TenThe }; }
public IQueryable <BONhanVien> GetAll(Transit mTransit) { return(from nv in mKaraokeEntities.NHANVIENs join lnv in mKaraokeEntities.LOAINHANVIENs on nv.LoaiNhanVienID equals lnv.LoaiNhanVienID where nv.Deleted == false && nv.CapDo > mTransit.NhanVien.CapDo || nv.NhanVienID == mTransit.NhanVien.NhanVienID select new BONhanVien { NhanVien = nv, LoaiNhanVien = lnv }); }
public IQueryable<BONhanVien> GetAll(Transit mTransit) { return (from nv in mKaraokeEntities.NHANVIENs join lnv in mKaraokeEntities.LOAINHANVIENs on nv.LoaiNhanVienID equals lnv.LoaiNhanVienID where nv.Deleted == false && nv.CapDo > mTransit.NhanVien.CapDo || nv.NhanVienID == mTransit.NhanVien.NhanVienID select new BONhanVien { NhanVien = nv, LoaiNhanVien = lnv }); }
public static int CapNhat(CHITIETBANHANG item, Transit mTransit) { CHITIETBANHANG m = (from x in mTransit.KaraokeEntities.CHITIETBANHANGs where x.ChiTietBanHangID == item.ChiTietBanHangID select x).First(); m.BanHangID = item.BanHangID; m.SoLuongBan = item.SoLuongBan; m.GiaBan = item.GiaBan; m.ThanhTien = item.ThanhTien; m.KichThuocMonID = item.KichThuocMonID; m.NhanVienID = item.NhanVienID; mTransit.KaraokeEntities.SaveChanges(); return item.ChiTietBanHangID; }
public void Luu(List<BOChiTietQuyen> lsArray, Transit mTransit) { if (lsArray != null) foreach (BOChiTietQuyen item in lsArray) { if (item.ChiTietQuyen.ChiTietQuyenID > 0) Sua(item, mTransit); else Them(item, mTransit); } frmChiTietQuyen.Commit(); }
public IQueryable<BOMenuGia> GetAllBOMenuGia(int KichThuocMonID, Transit mTransit) { var res = (from g in frmMenuGia.Query() join l in frmLoaiGia.Query() on g.LoaiGiaID equals l.LoaiGiaID where g.KichThuocMonID == KichThuocMonID select new BOMenuGia { MenuGia = g, LoaiGia = l }); return res; }
public IQueryable <BOMenuItemMayIn> GetAll(int MonID, Transit mTransit) { return(from mim in frmMenuItemMayIn.Query() join mi in frmMayIn.Query() on mim.MayInID equals mi.MayInID join m in frmMenuMon.Query() on mim.MonID equals m.MonID where mim.Deleted == false && mim.MonID == MonID select new BOMenuItemMayIn { MenuItemMayIn = mim, MayIn = mi, MenuMon = m }); }
public BOBanHang(Transit tran, KaraokeEntities kara) { mTransit = tran; mKaraokeEntities = kara; _CAIDATBANHANG = mKaraokeEntities.CAIDATBANHANGs.FirstOrDefault(); if (_CAIDATBANHANG == null) { _CAIDATBANHANG = new CAIDATBANHANG(); } _ListChiTietBanHang = new List <BOChiTietBanHang>(); mListChiTietBanHangDeleted = new List <BOChiTietBanHang>(); //LoadBanHang(); }
public IQueryable <BOQuyenNhanVien> GetAll(int MaQuyen, Transit mTransit) { return(from qnv in frmQuyenNhanVien.Query() join q in frmQuyen.Query() on qnv.QuyenID equals q.MaQuyen join nv in frmNhanVien.Query() on qnv.NhanVienID equals nv.NhanVienID where qnv.Deleted == false && qnv.Deleted == false && qnv.QuyenID == MaQuyen select new BOQuyenNhanVien { QuyenNhanVien = qnv, Quyen = q, NhanVien = nv }); }
public IQueryable<BOMenuItemMayIn> GetAll(int MonID, Transit mTransit) { return (from mim in frmMenuItemMayIn.Query() join mi in frmMayIn.Query() on mim.MayInID equals mi.MayInID join m in frmMenuMon.Query() on mim.MonID equals m.MonID where mim.Deleted == false && mim.MonID == MonID select new BOMenuItemMayIn { MenuItemMayIn = mim, MayIn = mi, MenuMon = m }); }
public static int CapNhat(CHITIETBANHANG item, Transit mTransit) { CHITIETBANHANG m = (from x in mTransit.KaraokeEntities.CHITIETBANHANGs where x.ChiTietBanHangID == item.ChiTietBanHangID select x).First(); m.BanHangID = item.BanHangID; m.SoLuongBan = item.SoLuongBan; m.GiaBan = item.GiaBan; m.ThanhTien = item.ThanhTien; m.KichThuocMonID = item.KichThuocMonID; m.NhanVienID = item.NhanVienID; mTransit.KaraokeEntities.SaveChanges(); return(item.ChiTietBanHangID); }
public IQueryable <BOMenuGia> GetAllBOMenuGia(int KichThuocMonID, Transit mTransit) { var res = (from g in frmMenuGia.Query() join l in frmLoaiGia.Query() on g.LoaiGiaID equals l.LoaiGiaID where g.KichThuocMonID == KichThuocMonID select new BOMenuGia { MenuGia = g, LoaiGia = l }); return(res); }
public void Luu(List<BOMenuGia> lsArray, Transit mTransit) { foreach (BOMenuGia item in lsArray) { if (item.MenuGia.Gia == 0 && item.MenuGia.GiaID > 0) Xoa(item, mTransit); else if (item.MenuGia.Gia != 0 && item.MenuGia.GiaID == 0) Them(item, mTransit); else if (item.MenuGia.Gia != 0 && item.MenuGia.GiaID > 0) Sua(item, mTransit); } frmMenuGia.Commit(); }
public BOBanHang(Transit tran,KaraokeEntities kara) { mTransit = tran; mKaraokeEntities = kara; _CAIDATBANHANG = mKaraokeEntities.CAIDATBANHANGs.FirstOrDefault(); if (_CAIDATBANHANG==null) { _CAIDATBANHANG = new CAIDATBANHANG(); } _ListChiTietBanHang = new List<BOChiTietBanHang>(); mListChiTietBanHangDeleted = new List<BOChiTietBanHang>(); //LoadBanHang(); }
public IQueryable<BODinhLuong> GetAll(int KichThuocMonID, Transit mTransit) { var res = (from dl in frmDinhLuong.Query() join mm in frmMenuMon.Query() on dl.MonID equals mm.MonID join lb in frmLoaiBan.Query() on dl.LoaiBanID equals lb.LoaiBanID where dl.KichThuocMonChinhID == KichThuocMonID select new BODinhLuong { DinhLuong = dl, MenuMon = mm, LoaiBan = lb }); return res; }
public static NHANVIEN CheckLogin(string user, string pass,Transit transit) { //if (!String.IsNullOrEmpty(user) && !String.IsNullOrEmpty(pass)) //{ // var Parameter_TenDangNhap = new System.Data.SqlClient.SqlParameter("@TenDangNhap", System.Data.SqlDbType.VarChar, 50); // Parameter_TenDangNhap.Value = user; // var Parameter_MatKhau = new System.Data.SqlClient.SqlParameter("@MatKhau", System.Data.SqlDbType.VarChar, 255); // Parameter_MatKhau.Value = pass; // NHANVIEN nv = transit.KaraokeEntities.ExecuteStoreQuery<NHANVIEN>("SP_Login_NhanVien @TenDangNhap, @MatKhau", Parameter_TenDangNhap, Parameter_MatKhau).FirstOrDefault(); // return nv; //} //return null; return CheckLogin(transit.KaraokeEntities, user, pass); }
public IQueryable<BOChiTietQuyen> GetAll(int MaQuyen, Transit mTransit) { var res = (from ctq in frmChiTietQuyen.Query() join q in frmQuyen.Query() on ctq.QuyenID equals q.MaQuyen join cn in frmChucNang.Query() on ctq.ChucNangID equals cn.ChucNangID where ctq.Deleted == false && ctq.QuyenID == MaQuyen select new BOChiTietQuyen { ChiTietQuyen = ctq, Quyen = q, ChucNang = cn }); return res; }
public static NHANVIEN CheckLogin(string user, string pass, Transit transit) { //if (!String.IsNullOrEmpty(user) && !String.IsNullOrEmpty(pass)) //{ // var Parameter_TenDangNhap = new System.Data.SqlClient.SqlParameter("@TenDangNhap", System.Data.SqlDbType.VarChar, 50); // Parameter_TenDangNhap.Value = user; // var Parameter_MatKhau = new System.Data.SqlClient.SqlParameter("@MatKhau", System.Data.SqlDbType.VarChar, 255); // Parameter_MatKhau.Value = pass; // NHANVIEN nv = transit.KaraokeEntities.ExecuteStoreQuery<NHANVIEN>("SP_Login_NhanVien @TenDangNhap, @MatKhau", Parameter_TenDangNhap, Parameter_MatKhau).FirstOrDefault(); // return nv; //} //return null; return(CheckLogin(transit.KaraokeEntities, user, pass)); }
public IQueryable<BOQuyenNhanVien> GetAll(int MaQuyen, Transit mTransit) { return (from qnv in frmQuyenNhanVien.Query() join q in frmQuyen.Query() on qnv.QuyenID equals q.MaQuyen join nv in frmNhanVien.Query() on qnv.NhanVienID equals nv.NhanVienID where qnv.Deleted == false && qnv.Deleted == false && qnv.QuyenID == MaQuyen select new BOQuyenNhanVien { QuyenNhanVien = qnv, Quyen = q, NhanVien = nv }); }
public static CAIDATBAN GetQueryNoTracking(Transit transit) { CAIDATBAN item = FrameworkRepository<CAIDATBAN>.QueryNoTracking(transit.KaraokeEntities.CAIDATBANs).FirstOrDefault(); if (item == null) { item = new CAIDATBAN(); item.TableWidth = (decimal)0.0735294000; item.TableHeight = (decimal)0.0938086000; item.TableFontSize = 12; item.TableFontStyle = (int)SomeEnum.FontStyles.Normal; item.TableFontWeights = (int)SomeEnum.FontWeights.Normal; } return item; }
public void Luu(List<BOMenuItemMayIn> lsArray, List<BOMenuItemMayIn> lsArrayDeleted, Transit mTransit) { if (lsArray != null) foreach (BOMenuItemMayIn item in lsArray) { Them(item, mTransit); } if (lsArrayDeleted != null) foreach (BOMenuItemMayIn item in lsArrayDeleted) { Xoa(item, mTransit); } frmMenuItemMayIn.Commit(); }
public BOChiTietBanHang(Data.BOMenuKichThuocMon ktm, Transit transit) { mTransit = transit; this.ChiTietBanHang = new CHITIETBANHANG(); _ListKhuyenMai = new List <BOChiTietBanHang>(); this.MenuKichThuocMon = ktm.MenuKichThuocMon; this.ChiTietBanHang.SoLuongBan = ktm.MenuKichThuocMon.SoLuongBanBan; this.ChiTietBanHang.GiaBan = ktm.MenuKichThuocMon.GiaBanMacDinh; this.ChiTietBanHang.KichThuocLoaiBan = ktm.KichThuocLoaiBan; this.ChiTietBanHang.GiamGia = ktm.MenuMon.GiamGia; this.ChiTietBanHang.KichThuocMonID = ktm.MenuKichThuocMon.KichThuocMonID; this.MenuMon = ktm.MenuMon; SoLuongBanTam = (int)this.ChiTietBanHang.SoLuongBan; ChangeThanhTien(); }
public IQueryable <BODinhLuong> GetAll(int KichThuocMonID, Transit mTransit) { var res = (from dl in frmDinhLuong.Query() join mm in frmMenuMon.Query() on dl.MonID equals mm.MonID join lb in frmLoaiBan.Query() on dl.LoaiBanID equals lb.LoaiBanID where dl.KichThuocMonChinhID == KichThuocMonID select new BODinhLuong { DinhLuong = dl, MenuMon = mm, LoaiBan = lb }); return(res); }
public BOChiTietBanHang(Data.BOMenuKichThuocMon ktm, Transit transit) { mTransit = transit; this.ChiTietBanHang = new CHITIETBANHANG(); _ListKhuyenMai = new List<BOChiTietBanHang>(); this.MenuKichThuocMon = ktm.MenuKichThuocMon; this.ChiTietBanHang.SoLuongBan = ktm.MenuKichThuocMon.SoLuongBanBan; this.ChiTietBanHang.GiaBan = ktm.MenuKichThuocMon.GiaBanMacDinh; this.ChiTietBanHang.KichThuocLoaiBan = ktm.KichThuocLoaiBan; this.ChiTietBanHang.GiamGia = ktm.MenuMon.GiamGia; this.ChiTietBanHang.KichThuocMonID = ktm.MenuKichThuocMon.KichThuocMonID; this.MenuMon = ktm.MenuMon; SoLuongBanTam = (int)this.ChiTietBanHang.SoLuongBan; ChangeThanhTien(); }
public static CAIDATBAN GetQueryNoTracking(Transit transit) { CAIDATBAN item = FrameworkRepository <CAIDATBAN> .QueryNoTracking(transit.KaraokeEntities.CAIDATBANs).FirstOrDefault(); if (item == null) { item = new CAIDATBAN(); item.TableWidth = (decimal)0.0735294000; item.TableHeight = (decimal)0.0938086000; item.TableFontSize = 12; item.TableFontStyle = (int)SomeEnum.FontStyles.Normal; item.TableFontWeights = (int)SomeEnum.FontWeights.Normal; } return(item); }
public IQueryable <BOChiTietQuyen> GetAll(int MaQuyen, Transit mTransit) { var res = (from ctq in frmChiTietQuyen.Query() join q in frmQuyen.Query() on ctq.QuyenID equals q.MaQuyen join cn in frmChucNang.Query() on ctq.ChucNangID equals cn.ChucNangID where ctq.Deleted == false && ctq.QuyenID == MaQuyen select new BOChiTietQuyen { ChiTietQuyen = ctq, Quyen = q, ChucNang = cn }); return(res); }
public IQueryable <BOXuLyKhoChiTiet> GetAll(int NhapKhoID, Transit mTransit) { return(from ctnk in frmChiTietXuLyKho.Query() join tk in frmTonKho.Query() on ctnk.TonKhoID equals tk.TonKhoID join lb in frmLoaiBan.Query() on tk.LoaiBanID equals lb.LoaiBanID join mm in frmMenuMon.Query() on tk.MonID equals mm.MonID join nk in frmXyLyKho.Query() on ctnk.ChinhKhoID equals nk.ChinhKhoID select new BOXuLyKhoChiTiet { XuLyKhoChiTiet = ctnk, XuLyKho = nk, LoaiBan = lb, TonKho = tk, MenuMon = mm }); }
public IQueryable <BONhapKho> GetAll(Transit mTransit, DateTime dt) { return(from nk in mKaraokeEntities.NHAPKHOes join k in mKaraokeEntities.KHOes on nk.KhoID equals k.KhoID join nv in mKaraokeEntities.NHANVIENs on nk.NhanVienID equals nv.NhanVienID join ncc in mKaraokeEntities.NHACUNGCAPs on nk.NhaCungCapID equals ncc.NhaCungCapID where nk.ThoiGian.Value.Year == dt.Year && nk.ThoiGian.Value.Month == dt.Month && nk.ThoiGian.Value.Day == dt.Day select new BONhapKho { NhapKho = nk, Kho = k, NhanVien = nv, NhaCungCap = ncc } ); }
public IQueryable <BOXuLyKho> GetAll(Transit mTransit, DateTime dt) { return(from xlk in frmXuLyKho.Query() join k in frmKho.Query() on xlk.KhoID equals k.KhoID join nv in frmNhanVien.Query() on xlk.NhanVienID equals nv.NhanVienID join l in frmXuLyKhoLoai.Query() on xlk.LoaiID equals l.ID where xlk.ThoiGian.Value.Year == dt.Year && xlk.ThoiGian.Value.Month == dt.Month && xlk.ThoiGian.Value.Day == dt.Day select new BOXuLyKho { XuLyKho = xlk, Kho = k, NhanVien = nv, Loai = l } ); }
public IQueryable <BOChiTietNhapKho> GetAll(int NhapKhoID, Transit mTransit) { //return from ctnk in frmChiTietNhapKho.Query() // join tk in frmTonKho.Query() on ctnk.TonKhoID equals tk.TonKhoID // join lb in frmLoaiBan.Query() on tk.LoaiBanID equals lb.LoaiBanID // join mm in frmMenuMon.Query() on tk.MonID equals mm.MonID // join nk in frmNhapKho.Query() on ctnk.NhapKhoID equals nk.NhapKhoID // select new BOChiTietNhapKho // { // ChiTietNhapKho = ctnk, // NhapKho = nk, // LoaiBan = lb, // TonKho = tk, // MenuMon = mm // }; return(null); }
public void Luu(List <BOChiTietQuyen> lsArray, Transit mTransit) { if (lsArray != null) { foreach (BOChiTietQuyen item in lsArray) { if (item.ChiTietQuyen.ChiTietQuyenID > 0) { Sua(item, mTransit); } else { Them(item, mTransit); } } } frmChiTietQuyen.Commit(); }
public static CAIDATTHONGTINCONGTY GetQueryNoTracking(Transit transit) { CAIDATTHONGTINCONGTY item = FrameworkRepository <CAIDATTHONGTINCONGTY> .QueryNoTracking(transit.KaraokeEntities.CAIDATTHONGTINCONGTies).FirstOrDefault(); if (item == null) { item = new CAIDATTHONGTINCONGTY(); item.TenCongTy = ""; item.TenVietTat = ""; item.MaSoThue = ""; item.NguoiDaiDien = ""; item.DiaChi = ""; item.DienThoaiBan = ""; item.DienThoaiDiDong = ""; item.Email = ""; item.Fax = ""; } return(item); }
public void Luu(List <BOMenuGia> lsArray, Transit mTransit) { foreach (BOMenuGia item in lsArray) { if (item.MenuGia.Gia == 0 && item.MenuGia.GiaID > 0) { Xoa(item, mTransit); } else if (item.MenuGia.Gia != 0 && item.MenuGia.GiaID == 0) { Them(item, mTransit); } else if (item.MenuGia.Gia != 0 && item.MenuGia.GiaID > 0) { Sua(item, mTransit); } } frmMenuGia.Commit(); }
public static CAIDATTHUCDON GetQueryNoTracking(Transit transit) { CAIDATTHUCDON item = FrameworkRepository <CAIDATTHUCDON> .QueryNoTracking(transit.KaraokeEntities.CAIDATTHUCDONs).FirstOrDefault(); if (item == null) { item = new CAIDATTHUCDON(); item.NhomTextFontSize = 12; item.NhomTextFontStyle = (int)SomeEnum.FontStyles.Normal; item.NhomTextFontWeights = (int)SomeEnum.FontWeights.Normal; item.MonTextFontSize = 12; item.MonTextFontStyle = (int)SomeEnum.FontStyles.Normal; item.MonTextFontWeights = (int)SomeEnum.FontWeights.Normal; item.LoaiNhomTextFontSize = 12; item.LoaiNhomTextFontStyle = (int)SomeEnum.FontStyles.Normal; item.LoaiNhomTextFontWeights = (int)SomeEnum.FontWeights.Normal; } return(item); }
public int Them(BOMenuMon item, Transit mTransit) { frmMon.AddObject(item.MenuMon); SapXep((int)item.MenuMon.NhomID, mTransit); frmMon.Commit(); if (item.MenuKichThuocMon != null) { item.MenuKichThuocMon.MonID = item.MenuMon.MonID; frmKichThuocMon.AddObject(item.MenuKichThuocMon); frmKichThuocMon.Commit(); } if (item.MenuItemMayIn != null) { item.MenuItemMayIn.MonID = item.MenuMon.MonID; frmItemMayIn.AddObject(item.MenuItemMayIn); frmItemMayIn.Commit(); } UpdateSoLuongMon((int)item.MenuMon.NhomID, mTransit); return(item.MenuMon.MonID); }
public BOChiTietNhapKho(Transit transit) { }
public static List <MENULOAINHOM> GetAll(Transit mTransit) { return(mTransit.KaraokeEntities.MENULOAINHOMs.ToList()); }
public static IQueryable <MENULOAINHOM> GetAllNoTracking(Transit mTransit) { return(FrameworkRepository <MENULOAINHOM> .QueryNoTracking(mTransit.KaraokeEntities.MENULOAINHOMs).Where(s => s.Deleted == false)); }
private int Xoa(BOXuLyKho item, Transit mTransit) { item.XuLyKho.Deleted = true; frmXuLyKho.Update(item.XuLyKho); return(item.XuLyKho.ChinhKhoID); }
private int Them(BOXuLyKho item, Transit mTransit) { frmXuLyKho.AddObject(item.XuLyKho); return(item.XuLyKho.ChinhKhoID); }
private int Sua(BOXuLyKho item, Transit mTransit) { item.XuLyKho.Edit = false; frmXuLyKho.Update(item.XuLyKho); return(item.XuLyKho.ChinhKhoID); }