Ejemplo n.º 1
0
        protected void Button1_Click(object sender, EventArgs e)
        {
            String     selectColumnName        = DropDownSelectCol1.SelectedValue;
            String     selectTableName         = DropDownPKTb2.SelectedItem.Text;
            String     selectAggregateFuncName = DropDownList4.SelectedItem.Text;
            String     myQuery       = "Select " + selectAggregateFuncName + "(" + selectColumnName + ") AS 'QUERY_RESULT' From " + selectTableName + " B1";
            DBQueUtils dbQueUtilsObj = new DBQueUtils();

            myQuery = dbQueUtilsObj.leftJoinQueryAppender(DropDownFKTb2, FKCol2, PKCol2, myQuery, "A1");
            myQuery = dbQueUtilsObj.leftJoinQueryAppender(DropDownFKTb3, FKCol3, PKCol3, myQuery, "A2");
            myQuery = dbQueUtilsObj.leftJoinQueryAppender(DropDownFKTb4, FKCol4, PKCol4, myQuery, "A3");
            myQuery = dbQueUtilsObj.leftJoinQueryAppender(DropDownFKTb5, FKCol5, PKCol5, myQuery, "A4");
            myQuery = dbQueUtilsObj.leftJoinQueryAppender(DropDownFKTb6, FKCol6, PKCol6, myQuery, "A5");
            myQuery = dbQueUtilsObj.leftJoinQueryAppender(DropDownFKTb7, FKCol7, PKCol7, myQuery, "A6");
            myQuery = dbQueUtilsObj.leftJoinQueryAppender(DropDownFKTb8, FKCol8, PKCol8, myQuery, "A7");
            myQuery = dbQueUtilsObj.leftJoinQueryAppender(DropDownFKTb9, FKCol9, PKCol9, myQuery, "A8");
            myQuery = dbQueUtilsObj.leftJoinQueryAppender(DropDownFKTb10, FKCol10, PKCol10, myQuery, "A9");
            myQuery = dbQueUtilsObj.leftJoinQueryAppender(DropDownFKTb11, FKCol11, PKCol11, myQuery, "A10");

            List <DropDownList> ddWhereTableList          = getListOfWhereTables();
            List <DropDownList> ddWhereDisplayColumnsList = getListOfWhereColumns();
            List <Label>        lblPKWhereColumnList      = getListOfPkColumnList();
            List <Label>        lblSelectedColumnIDList   = getListOfWhereSelectedIdList();
            List <CheckBox>     chBxAskUserList           = getListOfAskUsers();
            List <TextBox>      txtBxHeadingLabel         = getListOfHeadingWhereTable();

            List <String> whereClauseList = new List <String>();

            for (int i = 0; i < ddWhereTableList.Count; i++)
            {
                if (ddWhereTableList[i].SelectedItem != null && ddWhereTableList[i].SelectedItem.Value != "")
                {
                    if (chBxAskUserList[i].Checked)
                    {
                        whereClauseList.Add(lblPKWhereColumnList[i].Text
                                            + " = { id: \"" + (i + 1) + "\","
                                            + " tableName: \"" + ddWhereTableList[i].SelectedItem.Text + "\","
                                            + " alias: \"" + ddWhereTableList[i].SelectedItem.Value + "\","
                                            + " pkColumnName: \"" + lblPKWhereColumnList[i].Text.Split('.')[1] + "\","
                                            + " displayColumn: \"" + ddWhereDisplayColumnsList[i].SelectedItem.Text + "\","
                                            + " headingLabel: \"" + txtBxHeadingLabel[i].Text + "\" }");
                    }
                    else
                    {
                        whereClauseList.Add(lblPKWhereColumnList[i].Text + " = " + lblSelectedColumnIDList[i].Text);
                    }
                }
            }

            if (whereClauseList.Count > 0)
            {
                myQuery += " Where " + whereClauseList[0];
            }
            for (int i = 1; i < whereClauseList.Count; i++)
            {
                myQuery += " AND " + whereClauseList[i];
            }

            queryOutput.Text = myQuery;
        }
Ejemplo n.º 2
0
        protected void changeAskUserWhereClause(object sender, EventArgs e)
        {
            DBQueUtils          dbQueUtilsObj              = new DBQueUtils();
            int                 lastIndex                  = dbQueUtilsObj.getIndexOfCheckBoxList(sender) - 1;
            List <DropDownList> ddWhereTableList           = getListOfWhereTables();
            List <DropDownList> ddWhereColumnValueList     = getListOfWhereColumnValues();
            List <TextBox>      txbBxHeadingWhereTableList = getListOfHeadingWhereTable();
            List <Label>        lblWhereSelectedColumnId   = getListOfWhereSelectedIdList();

            if (((CheckBox)sender).Checked)
            {
                ddWhereColumnValueList[lastIndex].Visible     = false;
                lblWhereSelectedColumnId[lastIndex].Visible   = false;
                txbBxHeadingWhereTableList[lastIndex].Enabled = true;
                if (txbBxHeadingWhereTableList[lastIndex].Text == "")
                {
                    txbBxHeadingWhereTableList[lastIndex].Text = ddWhereTableList[lastIndex].SelectedItem.Text.Replace("_", " ");
                }
            }
            else
            {
                ddWhereColumnValueList[lastIndex].Visible     = true;
                lblWhereSelectedColumnId[lastIndex].Visible   = true;
                txbBxHeadingWhereTableList[lastIndex].Enabled = false;
            }
        }
Ejemplo n.º 3
0
        protected void ddlProgram_SelectedIndexChanged(object sender, EventArgs e)
        {
            DBQueUtils dbQueUtilsObj = new DBQueUtils();

            dbQueUtilsObj.changeInitOfSelectTableList(DropDownFKTb2, FKCol2,
                                                      DropDownPKTb2, selectTablePKName2, PKCol2, DropDownFKTb2, DropDownPKTb2, DropDownSelectCol1, "A1", "B1");
            changeOfPKFKTable(2);
        }
Ejemplo n.º 4
0
        private void initDbQuery()
        {
            DBQueUtils dbQueUtilsObj = new DBQueUtils();

            dbQueUtilsObj.fillSelectTableList(DropDownPKTb2, "B1");
            dbQueUtilsObj.changeInitOfSelectTableList(DropDownFKTb2, FKCol2,
                                                      DropDownPKTb2, selectTablePKName2, PKCol2, DropDownFKTb2, DropDownPKTb2, DropDownSelectCol1, "A1", "B1");
            dbQueUtilsObj.fillSelectAggregateFuncList(DropDownList4);
        }
Ejemplo n.º 5
0
        protected void ddlWhere_SelectedColumnValueChanged(object sender, EventArgs e)
        {
            DBQueUtils          dbQueUtilsObj              = new DBQueUtils();
            int                 lastIndex                  = dbQueUtilsObj.getIndexOfDDList(sender) - 1;
            List <DropDownList> ddWhereColumnValueList     = getListOfWhereColumnValues();
            List <Label>        lblWhereSelectedColumnList = getListOfWhereSelectedIdList();

            if (ddWhereColumnValueList[lastIndex] != null && ddWhereColumnValueList[lastIndex].SelectedItem != null)
            {
                lblWhereSelectedColumnList[lastIndex].Text = ddWhereColumnValueList[lastIndex].SelectedItem.Value;
            }
            else
            {
                lblWhereSelectedColumnList[lastIndex].Text = "";
            }
        }
Ejemplo n.º 6
0
        protected void ddlWhere_SelectedIndexChanged(object sender, EventArgs e)
        {
            DBQueUtils          dbQueUtilsObj              = new DBQueUtils();
            int                 lastIndex                  = dbQueUtilsObj.getIndexOfDDList(sender) - 1;
            List <DropDownList> ddWhereTableList           = getListOfWhereTables();
            List <DropDownList> ddWhereColumnsList         = getListOfWhereColumns();
            List <DropDownList> ddWhereColumnValueList     = getListOfWhereColumnValues();
            List <Label>        lblSelectedColumnIdList    = getListOfWhereSelectedIdList();
            List <Label>        lblPKColumnList            = getListOfPkColumnList();
            List <CheckBox>     cbAskUserList              = getListOfAskUsers();
            List <TextBox>      txbBxHeadingWhereTableList = getListOfHeadingWhereTable();

            if (ddWhereTableList[lastIndex].SelectedValue != "")
            {
                dbQueUtilsObj.fillSelectTableColumList(ddWhereColumnsList[lastIndex], ddWhereTableList[lastIndex], ddWhereTableList[lastIndex].SelectedValue);
                dbQueUtilsObj.fillSelectedColumnValues(ddWhereTableList[lastIndex], ddWhereColumnsList[lastIndex], ddWhereColumnValueList[lastIndex]);
                if (ddWhereColumnValueList[lastIndex] != null && ddWhereColumnValueList[lastIndex].SelectedItem != null)
                {
                    lblSelectedColumnIdList[lastIndex].Text = ddWhereColumnValueList[lastIndex].SelectedItem.Value;
                }
                else
                {
                    lblSelectedColumnIdList[lastIndex].Text = "";
                }
                DBQueDao dbQueDaoObj = new DBQueDao();
                String   pkColName   = dbQueDaoObj.getPKColumnByTableName(ddWhereTableList[lastIndex].SelectedItem.Text);
                lblPKColumnList[lastIndex].Text = ddWhereTableList[lastIndex].SelectedValue + "." + pkColName;
            }
            else
            {
                //do empty other dropdowns and fields
                ddWhereColumnsList[lastIndex].Items.Clear();
                cbAskUserList[lastIndex].Checked = false;
                ddWhereColumnValueList[lastIndex].Items.Clear();
                lblSelectedColumnIdList[lastIndex].Text    = "";
                lblPKColumnList[lastIndex].Text            = "";
                txbBxHeadingWhereTableList[lastIndex].Text = "";
            }
        }
Ejemplo n.º 7
0
        protected void ddlProgram_SelectedIndexChangedPKTable(object sender, EventArgs e)
        {
            DBQueUtils          dbQueUtilsObj = new DBQueUtils();
            int                 lastIndex     = dbQueUtilsObj.getIndexOfDDList(sender);
            bool                emptySelected = ((DropDownList)sender).SelectedValue == String.Empty ? true : false;
            List <DropDownList> ddPKList      = new List <DropDownList>();

            ddPKList.Add(new DropDownList());
            ddPKList.Add(new DropDownList());
            ddPKList.Add(new DropDownList());
            ddPKList.Add(DropDownPKTb3);
            ddPKList.Add(DropDownPKTb4);
            ddPKList.Add(DropDownPKTb5);
            ddPKList.Add(DropDownPKTb6);
            ddPKList.Add(DropDownPKTb7);
            ddPKList.Add(DropDownPKTb8);
            ddPKList.Add(DropDownPKTb9);
            ddPKList.Add(DropDownPKTb10);

            List <DropDownList> ddFKList = new List <DropDownList>();

            ddFKList.Add(new DropDownList());
            ddFKList.Add(new DropDownList());
            ddFKList.Add(new DropDownList());
            ddFKList.Add(DropDownFKTb3);
            ddFKList.Add(DropDownFKTb4);
            ddFKList.Add(DropDownFKTb5);
            ddFKList.Add(DropDownFKTb6);
            ddFKList.Add(DropDownFKTb7);
            ddFKList.Add(DropDownFKTb8);
            ddFKList.Add(DropDownFKTb9);
            ddFKList.Add(DropDownFKTb10);

            List <Label> lblPKList = new List <Label>();

            lblPKList.Add(new Label());
            lblPKList.Add(new Label());
            lblPKList.Add(new Label());
            lblPKList.Add(PKCol3);
            lblPKList.Add(PKCol4);
            lblPKList.Add(PKCol5);
            lblPKList.Add(PKCol6);
            lblPKList.Add(PKCol7);
            lblPKList.Add(PKCol8);
            lblPKList.Add(PKCol9);
            lblPKList.Add(PKCol10);

            List <Label> lblFKList = new List <Label>();

            lblFKList.Add(new Label());
            lblFKList.Add(new Label());
            lblFKList.Add(new Label());
            lblFKList.Add(FKCol3);
            lblFKList.Add(FKCol4);
            lblFKList.Add(FKCol5);
            lblFKList.Add(FKCol6);
            lblFKList.Add(FKCol7);
            lblFKList.Add(FKCol8);
            lblFKList.Add(FKCol9);
            lblFKList.Add(FKCol10);

            dbQueUtilsObj.ddlPKChangeAction(lastIndex, ddPKList, ddFKList, lblPKList, lblFKList);

            if (emptySelected == false)
            {
                changeOfPKFKTable(lastIndex);
            }
        }
Ejemplo n.º 8
0
        protected void fillTableListForWhereClause()
        {
            List <ListItem> listItems     = new List <ListItem>();
            DBQueUtils      dbQueUtilsObj = new DBQueUtils();

            if (DropDownPKTb2 != null && DropDownPKTb2.SelectedItem != null && DropDownPKTb2.SelectedItem.Value != "")
            {
                listItems = dbQueUtilsObj.fillWhereClauseDropDownTable(DropDownPKTb2, "B1", listItems);
            }
            if (DropDownFKTb2 != null && DropDownFKTb2.SelectedItem != null && DropDownFKTb2.SelectedItem.Value != "")
            {
                listItems = dbQueUtilsObj.fillWhereClauseDropDownTable(DropDownFKTb2, "A1", listItems);
            }
            if (DropDownFKTb3 != null && DropDownFKTb3.SelectedItem != null && DropDownFKTb3.SelectedItem.Value != "")
            {
                listItems = dbQueUtilsObj.fillWhereClauseDropDownTable(DropDownFKTb3, "A2", listItems);
            }
            if (DropDownFKTb4 != null && DropDownFKTb4.SelectedItem != null && DropDownFKTb4.SelectedItem.Value != "")
            {
                listItems = dbQueUtilsObj.fillWhereClauseDropDownTable(DropDownFKTb4, "A3", listItems);
            }
            if (DropDownFKTb5 != null && DropDownFKTb5.SelectedItem != null && DropDownFKTb5.SelectedItem.Value != "")
            {
                listItems = dbQueUtilsObj.fillWhereClauseDropDownTable(DropDownFKTb5, "A4", listItems);
            }
            if (DropDownFKTb6 != null && DropDownFKTb6.SelectedItem != null && DropDownFKTb6.SelectedItem.Value != "")
            {
                listItems = dbQueUtilsObj.fillWhereClauseDropDownTable(DropDownFKTb6, "A5", listItems);
            }
            if (DropDownFKTb7 != null && DropDownFKTb7.SelectedItem != null && DropDownFKTb7.SelectedItem.Value != "")
            {
                listItems = dbQueUtilsObj.fillWhereClauseDropDownTable(DropDownFKTb7, "A6", listItems);
            }
            if (DropDownFKTb8 != null && DropDownFKTb8.SelectedItem != null && DropDownFKTb8.SelectedItem.Value != "")
            {
                listItems = dbQueUtilsObj.fillWhereClauseDropDownTable(DropDownFKTb8, "A7", listItems);
            }
            if (DropDownFKTb9 != null && DropDownFKTb9.SelectedItem != null && DropDownFKTb9.SelectedItem.Value != "")
            {
                listItems = dbQueUtilsObj.fillWhereClauseDropDownTable(DropDownFKTb9, "A8", listItems);
            }
            if (DropDownFKTb10 != null && DropDownFKTb10.SelectedItem != null && DropDownFKTb10.SelectedItem.Value != "")
            {
                listItems = dbQueUtilsObj.fillWhereClauseDropDownTable(DropDownFKTb10, "A9", listItems);
            }
            if (DropDownFKTb11 != null && DropDownFKTb11.SelectedItem != null && DropDownFKTb11.SelectedItem.Value != "")
            {
                listItems = dbQueUtilsObj.fillWhereClauseDropDownTable(DropDownFKTb11, "A10", listItems);
            }

            List <DropDownList> ddWhereTableList = getListOfWhereTables();

            foreach (DropDownList ddItem in ddWhereTableList)
            {
                fillWhereTableData(listItems, ddItem);
            }
            //dbQueUtilsObj.fillPKTableList(DropDownWhereTable1, listItems);
            //if (DropDownWhereTable1.SelectedValue != "")
            //{
            //    dbQueUtilsObj.fillSelectTableColumList(DropDownWhereColumnList1, DropDownWhereTable1, DropDownWhereTable1.SelectedValue);
            //    dbQueUtilsObj.fillSelectedColumnValues(DropDownWhereTable1, DropDownWhereColumnList1, DropDownColumnValues1);
            //    if (DropDownColumnValues1 != null && DropDownColumnValues1.SelectedItem != null)
            //        SelectedColumnID1.Text = DropDownColumnValues1.SelectedItem.Value;
            //    else SelectedColumnID1.Text = "";
            //    DBQueDao dbQueDaoObj = new DBQueDao();
            //    String pkColName = dbQueDaoObj.getPKColumnByTableName(DropDownWhereTable1.SelectedItem.Text);
            //    pkColumnName1.Text = DropDownWhereTable1.SelectedValue + "." + pkColName;
            //}
        }
Ejemplo n.º 9
0
        private void changeOfPKFKTable(int lastIndex)
        {
            List <ListItem> listOfTables = new List <ListItem>();

            listOfTables.Add(new ListItem(String.Empty, String.Empty));
            DBQueUtils dbQueUtilsObj = new DBQueUtils();

            if (lastIndex >= 2)
            {
                listOfTables = dbQueUtilsObj.fillPKFKTableListItem(DropDownFKTb2, DropDownPKTb2, listOfTables);
                if (lastIndex == 2)
                {
                    dbQueUtilsObj.fillPKTableList(DropDownPKTb3, listOfTables);
                }
            }

            if (lastIndex >= 3)
            {
                listOfTables = dbQueUtilsObj.fillPKFKTableListItem(DropDownFKTb3, DropDownPKTb3, listOfTables);
                if (lastIndex == 3)
                {
                    dbQueUtilsObj.fillPKTableList(DropDownPKTb4, listOfTables);
                }
            }

            if (lastIndex >= 4)
            {
                listOfTables = dbQueUtilsObj.fillPKFKTableListItem(DropDownFKTb4, DropDownPKTb4, listOfTables);
                if (lastIndex == 4)
                {
                    dbQueUtilsObj.fillPKTableList(DropDownPKTb5, listOfTables);
                }
            }
            if (lastIndex >= 5)
            {
                listOfTables = dbQueUtilsObj.fillPKFKTableListItem(DropDownFKTb5, DropDownPKTb5, listOfTables);
                if (lastIndex == 5)
                {
                    dbQueUtilsObj.fillPKTableList(DropDownPKTb6, listOfTables);
                }
            }
            if (lastIndex >= 6)
            {
                listOfTables = dbQueUtilsObj.fillPKFKTableListItem(DropDownFKTb6, DropDownPKTb6, listOfTables);
                if (lastIndex == 6)
                {
                    dbQueUtilsObj.fillPKTableList(DropDownPKTb7, listOfTables);
                }
            }
            if (lastIndex >= 7)
            {
                listOfTables = dbQueUtilsObj.fillPKFKTableListItem(DropDownFKTb7, DropDownPKTb7, listOfTables);
                if (lastIndex == 7)
                {
                    dbQueUtilsObj.fillPKTableList(DropDownPKTb8, listOfTables);
                }
            }
            if (lastIndex >= 8)
            {
                listOfTables = dbQueUtilsObj.fillPKFKTableListItem(DropDownFKTb8, DropDownPKTb8, listOfTables);
                if (lastIndex == 8)
                {
                    dbQueUtilsObj.fillPKTableList(DropDownPKTb9, listOfTables);
                }
            }
            if (lastIndex >= 9)
            {
                listOfTables = dbQueUtilsObj.fillPKFKTableListItem(DropDownFKTb9, DropDownPKTb9, listOfTables);
                if (lastIndex == 9)
                {
                    dbQueUtilsObj.fillPKTableList(DropDownPKTb10, listOfTables);
                }
            }
            if (lastIndex >= 10)
            {
                listOfTables = dbQueUtilsObj.fillPKFKTableListItem(DropDownFKTb10, DropDownPKTb10, listOfTables);
                if (lastIndex == 10)
                {
                    dbQueUtilsObj.fillPKTableList(DropDownPKTb11, listOfTables);
                }
            }

            fillTableListForWhereClause();
        }
Ejemplo n.º 10
0
        protected void ddlProgram_SelectedIndexChangedFKTable(object sender, EventArgs e)
        {
            FKCol2.Text = DropDownFKTb2.SelectedItem.Value;
            DBQueDao   daoObj        = new DBQueDao();
            DBQueUtils dbQueUtilsObj = new DBQueUtils();

            PKCol2.Text = DropDownPKTb2.SelectedItem.Value.Split(' ')[1] + "." + daoObj.getPKFKColumnValue(DropDownFKTb2.SelectedItem.Text, DropDownPKTb2.SelectedItem.Text);
            int lastIndex = dbQueUtilsObj.getIndexOfDDList(sender);

            changeOfPKFKTable(lastIndex);
            if (lastIndex == 2)
            {
                PKCol3.Text = String.Empty;
                DropDownFKTb3.Items.Clear();
                FKCol3.Text = String.Empty;
            }

            if (lastIndex == 3)
            {
                FKCol3.Text = DropDownFKTb3.SelectedValue;
                PKCol3.Text = DropDownPKTb3.SelectedItem.Value.Split(' ')[1] + "." + daoObj.getPKFKColumnValue(DropDownFKTb3.SelectedItem.Text, DropDownPKTb3.SelectedItem.Text);
            }
            if (lastIndex == 4)
            {
                FKCol4.Text = DropDownFKTb4.SelectedValue;
                PKCol4.Text = DropDownPKTb4.SelectedItem.Value.Split(' ')[1] + "." + daoObj.getPKFKColumnValue(DropDownFKTb4.SelectedItem.Text, DropDownPKTb4.SelectedItem.Text);
            }
            if (lastIndex == 5)
            {
                FKCol5.Text = DropDownFKTb5.SelectedValue;
                PKCol5.Text = DropDownPKTb5.SelectedItem.Value.Split(' ')[1] + "." + daoObj.getPKFKColumnValue(DropDownFKTb5.SelectedItem.Text, DropDownPKTb5.SelectedItem.Text);
            }
            if (lastIndex == 6)
            {
                FKCol6.Text = DropDownFKTb6.SelectedValue;
                PKCol6.Text = DropDownPKTb6.SelectedItem.Value.Split(' ')[1] + "." + daoObj.getPKFKColumnValue(DropDownFKTb6.SelectedItem.Text, DropDownPKTb6.SelectedItem.Text);
            }
            if (lastIndex == 7)
            {
                FKCol7.Text = DropDownFKTb7.SelectedValue;
                PKCol7.Text = DropDownPKTb7.SelectedItem.Value.Split(' ')[1] + "." + daoObj.getPKFKColumnValue(DropDownFKTb7.SelectedItem.Text, DropDownPKTb7.SelectedItem.Text);
            }
            if (lastIndex == 8)
            {
                FKCol8.Text = DropDownFKTb8.SelectedValue;
                PKCol8.Text = DropDownPKTb8.SelectedItem.Value.Split(' ')[1] + "." + daoObj.getPKFKColumnValue(DropDownFKTb8.SelectedItem.Text, DropDownPKTb8.SelectedItem.Text);
            }
            if (lastIndex == 9)
            {
                FKCol9.Text = DropDownFKTb9.SelectedValue;
                PKCol9.Text = DropDownPKTb9.SelectedItem.Value.Split(' ')[1] + "." + daoObj.getPKFKColumnValue(DropDownFKTb9.SelectedItem.Text, DropDownPKTb9.SelectedItem.Text);
            }
            if (lastIndex == 10)
            {
                FKCol10.Text = DropDownFKTb10.SelectedValue;
                PKCol10.Text = DropDownPKTb10.SelectedItem.Value.Split(' ')[1] + "." + daoObj.getPKFKColumnValue(DropDownFKTb10.SelectedItem.Text, DropDownPKTb10.SelectedItem.Text);
            }
            if (lastIndex == 11)
            {
                FKCol11.Text = DropDownFKTb11.SelectedValue;
                PKCol11.Text = DropDownPKTb11.SelectedItem.Value.Split(' ')[1] + "." + daoObj.getPKFKColumnValue(DropDownFKTb11.SelectedItem.Text, DropDownPKTb11.SelectedItem.Text);
            }
        }