private void Interface_StockByMachine(DateTime lastupdate)
{
List <StockByMachine> lstStkMachine;
try
{
//eventLog1.WriteEntry("Get Stock By Machine", EventLogEntryType.Information);
//get data from oracle database
using (QueryBLL oraQuery = new QueryBLL())
{
lstStkMachine = oraQuery.GetStockByMachine();
}
// Insert data to SQLite database
if (lstStkMachine != null)
{
//eventLog1.WriteEntry("SQLite Stock By Machine", EventLogEntryType.Information);
using (InterfaceBLL infBll = new InterfaceBLL())
{
infBll.InsertStockByMachine(lstStkMachine, lastupdate);
infBll.DeleteStockByMachine();
infBll.UpdateStockByMachine();
}
}
}
catch (Exception ex)
{
eventLog1.WriteEntry(ex.Message, EventLogEntryType.Error);
}
}
