public static List<UserComposition> Load() { using (SqlCommand sqlcmd = new SqlCommand()) { List<UserComposition> ListUserCompositions = new List<UserComposition>(); sqlcmd.Connection = new System.Data.SqlClient.SqlConnection(ConnectionString); sqlcmd.CommandText = "SELECT * FROM UserCompositions"; sqlcmd.Connection.Open(); using (var sqlreader = sqlcmd.ExecuteReader()) { if (sqlreader.HasRows) { while (sqlreader.Read()) { UserComposition UserComposition = new UserComposition(); UserComposition.Id = (Guid)sqlreader[0]; UserComposition.User = (User)User.Find((Guid)sqlreader[1]); UserComposition.Composition = (Composition)Composition.Find((Guid)sqlreader[2]); ListUserCompositions.Add(UserComposition); } } sqlcmd.Connection.Close(); return ListUserCompositions; } } }
public void CreateLink(User SelectedUser, Composition SelectedComposition) { UserComposition UserComposition = new UserComposition(SelectedUser, SelectedComposition); }
private void we_Click(object sender, RoutedEventArgs e) { UserComposition us = new UserComposition((User)Users.SelectedItem, (Composition)Compositions.SelectedItem); }