}//end method
/// <summary>
/// Adds a record to the database via a ProductSql container.
/// </summary>
/// <param name="info"> The Product business container that needs to be added. </param>
/// <returns> The Product ID of the item added to the database. </returns>
public static int Add(Biz.Containers.Product info)
{
var data = ConvertToDataContainer(info);
Data.Sql.ProductSql ProductSql = new Data.Sql.ProductSql();
int toReturn = ProductSql.Add(data);
return toReturn;
}//end method
/// <summary>
/// Returns the Product ID instance that matches this ID
/// </summary>
/// <param name="ID">The ID of a Product object we want retrieved. </param>
/// <returns> A Product business container with Product ID record information. </returns>
public static Biz.Containers.Product Get(int ID)
{
Data.Sql.ProductSql ProductSql = new Data.Sql.ProductSql();
Data.Containers.Product data = ProductSql.GetByID(ID);
Biz.Containers.Product toReturn = ConvertFromDataContainer(data);
return toReturn;
}//end method
}//end Method
/// <summary> Converts Business Container object to Data Container object </summary>
/// <param name="info">The business container Product object. </param>
/// <returns> The data container Product object. </returns>
internal static Data.Containers.Product ConvertToDataContainer(Biz.Containers.Product info)
{
return new Data.Containers.Product()
{
ID = info.ID,
Name = info.Name,
LOB = info.LOB,
Model = info.Model,
Variant = info.Variant,
Phase = info.Phase
};
}//end method
}//end method
/// <summary> Returns all Product items </summary>
/// <returns> An array of Product Business containers. </returns>
public static Biz.Containers.Product[] GetAll()
{
Data.Sql.ProductSql ProductSql = new Data.Sql.ProductSql();
Data.Containers.Product[] data = ProductSql.GetAll();
List<Biz.Containers.Product> toReturn = new List<Biz.Containers.Product>();
foreach (var info in data)
{
Biz.Containers.Product Product = ConvertFromDataContainer(info);
toReturn.Add(Product);
}
return toReturn.ToArray();
}//end method
}//end method
/// <summary>
/// Updates a record via the ProductSql container.
/// </summary>
/// <param name="info"> The Product container object we want to update. </param>
public static void Update(Biz.Containers.Product info)
{
var data = ConvertToDataContainer(info);
Data.Sql.ProductSql ProductSql = new Data.Sql.ProductSql();
ProductSql.Update(data);
}//end method
