Exemplo n.º 1
0
        /**
         * Updates Book, Magazine, MusicCD is gathered under 1 function as they all derived from ProductClass
         */

        public bool updateProduct(ProductClass product)
        {
            DatabaseHelperClass dbHelper = DatabaseHelperClass.Instance;
            bool affected = dbHelper.updateAProductAtDB(product);

            return(affected);
        }
Exemplo n.º 2
0
        }                                    //singleton pattern

        /**
         * Addnew Book, Magazine, MusicCD is gathered under 1 function as they all derived from ProductClass
         */
        public bool addNewProduct(ProductClass product)
        {
            DatabaseHelperClass dbHelper = DatabaseHelperClass.Instance;
            bool affected = dbHelper.addAProductToDB(product);

            return(affected);
        }
Exemplo n.º 3
0
        public bool updateAProductAtDB(ProductClass product)
        {
            try
            {
                SqlConnection connection = dbHelper.getConnection();
                SqlCommand    command    = null;
                if (product.GetType() == typeof(BookHouseOOP.BookClass))
                {
                    command = new SqlCommand("UPDATE BookTable SET name=@name,price=@price,stock=@stock,isbn=@isbn,author=@author,publisher=@publisher,page=@page,cover_page_picture=@cover_page_picture WHERE id=@id", connection);
                    command.Parameters.AddWithValue("@id", ((BookClass)product).id);
                    command.Parameters.AddWithValue("@name", ((BookClass)product).name);
                    command.Parameters.AddWithValue("@price", ((BookClass)product).price);
                    command.Parameters.AddWithValue("@stock", ((BookClass)product).stock);
                    command.Parameters.AddWithValue("@isbn", ((BookClass)product).isbn);
                    command.Parameters.AddWithValue("@author", ((BookClass)product).author);
                    command.Parameters.AddWithValue("@publisher", ((BookClass)product).publisher);
                    command.Parameters.AddWithValue("@page", ((BookClass)product).page);
                    command.Parameters.AddWithValue("@cover_page_picture", ((BookClass)product).cover_page_picture);
                }
                else if (product.GetType() == typeof(BookHouseOOP.MagazineClass))
                {
                    command = new SqlCommand("UPDATE MagazineTable SET name=@name,price=@price,stock=@stock,issue=@issue,type=@type,cover_page_picture=@cover_page_picture WHERE id=@id", connection);
                    command.Parameters.AddWithValue("@id", ((MagazineClass)product).id);
                    command.Parameters.AddWithValue("@name", ((MagazineClass)product).name);
                    command.Parameters.AddWithValue("@price", ((MagazineClass)product).price);
                    command.Parameters.AddWithValue("@stock", ((MagazineClass)product).stock);
                    command.Parameters.AddWithValue("@issue", ((MagazineClass)product).issue);
                    command.Parameters.AddWithValue("@type", ((MagazineClass)product).magazineType);
                    command.Parameters.AddWithValue("@cover_page_picture", ((MagazineClass)product).cover_page_picture);
                }
                else if (product.GetType() == typeof(BookHouseOOP.MusicCDsClass))
                {
                    command = new SqlCommand("UPDATE MusicCDsTable SET name=@name,price=@price,stock=@stock,singer=@singer,type=@type,picture=@picture WHERE id=@id", connection);
                    command.Parameters.AddWithValue("@id", ((MusicCDsClass)product).id);
                    command.Parameters.AddWithValue("@name", ((MusicCDsClass)product).name);
                    command.Parameters.AddWithValue("@price", ((MusicCDsClass)product).price);
                    command.Parameters.AddWithValue("@stock", ((MusicCDsClass)product).stock);
                    command.Parameters.AddWithValue("@singer", ((MusicCDsClass)product).singer);
                    command.Parameters.AddWithValue("@type", ((MusicCDsClass)product).type);
                    command.Parameters.AddWithValue("@picture", ((MusicCDsClass)product).cover_page_picture);
                }


                int affected = command.ExecuteNonQuery();

                if (affected > 0)
                {
                    return(true);
                }
                return(false);
            }
            catch (Exception e)
            {
                FileWriterClass.WriteFile(AppConstants.EXCEPTION_LOG_FILE_LOCATION, "Exception at updateAProductAtDB function" + e.Message);
                Console.WriteLine("Click {0}", e.Message);
                return(false);
            }
        }
Exemplo n.º 4
0
 /**
  * @brief Default Constructor
  * Constructs the object with default parameters
  * @param ProductClass product
  * @param int quantity
  */
 public ItemToPurchaseClass(ProductClass product, int quantity)
 {
     this.product  = product;
     this.quantity = quantity;
 }