public static string UpdateData(Data.KaraokeEntities kara, IQueryable <TEntity> query, System.Data.Objects.ObjectSet <TEntity> obj, TEntity data)
{
string resuilt = "";
try
{
TEntity entity = query.FirstOrDefault();
if (entity == null)
{
entity = data;
obj.AddObject(entity);
}
else
{
ObjectConvert <TEntity> .Coppy(data, entity);
//kara.ObjectStateManager.ChangeObjectState(entity, System.Data.EntityState.Modified);
}
kara.SaveChanges();
}
catch (Exception ex)
{
resuilt = "Lỗi..." + ex.Message;
}
return(resuilt);
}
private void btnLuu_Click(object sender, RoutedEventArgs e)
{
foreach (var nhom in mQueryMenuNhom)
{
if (nhom.EntityState == System.Data.EntityState.Modified)
{
var queryMon = Data.BOMenuMon.GetAll(mKaraokeEntities, nhom);
foreach (var item in queryMon)
{
item.GiamGia = nhom.GiamGia;
}
}
}
mKaraokeEntities.SaveChanges();
}
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);
}