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); } }
private void Interface_StockByMinMax(DateTime lastupdate) { List <StockByMinMax> lstStkMinMax; try { //eventLog1.WriteEntry("Get Stock By Min Max", EventLogEntryType.Information); //get data from oracle database using (QueryBLL oraQuery = new QueryBLL()) { lstStkMinMax = oraQuery.GetStockByMinMax(); } // Insert data to SQLite database if (lstStkMinMax != null) { //eventLog1.WriteEntry("SQLite Stock By MinMax", EventLogEntryType.Information); using (InterfaceBLL infBll = new InterfaceBLL()) { infBll.InsertStockByMinMax(lstStkMinMax, lastupdate); infBll.DeleteStockByMinMax(); infBll.UpdateStockByMinMax(); } } } catch (Exception ex) { eventLog1.WriteEntry(ex.Message, EventLogEntryType.Error); } }
public RolesController() { bll = new UserRoleBLL(); }
public RolesController(InterfaceBLL<Role> bll) { this.bll = bll; }
public OrderController() { bll = new OrderBLL(); }
public OrderController(InterfaceBLL<Order> bll) { this.bll = bll; }
public UserController() { bll = new UserBLL(); }
public UserController(InterfaceBLL<User> bll) { this.bll = bll; }