/// <summary>
/// Devuelve las tesis relacionadas con el tema seleccionado
/// </summary>
/// <param name="idTema">Identificador del tema seleccionado</param>
/// <returns></returns>
public List <TesisDTO> GetTesisRelacionadas(int idTema)
{
List <TesisDTO> listaTesis = new List <TesisDTO>();
SqlConnection connection = Conexion.GetConecctionManttoCE();
SqlDataReader dataReader;
SqlCommand cmdAntes;
cmdAntes = connection.CreateCommand();
cmdAntes.Connection = connection;
try
{
connection.Open();
string miQry = "SELECT T.IUS,T.Rubro,T.Texto,T.Prec,T.LocAbr,T.LocExp,T.Volumen,T.Parte " +
" FROM Tesis T INNER JOIN TemasIUS I ON I.IUS = T.IUS " +
" WHERE (I.Id = @idTema AND T.IdProd = @idProducto ) AND I.idProd = @idProducto " +
" ORDER BY T.ConsecIndx";
cmdAntes = new SqlCommand(miQry, connection);
cmdAntes.Parameters.AddWithValue("@idTema", idTema);
cmdAntes.Parameters.AddWithValue("@idProducto", idProducto);
dataReader = cmdAntes.ExecuteReader();
while (dataReader.Read())
{
TesisDTO tesis = new TesisDTO();
tesis.Ius = Convert.ToInt32(dataReader["IUS"].ToString());
tesis.Rubro = dataReader["Rubro"].ToString();
tesis.Texto = dataReader["Texto"].ToString();
tesis.Precedente = dataReader["Prec"].ToString();
tesis.LocAbr = dataReader["LocAbr"].ToString();
tesis.LocExpr = dataReader["LocExp"].ToString();
tesis.Volumen = Convert.ToInt32(dataReader["Volumen"].ToString());
tesis.Parte = Convert.ToInt32(dataReader["Parte"].ToString());
listaTesis.Add(tesis);
}
dataReader.Close();
}
catch (SqlException ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,TesisModel", "ManttoProductosAlternos");
}
catch (Exception ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,TesisModel", "ManttoProductosAlternos");
}
finally
{
connection.Close();
}
return(listaTesis);
}
private void DgTesisSelectionChanged(object sender, Telerik.Windows.Controls.SelectionChangeEventArgs e)
{
selectedTesis = dgTesis.SelectedItem as TesisDTO;
temasRelacionados = new TemasModel(idProducto).GetTemasRelacionados(selectedTesis.Ius);
LstTemas.DataContext = temasRelacionados;
BtnEliminar.IsEnabled = true;
BtnSustituir.IsEnabled = true;
}
public List <TesisDTO> GetTesisRelacionadasScjn()
{
List <TesisDTO> listaTesis = new List <TesisDTO>();
SqlConnection connection = Conexion.GetConecctionManttoCE();
SqlDataReader reader;
SqlCommand cmdAntes;
cmdAntes = connection.CreateCommand();
cmdAntes.Connection = connection;
try
{
connection.Open();
string miQry = "SELECT * FROM TemasIUS WHERE IdProd = " + idProducto +
" ORDER BY id,ConsecIndx";
cmdAntes = new SqlCommand(miQry, connection);
reader = cmdAntes.ExecuteReader();
while (reader.Read())
{
TesisDTO tesis = new TesisDTO();
tesis.Ius = Convert.ToInt32(reader["IUS"].ToString());
tesis.Parte = Convert.ToInt32(reader["Id"].ToString());
tesis.Volumen = Convert.ToInt32(reader["ConsecIndx"].ToString());
listaTesis.Add(tesis);
}
reader.Close();
}
catch (SqlException ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,MigradorModel", "ChecaPrecedentes");
}
catch (Exception ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,MigradorModel", "ChecaPrecedentes");
}
finally
{
connection.Close();
}
return(listaTesis);
}
// Este metodo simplemente expande los nodos padre con un tipo de backtraking.
//private void AbreRaiz(object root)
//{
// if (root.GetType() == typeof(TreeViewItem))
// {
// TreeViewItem node = root as TreeViewItem;
// if (root.GetType() == typeof(TreeViewItem))
// {
// if (((TreeViewItem)root).Parent.GetType() == typeof(TreeViewItem))
// {
// ((TreeViewItem)node.Parent).IsExpanded = expande;
// AbreRaiz((TreeViewItem)node.Parent);
// }
// }
// }
//}
#endregion
#region Grid
public void RegistroActivado(object sender)
{
tesisSeleccionada = ((RadGridView)sender).SelectedItem as TesisDTO;
}
