Esempio n. 1
0
        /// <summary>
        /// Fills a productModel with data from the database.
        /// </summary>
        /// <param name="rec">An IDataRecord from an IDataReader</param>
        /// <returns>The filled out productModel.</returns>
        protected static productModel FillList(IDataRecord rec)
        {
            productModel tempProductModel = new productModel();

            if (!rec.IsDBNull(rec.GetOrdinal("Product_ID")))
            {
                tempProductModel.Product_ID = Convert.ToString(rec.GetValue(rec.GetOrdinal("Product_ID")));
            }

            if (!rec.IsDBNull(rec.GetOrdinal("Description")))
            {
                tempProductModel.Description = rec.GetString(rec.GetOrdinal("Description"));
            }

            if (!rec.IsDBNull(rec.GetOrdinal("Last_Sold")))
            {
                tempProductModel.Last_Sold = Convert.ToString(rec.GetValue(rec.GetOrdinal("Last_Sold")));
            }

            if (!rec.IsDBNull(rec.GetOrdinal("Shelf_Life")))
            {
                tempProductModel.Shelf_Life = Convert.ToString(rec.GetValue(rec.GetOrdinal("Shelf_Life")));
            }

            if (!rec.IsDBNull(rec.GetOrdinal("Department_ID")))
            {
                tempProductModel.Department_ID = Convert.ToString(rec.GetValue(rec.GetOrdinal("Department_ID")));
            }

            if (!rec.IsDBNull(rec.GetOrdinal("Price")))
            {
                tempProductModel.Price = Convert.ToString(rec.GetValue(rec.GetOrdinal("Price")));
            }

            if (!rec.IsDBNull(rec.GetOrdinal("Unit")))
            {
                tempProductModel.Unit = rec.GetString(rec.GetOrdinal("Unit"));
            }

            if (!rec.IsDBNull(rec.GetOrdinal("xFor")))
            {
                tempProductModel.xFor = Convert.ToString(rec.GetValue(rec.GetOrdinal("xFor")));
            }

            if (!rec.IsDBNull(rec.GetOrdinal("Cost")))
            {
                tempProductModel.Cost = Convert.ToString(rec.GetValue(rec.GetOrdinal("Cost")));
            }

            if (!rec.IsDBNull(rec.GetOrdinal("Department_Name")))
            {
                tempProductModel.Department_Name = rec.GetString(rec.GetOrdinal("Department_Name"));
            }

            return(tempProductModel);
        }
Esempio n. 2
0
        /// <summary>
        /// Searches the product table for all products that match the search criteria.
        /// </summary>
        /// <param name="myproducts">The productModel with search parameters.</param>
        /// <returns>A generic list of products.</returns>
        public static productList getProducts(productModel myproducts)
        {
            productList myProductList = null;

            using (SqlConnection myConn = dac.getConnection())
            {
                SqlCommand myCommand = new SqlCommand("searchProducts", myConn);
                myCommand.CommandType = CommandType.StoredProcedure;

                if (myproducts.Product_ID == null)
                {
                    myCommand.Parameters.AddWithValue("@Product_ID", DBNull.Value);
                }
                else
                {
                    myCommand.Parameters.AddWithValue("@Product_ID", myproducts.Product_ID);
                }

                if (myproducts.Description == null)
                {
                    myCommand.Parameters.AddWithValue("@Description", DBNull.Value);
                }
                else
                {
                    myCommand.Parameters.AddWithValue("@Description", myproducts.Description);
                }

                if (myproducts.Department_Name == null)
                {
                    myCommand.Parameters.AddWithValue("@Department_Name", DBNull.Value);
                }
                else
                {
                    myCommand.Parameters.AddWithValue("@Department_Name", myproducts.Department_Name);
                }

                if (myproducts.Last_Sold == null)
                {
                    myCommand.Parameters.AddWithValue("@Last_Sold", DBNull.Value);
                }
                else
                {
                    myCommand.Parameters.AddWithValue("@Last_Sold", myproducts.Last_Sold);
                }

                if (myproducts.Shelf_Life == null)
                {
                    myCommand.Parameters.AddWithValue("@Shelf_Life", DBNull.Value);
                }
                else
                {
                    myCommand.Parameters.AddWithValue("@Shelf_Life", myproducts.Shelf_Life);
                }

                if (myproducts.Price == null)
                {
                    myCommand.Parameters.AddWithValue("@Price", DBNull.Value);
                }
                else
                {
                    myCommand.Parameters.AddWithValue("@Price", myproducts.Price);
                }

                if (myproducts.Unit == null)
                {
                    myCommand.Parameters.AddWithValue("@Unit", DBNull.Value);
                }
                else
                {
                    myCommand.Parameters.AddWithValue("@Unit", myproducts.Unit);
                }

                if (myproducts.xFor == null)
                {
                    myCommand.Parameters.AddWithValue("@xFor", DBNull.Value);
                }
                else
                {
                    myCommand.Parameters.AddWithValue("@xFor", myproducts.xFor);
                }

                if (myproducts.Cost == null)
                {
                    myCommand.Parameters.AddWithValue("@Cost", DBNull.Value);
                }
                else
                {
                    myCommand.Parameters.AddWithValue("@Cost", myproducts.Cost);
                }

                myConn.Open();
                try
                {
                    myProductList = new productList();

                    SqlDataReader sqlReader = myCommand.ExecuteReader();
                    while (sqlReader.Read())
                    {
                        myProductList.Add(FillList(sqlReader));
                    }
                }
                catch (Exception ex)
                {
                }
                finally
                {
                    myConn.Close();
                }

                return(myProductList);
            }
        }