/// <summary> /// Creaza lista cu departamente /// </summary> /// <param name="parinte"></param> /// <param name="nivel"></param> /// <param name="listObj"></param> public void CreateDepartamenteSelectBox(int parinte, int nivel, DropDownList listObj) { string connStr = Salaries.Configuration.ModuleConfig.GetSettings().ConnectionString; SqlConnection m_con = new SqlConnection(connStr); SqlCommand myCommand = new SqlCommand("GetDepartamente", m_con); myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@DeptParinte", SqlDbType.Int, 4, parinte)); myCommand.CommandType = CommandType.StoredProcedure; SqlDataAdapter dAdapt = new SqlDataAdapter(myCommand); DataSet ds = new DataSet(); dAdapt.Fill(ds); DataTable myTable = new DataTable(); myTable = ds.Tables[0]; string nivel_text = ""; for (int j = 0; j < nivel; j++) { nivel_text += ". . "; } for (int i = 0; i < myTable.Rows.Count; i++) { DataRow myRow = myTable.Rows[i]; ListItem myItem = new ListItem(nivel_text + myRow["nume"].ToString(), myRow["DepartamentID"].ToString()); listObj.Items.Add(myItem); nivel++; CreateDepartamenteSelectBox(Convert.ToInt32(myRow["DepartamentID"]), nivel, listObj); nivel--; } }
/// <summary> /// Creaza lista cu training-uri externe /// </summary> /// <param name="listObj"></param> public void CreateExternalTrainingSelectBox(DropDownList listObj) { string connStr = Salaries.Configuration.ModuleConfig.GetSettings().ConnectionString; SqlConnection m_con = new SqlConnection(connStr); SqlCommand myCommand = new SqlCommand("spGetTrainingDupaTip", m_con); myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@TipTraining", SqlDbType.Int, 4, 0)); myCommand.CommandType = CommandType.StoredProcedure; SqlDataAdapter dAdapt = new SqlDataAdapter(myCommand); DataSet ds = new DataSet(); dAdapt.Fill(ds); DataTable myTable = new DataTable(); myTable = ds.Tables[0]; listObj.Items.Clear(); for (int i = 0; i < myTable.Rows.Count; i++) { DataRow myRow = myTable.Rows[i]; ListItem myItem = new ListItem(myRow["Nume"].ToString(), myRow["TrainingID"].ToString()); listObj.Items.Add(myItem); } }