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...
===============================================================