/// <summary>
/// Robert Forbes
/// 2017/02/02
///
/// Gets a list of all packages with the provided orderID
/// </summary>
/// <param name="orderID">The order ID that the packages should be associated with</param>
/// <returns>A list of packages</returns>
public List <Package> RetrievePackagesInOrder(int orderID)
{
List <Package> packages = new List <Package>();
try
{
packages = PackageAccessor.RetrieveAllPackagesByOrder(orderID);
foreach (Package p in packages)
{
try{
p.PackageLineList = PackageLineAccessor.RetrievePackageLinesInPackage(p.PackageId);
}
catch
{
// If we cant get the package lines from the db set it to an empty list
p.PackageLineList = new List <PackageLine>();
}
}
}
catch (Exception)
{
throw;
}
return(packages);
}
/// <summary>
/// Robert Forbes
/// 2017/04/13
///
/// Retrieves all routes with assigned dates for today or after
/// </summary>
/// <param name="driverId"></param>
/// <returns></returns>
public List <Route> RetrieveFutureRoutesForDriver(int?driverId)
{
List <Route> routes = new List <Route>();
try
{
List <Route> routesToRemove = new List <Route>();
//Getting all the routes
routes = RouteAccessor.RetrieveFutureRoutesForDriver(driverId);
foreach (Route r in routes)
{
//Getting all the deliveries for each route
List <Delivery> deliveriesToRemove = new List <Delivery>();
r.Deliveries = DeliveryAccessor.RetrieveDeliveriesForRoute(r.RouteId);
foreach (Delivery d in r.Deliveries)
{
if (d.StatusId == "Delivered")
{
deliveriesToRemove.Add(d);
}
//Getting the address for each delivery
d.Address = DeliveryAccessor.RetrieveUserAddressForDelivery(d.DeliveryId);
//Getting the packages for each delivery
d.PackageList = PackageAccessor.RetrieveAllPackagesInDelivery(d.DeliveryId);
foreach (Package p in d.PackageList)
{
//Getting all the lines for each package
p.PackageLineList = PackageLineAccessor.RetrievePackageLinesInPackage(p.PackageId);
foreach (PackageLine line in p.PackageLineList)
{
//Getting the name of each product for each package line
line.ProductName = ProductAccessor.RetrieveProductNameFromProductLotId(line.ProductLotId);
}
}
}
foreach (Delivery d in deliveriesToRemove)
{
r.Deliveries.Remove(d);
}
if (r.Deliveries.Count == 0)
{
routesToRemove.Add(r);
}
}
foreach (Route r in routesToRemove)
{
routes.Remove(r);
}
}
catch (Exception)
{
throw;
}
return(routes);
}
public SaveCurrentSessionCommand(
PackageAccessor packageAccessor,
ISessionManager sessionManager,
IIDE ide,
ILogger logger)
{
_package = packageAccessor.Package;
_sessionManager = sessionManager;
_ide = ide;
_logger = logger;
_saveLock = new object();
}
/// <summary>
/// Robert Forbes
/// 2017/02/02
///
/// Calls the data access class to create a package in the database from the passed package object
/// </summary>
/// <param name="package">The package to add to the database</param>
/// <returns>bool representing if the package was successfully added</returns>
public bool CreatePackage(Package package)
{
bool result = false;
try
{
if (PackageAccessor.CreatePackage(package) == 1)
{
result = true;
}
}
catch (Exception)
{
throw;
}
return(result);
}
/// <summary>
/// Robert Forbes
/// 2017/03/09
///
/// Updates the oldPackage to the values of the newPackage
/// </summary>
/// <param name="deliveryId">The new delivery id</param>
/// <param name="packageId">The package to update</param>
/// <returns></returns>
public bool UpdatePackageDelivery(int packageId, int deliveryId)
{
bool result = false;
try
{
if (PackageAccessor.UpdatePackageDelivery(packageId, deliveryId) == 1)
{
result = true;
}
}
catch (Exception)
{
throw;
}
return(result);
}
public List <ProductOrder> RetrieveProductOrdersByStatus(String Status)
{
List <ProductOrder> ProductOrderList;
try
{
ProductOrderList = ProductOrderAccessor.RetrieveProductOrdersByStatus(Status);
foreach (ProductOrder ProductOrderFound in ProductOrderList)
{
ProductOrderFound.BackorderPreorderList = BackorderPreorderAccessor.RetrieveBackorderPreorders(
new BackorderPreorder
{
OrderId = ProductOrderFound.OrderId
}
);
ProductOrderFound.DeliveryList = DeliveryAccessor.RetrieveDelivery(
new Delivery
{
OrderId = ProductOrderFound.OrderId
}
);
ProductOrderFound.EmployeeOrderResponsibilityList = EmployeeOrderResponsibilityAccessor.RetrieveEmployeeOrderResponsibility(
new EmployeeOrderResponsibility
{
OrderId = ProductOrderFound.OrderId
}
);
ProductOrderFound.PackageList = PackageAccessor.RetrievePackageFromSearch(
new Package
{
OrderId = ProductOrderFound.OrderId
}
);
}
}
catch (Exception)
{
throw;
}
return(ProductOrderList);
}
/// <summary>
/// Initializes a new instance of the <see cref="SessionManagerToolWindowControl"/> class.
/// </summary>
public SessionManagerToolWindowControl(
SessionManagerToolWindowState state,
ISessionManager sessionManager,
SaveCurrentSessionCommand saveCurrentSessionCommand,
RestoreSessionCommand restoreSessionCommand,
OpenSessionCommand openSessionCommand,
CloseSessionDocumentsCommand closeSessionDocumentsCommand,
DeleteSessionCommand deleteSessionCommand,
PackageAccessor packageAccessor)
{
State = state;
SessionManager = sessionManager;
_openSessionCommand = openSessionCommand;
_package = packageAccessor.Package;
RestoreSessionCommand = new RelayCommand(
param => _package.JoinableTaskFactory.RunAsync(async() => await restoreSessionCommand.ExecuteAsync(State.SelectedSession)));
OpenSessionCommand = new RelayCommand(
param => _package.JoinableTaskFactory.RunAsync(async() => await openSessionCommand.ExecuteAsync(State.SelectedSession)));
CloseSessionDocumentsCommand = new RelayCommand(
param => _package.JoinableTaskFactory.RunAsync(async() => await closeSessionDocumentsCommand.ExecuteAsync(State.SelectedSession)));
DeleteSessionCommand = new RelayCommand(
param => _package.JoinableTaskFactory.RunAsync(async() => await deleteSessionCommand.ExecuteAsync(State.SelectedSession)));
RenameSessionCommand = new RelayCommand(
param => _package.JoinableTaskFactory.RunAsync(async() => await RenameSessionAsync()));
UpdateSessionCommand = new RelayCommand(
param => _package.JoinableTaskFactory.RunAsync(async() =>
{
if (MessageBox.Show($"Documents saved in \"{State.SelectedSession.Name}\" will be replaced with " +
$"the currently opened documents. Are you sure you want to continue?",
"Confirm",
MessageBoxButton.YesNo,
MessageBoxImage.Question) != MessageBoxResult.Yes)
{
return;
}
await saveCurrentSessionCommand.ExecuteAsync(State.SelectedSession);
}));
this.InitializeComponent();
}
public SessionManagerToolWindowCommand(PackageAccessor packageAccessor)
{
_package = packageAccessor.Package;
}
public CloseSessionDocumentsCommand(IIDE ide, SessionManagerToolWindowState sessionManagerToolWindowState, PackageAccessor packageAccessor)
{
_ide = ide;
_sessionManagerToolWindowState = sessionManagerToolWindowState;
_package = packageAccessor.Package;
}
