/// <summary>
/// Updates the article information of this item pack.
/// </summary>
/// <param name="database">The database to retrieve the article information from.</param>
public void UpdateArticleInformation(DB.Database database)
{
if (database == null)
{
throw new ArgumentException("Invalid database specified.");
}
if ((this.RobotArticleID == 0) || (this.ComponentID == 0))
{
this.RobotArticleCode = string.Empty;
this.RobotArticleName = string.Empty;
this.RobotArticleDosageForm = string.Empty;
this.RobotArticlePackagingUnit = string.Empty;
}
else
{
var articleList = database.Query <RobotArticle>(new CommandFilter("ID", this.RobotArticleID),
new CommandFilter("ComponentID", this.ComponentID));
if (articleList.Count == 0)
{
this.Error("Article with ID '{0}' for component '{1}' not found.", this.RobotArticleID, this.ComponentID);
this.RobotArticleCode = this.ScanCode == null ? string.Empty : this.ScanCode;
this.RobotArticleName = string.Empty;
this.RobotArticleDosageForm = string.Empty;
this.RobotArticlePackagingUnit = string.Empty;
}
this.RobotArticleCode = articleList[0].Code;
this.RobotArticleName = articleList[0].Name;
this.RobotArticleDosageForm = articleList[0].DosageForm;
this.RobotArticlePackagingUnit = articleList[0].PackagingUnit;
}
}
/// <summary>
/// Loads the attribute from related PIS ID.
/// </summary>
/// <param name="dataRow">The database row object to load the database type from.</param>
/// <param name="database">The database instance to use for loading additional dependencies.</param>
public void Load(DB.Database _database, int pisArticleID)
{
List <PisArticleAttribute> unsortedAttribute = _database.Query <PisArticleAttribute>(new CommandFilter("PisArticleID", pisArticleID));
foreach (PisArticleAttribute attribute in unsortedAttribute)
{
_attributes.Add(attribute.Name, attribute);
}
}
/// <summary>
/// Updates the stock location and tenant information of this item pack.
/// </summary>
/// <param name="database">The database to retrieve the stock location and tenant information from.</param>
public void UpdateLocationAndTenantInformation(DB.Database database)
{
if (database == null)
{
throw new ArgumentException("Invalid database specified.");
}
var tenants = database.Query <Tenant>(new CommandFilter("ID", this.TenantID),
new CommandFilter("ComponentID", this.ComponentID));
if (tenants.Count > 0)
{
this.TenantDescription = tenants[0].Description;
}
var locations = database.Query <StockLocation>(new CommandFilter("ID", this.StockLocationID),
new CommandFilter("ComponentID", this.ComponentID));
if (locations.Count > 0)
{
this.StockLocationDescription = locations[0].Description;
}
}
