//Repeated code
internal static void UpdateSpDecision(Classes.SeasonPlannerDecision spDecision)
{
if (!spDecision.IsNull())
{
string connectionString = Constants.connectionString;
using (SqlConnection conn = new SqlConnection(connectionString))
using (SqlCommand command = conn.CreateCommand())
{
command.CommandText = "UPDATE SeasonPlannerDecisions " +
"SET Trainning = @Trainning, Testing = @Testing, " +
"TargetCarLevelEngBra = @TargetCarLevelEngBra, " +
"TargetCarLevelOthers = @TargetCarLevelOthers, CT = @CT " +
"WHERE Id = @Id";
command.Parameters.Clear();
command.Parameters.AddWithValue("@Id", spDecision.SeasonRace);
command.Parameters.AddWithValue("@Trainning", spDecision.Training);
command.Parameters.AddWithValue("@Testing", spDecision.Testing);
command.Parameters.AddWithValue("@TargetCarLevelEngBra", spDecision.TargetCarLevelEngBra);
command.Parameters.AddWithValue("@TargetCarLevelOthers", spDecision.TargetCarLevelOthers);
command.Parameters.AddWithValue("@CT", spDecision.CT);
conn.Open();
command.ExecuteNonQuery();
conn.Close();
}
}
}
internal static Classes.SeasonPlannerDecision[] ReadSpDecisionsFromDB(int initialRace = 0)
{
Classes.SeasonPlannerDecision[] spDecisions = new Classes.SeasonPlannerDecision[17];
string connectionString = Constants.connectionString;
using (SqlConnection conn = new SqlConnection(connectionString))
using (SqlCommand command = conn.CreateCommand())
{
command.CommandText = "SELECT * FROM SeasonPlannerDecisions";
conn.Open();
SqlDataReader reader = command.ExecuteReader();
for (int line = initialRace; line < 17; line++)
{
reader.Read();
spDecisions[line] = new Classes.SeasonPlannerDecision();
spDecisions[line].SeasonRace = int.Parse(reader["Id"].ToString());
spDecisions[line].Training = (Classes.DriverTrainning)Enum.Parse(typeof(Classes.DriverTrainning), reader["Trainning"].ToString());
spDecisions[line].Testing = Convert.ToBoolean(reader["Testing"].ToString());
spDecisions[line].TargetCarLevelEngBra = int.Parse(reader["TargetCarLevelEngBra"].ToString());
spDecisions[line].TargetCarLevelOthers = int.Parse(reader["TargetCarLevelOthers"].ToString());
spDecisions[line].CT = int.Parse(reader["CT"].ToString());
}
conn.Close();
}
return(spDecisions);
}
