Exemple #1
0
        }//end method

        /// <summary>
        /// Adds a record to the database via a SKUSql container.
        /// </summary>
        /// <param name="info"> The SKU business container that needs to be added. </param>
        /// <returns> The SKU ID of the item added to the database. </returns>
        public static int Add(Biz.Containers.SKU info)
        {
            var data = ConvertToDataContainer(info);
            Data.Sql.SKUSql skuSql = new Data.Sql.SKUSql();
            int toReturn = skuSql.Add(data);
            return toReturn;
        }//end method
Exemple #2
0
        /// <summary>
        /// Returns the SKU ID instance that matches this ID
        /// </summary>
        /// <param name="ID">The ID of a SKU object we want retrieved. </param>
        /// <returns> A SKU business container with SKU ID record information. </returns>
        public static Biz.Containers.SKU Get(int ID)
        {
            Data.Sql.SKUSql SKUSql = new Data.Sql.SKUSql();
            Data.Containers.SKU data = SKUSql.GetByID(ID);

            Biz.Containers.SKU toReturn = ConvertFromDataContainer(data);

            return toReturn;
        }//end method
Exemple #3
0
        }//end method

        /// <summary>
        /// Returns all SKU items
        /// </summary>
        /// <returns> An array of SKU Business containers. </returns>
        public static Biz.Containers.SKU[] GetAll()
        {
            Data.Sql.SKUSql skuSql = new Data.Sql.SKUSql();
            Data.Containers.SKU[] data = skuSql.GetAll();

            List<Biz.Containers.SKU> toReturn = new List<Biz.Containers.SKU>();
            foreach (var info in data)
            {
                Biz.Containers.SKU sku = ConvertFromDataContainer(info);
                toReturn.Add(sku);
            }
            return toReturn.ToArray();
        }//end method
Exemple #4
0
        }//end method

        /// <summary> Deletes an SKU record via SKUSql container. </summary>
        /// <param name="ID"> The ID of the SKU record you want deleted. </param>
        public static void Delete(int ID)
        {
            Data.Sql.SKUSql skuSql = new Data.Sql.SKUSql();
            skuSql.Delete(ID);
        }//end method
Exemple #5
0
        }//end method

        /// <summary>
        /// Updates a record via the SKUSql container.
        /// </summary>
        /// <param name="info"> The SKU container object we want to update. </param>
        public static void Update(Biz.Containers.SKU info)
        {
            var data = ConvertToDataContainer(info);
            Data.Sql.SKUSql skuSql = new Data.Sql.SKUSql();
            skuSql.Update(data);
        }//end method