public override bool Insert(iVehiclefeaturelookup c) { using (SqlConnection conn = new SqlConnection(ConnectionString)) { string q = string.Empty; SqlCommand cmd = new SqlCommand(q, conn); q = @"INSERT INTO vehfeaturelookup (feature) VALUES ( @pFeature)"; cmd.CommandText = q; cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@pFeature", SqlDbType.VarChar).Value = c.Feature; try { conn.Open(); int rc = ExecuteNonQuery(cmd); return(rc == 1); } catch (SqlException ex) { ErrorHandler.writeSQLExceptionToLogFile(ex); return(false); } } }
public override bool Update(iVehiclefeaturelookup c) { using (SqlConnection conn = new SqlConnection(ConnectionString)) { string q = string.Empty; q = @"UPDATE vehfeaturelookup SET feature = @pFeature WHERE id = @pid" ; SqlCommand cmd = new SqlCommand(q, conn); cmd.CommandText = q; cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@pFeature", SqlDbType.Int).Value = c.Feature; try { conn.Open(); int rc = ExecuteNonQuery(cmd); return(rc == 1); } catch (SqlException ex) { ErrorHandler.writeSQLExceptionToLogFile(ex); return(false); } } }
protected virtual iVehiclefeaturelookup GetVehiclefeaturelookupFromReader(IDataReader reader, bool singleRecord) { if (singleRecord) { reader.Read(); } iVehiclefeaturelookup vehiclefeaturelookup = new iVehiclefeaturelookup( Convert.ToInt32(reader["id"]), reader["feature"].ToString(), reader["featuretype"].ToString(), reader["listtype"].ToString() ); return(vehiclefeaturelookup); }
public abstract bool Update(iVehiclefeaturelookup c);
public abstract bool Insert(iVehiclefeaturelookup c);