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;
}
