public GameRecordModel RetrieveByID(int id)
{
string connectionString = "Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=MinesweeperDatabase;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
using (SqlConnection connection = new SqlConnection(connectionString))
{
GameRecordDAO dao = new GameRecordDAO(connection);
connection.Open();
List <GameRecordModel> records = dao.ReadByID(id);
connection.Close();
if (records.Count != 1)
{
return(null);
}
else
{
foreach (GameRecordModel model in records)
{
return(model);
}
return(null);
}
}
}
public bool Archive(GameRecordModel game)
{
string connectionString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=MinesweeperDatabase;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
bool success = false;
using (SqlConnection connection = new SqlConnection(connectionString))
{
GameRecordDAO dao = new GameRecordDAO(connection);
connection.Open();
success = dao.Create(game);
connection.Close();
}
return(success);
}
