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