private static void addMemberToGame()
{
displayMembers();
Console.Write("Member ID: ");
int mID = Convert.ToInt32(Console.ReadLine());
displayGames();
Console.Write("Game ID:");
int gID = Convert.ToInt32(Console.ReadLine());
using (DBGameClubContainer DB = new DBGameClubContainer())
{
var qMember = from m in DB.Members
where m.Id == mID
select m;
Member member = qMember.First();
Game game = (from g in DB.Games
where g.Id == gID
select g).First();
game.Members.Add(member);
DB.SaveChanges();
}
}
private static void addNewMember()
{
Console.Write("Member Name: ");
string mName = Console.ReadLine();
Member m = new Member();
m.Name = mName;
using (DBGameClubContainer DB = new DBGameClubContainer())
{
DB.Members.Add(m);
DB.SaveChanges();
}
Console.WriteLine($"Member {m.Name} added.");
}
private static void addNewGame()
{
Console.Write("Game Title: ");
string gTitle = Console.ReadLine();
Console.Write("Game Studio: ");
string gStudio = Console.ReadLine();
Game g = new Game()
{
Title = gTitle, Studio = gStudio
};
using (DBGameClubContainer db = new DBGameClubContainer())
{
db.Games.Add(g);
db.SaveChanges();
}
}
private static void addGameToMember()
{
displayGames();
Console.Write("Game ID:");
int gID = Convert.ToInt32(Console.ReadLine());
displayMembers();
Console.Write("Member ID: ");
int mID = Convert.ToInt32(Console.ReadLine());
using (DBGameClubContainer DB = new DBGameClubContainer())
{
Game game = DB.Games.Where(g => g.Id == gID).First();
Member member = DB.Members.Where(m => m.Id == mID).First();
member.Games.Add(game);
DB.SaveChanges();
}
}
