public StartingForm()
{
InitializeComponent();
try
{
//Get all Products
DataHolders.ProductsHolder.products = ProductClient.GetProducts();
//Get all connections
DataHolders.ButtonConnectionHolder.connections = ButtonsClient.GetButtonConnections();
DataHolders.UnitProductConnectionHolder.Connections = ButtonsClient
.GetUnitPorductConnections();
//Documents
DataHolders.DocumentConnectionHolder.documentProductConnections = DocumentClient
.GetAllDocumnetProductConnections();
//Warehouse
DataHolders.WarehouseHolder.warehouses = DatabaseManagers.WarehouseClient.GetWarehouses();
//DatabaseManagers.WarehouseManager.GetWarehouses();
DataHolders.WarehouseHolder.warehouseProductConnections = DatabaseManagers.WarehouseClient
.GetWarehouseProductConnection();
//workers
DataHolders.WorkerHolder.workers = WorkerClient.GetWorkers();
DataHolders.WorkerHolder.avaliableWorkers = WorkerClient.GetAavalibleWorkers();
//Delivery
DataHolders.DeliveryHolder.partners = DeliveryClient.GetPartners();
DataHolders.DeliveryHolder.locations = DeliveryClient.GetLocations();
DataHolders.DeliveryHolder.vehicles = DeliveryClient.GetVehicles();
DataHolders.DeliveryHolder.routes = DeliveryClient.GetRoutes();
DataHolders.DeliveryHolder.avaliableVehicles = DeliveryClient.GetAvalibleVehicles();
//properties
if (PropertiesClient.GetProperties().Exists((e) => e.name == Enums.PropertyName.distance))
{
DataHolders.PropertiesHolder.distanceUnit = PropertiesClient.GetProperties()
.Find((e) => e.name == Enums.PropertyName.distance).value;
}
if (PropertiesClient.GetProperties().Exists((e) => e.name == Enums.PropertyName.weight))
{
DataHolders.PropertiesHolder.weightUnit = PropertiesClient.GetProperties()
.Find((e) => e.name == Enums.PropertyName.weight).value;
}
}
catch (Exception)
{
MessageBox.Show("Error connecting to database, initial data couldn't be load");
Environment.Exit(1);
}
}
private void getValuesFromDatabase()
{
try
{
switch ((ReportTypes)cmbReport.SelectedItem)
{
case ReportTypes.vehicle:
ReportHolder.vehicleReports = ReportClient.GetVehicleReport(dtpFrom.Value, dtpTo.Value);
break;
case ReportTypes.worker:
ReportHolder.workerReports = ReportClient.GetWorkerReport(dtpFrom.Value, dtpTo.Value);
break;
case ReportTypes.route:
ReportHolder.routeDisplays = RouteHelper.makeRoutesDisplayable(
DeliveryClient.GetRoutes())
.FindAll((elem) =>
elem.startDate.Date >= dtpFrom.Value.Date &&
elem.startDate <= dtpTo.Value.Date);
break;
case ReportTypes.received:
ReportHolder.receiveReports = ReportClient.GetReceiveReport(dtpFrom.Value, dtpTo.Value);
break;
case ReportTypes.intermediateWarehouse:
ReportHolder.iWReports = ReportClient.GetIWReport(dtpFrom.Value, dtpTo.Value);
break;
case ReportTypes.returned:
ReportHolder.returnReports = ReportClient.GetReturnToSupplierReport(dtpFrom.Value, dtpTo.Value);
break;
case ReportTypes.writeOff:
ReportHolder.writeOffReports = ReportClient.GetWriteOffReport(dtpFrom.Value, dtpTo.Value);
break;
default:
break;
}
}
catch (Exception)
{
MessageBox.Show("Failed to get values from database");
}
}
