internal static Classes.SeasonPlannerTab ReadSeasonPlannerTabFromDB() { string connectionString = Constants.connectionString; Classes.SeasonPlannerTab spTab = new Classes.SeasonPlannerTab(); using (SqlConnection conn = new SqlConnection(connectionString)) using (SqlCommand command = conn.CreateCommand()) { command.CommandText = "SELECT * FROM SeasonPlannerTab"; conn.Open(); SqlDataReader reader = command.ExecuteReader(); reader.Read(); spTab.Division = short.Parse(reader["Division"].ToString()); spTab.StartingBalanceM = int.Parse(reader["StartingMoneyM"].ToString()); spTab.TargetPoints = int.Parse(reader["TargetPoints"].ToString()); spTab.nRuns = int.Parse(reader["nRuns"].ToString()); conn.Close(); } return(spTab); }
internal static void UpdateSeasonPlannerTab(Classes.SeasonPlannerTab spTab) { string connectionString = Constants.connectionString; using (SqlConnection conn = new SqlConnection(connectionString)) using (SqlCommand command = conn.CreateCommand()) { command.CommandText = "UPDATE SeasonPlannerTab " + " SET Division = @Division, StartingMoneyM = @StartingMoneyM, " + " TargetPoints = @TargetPoints, nRuns = @nRuns"; command.Parameters.Clear(); command.Parameters.AddWithValue("@Division", spTab.Division); command.Parameters.AddWithValue("@StartingMoneyM", spTab.StartingBalanceM); command.Parameters.AddWithValue("@TargetPoints", spTab.TargetPoints); command.Parameters.AddWithValue("@nRuns", spTab.nRuns); conn.Open(); command.ExecuteNonQuery(); conn.Close(); } }