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