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 = ""; } }
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 = ""; } }
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); } }
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); } }