public override bool Update(iVehicleFeatures Feature)
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
string q = string.Empty;
q = @"UPDATE vehiclefeatures SET
vehicleid = @pVehicleId,
featureid = @pFeatureId
WHERE id = @pid";
SqlCommand cmd = new SqlCommand(q, conn);
cmd.CommandText = q;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@pVehicleId", SqlDbType.Int).Value = Feature.VehicleId;
cmd.Parameters.Add("@pFeatureId", SqlDbType.Int).Value = Feature.FeatureId;
try
{
conn.Open();
int rc = ExecuteNonQuery(cmd);
return(rc == 1);
}
catch (SqlException ex)
{
ErrorHandler.writeSQLExceptionToLogFile(ex);
return(false);
}
}
}
protected virtual iVehicleFeatures GetVehicleFeaturesFromReader(IDataReader reader, bool singleRecord)
{
if (singleRecord)
{
reader.Read();
}
iVehicleFeatures vehiclefeature = new iVehicleFeatures(
Convert.ToInt32(reader["id"]),
Convert.ToInt32(reader["vehicleid"]),
Convert.ToInt16(reader["featureid"])
);
return(vehiclefeature);
}
public abstract bool Update(iVehicleFeatures Feature);
