public void GetSelectedGameData(string GameID)
{
this.game = this.Data.GetGameData(GameID);
this.SelectedGame = new GameViewModel(this.game);
Debug.WriteLine("Selected game id is "+SelectedGame.ID);
if (string.IsNullOrEmpty(this.SelectedGame.Description))
{
this.SelectedGame.Description = N0_DESCRIPTION;
}
if (string.IsNullOrEmpty(selectedGame.Notes))
{
this.SelectedGame.Notes = N0_NOTES;
}
Collections = new ObservableCollection<Collection>();
}
private static bool GameAlreadyInCollection(GameData game, int collectionID)
{
bool result = false;
using (GameDataContext context = new GameDataContext(Constants.DBConnectionString))
{
IQueryable<GameCollection> query = from c in context.CollectionManager
where c.CollectionID == collectionID && c.GameID == game.ID
select c;
result = (query.FirstOrDefault() != null);
}
return result;
}
public static void AddGameToCollection(GameData game, int collectionID)
{
if (GameAlreadyInCollection(game, collectionID))
{
return;
}
//GetDataBase();
using (GameDataContext context = new GameDataContext(Constants.DBConnectionString))
{
IQueryable<Collection> query = from c in context.Collection
where c.ID == collectionID
select c;
Collection collection = query.FirstOrDefault();
GameData foundGame = GetGameData(game.ID.ToString());
GameCollection collectionManager = new GameCollection();
collectionManager.GameID = foundGame.ID;
collectionManager.CollectionID = collection.ID;
game.GameCollections.Add(collectionManager);
collection.GameCollections.Add(collectionManager);
context.CollectionManager.InsertOnSubmit(collectionManager);
context.SubmitChanges();
}
}
public static void ProccessImages(GameData game, List<GameImage> imageList)
{
ObservableCollection<BitmapImage> result = new ObservableCollection<BitmapImage>();
foreach (GameImage item in imageList)
{
using (var ms = new MemoryStream(item.Image))
{
var bitmapImage = new BitmapImage();
bitmapImage.SetSource(ms);
game.Images.Add(bitmapImage);
}
}
}
public GameViewModel(GameData gamedata)
{
this.images = new ObservableCollection<BitmapImage>();
this.ID = gamedata.ID;
this.UKName = gamedata.UK_Name;
this.Description = gamedata.Description;
this.Notes = gamedata.Notes;
this.platform = gamedata.Platform;
this.Images = new ObservableCollection<BitmapImage>(gamedata.Images);
//ProccessImages(gamedata.GameImages);
GetPlatformIcon();
}
public void AddGameToCollection(int collectionID, GameData game)
{
DatabaseFunctions.AddGameToCollection(game, collectionID);
}
private void HandleGameData(GameList gamesList, Exception exception)
{
ObservableCollection<GameData> gameDataList = new ObservableCollection<GameData>();
if (exception == null)
{
GameDataContext context = new GameDataContext(Constants.DBConnectionString);
foreach (GameResponse g in gamesList.Games)
{
GameData game = new GameData(g, this.SelectedPlatform);
gameDataList.Add(game);
Debug.WriteLine("Adding " + game.UK_Name);
context.Games.InsertOnSubmit(game);
}
context.SubmitChanges();
}
#if DEBUG
PrintOutGameData(gamesList);
#endif
if (this.CallBack != null)
{
CallBack(gameDataList, exception);
}
}