Ejemplo n.º 1
0
        /**
         * A list of allmagazine in the  MagazineClass' getAllMagazineFromDB() function is created.
         * magazineUserControls is created from the  MagazineUserControls
         * The size of  MagazineUserControls is up to the length of allmagazine
         */
        private void populateMagazinesViewInHomePage()
        {
            List <MagazineClass> allmagazine = MagazineClass.getAllMagazineFromDB();

            MagazineUserControl[] magazineUserControls = new MagazineUserControl[allmagazine.Count];

            if (flpHomePage.Controls.Count > 0)
            {
                flpHomePage.Controls.Clear();
            }

            int i = 0;

            foreach (var item in allmagazine)
            {
                magazineUserControls[i]                    = new MagazineUserControl();
                magazineUserControls[i].magazineID         = item.id;
                magazineUserControls[i].magazineName       = item.name;
                magazineUserControls[i].magazinePrice      = item.price;
                magazineUserControls[i].magazineIssue      = item.issue;
                magazineUserControls[i].stock              = item.stock;
                magazineUserControls[i].cover_page_picture = item.cover_page_picture;
                flpHomePage.Controls.Add(magazineUserControls[i]);
                i++;
            }
        }
Ejemplo n.º 2
0
        /**this function read amagazine item in a database
         * @param string id
         * @return magazine
         */
        public static MagazineClass getAMagazineFromDB(string id)
        {
            DatabaseHelperClass dbHelper   = DatabaseHelperClass.Instance; //SINGLETON PATTERN
            SqlConnection       connection = dbHelper.getConnection();
            SqlCommand          command    = new SqlCommand("SELECT * FROM MagazineTable where id=@id", connection);

            command.Parameters.AddWithValue("@id", Convert.ToInt32(id));
            SqlDataReader readMagazine = command.ExecuteReader();

            MagazineClass magazine = new MagazineClass();

            if (readMagazine != null)
            {
                while (readMagazine.Read())
                {
                    magazine.id    = readMagazine["id"].ToString();
                    magazine.name  = readMagazine["name"].ToString();
                    magazine.price = Convert.ToDouble(readMagazine["price"]);
                    magazine.stock = Convert.ToInt32(readMagazine["stock"]);
                    magazine.issue = readMagazine["issue"].ToString();
                    magazine.cover_page_picture = readMagazine["cover_page_picture"].ToString();
                }
            }
            return(magazine);
        }
Ejemplo n.º 3
0
        /** @ brief adds the purchased magzine to the shopping cart
         * create a magzine from MagazineClass
         * and item added shoppingcartclass
         */
        private void btnMagazineAddToCart_Click(object sender, EventArgs e)
        {
            MagazineClass magazine = new MagazineClass();

            magazine = MagazineClass.getAMagazineFromDB(magazineID);
            ShoppingCartClass.addProduct(new ItemToPurchaseClass(magazine, Convert.ToInt32(Math.Round(nudQuantity.Value, 0))));
            System.Windows.Forms.Form f = System.Windows.Forms.Application.OpenForms["BookShopForm"];
            int quantity = 0;

            foreach (var item in ShoppingCartClass.itemsToPurchase)
            {
                quantity += item.quantity;
            }
            ((BookShopForm)f).lblShoppinCartValue.Text = quantity.ToString();
            MessageBox.Show("Added to cart.", "INFORMATION", MessageBoxButtons.OK, MessageBoxIcon.Information);
        }
Ejemplo n.º 4
0
        private void btnUpdateMagazine_Click(object sender, EventArgs e)
        {
            MagazineClass magazine = new MagazineClass(txtMagazineName.Text, txtMagazineId.Text, Convert.ToDouble(txtMagazinePrice.Text), Convert.ToInt32(txtMagazineStock.Text), txtMagazineIssue.Text, txtMagazineType.Text, txtMagazineImage.Text);
            //bool affected = dbHelper.updateAProductAtDB(magazine);
            AdminUserClass adminOps = AdminUserClass.Instance;
            bool           affected = adminOps.updateProduct(magazine);

            if (!affected)
            {
                MessageBox.Show("Error not successful", "INFORMATION", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            else
            {
                MessageBox.Show("Magazine added successfully", "INFORMATION", MessageBoxButtons.OK, MessageBoxIcon.Information);
                clearMagazineControls();
            }
        }
Ejemplo n.º 5
0
        /**
         * magazineList created fromMagazineClass
         * this function reads magazine items in database
         * and add in magazinelist
         * @return magazineList
         */
        public static List <MagazineClass> getAllMagazineFromDB()
        {
            List <MagazineClass> magazineList = new List <MagazineClass>();
            DatabaseHelperClass  dbHelper     = DatabaseHelperClass.Instance; //SINGLETON PATTERN
            SqlConnection        connection   = dbHelper.getConnection();
            SqlCommand           command      = new SqlCommand("SELECT * FROM MagazineTable", connection);
            SqlDataReader        readMagazine = command.ExecuteReader();

            if (readMagazine != null)
            {
                while (readMagazine.Read())
                {
                    MagazineClass magazine = new MagazineClass();
                    magazine.id    = readMagazine["id"].ToString();
                    magazine.name  = readMagazine["name"].ToString();
                    magazine.price = Convert.ToDouble(readMagazine["price"]);
                    magazine.stock = Convert.ToInt32(readMagazine["stock"]);
                    magazine.issue = readMagazine["issue"].ToString();
                    magazine.cover_page_picture = readMagazine["cover_page_picture"].ToString();
                    magazineList.Add(magazine);
                }
            }
            return(magazineList);
        }