//private ArrayList GetDummyData1() //{ // DataTable DTTeam = objCls.GetTeam(); // //if (DTTeam.Rows.Count >0 ) // //{ // //arr1.Add(new ListItem(Convert.ToString(DTTeam.Rows[0]["TeamName"]), "1")); // //arr1.Add(new ListItem("Team-B", "2")); // //arr1.Add(new ListItem("Team-C", "3")); // //arr1.Add(new ListItem("Team-D", "4")); // //arr1.Add(new ListItem("Team-E", "5")); // //arr1.Add(new ListItem("Team-F", "6")); // //} // foreach (DataRow row in DTTeam.Rows) // { // //arr1.Add(new ListItem(row["TeamName"].ToString(), row["TeamID"].ToString())); // dd2.Items.Add(new ListItem(row["TeamName"].ToString(), row["TeamID"].ToString())); // dd2.Items.Add(item1); // } // return arr1; //} private void FillDropDownList2(DropDownList dd2) { //DataTable DTTeam = objCls.GetTeam(); DataTable DTTeam = objBSS.GetTeamList(); foreach (DataRow row in DTTeam.Rows) { //arr1.Add(new ListItem(row["TeamName"].ToString(), row["TeamID"].ToString())); dd2.Items.Add(new ListItem(row["TeamName"].ToString(), row["TeamID"].ToString())); } }
private void LoadMyCombos(string click) { try { objBL.loadAssignedDepartment(cmbAssignedDepartment, "Follow"); objBL.LoadComplainStatus(cmbComplainStatus, "Follow"); cmbComplainStatus.SelectedValue = "4"; if (Convert.ToInt32(Session["DeptID"]) == 15 | Convert.ToInt32(Session["DeptID"]) == 1) { cmbAssignedDepartment.Enabled = true; } if (Convert.ToInt32(Session["DepartmentID"]).Equals(1) || Convert.ToInt32(Session["DepartmentID"]).Equals(58) || Convert.ToInt32(Session["DepartmentID"]).Equals(59) || Convert.ToInt32(Session["DepartmentID"]).Equals(60)) { pnlEscalation.Visible = true; DataTable DTTeam = objBSS.GetTeamList(); cmbTeam.DataSource = DTTeam; cmbTeam.DataTextField = "TeamName"; cmbTeam.DataValueField = "TeamID"; //cmbTeam.Items.Insert(0, new DropDownList("Please Select", "0")); cmbTeam.DataBind(); //DataTable DTPriority = objCls.GetPriority(); DataTable DTPriority = objBSS.GetTeamPrioirty(); cmbPriority.DataSource = DTPriority; cmbPriority.DataTextField = "OMPriorityName"; cmbPriority.DataValueField = "OMPriorityID"; //cmbPriority.Items.Insert(0, new RadComboBoxItem("Please Select", "0")); cmbPriority.DataBind(); } else { cmbTeam.SelectedValue = "0"; cmbPriority.SelectedValue = "0"; pnlEscalation.Visible = false; } } catch (Exception ex) { throw ex; } }
private void SetInitialRow() { int SignupID = 0; int City = 0; int node = 0; string team = ""; if (txtSignUpID.Text != "") { SignupID = Convert.ToInt32(txtSignUpID.Text); } if (cmbCity.SelectedValue != "0") { City = Convert.ToInt32(cmbCity.SelectedValue); } if (cmbNode.SelectedValue != "0") { node = Convert.ToInt32(cmbNode.SelectedValue); } System.DateTime sysdate = DateTime.MinValue; DataTable dt_SearchComplainCirciuits = objBSS.SearchComplainCircuits("", SignupID, "", "", "", "", 4, City, 0, "", 0, 0, 0, 0, sysdate, sysdate, 0, Convert.ToInt32(Session["DepartmentID"]), node, 0, "OM", 0, 0, 0, 0, 0); DataTable DTTeam = objBSS.GetTeamList(); GVTeam.DataSource = dt_SearchComplainCirciuits; GVTeam.DataBind(); //Store the DataTable in ViewState for future reference ViewState["CurrentTable"] = dt_SearchComplainCirciuits; //Bind the Gridview GVTeam.DataSource = dt_SearchComplainCirciuits; GVTeam.DataBind(); dtForExcel = new DataTable(); dtForExcel = dt_SearchComplainCirciuits; //After binding the gridview, we can then extract and fill the DropDownList with Data for (int i = 0; i < dt_SearchComplainCirciuits.Rows.Count; i++) { DropDownList ddl1 = (DropDownList)GVTeam.Rows[i].Cells[1].FindControl("DropDownList1"); DropDownList ddl2 = (DropDownList)GVTeam.Rows[i].Cells[2].FindControl("DropDownList2"); FillDropDownList(ddl2); FillDropDownList2(ddl1); if (dt_SearchComplainCirciuits.Rows[i]["TeamName"].ToString() != "N/A") { foreach (DataRow row in DTTeam.Rows) { if (row["TeamName"].ToString() == dt_SearchComplainCirciuits.Rows[i]["TeamName"].ToString()) { team = row["TeamID"].ToString(); } } ddl1.SelectedValue = team; ddl2.SelectedValue = dt_SearchComplainCirciuits.Rows[i]["Priority"].ToString(); } } }