/// <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);
}
}