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 BOMenuMon(Data.Transit transit)
{
frmMon = new FrameworkRepository <MENUMON>(transit.KaraokeEntities, transit.KaraokeEntities.MENUMONs);
frmNhom = new FrameworkRepository <MENUNHOM>(transit.KaraokeEntities, transit.KaraokeEntities.MENUNHOMs);
frmKichThuocMon = new FrameworkRepository <MENUKICHTHUOCMON>(transit.KaraokeEntities, transit.KaraokeEntities.MENUKICHTHUOCMONs);
frmItemMayIn = new FrameworkRepository <MENUITEMMAYIN>(transit.KaraokeEntities, transit.KaraokeEntities.MENUITEMMAYINs);
}
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 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 BOXuLyKho(Data.Transit transit)
{
frmXuLyKho = new FrameworkRepository <XULYKHO>(transit.KaraokeEntities, transit.KaraokeEntities.XULYKHOes);
frmKho = new FrameworkRepository <KHO>(transit.KaraokeEntities, transit.KaraokeEntities.KHOes);
frmNhanVien = new FrameworkRepository <NHANVIEN>(transit.KaraokeEntities, transit.KaraokeEntities.NHANVIENs);
frmXuLyKhoLoai = new FrameworkRepository <XULYKHOLOAI>(transit.KaraokeEntities, transit.KaraokeEntities.XULYKHOLOAIs);
frmTonKho = new FrameworkRepository <TONKHO>(transit.KaraokeEntities, transit.KaraokeEntities.TONKHOes);
frmTonKhoTong = new FrameworkRepository <TONKHOTONG>(transit.KaraokeEntities, transit.KaraokeEntities.TONKHOTONGs);
}
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 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 CAIDATMAYINHOADON GetQueryNoTracking(KaraokeEntities kara)
{
CAIDATMAYINHOADON item = FrameworkRepository <CAIDATMAYINHOADON> .QueryNoTracking(kara.CAIDATMAYINHOADONs).FirstOrDefault();
if (item == null)
{
item = new CAIDATMAYINHOADON();
item.HeaderTextString1 = "";
item.HeaderTextString2 = "";
item.HeaderTextString3 = "";
item.HeaderTextString4 = "";
item.HeaderTextFontSize1 = 12;
item.HeaderTextFontSize2 = 12;
item.HeaderTextFontSize3 = 12;
item.HeaderTextFontSize4 = 12;
item.HeaderTextFontStyle1 = (int)System.Drawing.FontStyle.Regular;
item.HeaderTextFontStyle2 = (int)System.Drawing.FontStyle.Regular;
item.HeaderTextFontStyle3 = (int)System.Drawing.FontStyle.Regular;
item.HeaderTextFontStyle4 = (int)System.Drawing.FontStyle.Regular;
item.HeaderTextFontWeights1 = (int)SomeEnum.FontWeights.Normal;
item.HeaderTextFontWeights2 = (int)SomeEnum.FontWeights.Normal;
item.HeaderTextFontWeights3 = (int)SomeEnum.FontWeights.Normal;
item.HeaderTextFontWeights4 = (int)SomeEnum.FontWeights.Normal;
item.FooterTextString1 = "";
item.FooterTextString2 = "";
item.FooterTextString3 = "";
item.FooterTextString4 = "";
item.FooterTextFontSize1 = 12;
item.FooterTextFontSize2 = 12;
item.FooterTextFontSize3 = 12;
item.FooterTextFontSize4 = 12;
item.FooterTextFontStyle1 = (int)System.Drawing.FontStyle.Regular;
item.FooterTextFontStyle2 = (int)System.Drawing.FontStyle.Regular;
item.FooterTextFontStyle3 = (int)System.Drawing.FontStyle.Regular;
item.FooterTextFontStyle4 = (int)System.Drawing.FontStyle.Regular;
item.FooterTextFontWeights1 = (int)SomeEnum.FontWeights.Normal;
item.FooterTextFontWeights2 = (int)SomeEnum.FontWeights.Normal;
item.FooterTextFontWeights3 = (int)SomeEnum.FontWeights.Normal;
item.FooterTextFontWeights4 = (int)SomeEnum.FontWeights.Normal;
item.SumanyFontSize = 12;
item.SumanyFontStyle = (int)System.Drawing.FontStyle.Regular;
item.SumanyFontWeights = (int)SomeEnum.FontWeights.Normal;
item.SumanyFontSizeBig = 12;
item.SumanyFontStyleBig = (int)System.Drawing.FontStyle.Regular;
item.SumanyFontWeightsBig = (int)SomeEnum.FontWeights.Normal;
item.TitleTextFontSize = 12;
item.TitleTextFontStyle = (int)System.Drawing.FontStyle.Regular;
item.TitleTextFontWeights = (int)SomeEnum.FontWeights.Normal;
}
return(item);
}
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 static IQueryable <BOBanHang> GetAllCompleted(KaraokeEntities kara, DateTime date)
{
return(from a in FrameworkRepository <BANHANG> .QueryNoTracking(kara.BANHANGs).Where(
b =>
b.TrangThaiID == 4 &&
b.NgayBan.Value.Day == date.Day &&
b.NgayBan.Value.Month == date.Month &&
b.NgayBan.Value.Year == date.Year
)
join b in kara.BANs on a.BanID equals b.BanID
select new BOBanHang
{
BAN = b,
BANHANG = a
});
}
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 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 static BOThongTinCongTy GetQueryNoTracking(KaraokeEntities kara)
{
BOThongTinCongTy item = (from x in FrameworkRepository <CAIDATTHONGTINCONGTY> .QueryNoTracking(kara.CAIDATTHONGTINCONGTies)
select new BOThongTinCongTy
{
TenCongTy = x.TenCongTy,
DiaChi = x.DiaChi,
DienThoai = x.DienThoaiBan,
Hinh = x.Logo
}).FirstOrDefault();
if (item == null)
{
item = new BOThongTinCongTy();
item.TenCongTy = "";
item.DienThoai = "";
item.DiaChi = "";
}
return(item);
}
private Data.TONKHOTONG KiemTraTonKhoTong(FrameworkRepository <TONKHOTONG> frm, int KhoID, int MonID, int DonViID)
{
Data.TONKHOTONG item = null;
if (frm.Query().Where(s => s.KhoID == KhoID && s.MonID == MonID && s.DonViID == DonViID).Count() == 0)
{
item = new TONKHOTONG();
item.DonViID = DonViID;
item.KhoID = KhoID;
item.MonID = MonID;
item.TenMonBaoCao = "";
item.SoLuongBan = 0;
item.SoLuongDieuChinh = 0;
item.SoLuongHu = 0;
item.SoLuongNhap = 0;
item.SoLuongTon = 0;
item.SoLuongMat = 0;
item.SoLuongChuyen = 0;
return(item);
}
return(frm.Query().Where(s => s.KhoID == KhoID && s.MonID == MonID && s.DonViID == DonViID).FirstOrDefault());
}
public static CAIDATMAYINBEP GetQueryNoTracking(KaraokeEntities kara)
{
CAIDATMAYINBEP item = FrameworkRepository <CAIDATMAYINBEP> .QueryNoTracking(kara.CAIDATMAYINBEPs).FirstOrDefault();
if (item == null)
{
item = new CAIDATMAYINBEP();
item.TitleTextFontSize = 12;
item.TitleTextFontStyle = (int)System.Drawing.FontStyle.Regular;
item.TitleTextFontWeights = (int)SomeEnum.FontWeights.Normal;
item.InfoTextFontSize = 12;
item.InfoTextFontStyle = (int)System.Drawing.FontStyle.Regular;
item.InfoTextFontWeights = (int)SomeEnum.FontWeights.Normal;
item.ItemTextFontSize = 12;
item.ItemTextFontStyle = (int)System.Drawing.FontStyle.Regular;
item.ItemTextFontWeights = (int)SomeEnum.FontWeights.Normal;
item.SumTextFontSize = 12;
item.SumTextFontStyle = (int)System.Drawing.FontStyle.Regular;
item.SumTextFontWeights = (int)SomeEnum.FontWeights.Normal;
}
return(item);
}
public BODinhLuong(Data.Transit transit)
{
frmDinhLuong = new FrameworkRepository <DINHLUONG>(transit.KaraokeEntities, transit.KaraokeEntities.DINHLUONGs);
frmMenuMon = new FrameworkRepository <MENUMON>(transit.KaraokeEntities, transit.KaraokeEntities.MENUMONs);
frmLoaiBan = new FrameworkRepository <LOAIBAN>(transit.KaraokeEntities, transit.KaraokeEntities.LOAIBANs);
}
public static IQueryable <KHO> GetAllNoTracking(Transit mTransit)
{
return(FrameworkRepository <KHO> .QueryNoTracking(mTransit.KaraokeEntities.KHOes).Where(s => s.Deleted == false));
}
public static IQueryable <GIAODIENCHUCNANGBANHANG> GetNoTracking(Transit transit)
{
return(FrameworkRepository <GIAODIENCHUCNANGBANHANG> .QueryNoTracking(transit.KaraokeEntities.GIAODIENCHUCNANGBANHANGs));
}
public BOBan(Transit transit)
{
mTransit = transit;
frBan = new FrameworkRepository <BAN>(mTransit.KaraokeEntities, mTransit.KaraokeEntities.BANs);
_CAIDATBAN = BOCaiDatBan.GetQueryNoTracking(mTransit);
}
public static IQueryable <MENULOAINHOM> GetAllNoTracking(Transit mTransit)
{
return(FrameworkRepository <MENULOAINHOM> .QueryNoTracking(mTransit.KaraokeEntities.MENULOAINHOMs).Where(s => s.Deleted == false));
}
public static IQueryable <BAOCAOLICHDANGNHAP> GetNoTracking(Transit transit)
{
return(FrameworkRepository <BAOCAOLICHDANGNHAP> .QueryNoTracking(transit.KaraokeEntities.BAOCAOLICHDANGNHAPs));
}
public static IQueryable <MENULOAIGIA> GetAll(Transit transit)
{
return(FrameworkRepository <MENULOAIGIA> .QueryNoTracking(transit.KaraokeEntities.MENULOAIGIAs).Where(o => o.Deleted == false));
}
public BOMenuKichThuocMon(Data.Transit transit)
{
frmKichThuocMon = new FrameworkRepository <MENUKICHTHUOCMON>(transit.KaraokeEntities, transit.KaraokeEntities.MENUKICHTHUOCMONs);
frmmenuMon = new FrameworkRepository <MENUMON>(transit.KaraokeEntities, transit.KaraokeEntities.MENUMONs);
frmLoaiBan = new FrameworkRepository <LOAIBAN>(transit.KaraokeEntities, transit.KaraokeEntities.LOAIBANs);
}
public static IQueryable <XULYKHOLOAI> GetQueryNoTracking(Data.Transit mTransit)
{
return(FrameworkRepository <XULYKHOLOAI> .QueryNoTracking(mTransit.KaraokeEntities.XULYKHOLOAIs));
}
public BOTonKhoTong(Data.Transit mTransit)
{
frmTonKhoTong = new FrameworkRepository <TONKHOTONG>(mTransit.KaraokeEntities, mTransit.KaraokeEntities.TONKHOTONGs);
frmMon = new FrameworkRepository <MENUMON>(mTransit.KaraokeEntities, mTransit.KaraokeEntities.MENUMONs);
}
public static IQueryable <BAN> GetVisual(Transit transit)
{
return(FrameworkRepository <BAN> .QueryNoTracking(transit.KaraokeEntities.BANs).Where(b => b.Visual == true && b.Deleted == false));
}
public BOMenuItemMayIn(Data.Transit transit)
{
frmMenuItemMayIn = new FrameworkRepository <MENUITEMMAYIN>(transit.KaraokeEntities, transit.KaraokeEntities.MENUITEMMAYINs);
frmMayIn = new FrameworkRepository <MAYIN>(transit.KaraokeEntities, transit.KaraokeEntities.MAYINs);
frmMenuMon = new FrameworkRepository <MENUMON>(transit.KaraokeEntities, transit.KaraokeEntities.MENUMONs);
}
public static List <KHU> GetAllNoTrackingToList(Transit transit)
{
return(FrameworkRepository <KHU> .QueryNoTracking(transit.KaraokeEntities.KHUs).Where(k => k.Deleted == false).ToList());
}
public static IQueryable <MAYIN> GetAllNoTracking(Transit mTransit, bool IsMayInHoaDon)
{
return(FrameworkRepository <MAYIN> .QueryNoTracking(mTransit.KaraokeEntities.MAYINs).Where(s => s.Deleted == false && s.MayInHoaDon == IsMayInHoaDon));
}
public BOQuyenNhanVien(Data.Transit transit)
{
frmNhanVien = new FrameworkRepository <NHANVIEN>(transit.KaraokeEntities, transit.KaraokeEntities.NHANVIENs);
frmQuyen = new FrameworkRepository <QUYEN>(transit.KaraokeEntities, transit.KaraokeEntities.QUYENs);
frmQuyenNhanVien = new FrameworkRepository <QUYENNHANVIEN>(transit.KaraokeEntities, transit.KaraokeEntities.QUYENNHANVIENs);
}
