Пример #1
0
        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);
            }
        }