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