private void Materias_RecordUpdated(object sender, Infragistics.Windows.DataPresenter.Events.RecordUpdatedEventArgs e)
{
try
{
DataRecord myRecord = (DataRecord)e.Record;
// Display the selected Records values in the appropriate
// editor
ClasificacionSga materia = new ClasificacionSga(myRecord.Cells[3].Value.ToString());
materia.IdClasificacion = Convert.ToInt32(myRecord.Cells[0].Value);
materia.Nivel = Convert.ToInt32(myRecord.Cells[1].Value);
materia.Padre = Convert.ToInt32(myRecord.Cells[2].Value);
materia.Descripcion = myRecord.Cells[3].Value.ToString();
materia.SeccionPadre = Convert.ToInt32(myRecord.Cells[4].Value);
materia.Historica = Convert.ToInt32(myRecord.Cells[5].Value);
materia.Consec = Convert.ToInt32(myRecord.Cells[6].Value);
materia.Hoja = Convert.ToInt32(myRecord.Cells[7].Value);
materia.NvlImpresion = Convert.ToInt32(myRecord.Cells[8].Value);
if (registroNuevo)
new ClasificacionSgaModel().InsertarRegistro(materia);
else
new ClasificacionSgaModel().ActualizaRegistroMaterias(materia);
registroNuevo = false;
}
catch (InvalidCastException)
{
e.Record.Visibility = System.Windows.Visibility.Collapsed;
e.Record.CancelUpdate();
MessageBox.Show("Debe completar todos los campos para poder ingresar un elemento", "Atención:", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
private void MateriasTree_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (CbxFiltroVol.SelectedIndex > 1)
{
CbxFiltroVol.SelectedIndex = 0;
}
selectedClasif = MateriasTree.SelectedItem as ClasificacionSga;
tesisRel = new RelacionesModel().GetTesisRelacionadas(selectedClasif.IdClasificacion);
GTesisRel.DataContext = tesisRel;
LblTotal.Content = GTesisRel.Items.Count + " tesis relacionadas";
}
private void MateriasTree_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
selectedClasificacion = MateriasTree.SelectedItem as ClasificacionSga;
}
private void GetMateriasTreeString(ClasificacionSga item)
{
textoDeLasMaterias = this.GetTabNumber(item.Nivel) + item.Descripcion + "\n" + textoDeLasMaterias;
if (!item.Descripcion.Contains("Todas"))
GetMateriasTreeString(item.GetParent());
}
/// <summary>
/// Genera un nuevo registro para la clasificación de Materias SGA
/// </summary>
/// <param name="materia">Materia creada</param>
public void InsertarRegistro(ClasificacionSga materia)
{
SqlConnection connection = new SqlConnection(connectionString);
SqlDataAdapter dataAdapter = null;
DataSet dataSet = new DataSet();
DataRow dr;
try
{
string sqlCadena = "SELECT * FROM cMateriasSGA WHERE id = 0";
dataAdapter = new SqlDataAdapter();
dataAdapter.SelectCommand = new SqlCommand(sqlCadena, connection);
dataAdapter.Fill(dataSet, "Materias");
dr = dataSet.Tables["Materias"].NewRow();
dr["Id"] = materia.IdClasificacion;
dr["Nivel"] = materia.Nivel;
dr["Padre"] = materia.Padre;
dr["Descripcion"] = materia.Descripcion;
dr["SeccionPadre"] = materia.SeccionPadre;
dr["Historica"] = materia.Historica;
dr["Consec"] = materia.Consec;
dr["Hoja"] = materia.Hoja;
dr["NvlImpresion"] = materia.NvlImpresion;
dataSet.Tables["Materias"].Rows.Add(dr);
dataAdapter.InsertCommand = connection.CreateCommand();
dataAdapter.InsertCommand.CommandText = "INSERT INTO cMateriasSGA(Id,Nivel,Padre,Descripcion,SeccionPadre,Historica,Consec,Hoja,NvlImpresion)" +
" VALUES(@Id,@Nivel,@Padre,@Descripcion,@SeccionPadre,@Historica,@Consec,@Hoja,@NvlImpresion)";
dataAdapter.InsertCommand.Parameters.Add("@Id", SqlDbType.BigInt, 0, "Id");
dataAdapter.InsertCommand.Parameters.Add("@Nivel", SqlDbType.Int, 0, "Nivel");
dataAdapter.InsertCommand.Parameters.Add("@Padre", SqlDbType.Int, 0, "Padre");
dataAdapter.InsertCommand.Parameters.Add("@Descripcion", SqlDbType.VarChar, 0, "Descripcion");
dataAdapter.InsertCommand.Parameters.Add("@SeccionPadre", SqlDbType.Int, 0, "SeccionPadre");
dataAdapter.InsertCommand.Parameters.Add("@Historica", SqlDbType.Int, 0, "Historica");
dataAdapter.InsertCommand.Parameters.Add("@Consec", SqlDbType.Int, 0, "Consec");
dataAdapter.InsertCommand.Parameters.Add("@Hoja", SqlDbType.Int, 0, "Hoja");
dataAdapter.InsertCommand.Parameters.Add("@NvlImpresion", SqlDbType.Int, 0, "NvlImpresion");
dataAdapter.Update(dataSet, "Materias");
dataSet.Dispose();
dataAdapter.Dispose();
}
catch (SqlException ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,ClasificacionSgaModel", "SgaControl");
}
catch (Exception ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,ClasificacionSgaModel", "SgaControl");
}
finally
{
connection.Close();
}
}
/// <summary>
/// Actualiza la información de la Materia SGA que se esta editando
/// </summary>
/// <param name="materia">Materia SGA</param>
public void ActualizaRegistroMaterias(ClasificacionSga materia)
{
SqlConnection connection = new SqlConnection(connectionString);
SqlDataAdapter dataAdapter;
SqlCommand cmd;
cmd = connection.CreateCommand();
cmd.Connection = connection;
try
{
connection.Open();
DataSet dataSet = new DataSet();
DataRow dr;
string sqlCadena = "SELECT * FROM cMateriasSGA WHERE id = " + materia.IdClasificacion;
dataAdapter = new SqlDataAdapter();
dataAdapter.SelectCommand = new SqlCommand(sqlCadena, connection);
dataAdapter.Fill(dataSet, "Materia");
dr = dataSet.Tables[0].Rows[0];
dr.BeginEdit();
dr["Id"] = materia.IdClasificacion;
dr["Nivel"] = materia.Nivel;
dr["Padre"] = materia.Padre;
dr["Descripcion"] = materia.Descripcion;
dr["SeccionPadre"] = materia.SeccionPadre;
dr["Historica"] = materia.Historica;
dr["Consec"] = materia.Consec;
dr["Hoja"] = materia.Hoja;
dr["NvlImpresion"] = materia.NvlImpresion;
dr.EndEdit();
dataAdapter.UpdateCommand = connection.CreateCommand();
string sSql = "UPDATE cMateriasSGA " +
"SET Nivel = @Nivel, " +
" Padre = @Padre, Descripcion = @Descripcion, SeccionPadre = @SeccionPadre, Historica = @Historica," +
" Consec = @Consec, Hoja = @Hoja,NvlImpresion = @NvlImpresion" +
" WHERE Id = @Id";
dataAdapter.UpdateCommand.CommandText = sSql;
dataAdapter.UpdateCommand.Parameters.Add("@Nivel", SqlDbType.Int, 0, "Nivel");
dataAdapter.UpdateCommand.Parameters.Add("@Padre", SqlDbType.Int, 0, "Padre");
dataAdapter.UpdateCommand.Parameters.Add("@Descripcion", SqlDbType.VarChar, 0, "Descripcion");
dataAdapter.UpdateCommand.Parameters.Add("@SeccionPadre", SqlDbType.Int, 0, "SeccionPadre");
dataAdapter.UpdateCommand.Parameters.Add("@Historica", SqlDbType.Int, 0, "Historica");
dataAdapter.UpdateCommand.Parameters.Add("@Consec", SqlDbType.Int, 0, "Consec");
dataAdapter.UpdateCommand.Parameters.Add("@Hoja", SqlDbType.Int, 0, "Hoja");
dataAdapter.UpdateCommand.Parameters.Add("@NvlImpresion", SqlDbType.Int, 0, "NvlImpresion");
dataAdapter.UpdateCommand.Parameters.Add("@Id", SqlDbType.BigInt, 0, "Id");
dataAdapter.Update(dataSet, "Materia");
dataSet.Dispose();
dataAdapter.Dispose();
}
catch (SqlException ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,ClasificacionSgaModel", "SgaControl");
}
catch (Exception ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,ClasificacionSgaModel", "SgaControl");
}
finally
{
connection.Close();
}
}
public List<ClasificacionSga> GetEstructuraNivel(int padre, bool isReadOnly)
{
List<ClasificacionSga> listaMaterias = new List<ClasificacionSga>();
SqlConnection connection = new SqlConnection(connectionString);// (SqlConnection)DbConnDac.GetConnectionIus();
SqlCommand cmd;
SqlDataReader dataReader;
string miQry;
try
{
connection.Open();
miQry = "Select * FROM cMateriasSGA WHERE padre = " + padre + " ORDER BY Consec";
cmd = new SqlCommand(miQry, connection);
dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
ClasificacionSga materia = new ClasificacionSga(dataReader["Descripcion"].ToString(),
GetEstructuraNivel(Convert.ToInt32(dataReader["ID"].ToString()), isReadOnly), Convert.ToInt32(dataReader["ID"].ToString()));
materia.Nivel = Convert.ToInt32(dataReader["Nivel"]);
materia.IsReadOnly = isReadOnly;
listaMaterias.Add(materia);
}
}
catch (SqlException ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,ClasificacionSgaModel", "SgaControl");
}
catch (Exception ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,ClasificacionSgaModel", "SgaControl");
}
finally
{
connection.Close();
}
return listaMaterias;
}
public static List<ClasificacionSga> CreateMateriasTree(bool isReadOnly)
{
List<ClasificacionSga> listaMaterias = new ClasificacionSgaModel().GetEstructuraNivel(-1,isReadOnly);
ClasificacionSga root = new ClasificacionSga("Todas")
{
IsInitiallySelected = true,
SubClasificaciones = listaMaterias
};
root.Initialize();
return new List<ClasificacionSga> { root };
}
