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);
}