}//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> 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> Deletes an Product record via ProductSql container. </summary> /// <param name="ID"> The ID of the Product record you want deleted. </param> public static void Delete(int ID) { Data.Sql.ProductSql ProductSql = new Data.Sql.ProductSql(); ProductSql.Delete(ID); }//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