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