protected virtual iCustomerVehicleInfo GetVehicleInfoFromReader(SqlDataReader reader, bool singleRecord)
{
if (singleRecord)
{
reader.Read();
}
iCustomerVehicleInfo vehicleinfo = new iCustomerVehicleInfo(
Convert.ToInt32(reader["id"]),
Convert.ToInt32(reader["seller"]),
reader["condition"].ToString(),
Convert.ToInt16(reader["modelyear"]),
reader["manufacturer"].ToString(),
Helpers.ConvertNullToBlank(reader["othermake"].ToString()),
Convert.ToInt16(reader["vehiclecategoryid"]),
reader["model"].ToString(),
Helpers.ConvertNullToBlank(reader["othermodel"].ToString()),
Convert.ToInt32(reader["modeltrim"]),
Helpers.ConvertNullToBlank(reader["othertrim"]),
reader["model_trim"].ToString(),
reader["exteriorcolor"].ToString(),
reader["interiorcolor"].ToString(),
reader["transmission"].ToString(),
reader["fueltype"].ToString(),
Convert.ToInt32(reader["currentmileage"]),
reader["wheels"].ToString(),
Convert.ToBoolean(reader["chromewheels"]),
reader["tires"].ToString(),
Convert.ToBoolean(reader["wintertires"]),
Convert.ToDateTime(reader["expires"]),
Helpers.ConvertNullToBlank(reader["comments"]),
Convert.ToDateTime(reader["entrydate"]),
Convert.ToBoolean(reader["approved"]),
Convert.ToBoolean(reader["confirmed"]),
Helpers.ConvertDbNullToBlank(reader["status"]),
Convert.ToBoolean(reader["declined"]),
Helpers.ConvertNullInt64ToZero(reader["billingid"]),
Helpers.ConvertDbNullToBlank(reader["displacement"]),
Convert.ToInt32(reader["finid"]),
Helpers.ConvertNullToBlank(reader["paymentcycle"].ToString()),
Convert.ToDateTime(reader["updated"]),
Convert.ToBoolean(reader["adstatus"])
);
return(vehicleinfo);
}
public override bool RepostSelectedVehicle(iCustomerVehicleInfo c)
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
string q = string.Empty;
q = @"
UPDATE [dbo].[customervehicleinfo]
SET [modelyear] = @ModelYear,
[vehiclecategoryid] = @VehicleCategory,
[manufacturer] = @Manufacturer,
[model] = @Model,
[modeltrim] = @ModelTrim,
[expires] = @vExpires,
[updated] = @vUpdated
WHERE [id] = @VehicleId";
SqlCommand cmd = new SqlCommand(q, conn)
{
CommandType = CommandType.Text
};
cmd.Parameters.AddWithValue("@ModelYear", c.ModelYear);
cmd.Parameters.AddWithValue("@VehicleCategory", c.VehicleCategoryId);
cmd.Parameters.AddWithValue("@Manufacturer", c.Manufacturer);
cmd.Parameters.AddWithValue("@Model", c.Model);
cmd.Parameters.AddWithValue("@ModelTrim", c.ModelTrim);
cmd.Parameters.AddWithValue("@VehicleId", c.Id);
cmd.Parameters.AddWithValue("@vExpires", c.Expires);
cmd.Parameters.AddWithValue("@vUpdated", c.Updated);
try
{
conn.Open();
int ret = ExecuteNonQuery(cmd);
return(ret == 1);
}
catch (SqlException ex)
{
ErrorHandler.writeSQLExceptionToLogFile(ex);
return(false);
}
}
}
public override int Insert(iCustomerVehicleInfo vi)
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
string q = string.Empty;
SqlCommand cmd = new SqlCommand(q, conn);
q = @"INSERT INTO [dbo].[customervehicleinfo]
([seller]
,[condition]
,[modelyear]
,[manufacturer]
,[othermake]
,[vehiclecategoryid]
,[model]
,[othermodel]
,[modeltrim]
,[othertrim]
,[exteriorcolor]
,[interiorcolor]
,[transmission]
,[fueltype]
,[currentmileage]
,[wheels]
,[chromewheels]
,[tires]
,[wintertires]
,[expires]
,[comments]
,[approved]
,[confirmed]
,[displacement]
,[updated]
)
VALUES
(@pSeller
,@pCondition
,@pModelYear
,@pManufacturer
,@pOtherMake
,@pVehiclecategoryId
,@pModel
,@pOtherModel
,@pModelTrim
,@pOtherTrim
,@pExteriorcolor
,@pInteriorcolor
,@pTransmission
,@pFueltype
,@pCurrentmileage
,@pWheels
,@pChromeWheels
,@pTires
,@pExtraWinterTires
,@pExpires
,@pComments
,@pApproved
,@pConfirmed
,@Displacement
,@Updated
);
SELECT SCOPE_IDENTITY()";
cmd.CommandText = q;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@pSeller", SqlDbType.Int).Value = vi.Seller;
cmd.Parameters.Add("@pCondition", SqlDbType.VarChar).Value = vi.VehicleCondition;
cmd.Parameters.Add("@pModelYear", SqlDbType.SmallInt).Value = vi.ModelYear;
cmd.Parameters.Add("@pManufacturer", SqlDbType.VarChar).Value = vi.Manufacturer;
cmd.Parameters.Add("@pOtherMake", SqlDbType.VarChar).Value = vi.OtherMake;
cmd.Parameters.Add("@pVehiclecategoryId", SqlDbType.Int).Value = vi.VehicleCategoryId;
cmd.Parameters.Add("@pModel", SqlDbType.VarChar).Value = vi.Model;
cmd.Parameters.Add("@pOtherModel", SqlDbType.VarChar).Value = vi.OtherModel;
cmd.Parameters.Add("@pModelTrim", SqlDbType.Int).Value = vi.ModelTrim;
cmd.Parameters.Add("@pOtherTrim", SqlDbType.VarChar).Value = vi.OtherTrim;
cmd.Parameters.Add("@pExteriorcolor", SqlDbType.VarChar).Value = vi.ExteriorColor;
cmd.Parameters.Add("@pInteriorcolor", SqlDbType.VarChar).Value = vi.InteriorColor;
cmd.Parameters.Add("@pTransmission", SqlDbType.VarChar).Value = vi.Transmission;
cmd.Parameters.Add("@pFueltype", SqlDbType.VarChar).Value = vi.FuelType;
cmd.Parameters.Add("@pCurrentmileage", SqlDbType.Int).Value = vi.CurrentMileage;
cmd.Parameters.Add("@pWheels", SqlDbType.VarChar).Value = vi.Wheels;
cmd.Parameters.Add("@pChromeWheels", SqlDbType.Bit).Value = vi.ChromeWheels;
cmd.Parameters.Add("@pTires", SqlDbType.VarChar).Value = vi.Tires;
cmd.Parameters.Add("@pExtraWinterTires", SqlDbType.Bit).Value = vi.ExtraWinterTires;
cmd.Parameters.Add("@pExpires", SqlDbType.DateTime).Value = vi.Expires;
cmd.Parameters.Add("@pComments", SqlDbType.Text).Value = vi.Comments;
cmd.Parameters.Add("@pApproved", SqlDbType.Bit).Value = vi.Approved;
cmd.Parameters.Add("@pConfirmed", SqlDbType.Bit).Value = vi.Confirmed;
cmd.Parameters.Add("@Displacement", SqlDbType.VarChar).Value = vi.Displacement;
cmd.Parameters.Add("@Updated", SqlDbType.Date).Value = vi.Updated;
try
{
conn.Open();
var rc = Convert.ToInt32(ExecuteScalar(cmd));
return(rc);
}
catch (SqlException ex)
{
ErrorHandler.writeSQLExceptionToLogFile(ex);
return(0);
}
}
}
public override bool Update(iCustomerVehicleInfo vi)
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
string q = string.Empty;
q = @"UPDATE [dbo].[customervehicleinfo]
SET [seller] = @pSeller
,[condition] = @pCondition
,[modelyear] = @pModelYear
,[manufacturer] = @pManufacturer
,[othermake] = @pOtherMake
,[vehiclecategoryid] = @pVehiclecategoryId
,[model] = @pModel
,[othermodel] = @pOtherModel
,[modeltrim] = @pModelTrim
,[othertrim] = @pOtherTrim
,[exteriorcolor] = @pExteriorcolor
,[interiorcolor] = @pInteriorcolor
,[transmission] = @pTransmission
,[fueltype] = @pFueltype
,[currentmileage] = @pCurrentmileage
,[wheels] = @pWheels
,[chromewheels] = @pChromeWheels
,[tires] = @pTires
,[wintertires] = @pExtraWinterTires
,[expires] = @pExpires
,[comments] = @pComments
,[displacement] = @Displacement
,[updated] = @Updated
WHERE id = @pid";
SqlCommand cmd = new SqlCommand(q, conn)
{
CommandText = q,
CommandType = CommandType.Text
};
cmd.Parameters.Add("@pid", SqlDbType.Int).Value = vi.Id;
cmd.Parameters.Add("@pSeller", SqlDbType.Int).Value = vi.Seller;
cmd.Parameters.Add("@pCondition", SqlDbType.VarChar).Value = vi.VehicleCondition;
cmd.Parameters.Add("@pModelYear", SqlDbType.SmallInt).Value = vi.ModelYear;
cmd.Parameters.Add("@pManufacturer", SqlDbType.VarChar).Value = vi.Manufacturer;
cmd.Parameters.Add("@pOtherMake", SqlDbType.VarChar).Value = vi.OtherMake;
cmd.Parameters.Add("@pVehiclecategoryId", SqlDbType.Int).Value = vi.VehicleCategoryId;
cmd.Parameters.Add("@pModel", SqlDbType.VarChar).Value = vi.Model;
cmd.Parameters.Add("@pOtherModel", SqlDbType.VarChar).Value = vi.OtherModel;
cmd.Parameters.Add("@pModelTrim", SqlDbType.Int).Value = vi.ModelTrim;
cmd.Parameters.Add("@pOtherTrim", SqlDbType.VarChar).Value = vi.OtherTrim;
cmd.Parameters.Add("@pExteriorcolor", SqlDbType.VarChar).Value = vi.ExteriorColor;
cmd.Parameters.Add("@pInteriorcolor", SqlDbType.VarChar).Value = vi.InteriorColor;
cmd.Parameters.Add("@pTransmission", SqlDbType.VarChar).Value = vi.Transmission;
cmd.Parameters.Add("@pFueltype", SqlDbType.VarChar).Value = vi.FuelType;
cmd.Parameters.Add("@pCurrentmileage", SqlDbType.Int).Value = vi.CurrentMileage;
cmd.Parameters.Add("@pWheels", SqlDbType.VarChar).Value = vi.Wheels;
cmd.Parameters.Add("@pChromeWheels", SqlDbType.Bit).Value = vi.ChromeWheels;
cmd.Parameters.Add("@pTires", SqlDbType.VarChar).Value = vi.Tires;
cmd.Parameters.Add("@pExtraWinterTires", SqlDbType.Bit).Value = vi.ExtraWinterTires;
cmd.Parameters.Add("@pExpires", SqlDbType.DateTime).Value = vi.Expires;
cmd.Parameters.Add("@pComments", SqlDbType.Text).Value = vi.Comments;
cmd.Parameters.Add("@Displacement", SqlDbType.VarChar).Value = vi.Displacement;
cmd.Parameters.Add("@Updated", SqlDbType.Date).Value = vi.Updated;
try
{
conn.Open();
int rc = ExecuteNonQuery(cmd);
return(rc == 1);
}
catch (SqlException ex)
{
ErrorHandler.writeSQLExceptionToLogFile(ex);
return(false);
}
}
}
public abstract bool RepostSelectedVehicle(iCustomerVehicleInfo c);
public abstract bool Update(iCustomerVehicleInfo c);
public abstract int Insert(iCustomerVehicleInfo c);
