ProitOpslaan

using System;
using System.Collections.Generic;
using System.Linq;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Web.Security;
using System.Data.SqlClient;
using System.Web.Configuration;
using System.Diagnostics;
using System.Data.OleDb;


public partial class Formulier : System.Web.UI.Page
{
    static int domarraylengt;
    static int critarraylengt;
    static int rdbhelpteller;
    static ImageButton[] btn_arr = new ImageButton[1];

    SqlConnection con;
    SqlCommand cmd;
    SqlDataReader dr;

    static int btn_count;
    static int lbl_count;
    static int rdb_count;

    protected void Page_Load(object sender, EventArgs e)
    {

    }

    protected void add_button(ImageButton button)
    {
            //add to a container on the page
            pnlMain.Controls.Add(button);
            //add a spacer after the control
            pnlMain.Controls.Add(new LiteralControl("<br>"));
    }
    protected void add_label(Label label)
    {
            //add to a container on the page
            pnlMain.Controls.Add(label);
            //add a spacer after the control
            pnlMain.Controls.Add(new LiteralControl("<br>"));

    }
    protected void add_rdb(RadioButtonList rdb)
    {
            //add to a container on the page
            pnlMain.Controls.Add(rdb);
            //add a spacer after the control
            pnlMain.Controls.Add(new LiteralControl("<br>"));

    }
    protected void opvullen()
    {
        string modid;
        int domid;
        modid = ddlModel.SelectedValue;

        //Connection string.
        string connstring = ConfigurationManager.ConnectionStrings["Connection"].ConnectionString;
        con = new SqlConnection(connstring);
        con.Open();

        //sql code voor lengte van label array.
        SqlCommand cmd = new SqlCommand("SELECT COUNT (*) FROM Domein WHERE Mod_ID = " + modid + " ", con);
        domarraylengt = (int)cmd.ExecuteScalar();

        Label[] lbl_arr = new Label[domarraylengt];

        //sql code voor radiobuttonlist array.
        SqlCommand cmd3 = new SqlCommand("SELECT Dom_ID FROM Domein WHERE Mod_ID = " + modid + " ", con);
        domid = (int)cmd3.ExecuteScalar();

        //sql code voor radiobuttonlist array.
        SqlCommand cmd4 = new SqlCommand("SELECT COUNT(*) FROM Criterium WHERE Dom_ID = '" + domid + "' ", con);
        rdbhelpteller = (int)cmd4.ExecuteScalar();

        RadioButtonList[] rdb_arr = new RadioButtonList[rdbhelpteller];

        if (btn_arr[0] is ImageButton)
        {
            //for each button saved in our array, recreate it
            foreach (ImageButton button in btn_arr)
            {
                add_button(button);
            }
        }
        if (lbl_arr[0] is Label)
        {
            foreach (Label label in lbl_arr)
            {
                add_label(label);
            }
        }
        if (rdb_arr[0] is RadioButtonList)
        {
            foreach (RadioButtonList rdb in rdb_arr)
            {
                add_rdb(rdb);
            }
        }
    }

    protected void ddlModel_SelectedIndexChanged(object sender, EventArgs e)
    {
        string modid;
        string modnaam;
        int teller;
        int pxteller;
        modid = ddlModel.SelectedValue;
        pxteller = 0;
        teller = 0;
        lblError.Text = "";

        if (modid == "0")
        {
            lblError.Text = "*Selecteer een model";
            pnlMain.BackImageUrl = "~/Images/VoorbeeldFormulierTest.jpg";
            pnlMain.Height = 650;
        }
        else
        {
            pnlMain.BackImageUrl = "~/Images/FormulierTest.jpg";

            //Connection string.
            string connstring = ConfigurationManager.ConnectionStrings["Connection"].ConnectionString;
            con = new SqlConnection(connstring);
            con.Open();

            SqlCommand cmd6 = new SqlCommand("SELECT Mod_Naam FROM Model WHERE Mod_ID = " + modid + " ", con);
            modnaam = (string)cmd6.ExecuteScalar();

            Label lblopmaak = new Label();
            lblopmaak.Text = "";
            lblopmaak.Font.Size = 45;
            add_label(lblopmaak);
            pxteller += 40;

            add_label(lblopmaak);
            pxteller += 40;

            Label lblmodel = new Label();
            lblmodel.Text = modnaam;
            lblmodel.ID = "lblmodel";
            lblmodel.Font.Bold = true;
            lblmodel.Font.Name = "Century Schoolbook";
            //lblmodel.Font.Underline = true;
            lblmodel.Font.Size = 22;
            add_label(lblmodel);
            pxteller += 22;

            add_label(lblopmaak);
            pxteller += 40;

            add_label(lblopmaak);
            pxteller += 40;

            //-------------------------Begin Domein---------------------------

            //sql code voor het weergeven van de huidige data van model.
            SqlCommand cmd = new SqlCommand("SELECT COUNT (*) FROM Domein WHERE Mod_ID = " + modid + " ", con);
            domarraylengt = (int)cmd.ExecuteScalar();

            string[] arr_DomNaamLijst = new string[domarraylengt + 1];
            string[] arr_DomOmschrijvingLijst = new string[domarraylengt + 1];
            Label[] lbldomnaam_arr = new Label[domarraylengt];
            Label[] lbldomomschrijving_arr = new Label[domarraylengt];
            Label[] lblhulpje_arr = new Label[domarraylengt];

            //sql code voor het weergeven van de huidige data van model.
            SqlCommand cmd1 = new SqlCommand("SELECT * FROM Domein WHERE Mod_ID = " + modid + " ", con);
            dr = cmd1.ExecuteReader();

            while (dr.Read())
            {
                arr_DomNaamLijst[teller] = dr["Dom_Naam"].ToString(); ;
                arr_DomOmschrijvingLijst[teller] = dr["Dom_Omschrijving"].ToString();
                teller++;
            }

            dr.Close();

            lbl_count = 0;
            teller = 0;

            while (teller < domarraylengt)
            {

                Label lbldomnaam = new Label();
                lbldomnaam.Text = arr_DomNaamLijst[teller];
                lbldomnaam.ID = "lbldomnaam" + teller;
                lbldomnaam.Font.Bold = true;
                lbldomnaam.Font.Underline = true;
                lbldomnaam.Font.Size = 14;
                lbldomnaam_arr[lbl_count] = lbldomnaam;
                add_label(lbldomnaam);
                pxteller += 14;

                Label lbldomom = new Label();
                lbldomom.Text = "Omschrijving : '" + arr_DomOmschrijvingLijst[teller] + "'";
                lbldomom.ID = "lbldomom" + teller;
                lbldomom.Font.Size = 10;
                lbldomom.Font.Italic = true;
                lbldomomschrijving_arr[lbl_count] = lbldomom;
                add_label(lbldomom);
                pxteller += 10;

                //hulp voor het toevoegen van spatie tussen Domein en Criterium (opmaak)
                Label lblhulp = new Label();
                lblhulp.Text = " ";
                lblhulp.ID = "hulpje" + teller;
                lblhulpje_arr[lbl_count] = lblhulp;
                add_label(lblhulp);
                pxteller += 12;

                //-----------------------------CRITERIUMS-BEGIN------------------------------

                int domid;
                int teller2;
                int rdbteller;
                int rdbteller1;
                rdbteller1 = 0;

                //sql code voor het selecteren van de huidige data van model.
                SqlCommand cmd2 = new SqlCommand("SELECT Dom_ID FROM Domein WHERE Dom_Naam = '" + lbldomnaam.Text + "' AND Mod_ID = " + modid + " ", con);
                domid = (int)cmd2.ExecuteScalar();

                //sql code voor het tellen van de huidige data van model.
                SqlCommand cmd3 = new SqlCommand("SELECT COUNT (*) FROM Criterium WHERE Dom_ID = " + domid + " ", con);
                critarraylengt = (int)cmd3.ExecuteScalar();

                string[] arr_CritNaamLijst = new string[critarraylengt + 1];
                string[] arr_CritOmschrijvingLijst = new string[critarraylengt + 1];
                Label[] lblcritnaam_arr = new Label[critarraylengt + 1];
                Label[] lblcritomschrijving_arr = new Label[critarraylengt + 1];

                //sql code voor het weergeven van de huidige data van model.
                SqlCommand cmd4 = new SqlCommand("SELECT * FROM Criterium WHERE Dom_ID = " + domid + " ", con);
                dr = cmd4.ExecuteReader();

                teller2 = 0;

                while (dr.Read())
                {
                    arr_CritNaamLijst[teller2] = dr["Crit_Naam"].ToString(); ;
                    arr_CritOmschrijvingLijst[teller2] = dr["Crit_Omschrijving"].ToString();
                    teller2++;
                }

                dr.Close();

                teller2 = 0;

                while (teller2 < critarraylengt)
                {
                    Label lblcritnaam = new Label();
                    lblcritnaam.Text = "- Criterium : " + arr_CritNaamLijst[teller2] + "-";
                    lblcritnaam.ID = "lblcritnaam" + teller + teller2;
                    lblcritnaam.Font.Bold = true;
                    lblcritnaam.Font.Size = 10;
                    lblcritnaam_arr[lbl_count] = lblcritnaam;
                    add_label(lblcritnaam);
                    pxteller += 10;

                    Label lblcritom = new Label();
                    lblcritom.Text = "Omschrijving : '" + arr_CritOmschrijvingLijst[teller2] + "'";
                    lblcritom.Font.Size = 8;
                    lblcritom.Font.Italic = true;
                    lblcritom.ID = "lblcritom" + teller + teller2;
                    lblcritomschrijving_arr[lbl_count] = lblcritom;
                    add_label(lblcritom);
                    pxteller += 8;

                    //---------------------------------Radiobuttons-Begin------------------------

                    //sql code voor het tellen van de huidige data van model.
                    SqlCommand cmd5 = new SqlCommand("SELECT Crit_Scoremodel FROM Criterium WHERE Crit_Naam = '" + arr_CritNaamLijst[teller2] + "' AND Dom_ID = " + domid + " ", con);
                    rdbteller = (int)cmd5.ExecuteScalar();

                    switch (rdbteller)
                    {
                        case 1:
                            rdbteller1 = 5;
                            break;
                        case 2:
                            rdbteller1 = 7;
                            break;
                        case 3:
                            rdbteller1 = 10;
                            break;
                    }

                    string[] arr_RadioButtonList = new string[rdbteller1];
                    RadioButtonList[] rdb_arr = new RadioButtonList[rdbteller1];

                    int teller3;
                    teller3 = 0;
                    rdb_count = 0;

                      RadioButtonList rdbradiobuttonlist = new RadioButtonList();
                      //ID uitleg = eerste cijver van dom, 2e van crit, 3e van rdblijst
                      rdbradiobuttonlist.ID = "rdblistcrit" + teller + teller2;
                      rdbradiobuttonlist.RepeatDirection = RepeatDirection.Horizontal;
                      rdb_arr[rdb_count] = rdbradiobuttonlist;

                      while (teller3 < rdbteller1) {

                          //RadioButton rdbradiobutton = new RadioButton();
                          //ID uitleg = eerste cijver van dom, 2e van crit, 3e van rdblijst, 4e van score rdb
                          //rdbradiobutton.ID = "rdblistcrit" + teller + teller2 + teller3;
                          //int texthulp = teller3 + 1;
                          //rdbradiobutton.Text = "" + texthulp;
                          int id = teller3 + 1;
                          //rdbradiobuttonlist.Controls.Add(rdbradiobutton);
                          rdbradiobuttonlist.Items.Add("" + id);
                          teller3++;
                          pxteller += 11;
                      }

                        add_rdb(rdbradiobuttonlist);
                        rdb_count++;
                        teller3++;
                    //---------------------------------Radiobuttons-Einde------------------------

                    teller2++;
                }
                //-----------------------------CRITERIUMS-EINDE------------------------------


                //-----------------------------SpatieVoorLayout------------------------------
                Label lblspatie = new Label();
                lblspatie.Text = " ";
                lblspatie.ID = "lblspatie" + teller;
                lbldomomschrijving_arr[lbl_count] = lblspatie;
                add_label(lblspatie);
                pxteller += 11;
                //-----------------------------SpatieVoorLayout------------------------------


                lbl_count++;
                teller++;
                opvullen();
            }

            ImageButton[] btnopslaan_arr = new ImageButton[1];

            ImageButton btnOpslaan = new ImageButton();
            btnOpslaan.ImageUrl = "~/Images/Opslaan.gif";
            btnOpslaan.ID = "btnOpslaan";
            btnOpslaan.Click += new ImageClickEventHandler(buttonOpslaan_Click);
            btnopslaan_arr[btn_count] = btnOpslaan;
            add_button(btnOpslaan);
            pnlMain.Height = pxteller += 11;

            con.Close();
        }
    }
    protected void buttonOpslaan_Click(object sender, EventArgs e)
    {


    }
    protected void btnop_Click(object sender, EventArgs e)
    {
        int teller = 0;

        foreach (Control RBL in pnlMain.Controls)
        {
            if (RBL is RadioButtonList)
            {
                foreach (Control Ctrl in (RBL as RadioButtonList).Controls)
                {
                    if (Ctrl is RadioButton && (Ctrl as RadioButton).Checked)
                    {
                        RadioButton RBCtrl = Ctrl as RadioButton;
                    }
                }
                teller++;
            }
        }

        Debug.WriteLine(teller);
    }
}