public ObservableCollection <AsocFiles> GetBackUpFiles(int idObra)
{
ObservableCollection <AsocFiles> asocFiles = new ObservableCollection <AsocFiles>();
SqlConnection connection = new SqlConnection(connectionString);
try
{
connection.Open();
SqlCommand cmd = new SqlCommand("SELECT R.*, (U.Nombre + ' ' + U.Apellidos) Nombre FROM RespaldoEdicion R INNER JOIN C_Usuario U ON R.IdUsr = U.IdUsr WHERE IdObra = @IdObra", connection);
cmd.Parameters.AddWithValue("@IdObra", idObra);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
AsocFiles respaldo = new AsocFiles()
{
IdFile = Convert.ToInt32(reader["Id"]),
IdObra = Convert.ToInt32(reader["IdObra"]),
Usuario = reader["Nombre"].ToString(),
NombreArchivo = reader["ObraFileName"].ToString(),
RecursoOriginal = reader["SourceResource"].ToString()
};
asocFiles.Add(respaldo);
}
}
cmd.Dispose();
reader.Close();
}
catch (SqlException ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,AsocFilesModel", "RespaldoEdicion");
}
catch (Exception ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,AsocFilesModel", "RespaldoEdicion");
}
finally
{
connection.Close();
}
return(asocFiles);
}
private void GFiles_SelectionChanged(object sender, SelectionChangeEventArgs e)
{
selectedFile = GFiles.SelectedItem as AsocFiles;
}
