private void ThemDanhSachBan()
{
IQueryable <Data.LOAIBAN> lsLoaiBan = Data.BOLoaiBan.GetAllNoTracking(mTransit, (int)_Mon.MenuMon.DonViID);
if (lsLoaiBan.Count() > 0)
{
_Mon.MenuMon.SapXepKichThuocMon = 2;
_Mon.MenuMon.SLMonChoPhepTonKho = 1;
_Mon.MenuMon.SLMonKhongChoPhepTonKho = 0;
Data.LOAIBAN item = lsLoaiBan.OrderByDescending(s => s.KichThuocBan).FirstOrDefault();
_Mon.MenuKichThuocMon = new Data.MENUKICHTHUOCMON()
{
TenLoaiBan = "", LoaiBanID = item.LoaiBanID, DonViID = item.DonViID, GiaBanMacDinh = _Mon.MenuMon.Gia, ChoPhepTonKho = true, ThoiGia = false, KichThuocLoaiBan = item.KichThuocBan, SoLuongBanBan = 1, SapXep = 1, Visual = true, Edit = false, Deleted = false
};
}
}
private void GetValues()
{
if (_Item == null)
{
_Item = new Data.BOMenuKichThuocMon();
}
_Item.MenuKichThuocMon.MonID = mMon.MenuMon.MonID;
_Item.MenuKichThuocMon.LoaiBanID = (int)cbbLoaiBan.SelectedValue;
Data.LOAIBAN loaiBan = (Data.LOAIBAN)cbbLoaiBan.SelectedItem;
_Item.LoaiBan = loaiBan;
_Item.MenuKichThuocMon.DonViID = _Item.LoaiBan.DonViID;
_Item.MenuKichThuocMon.TenLoaiBan = txtTenLoaiBan.Text;
_Item.MenuKichThuocMon.KichThuocLoaiBan = System.Convert.ToInt32(txtKichThuocLoaiBan.Text);
_Item.MenuKichThuocMon.KichThuocLoaiBan = (int)_Item.MenuKichThuocMon.KichThuocLoaiBan * (int)loaiBan.KichThuocBan;
_Item.MenuKichThuocMon.GiaBanMacDinh = Utilities.MoneyFormat.ConvertToDecimal(txtGiaMacDinh.Text);
_Item.MenuKichThuocMon.SoLuongBanBan = System.Convert.ToInt32(txtSoLuongBan.Text);
_Item.MenuKichThuocMon.Visual = (bool)ckBan.IsChecked;
_Item.MenuKichThuocMon.ChoPhepTonKho = (bool)ckChoPhepTonKho.IsChecked;
_Item.MenuKichThuocMon.ThoiGia = false;
_Item.MenuKichThuocMon.Deleted = false;
}
private void cbbLoaiBan_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (cbbLoaiBan.SelectedValue != null)
{
Data.LOAIBAN lb = (Data.LOAIBAN)cbbLoaiBan.SelectedItem;
switch (lb.LoaiBanID)
{
case (int)Data.EnumLoaiBan.Cai:
case (int)Data.EnumLoaiBan.DinhLuong:
txtKichThuocLoaiBan.Text = "1";
break;
case (int)Data.EnumLoaiBan.Gram:
case (int)Data.EnumLoaiBan.Millilit:
case (int)Data.EnumLoaiBan.Kg:
case (int)Data.EnumLoaiBan.Lit:
case (int)Data.EnumLoaiBan.Gio:
case (int)Data.EnumLoaiBan.Phut:
case (int)Data.EnumLoaiBan.Giay:
if (_Item == null)
{
txtKichThuocLoaiBan.Text = "1";
}
//else if (_Item.MenuKichThuocMon.LoaiBanID == lb.LoaiBanID)
// //txtKichThuocLoaiBan.Text = ((int)(_Item.MenuKichThuocMon.KichThuocLoaiBan / lb.KichThuocBan)).ToString();
// txtSoLuongBan.Text = txtKichThuocLoaiBan.Text = lb.KichThuocBan.ToString();
else
{
txtKichThuocLoaiBan.Text = lb.KichThuocBan.ToString();
}
break;
default:
break;
}
}
}
public void ImportItem(string url)
{
_OnImportExport("----------------------------", false);
_OnImportExport(String.Format("Đọc tập tin excel..."), false);
var listItem = ExcelReader.GetDataToList(url, MON, ImportExportItem.GetProductData);
List <Data.MENUNHOM> listNhom = new List <Data.MENUNHOM>();
//List<Data.MENUMON> listMon = new List<Data.MENUMON>();
_OnImportExport(String.Format("Xóa dữ liệu cũ..."), false);
mKaraokeEntities.ExecuteStoreCommand("SP_DELETE_ALL_MENU");
_OnImportExport(String.Format("Tạo {0}...", MAYIN), false);
Data.MAYIN mayin = new Data.MAYIN();
mayin.TenMayIn = "Test";
mayin.TieuDeIn = "BẾP";
mayin.SoLanIn = 1;
mayin.Visual = true;
mKaraokeEntities.MAYINs.AddObject(mayin);
_OnImportExport(String.Format("Tạo {0}...", MAYIN), false);
Data.MAYIN mayinBill = new Data.MAYIN();
mayinBill.TenMayIn = "Test";
mayinBill.TieuDeIn = "HÓA ĐƠN";
mayinBill.SoLanIn = 1;
mayinBill.MayInHoaDon = true;
mayinBill.Visual = true;
mKaraokeEntities.MAYINs.AddObject(mayinBill);
_OnImportExport(String.Format("Tạo {0}...", DONVI), false);
Data.DONVI donvi = mKaraokeEntities.DONVIs.Where(o => o.DonViID == 1).FirstOrDefault();
if (donvi == null)
{
donvi = new Data.DONVI();
donvi.TenDonVi = "Số lượng";
donvi.Visual = true;
mKaraokeEntities.DONVIs.AddObject(donvi);
}
_OnImportExport(String.Format("Tạo {0}...", LOAIDONVIBAN), false);
Data.LOAIBAN loaiban = mKaraokeEntities.LOAIBANs.Where(o => o.LoaiBanID == 1).FirstOrDefault();
if (loaiban == null)
{
loaiban.TenLoaiBan = "Cái";
loaiban.KichThuocBan = 1;
loaiban.Visual = true;
mKaraokeEntities.LOAIBANs.AddObject(loaiban);
donvi.LOAIBANs.Add(loaiban);
}
foreach (var item in listItem)
{
var nhom = (from a in listNhom
where a.TenNgan == item.TenNhom
select a).FirstOrDefault();
if (nhom == null)
{
_OnImportExport(String.Format("Tạo {0}---{1}", NHOM, item.TenNhom), false);
nhom = new Data.MENUNHOM();
nhom.TenDai = nhom.TenNgan = item.TenNhom;
nhom.Visual = true;
mKaraokeEntities.MENUNHOMs.AddObject(nhom);
listNhom.Add(nhom);
}
var mon = (from a in nhom.MENUMONs
where a.TenNgan == item.TenMon
select a).FirstOrDefault();
if (mon == null)
{
_OnImportExport(String.Format("Tạo {0}---{1}", MON, item.TenMon), false);
mon = new Data.MENUMON();
mon.TenNgan = mon.TenDai = item.TenMon;
mon.Gia = item.DonGia;
mon.Visual = true;
nhom.MENUMONs.Add(mon);
donvi.MENUMONs.Add(mon);
nhom.SLMonChoPhepTonKho++;
Data.MENUITEMMAYIN monmayin = new Data.MENUITEMMAYIN();
mon.MENUITEMMAYINs.Add(monmayin);
mayin.MENUITEMMAYINs.Add(monmayin);
mKaraokeEntities.MENUMONs.AddObject(mon);
//listMon.Add(mon);
}
_OnImportExport(String.Format("Tạo {0}---{1}", CHITIETMON, item.ChiTietMon), false);
Data.MENUKICHTHUOCMON ktm = new Data.MENUKICHTHUOCMON();
ktm.TenLoaiBan = item.ChiTietMon;
ktm.GiaBanMacDinh = item.DonGia;
ktm.SoLuongBanBan = item.SoLuongBanMacDinh;
ktm.KichThuocLoaiBan = 1;
ktm.Visual = true;
ktm.ChoPhepTonKho = true;
mon.SLMonChoPhepTonKho++;
mon.MENUKICHTHUOCMONs.Add(ktm);
loaiban.MENUKICHTHUOCMONs.Add(ktm);
donvi.MENUKICHTHUOCMONs.Add(ktm);
mKaraokeEntities.MENUKICHTHUOCMONs.AddObject(ktm);
}
_OnImportExport(String.Format("Lưu dữ liệu..."), false);
mKaraokeEntities.SaveChanges();
_OnImportExport(String.Format("Lưu dữ liệu thành công ...{0}", url), false);
}
