private void Interface_DeliveryBoardDetail(DateTime lastupdate) { List <DeliveryBoardDetail> lstDeliveryDetail; try { //eventLog1.WriteEntry("Get Stock By Delivery Board Detail", EventLogEntryType.Information); //get data from oracle database using (QueryBLL oraQuery = new QueryBLL()) { lstDeliveryDetail = oraQuery.GetDeliveryBoardDetail(); } // Insert data to SQLite database if (lstDeliveryDetail != null) { //eventLog1.WriteEntry("SQLite Stock By Delivery Board Detail", EventLogEntryType.Information); using (InterfaceBLL infBll = new InterfaceBLL()) { infBll.InsertDeliveryBoardDetail(lstDeliveryDetail, lastupdate); infBll.DeleteDeliveryBoardDetail(); infBll.UpdateDeliveryBoardDetail(); } } } catch (Exception ex) { eventLog1.WriteEntry(ex.Message, EventLogEntryType.Error); } }