// HANDLING EXCEPTION
private void HandlingException(Exception ex)
{
try
{
using (EurofarStockEntities context = new EurofarStockEntities(Library.Helper.CreateEntityConnectionString("EurofarStockModel")))
{
SystemLogging logItem = new SystemLogging();
logItem.LogDate = System.DateTime.Now;
logItem.RequestUD = requestUD;
logItem.ProcessDescription = GetDescription();
logItem.DetailMessage = Library.Helper.GetInnerException(ex).Message;
context.SystemLogging.Add(logItem);
context.SaveChanges();
}
}
catch { }
}
// TILSOFT
private bool getTilsoftData(out List<DTO.ProductDTO> data)
{
data = new List<DTO.ProductDTO>();
try
{
//List<DTO.WEX.Article> jsonAllData;
//List<DTO.WEX.Article> jsonData;
//if (!getWEXData(out jsonAllData))
//{
// return false;
//}
//if (getWEXFreeToSaleData(out jsonData))
//{
// return false;
//}
using (EurofarStockEntities context = new EurofarStockEntities(Library.Helper.CreateEntityConnectionString("EurofarStockModel")))
{
using (DbContextTransaction scope = context.Database.BeginTransaction())
{
//context.Database.ExecuteSqlCommand("SELECT * FROM WexItem WITH (TABLOCKX, HOLDLOCK)");
//if (jsonAllData.Count() > 0)
//{
// context.Database.ExecuteSqlCommand("DELETE FROM WexItem");
// context.Database.ExecuteSqlCommand("DBCC CHECKIDENT('WexItem', RESEED, 1)");
//}
//try
//{
// // delete wex item which is not in jsonAll
// List<string> articleCodes = jsonAllData.Select(o => o.out_item_no).ToList();
// context.WexItem.Where(o => !articleCodes.Contains(o.ArticleCode)).ToList().ForEach(o => context.WexItem.Remove(o));
// foreach (DTO.WEX.Article wexItem in jsonAllData)
// {
// WexItem dbItem = context.WexItem.FirstOrDefault(o => o.ArticleCode == wexItem.out_item_no);
// if (dbItem == null)
// {
// dbItem = new WexItem();
// dbItem.ArticleCode = wexItem.out_item_no;
// dbItem.SubEANCode = wexItem.out_barcode_base;
// context.WexItem.Add(dbItem);
// }
// dbItem.StockQnt = 0;
// dbItem.TotalStockQnt = Convert.ToInt32(wexItem.out_stock);
// dbItem.IsEnabled = true;
// if (jsonData.FirstOrDefault(o => o.out_item_no == wexItem.out_item_no) != null)
// {
// dbItem.StockQnt = Convert.ToInt32(jsonData.FirstOrDefault(o => o.out_item_no == wexItem.out_item_no).out_available_stock);
// }
// //if (wexItem.out_available_stock > 0)
// //{
// // WexItem nItem = new WexItem()
// // {
// // ArticleCode = wexItem.out_item_no
// // , SubEANCode = wexItem.out_barcode_base
// // , StockQnt = 0
// // , TotalStockQnt = Convert.ToInt32(wexItem.out_stock)
// // , IsEnabled = true
// // };
// // if (jsonData.FirstOrDefault(o => o.out_item_no == wexItem.out_item_no) != null)
// // {
// // nItem.StockQnt = Convert.ToInt32(jsonData.FirstOrDefault(o => o.out_item_no == wexItem.out_item_no).out_available_stock);
// // }
// // context.WexItem.Add(nItem);
// //}
// }
// context.SaveChanges();
//}
//catch (Exception ex)
//{
// throw ex;
//}
//finally
//{
// scope.Commit();
//}
// update price table
context.EurofarStockSync_function_UpdatePriceTable();
data = converter.DB2DTO_Product(context.WarehouseConnectMng_Product_View.ToList());
}
}
}
catch (Exception ex)
{
HandlingException(ex);
data = new List<DTO.ProductDTO>();
return false;
}
return true;
}