//--------------------------------------------------
private void LoadParameters(SqlCommand cmd, RacePower power)
{
cmd.Parameters.AddWithValue("@ID", power.Id);
cmd.Parameters.AddWithValue("@RACEID_FK", power.RaceId);
cmd.Parameters.AddWithValue("@NAME", power.Name);
cmd.Parameters.AddWithValue("@DESCRIPTION", power.Description);
}
public void UpdatePower(RacePower power)
{
using (SqlCommand cmd = new SqlCommand(SQL_UPDATE_RACEPOWER))
{
LoadParameters(cmd, power);
ExecuteSqlNonQuery(cmd);
}
}
public static RacePower CreateObjectFromDataRow(DataRow row)
{
RacePower power = new RacePower();
power.Id = (row["ID"] == DBNull.Value) ? 0 : Convert.ToInt32(row["ID"]);
power.RaceId = (row["RACEID_FK"] == DBNull.Value) ? 0 : Convert.ToInt32(row["RACEID_FK"]);
power.Name = (row["NAME"] == DBNull.Value) ? string.Empty : Convert.ToString(row["NAME"]);
power.Description = (row["DESCRIPTION"] == DBNull.Value) ? string.Empty : Convert.ToString(row["DESCRIPTION"]);
return(power);
}
public int AddPower(RacePower newPower)
{
int id = 0;
using (SqlCommand cmd = new SqlCommand(SQL_ADD_RACEPOWER))
{
LoadParameters(cmd, newPower);
id = (int)ExecuteScalarQuery(cmd);
}
return(id);
}
