public CollectionViewModel(Collection data)
{
this.ID = data.ID;
this.Icon = data.Icon;
this.Name = data.Name;
ProcessNumberOfGames(data);
}
public CollectionViewModel(Collection collection)
{
this.Games = new List<GameData>();
this.ID = collection.ID;
this.Name = collection.Name;
this.Icon = collection.Icon;
this.Games = collection.Games;
}
public static void AddNewCollection(string collectionName, string icon)
{
//GetDataBase();
using (GameDataContext context = new GameDataContext(Constants.DBConnectionString))
{
Collection collection = new Collection();
collection.Name = collectionName;
collection.Icon = icon;
context.Collection.InsertOnSubmit(collection);
context.SubmitChanges();
}
}
private void ProcessNumberOfGames(Collection data)
{
int total = 0;
try
{
total = data.GameCollections.Count;
}
catch (System.Exception)
{}
string s = total == 1 ? "Game" : "Games";
this.NumberOfGamesStringValue = string.Format("{0} {1} in collection", total, s);
}
public static Collection GetCollection(string id)
{
//GetDataBase();
Collection collection = new Collection();
using (GameDataContext context = new GameDataContext(Constants.DBConnectionString))
{
IQueryable<Collection> query = from c in context.Collection
where c.ID.ToString() == id
select c;
collection = query.FirstOrDefault();
}
return collection;
}