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 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 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 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);
}
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 static List <KHU> GetAllNoTrackingToList(Transit transit)
{
return(FrameworkRepository <KHU> .QueryNoTracking(transit.KaraokeEntities.KHUs).Where(k => k.Deleted == false).ToList());
}
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 static IQueryable <BAOCAOLICHDANGNHAP> GetNoTracking(Transit transit)
{
return(FrameworkRepository <BAOCAOLICHDANGNHAP> .QueryNoTracking(transit.KaraokeEntities.BAOCAOLICHDANGNHAPs));
}
public static IQueryable <LOAIBAN> GetAllNoTracking(Transit mTransit, int DonViID)
{
return(FrameworkRepository <LOAIBAN> .QueryNoTracking(mTransit.KaraokeEntities.LOAIBANs).Where(s => s.DonViID == DonViID));
}
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 static IQueryable <BAN> GetVisual(Transit transit)
{
return(FrameworkRepository <BAN> .QueryNoTracking(transit.KaraokeEntities.BANs).Where(b => b.Visual == true && b.Deleted == false));
}
public static IQueryable <XULYKHOLOAI> GetQueryNoTracking(Data.Transit mTransit)
{
return(FrameworkRepository <XULYKHOLOAI> .QueryNoTracking(mTransit.KaraokeEntities.XULYKHOLOAIs));
}
public static IQueryable <LOAIBAN> GetAllNoTracking(Transit mTransit)
{
return(FrameworkRepository <LOAIBAN> .QueryNoTracking(mTransit.KaraokeEntities.LOAIBANs));
}
public static IQueryable <MENULOAINHOM> GetAllNoTracking(Transit mTransit)
{
return(FrameworkRepository <MENULOAINHOM> .QueryNoTracking(mTransit.KaraokeEntities.MENULOAINHOMs).Where(s => s.Deleted == false));
}
public static IQueryable <KHU> GetAllVisual(Transit transit)
{
var query = FrameworkRepository <KHU> .QueryNoTracking(transit.KaraokeEntities.KHUs).Where(o => o.Deleted == false && o.Visual == true);
return(query);
}
public static IQueryable <NHOMCHUCNANG> GetAllNoTracking(Transit mTransit)
{
return(FrameworkRepository <NHOMCHUCNANG> .QueryNoTracking(mTransit.KaraokeEntities.NHOMCHUCNANGs).Where(s => s.Deleted == false));
}
public static IQueryable <MENUMON> GetAll(Transit tran)
{
return(FrameworkRepository <MENUMON> .QueryNoTracking(tran.KaraokeEntities.MENUMONs));
}
public static IQueryable <MENULOAIGIA> GetAll(Transit transit)
{
return(FrameworkRepository <MENULOAIGIA> .QueryNoTracking(transit.KaraokeEntities.MENULOAIGIAs).Where(o => o.Deleted == false));
}
public static IQueryable <LICHBIEUDINHKY> GetAll(Transit transit)
{
return(FrameworkRepository <LICHBIEUDINHKY> .QueryNoTracking(transit.KaraokeEntities.LICHBIEUDINHKies).Where(o => o.Deleted == false));
}
