C#

LAPEC wrote:

Now with the panels (such as: starters panel, mains panel, etc etc,) that you mentioned on e-mail well basically they are empty, but when I click for instance the Starter Button it calls the StarterUserControl and places inside the starter panel

Starters ════════════════════════════════════
1 Soup		£0.00		
1 Bruschetta	£0.00	
Mains ═══════════════════════════════════════
1 Ravioli	£0.00
1 Lasagne	£0.00
1 Veg. Pizza    £0.00

Starters ════════════════════════════════════
1 Soup		£0.00		
1 Bruschetta	£0.00	
****** Course 1 ****** this is what I want to insert in between...
Mains ═══════════════════════════════════════
1 Ravioli	£0.00
1 Lasagne	£0.00
1 Veg. Pizza    £0.00

private void cmdCourseSeparator_Click(object sender, EventArgs e)
        {
            string line1 = "════";
            string line2 = "══════ Course 1 ══════";
            string line3 = "══════";
            string line4 = "══════ Course 2 ══════";
            ListViewGroup liViGroup = new ListViewGroup();
            liViGroup.HeaderAlignment = System.Windows.Forms.HorizontalAlignment.Center;
            if (liViGroup.Header == "Starter")
            {
                liViGroup.Items.Add(line1);
                //foodItem.SubItems.Add(line2);
                //foodItem.SubItems.Add(line3);
                //foodItem.SubItems.Add(line3);
            }
            this.TableOrderListView.Groups.AddRange(new System.Windows.Forms.ListViewGroup[] {
            liViGroup});
        }

private void btnSeparator_Click(object sender, EventArgs e)
 {
     string line2 = "══════ Course 1 ";
     string line3 = "══════";
     string currentGroup = GetCurrentGroup();

     if (!string.IsNullOrEmpty(currentGroup))
     {
         // Don't want to add it twice
         if (!lvwOrder.Groups[currentGroup].Items[lvwOrder.Groups[currentGroup].Items.Count - 1].Text.Contains("Course"))
         {
             switch (currentGroup)
             {
                 case "Dessert":
                     line2 = "══════ Course 3";
                     break;
                 case "Main":
                     line2 = "══════ Course 2";
                     break;
             }

             ListViewItem newItem = new ListViewItem(line2);
             newItem.SubItems.Add(line3);
             newItem.SubItems.Add(line3);
             newItem.Group = lvwOrder.Groups[currentGroup];
             lvwOrder.Items.Add(newItem);
         }
     }
 }

 private string GetCurrentGroup()
 {
     string result = string.Empty;
     if (((DataRowView)MenuBS.Current) != null)
     {
         result = ((DataRowView)MenuBS.Current)["FoodType"].ToString();
     }

     return result;
 }

private DataGridViewTextBoxColumn ColFoodQtyStock = new DataGridViewTextBoxColumn();
        private DataGridViewTextBoxColumn ColFoodStatus = new DataGridViewTextBoxColumn();
        
        private void cmdStarters_Click(object sender, EventArgs e)
        {
            OleDbConnectionStringBuilder connBuilder = new OleDbConnectionStringBuilder();
            connBuilder.DataSource = @"C:\Users\AP_AE\Desktop\DTPOS_APP\DataBase\DtposMenu.accdb";
            connBuilder.Provider = "Microsoft.ACE.OLEDB.12.0";
            connBuilder.Add("Jet OLEDB:Engine Type", "5");

            // Food SQL Query
            string foodTypeSql = @"SELECT FoodName, FoodType FROM Food WHERE FoodType = @foodType";
            using (OleDbConnection conn = new OleDbConnection(connBuilder.ConnectionString))
            {
                dataGridView1.Columns.Clear();
                dataGridView1.RowTemplate.Height = 60;
                //====================================\\
                dataGridView1.Visible = true;
                dataGridView2.Visible = false;
                try
                {
                    OleDbCommand foodsCommand = new OleDbCommand(foodTypeSql, conn);
                    OleDbParameter foodType = foodsCommand.Parameters.Add("@foodType", OleDbType.VarChar, 15);
                    OleDbDataAdapter foodsDa = new OleDbDataAdapter(foodsCommand);
                    DataRow dr;
                    DataSet ds = new DataSet();
                    conn.Open();
                    foodType.Value = "Starter";
                    foodsDa.Fill(ds, "Food_table");
                    conn.Close();
                    dataGridView1.DataSource = ds;
                    dataGridView1.DataMember = "Food_table";

                    dataGridView1.Columns.AddRange(ColFoodQtyStock, ColFoodStatus);
                    
                    DataGridViewCellStyle dataGridViewCellStyle1 = new DataGridViewCellStyle();
                    this.dataGridView1.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle1;
                    dataGridViewCellStyle1.Font = new Font("Verdana", 20.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

                    this.dataGridView1.Columns[0].Width = 420;
                    this.dataGridView1.Columns[1].Width = 180;
                    this.dataGridView1.Columns[2].Width = 300;
                    this.dataGridView1.Columns[3].Width = 308;

                    // ColStatus 
                    ColFoodStatus.HeaderText = "Status";
                    ColFoodStatus.Name = "ColFoodStatus";

                    // ColQtyStock
                    ColFoodQtyStock.HeaderText = "Quantity In Stock";
                    ColFoodQtyStock.Name = "ColFoodQtyStock";
                    
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Error: " + ex);
                }
            }
        }

===============================================================
FoodName     FoodType     Qty In Stock     Status
===============================================================
Olives       Starter                      
Soup         Starter                      
etc...       etc...                  
===============================================================

===============================================================
FoodName     FoodType     Qty In Stock     Status
===============================================================
Olives       Starter      0                <Allways on Stock>
Soup         Starter      0                <Allways on Stock>
etc...       etc...       etc...           etc...
===============================================================

===============================================================
FoodName     FoodType     Qty In Stock     Status
===============================================================
Olives       Starter      0                <Allways on Stock>
Soup         Starter      0                <Allways on Stock>
etc...       etc...       etc...           etc...
===============================================================

===============================================================
FoodName     FoodType     Qty In Stock     Status
===============================================================
Olives       Starter      0                <Allways on Stock>
Soup         Starter      10               <Controlled>
etc...       etc...       etc...           etc...
===============================================================

private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
    // make sure that the click was in the right column
    if (e.ColumnIndex == 1)  // I used 1 here because I didn't put a column for FoodType, you should use 2.
    {
        // Give it a value in case the cell is empty
        string cellContent = "0";
        if (this.dataGridView1[e.ColumnIndex, e.RowIndex].Value != null)
        {
            cellContent = this.dataGridView1[e.ColumnIndex, e.RowIndex].Value.ToString();
        }

        using (InputBox ib = new InputBox("Enter new stock amount:", this.dataGridView1[0, e.RowIndex].Value.ToString(), cellContent))
        {
            if (ib.ShowDialog() == DialogResult.OK)
            {
                this.dataGridView1[e.ColumnIndex, e.RowIndex].Value = ib.Result;
                cellContent = ib.Result;
            }
        }
    }
}

public partial class InputBox : Form
{
    public InputBox(string text, string caption, string defaultValue)
    {
        //
        // The InitializeComponent() call is required for Windows Forms designer support.
        //
        InitializeComponent();

        this.Text = caption;


        Size size;
        using (Graphics g = this.CreateGraphics())
        {
            Rectangle screen = Screen.PrimaryScreen.WorkingArea;
            SizeF sizeF = g.MeasureString(text, lblPrompt.Font, screen.Width - 20);
            size = sizeF.ToSize();
            size.Width += 4;
        }

        if (size.Width < 200)
        {
            size.Width = 200;
        }
        Size clientSize = this.ClientSize;
        clientSize.Width += size.Width - lblPrompt.Width;
        clientSize.Height += size.Height - lblPrompt.Height;
        this.ClientSize = clientSize;
        lblPrompt.Text = text;
        txtResult.Text = defaultValue;
        this.DialogResult = DialogResult.Cancel;
    }

    void CancelButtonClick(object sender, System.EventArgs e)
    {
        result = null;
        this.Close();
    }

    void AcceptButtonClick(object sender, System.EventArgs e)
    {
        this.DialogResult = DialogResult.OK;
        result = txtResult.Text;
        this.Close();
    }

    string result;

    public string Result
    {
        get
        {
            return result;
        }
    }
}