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