private void show_pnl_Drinks()
        {
            // Show modify and refresh button
            pnl_DisplayData.Show();
            btnRefresh.Show();

            // only accesible when logged in as admin
            if (role == "admin")
            {
                btnModify.Show();
            }

            // fill a list with drinks by calling a function from the service layer
            SomerenLogic.Drink_Service drinkService = new SomerenLogic.Drink_Service();
            List <Drink> drinkList = drinkService.GetDrinks();


            // clear the DataGridView and fill the column names
            ClearDataGridView();
            generateGridLayout(drinkList.FirstOrDefault().dataGridList());

            // Fill the DataGridView with all the drinks using a foreach
            foreach (var drink in drinkList)
            {
                FillDataInGridView(drink.dataGrid(drink, soldDrinks(drink.Id)));
            }
        }
        private void show_pnl_Order()
        {
            // only accesible when logged in as admin
            if (role == "admin")
            {
                pnl_Order.Show();
            }

            // get all the drinks and students
            SomerenLogic.Drink_Service drinkService = new SomerenLogic.Drink_Service();
            List <Drink> drinkList = drinkService.GetDrinks();

            SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
            List <Student> studentList = studService.GetStudents();

            // Fill each combobox with either drinks or students
            cmbDrinks.Items.Clear();
            cmbStudents.Items.Clear();
            foreach (Drink drink in drinkList)
            {
                cmbDrinks.Items.Add(drink.type);
            }
            cmbDrinks.SelectedIndex = 0; // selected index to 0

            foreach (Student student in studentList)
            {
                cmbStudents.Items.Add(student.Name);
            }
            cmbStudents.SelectedIndex = 0; // selected index to 0
        }
        private int soldDrinks(int id)
        {
            // get the amount of times sold per drink for the drink data grid
            SomerenLogic.Drink_Service drinkService = new SomerenLogic.Drink_Service();
            int amount = drinkService.GetSold(id);

            return(amount);
        }
Beispiel #4
0
        private void btn_Dialog_Drink_Add_Click(object sender, EventArgs e)
        {
            currentDrink.Name   = textBox_Name.Text;
            currentDrink.Price  = decimal.Parse(textBox_Price.Text);
            currentDrink.Supply = int.Parse(textBox_Supply.Text);

            SomerenLogic.Drink_Service drink_Service = new SomerenLogic.Drink_Service();
            drink_Service.AddDrink(currentDrink);
            this.Close();
        }
        private void btnSubmitOrder_Click(object sender, EventArgs e)
        {
            // get the selected index
            int studentId = cmbStudents.SelectedIndex + 1;
            int drinkId   = cmbDrinks.SelectedIndex + 1;

            SomerenLogic.Drink_Service drinkService = new SomerenLogic.Drink_Service();
            try
            {
                // first decrease the stock of the drink, then add transaction to sold table
                drinkService.decreaseStock(drinkId);
                drinkService.addTransaction(studentId, drinkId);
                MessageBox.Show("Transaction succeeded"); // display message
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Beispiel #6
0
        public void Checkout(String s, String d)
        {
            MessageBox.Show($"{s} /n {d}", "Checkout Data", MessageBoxButtons.OK);

            SomerenLogic.Drink_Service drink_Service = new SomerenLogic.Drink_Service();
            List <Drinks> drinkList = drink_Service.GetDrinks();

            String[] student = s.Split(' ');
            String[] drink   = d.Split(' ');


            Order o = new Order
            {
                DrinkID   = int.Parse(student[0]),
                StudentID = int.Parse(student[0]),
                Total     = drinkList[drinkList.FindIndex(item => item.Drinkid == int.Parse(drink[0]))].Price,
            };

            Order_DAO order_DB = new Order_DAO();

            order_DB.RecordOrder(o);
        }
        private void btngetRapport_Click(object sender, EventArgs e)
        {
            // get the start and end date of selected range
            DateTime start = RapportCalender.SelectionRange.Start;
            DateTime end   = RapportCalender.SelectionRange.End;

            // get rapport and convert date to amount of ticks
            try
            {
                SomerenLogic.Drink_Service drinkService = new SomerenLogic.Drink_Service();
                Sold sold = drinkService.getRapport(start.Ticks, end.Ticks);

                // clear the DataGridView and fill the column names
                ClearDataGridView();
                generateGridLayout(sold.dataGridList());

                // Fill the DataGridView with all the rooms using a foreach
                FillDataInGridView(sold.dataGrid(sold));
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }