// inicializa uma estrutura com todas as médias por grupo por competência.
// passado
private void initMediasCompetencias()
{
String OsGrupos="";
String TempTable="";
mediasCompetencias = new List<MediasCompetencia>();
mediasCompetenciasSorted = new SortedList<int, MediasCompetencia>();
SqlConnection conn = new SqlConnection(DBHelper.ConnectionString);
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "Rep_v2_Media_Competencias";
command.Parameters.AddWithValue("avaliadoID", _pessoaID);
command.Parameters.AddWithValue("projectoID", _Projecto.ProjectoID);
foreach (String s in _Projecto.GroupsCodes)
{
OsGrupos += s + ",";
TempTable += String.Format("[{0}] float,", s);
}
OsGrupos = OsGrupos + "T";
TempTable += "[T] float";
command.Parameters.AddWithValue("grupos", OsGrupos);
command.Parameters.AddWithValue("TempTable", TempTable);
command.Parameters.AddWithValue("qualidadeSelf", _Projecto.GroupsCodes[0]);
SqlDataAdapter da = new SqlDataAdapter(command);
DataSet ds = new DataSet();
conn.Open();
da.Fill(ds);
conn.Close();
MediasCompetencia medias;
float[] valores = new float[ReportGroupCodes.Length]; // o +1 é porcausa do total
int compID;
foreach (DataRow dr in ds.Tables[0].Rows)
{
compID = Convert.ToInt32(dr["compID"]);
for (int i = 0; i < ReportGroupCodes.Length; i++)
{
valores[i] = Convert.IsDBNull(dr[ReportGroupCodes[i]]) ? 0 : (float)Convert.ToDouble(dr[ReportGroupCodes[i]]);
}
medias = new MediasCompetencia(compID, valores, ReportGroupCodes, ReportGroupDescriptions);
mediasCompetenciasSorted.Add(compID, medias);
mediasCompetencias.Add(medias);
}
}
private void initMediasDerailerOne2One()
{
mediasDerailers = new List<MediasCompetencia>();
mediasDerailersSorted = new SortedList<int, MediasCompetencia>();
SqlConnection conn = new SqlConnection(DBHelper.ConnectionString);
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "Rep_v2_Media_DerailersOne2One";
command.Parameters.AddWithValue("avaliadoID", _avaliado.PessoaID);
command.Parameters.AddWithValue("projectoID", _Projecto.ProjectoID);
command.Parameters.AddWithValue("proprioID", _proprio.PessoaID);
SqlDataAdapter da = new SqlDataAdapter(command);
DataSet ds = new DataSet();
conn.Open();
da.Fill(ds);
conn.Close();
MediasCompetencia medias;
float P, B, S, O, C, T;
int compID;
foreach (DataRow dr in ds.Tables[0].Rows)
{
compID = Convert.ToInt32(dr["compID"]);
B = Convert.IsDBNull(dr["B"]) ? 0 : (float)Convert.ToDouble(dr["B"]);
P = Convert.IsDBNull(dr["P"]) ? 0 : (float)Convert.ToDouble(dr["P"]);
C = Convert.IsDBNull(dr["C"]) ? 0 : (float)Convert.ToDouble(dr["C"]);
O = Convert.IsDBNull(dr["O"]) ? 0 : (float)Convert.ToDouble(dr["O"]);
S = Convert.IsDBNull(dr["S"]) ? 0 : (float)Convert.ToDouble(dr["S"]);
T = Convert.IsDBNull(dr["T"]) ? 0 : (float)Convert.ToDouble(dr["T"]);
medias = new MediasCompetencia(compID, S, B, P, C, O, T);
mediasDerailersSorted.Add(compID, medias);
mediasDerailers.Add(medias);
}
}
