public void Export(string url)
{
try
{
System.Data.DataSet ds = new System.Data.DataSet();
_OnImportExport(String.Format("Đọc {0}...", LOAINHOM), false);
ds.Tables.Add(ObjectConvert <Data.MENULOAINHOM> .GetTableData(mKaraokeEntities.MENULOAINHOMs.ToList(), LOAINHOM));
_OnImportExport(String.Format("Đọc {0}...", MAYIN), false);
ds.Tables.Add(ObjectConvert <Data.MAYIN> .GetTableData(mKaraokeEntities.MAYINs.Where(o => o.Deleted == false).ToList(), MAYIN));
_OnImportExport(String.Format("Đọc {0}...", LOAIGIA), false);
ds.Tables.Add(ObjectConvert <Data.MENULOAIGIA> .GetTableData(mKaraokeEntities.MENULOAIGIAs.Where(o => o.Deleted == false).ToList(), LOAIGIA));
_OnImportExport(String.Format("Đọc {0}...", DONVI), false);
ds.Tables.Add(ObjectConvert <Data.DONVI> .GetTableData(mKaraokeEntities.DONVIs.Where(o => o.Deleted == false).ToList(), DONVI));
_OnImportExport(String.Format("Đọc {0}...", LOAIDONVIBAN), false);
ds.Tables.Add(ObjectConvert <Data.LOAIBAN> .GetTableData(mKaraokeEntities.LOAIBANs.Where(o => o.Deleted == false).ToList(), LOAIDONVIBAN));
_OnImportExport(String.Format("Đọc {0}...", NHOM), false);
ds.Tables.Add(ObjectConvert <Data.MENUNHOM> .GetTableData(mKaraokeEntities.MENUNHOMs.Where(o => o.Deleted == false).ToList(), NHOM));
_OnImportExport(String.Format("Đọc {0}...", MON), false);
ds.Tables.Add(ObjectConvert <Data.MENUMON> .GetTableData(mKaraokeEntities.MENUMONs.Where(o => o.Deleted == false).ToList(), MON));
_OnImportExport(String.Format("Đọc {0}...", CHITIETMON), false);
ds.Tables.Add(ObjectConvert <Data.MENUKICHTHUOCMON> .GetTableData(mKaraokeEntities.MENUKICHTHUOCMONs.Where(o => o.Deleted == false).ToList(), CHITIETMON));
_OnImportExport(String.Format("Đọc {0}...", CHITIETGIA), false);
ds.Tables.Add(ObjectConvert <Data.MENUGIA> .GetTableData(mKaraokeEntities.MENUGIAs.ToList(), CHITIETGIA));
_OnImportExport(String.Format("Đọc {0}...", MONMAYIN), false);
ds.Tables.Add(ObjectConvert <Data.MENUITEMMAYIN> .GetTableData(mKaraokeEntities.MENUITEMMAYINs.Where(o => o.Deleted == false).ToList(), MONMAYIN));
_OnImportExport("Lưu tập tin..." + url, false);
CreateExcelFile.CreateExcelDocument(ds, url);
_OnImportExport("Xuất dữ liệu thành công...", false);
}
catch (Exception ex)
{
_OnImportExport("Lỗi..." + ex.Message, true);
}
}
public void Import(string url)
{
try
{
_OnImportExport("----------------------------", false);
_OnImportExport(String.Format("Đọc {0}...", LOAINHOM), false);
var listLoaiNhom = ExcelReader.GetDataToList(url, LOAINHOM, ObjectConvert <Data.MENULOAINHOM> .GetProductData);
foreach (var item in listLoaiNhom)
{
_OnImportExport(String.Format("Cập nhật...{0} - {1}", item.LoaiNhomID, item.TenLoaiNhom), false);
var query = from x in mKaraokeEntities.MENULOAINHOMs
where x.LoaiNhomID == item.LoaiNhomID
select x;
string resuilt = ObjectConvert <Data.MENULOAINHOM> .UpdateData(mKaraokeEntities, query, mKaraokeEntities.MENULOAINHOMs, item);
if (resuilt != "")
{
_OnImportExport(resuilt, true);
}
}
_OnImportExport("----------------------------", false);
_OnImportExport(String.Format("Đọc {0}...", MAYIN), false);
var listMayIn = ExcelReader.GetDataToList(url, MAYIN, ObjectConvert <Data.MAYIN> .GetProductData);
foreach (var item in listMayIn)
{
_OnImportExport(String.Format("Cập nhật...{0} - {1}", item.MayInID, item.TenMayIn), false);
var query = from x in mKaraokeEntities.MAYINs
where x.MayInID == item.MayInID
select x;
string resuilt = ObjectConvert <Data.MAYIN> .UpdateData(mKaraokeEntities, query, mKaraokeEntities.MAYINs, item);
if (resuilt != "")
{
_OnImportExport(resuilt, true);
}
}
_OnImportExport("----------------------------", false);
_OnImportExport("Đọc loại giá...", false);
var listLoaiGia = ExcelReader.GetDataToList(url, LOAIGIA, ObjectConvert <Data.MENULOAIGIA> .GetProductData);
foreach (var item in listLoaiGia)
{
_OnImportExport(String.Format("Cập nhật...{0} - {1}", item.LoaiGiaID, item.Ten), false);
var query = from x in mKaraokeEntities.MENULOAIGIAs
where x.LoaiGiaID == item.LoaiGiaID
select x;
string resuilt = ObjectConvert <Data.MENULOAIGIA> .UpdateData(mKaraokeEntities, query, mKaraokeEntities.MENULOAIGIAs, item);
if (resuilt != "")
{
_OnImportExport(resuilt, true);
}
}
_OnImportExport("----------------------------", false);
_OnImportExport("Đọc đơn vị...", false);
var listDonVi = ExcelReader.GetDataToList(url, DONVI, ObjectConvert <Data.DONVI> .GetProductData);
foreach (var item in listDonVi)
{
_OnImportExport(String.Format("Cập nhật...{0} - {1}", item.DonViID, item.TenDonVi), false);
var query = from x in mKaraokeEntities.DONVIs
where x.DonViID == item.DonViID
select x;
string resuilt = ObjectConvert <Data.DONVI> .UpdateData(mKaraokeEntities, query, mKaraokeEntities.DONVIs, item);
if (resuilt != "")
{
_OnImportExport(resuilt, true);
}
}
_OnImportExport("----------------------------", false);
_OnImportExport("Đọc loại đơn vị...", false);
var listLoaiDonVi = ExcelReader.GetDataToList(url, LOAIDONVIBAN, ObjectConvert <Data.LOAIBAN> .GetProductData);
foreach (var item in listLoaiDonVi)
{
_OnImportExport(String.Format("Cập nhật...{0} - {1}", item.LoaiBanID, item.TenLoaiBan), false);
var query = from x in mKaraokeEntities.LOAIBANs
where x.LoaiBanID == item.LoaiBanID
select x;
string resuilt = ObjectConvert <Data.LOAIBAN> .UpdateData(mKaraokeEntities, query, mKaraokeEntities.LOAIBANs, item);
if (resuilt != "")
{
_OnImportExport(resuilt, true);
}
}
_OnImportExport("----------------------------", false);
_OnImportExport("Đọc nhóm...", false);
var listNhom = ExcelReader.GetDataToList(url, NHOM, ObjectConvert <Data.MENUNHOM> .GetProductData);
foreach (var item in listNhom)
{
_OnImportExport(String.Format("Cập nhật...{0} - {1}", item.NhomID, item.TenNgan), false);
var query = from x in mKaraokeEntities.MENUNHOMs
where x.NhomID == item.NhomID
select x;
string resuilt = ObjectConvert <Data.MENUNHOM> .UpdateData(mKaraokeEntities, query, mKaraokeEntities.MENUNHOMs, item);
if (resuilt != "")
{
_OnImportExport(resuilt, true);
}
}
_OnImportExport("----------------------------", false);
_OnImportExport("Đọc món...", false);
var listMon = ExcelReader.GetDataToList(url, MON, ObjectConvert <Data.MENUMON> .GetProductData);
foreach (var item in listMon)
{
_OnImportExport(String.Format("Cập nhật...{0} - {1}", item.MonID, item.TenNgan), false);
var query = from x in mKaraokeEntities.MENUMONs
where x.MonID == item.MonID
select x;
string resuilt = ObjectConvert <Data.MENUMON> .UpdateData(mKaraokeEntities, query, mKaraokeEntities.MENUMONs, item);
if (resuilt != "")
{
_OnImportExport(resuilt, true);
}
}
_OnImportExport("----------------------------", false);
_OnImportExport("Đọc chi tiết món...", false);
var listChiTietMon = ExcelReader.GetDataToList(url, CHITIETMON, ObjectConvert <Data.MENUKICHTHUOCMON> .GetProductData);
foreach (var item in listChiTietMon)
{
_OnImportExport(String.Format("Cập nhật...{0} - {1}", item.KichThuocMonID, item.TenLoaiBan), false);
var query = from x in mKaraokeEntities.MENUKICHTHUOCMONs
where x.KichThuocMonID == item.KichThuocMonID
select x;
string resuilt = ObjectConvert <Data.MENUKICHTHUOCMON> .UpdateData(mKaraokeEntities, query, mKaraokeEntities.MENUKICHTHUOCMONs, item);
if (resuilt != "")
{
_OnImportExport(resuilt, true);
}
}
_OnImportExport("----------------------------", false);
_OnImportExport("Đọc chi tiết giá...", false);
var listChiTietGia = ExcelReader.GetDataToList(url, CHITIETGIA, ObjectConvert <Data.MENUGIA> .GetProductData);
foreach (var item in listChiTietGia)
{
_OnImportExport(String.Format("Cập nhật...{0} - {1}", item.GiaID, item.Gia), false);
var query = from x in mKaraokeEntities.MENUGIAs
where x.GiaID == item.GiaID
select x;
string resuilt = ObjectConvert <Data.MENUGIA> .UpdateData(mKaraokeEntities, query, mKaraokeEntities.MENUGIAs, item);
if (resuilt != "")
{
_OnImportExport(resuilt, true);
}
}
_OnImportExport("----------------------------", false);
_OnImportExport("Đọc món máy in...", false);
var listMonMayIn = ExcelReader.GetDataToList(url, MONMAYIN, ObjectConvert <Data.MENUITEMMAYIN> .GetProductData);
foreach (var item in listMonMayIn)
{
_OnImportExport(String.Format("Cập nhật...{0} - {1}", item.MayInID, item.MonID), false);
var query = from x in mKaraokeEntities.MENUITEMMAYINs
where x.MayInID == item.MayInID && x.MonID == item.MonID
select x;
string resuilt = ObjectConvert <Data.MENUITEMMAYIN> .UpdateData(mKaraokeEntities, query, mKaraokeEntities.MENUITEMMAYINs, item);
if (resuilt != "")
{
_OnImportExport(resuilt, true);
}
}
mKaraokeEntities.ExecuteStoreCommand("SP_CREATEDEFAULT_KICHTHUOCMON");
_OnImportExport("Nhập dữ liệu thành công...", false);
//============================
}
catch (Exception ex)
{
_OnImportExport("Lỗi..." + ex.Message, true);
}
}
