コード例 #1
0
        private void btnCreateBar_Click(object sender, EventArgs e)
        {
            barTable = new BarTable();
            int startLeft = pnlRoom.Left;
            int startTop  = pnlRoom.Top;

            barTable.TableNumber    = 1;
            barTable.TablePositionX = startLeft;
            barTable.TablePositionY = startTop;

            Button button = new StayInsideButton();

            button.Cursor    = Cursors.Hand;
            button.Height    = 30;
            button.Width     = 200;
            button.FlatStyle = FlatStyle.Flat;
            button.FlatAppearance.BorderSize = 0;
            button.BackColor = Color.Cyan;
            button.Tag       = barTable;
            button.Text      = "Bar";
            button.Location  = new Point(startLeft, startTop);
            pnlRoom.Controls.Add(button);

            button.MouseDown += button_MouseDown;
            button.MouseUp   += button_MouseUp;
            button.MouseMove += button_MouseMove;

            btnSaveLayout.Enabled = true;
            lblMessage.Text       = "Bar was successfully added.";

            btnCreateBar.Enabled = false;
        }
コード例 #2
0
        public void LoadBarTable()
        {
            BarTable oBarTable = BarTableDA.GetBarTableLayout();

            if (oBarTable != null)
            {
                Button button = new StayInsideButton();
                button.Cursor    = Cursors.Hand;
                button.Height    = 30;
                button.Width     = 200;
                button.FlatStyle = FlatStyle.Flat;
                button.FlatAppearance.BorderSize = 0;
                button.BackColor = Color.Cyan;
                button.Tag       = oBarTable;
                button.Text      = "Bar";
                button.Location  = new Point(oBarTable.TablePositionX, oBarTable.TablePositionY);
                pnlRoom.Controls.Add(button);
            }
        }
コード例 #3
0
        public static BarTable GetBarTableLayout()
        {
            SqlConnection connection = RestaurantConnection.GetConnection();
            SqlCommand    command    = new SqlCommand();
            SqlDataReader reader     = null;
            BarTable      barTable   = null;

            command.CommandText = "Select * FROM barTable";
            command.CommandType = CommandType.Text;
            command.Connection  = connection;

            try {
                connection.Open();
                reader = command.ExecuteReader();

                while (reader.Read())
                {
                    barTable                = new BarTable();
                    barTable.TableNumber    = (int)reader["tableNumber"];
                    barTable.TablePositionX = (int)reader["tablePositionX"];
                    barTable.TablePositionY = (int)reader["tablePositionY"];
                }
            }
            catch (SqlException ex) {
                MessageBox.Show(ex.Message);
            }
            catch (Exception ex) {
                MessageBox.Show(ex.Message);
            }

            finally {
                connection.Close();
            }

            return(barTable);
        }
コード例 #4
0
        public static void SaveBarTableLayout(BarTable barTable)
        {
            SqlConnection connection = RestaurantConnection.GetConnection();

            // Select statement to see if bar table exists.
            string selectStatement = "SELECT COUNT(*) "
                                     + "FROM barTable";
            SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
            //selectCommand.Parameters.AddWithValue("@tableNumber", SqlDbType.Int);

            // Insert Statement.
            string insertStatement = "INSERT INTO barTable "
                                     + "(tableNumber, tablePositionX, tablePositionY) "
                                     + "VALUES (@tableNumber, @tablePositionX, @tablePositionY)";
            SqlCommand insertCommand = new SqlCommand(insertStatement, connection);

            insertCommand.Parameters.AddWithValue("@tableNumber", SqlDbType.Int);
            insertCommand.Parameters.AddWithValue("@tablePositionX", SqlDbType.Int);
            insertCommand.Parameters.AddWithValue("@tablePositionY", SqlDbType.Int);

            // Update Statement.
            string updateStatement = "UPDATE barTable "
                                     //+ "SET tableNumber = @tableNumber, "
                                     + "SET tablePositionX = @tablePositionX, "
                                     + "tablePositionY = @tablePositionY "
                                     + "WHERE tableNumber = @tableNumber";
            SqlCommand updateCommand = new SqlCommand(updateStatement, connection);

            updateCommand.Parameters.AddWithValue("@tableNumber", SqlDbType.Int);
            //updateCommand.Parameters.AddWithValue("@numberOfSeats", SqlDbType.Int);
            updateCommand.Parameters.AddWithValue("@tablePositionX", SqlDbType.Int);
            updateCommand.Parameters.AddWithValue("@tablePositionY", SqlDbType.Int);
            //updateCommand.Parameters.AddWithValue("@movedTableNumber", SqlDbType.Int);

            connection.Open();

            try {
                // Execute the select statement to see if the row exists.
                //selectCommand.Parameters["@tableNumber"].Value = barTable.TableNumber;
                int rowCount = (int)selectCommand.ExecuteScalar();

                if (rowCount > 0)
                {
                    // Update the row.
                    updateCommand.Parameters["@tableNumber"].Value = barTable.TableNumber;
                    //updateCommand.Parameters["@numberOfSeats"].Value = table.NumberOfSeats;
                    updateCommand.Parameters["@tablePositionX"].Value = barTable.TablePositionX;
                    updateCommand.Parameters["@tablePositionY"].Value = barTable.TablePositionY;
                    //updateCommand.Parameters["@movedTableNumber"].Value = table.TableNumber;

                    updateCommand.ExecuteNonQuery();
                }
                else
                {
                    // Insert the row.
                    insertCommand.Parameters["@tableNumber"].Value    = barTable.TableNumber;
                    insertCommand.Parameters["@tablePositionX"].Value = barTable.TablePositionX;
                    insertCommand.Parameters["@tablePositionY"].Value = barTable.TablePositionY;

                    insertCommand.ExecuteNonQuery();
                }
            }
            catch (SqlException ex) {
                MessageBox.Show(ex.Message);
            }
            finally {
                connection.Close();
            }
        }
コード例 #5
0
        public void LoadTables()
        {
            // Load Tables
            tables = TableDA.GetTableLayout();

            if (!(Utility.IsNullOrEmpty(tables)))
            {
                foreach (Table eachTable in tables)
                {
                    table = eachTable;

                    RoundButton button = new RoundButton();
                    button.Cursor    = Cursors.Hand;
                    button.Height    = 50;
                    button.Width     = 50;
                    button.FlatStyle = FlatStyle.Flat;
                    button.FlatAppearance.BorderSize = 0;
                    button.BackColor = Color.Cyan;
                    button.Tag       = table;
                    button.Text      = Convert.ToString(table.TableNumber)
                                       + "\n" + Convert.ToString(table.NumberOfSeats) + " seats";
                    button.Location = new Point(table.TablePositionX, table.TablePositionY);
                    pnlRoom.Controls.Add(button);

                    button.MouseDown += button_MouseDown;
                    button.MouseUp   += button_MouseUp;
                    button.MouseMove += button_MouseMove;
                }

                txtTableNumber.Text = Convert.ToString(Table.TotalTables);
            }

            //Load BarSeats.
            barSeats = BarSeatDA.GetBarSeatLayout();

            if (!(Utility.IsNullOrEmpty(barSeats)))
            {
                foreach (BarSeat eachBarSeat in barSeats)
                {
                    barSeat = eachBarSeat;

                    RoundButton button = new RoundButton();
                    button.Cursor    = Cursors.Hand;
                    button.Height    = 30;
                    button.Width     = 30;
                    button.FlatStyle = FlatStyle.Flat;
                    button.FlatAppearance.BorderSize = 0;
                    button.BackColor = Color.Cyan;
                    button.Tag       = barSeat;
                    button.Text      = "B" + Convert.ToString(barSeat.TableNumber);
                    button.Location  = new Point(barSeat.TablePositionX, barSeat.TablePositionY);
                    pnlRoom.Controls.Add(button);

                    button.MouseDown += button_MouseDown;
                    button.MouseUp   += button_MouseUp;
                    button.MouseMove += button_MouseMove;
                }

                txtBarSeatNumber.Text = Convert.ToString(BarSeat.TotalTables);
            }

            // Load BarTable.
            barTable = BarTableDA.GetBarTableLayout();

            if (barTable != null)
            {
                StayInsideButton button = new StayInsideButton();
                button.Cursor    = Cursors.Hand;
                button.Height    = 30;
                button.Width     = 200;
                button.FlatStyle = FlatStyle.Flat;
                button.FlatAppearance.BorderSize = 0;
                button.BackColor = Color.Cyan;
                button.Tag       = barTable;
                button.Text      = "Bar";
                button.Location  = new Point(barTable.TablePositionX, barTable.TablePositionY);
                pnlRoom.Controls.Add(button);

                button.MouseDown += button_MouseDown;
                button.MouseUp   += button_MouseUp;
                button.MouseMove += button_MouseMove;
            }

            lblMessage.Text = "Seating layout successfully loaded!";
        }