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