public IEnumerable <VehicleRequestItem> GetDetailsAllByVehicleTypeId(byte vehicleTypeId)
{
List <VehicleRequestItem> vehicles = new List <VehicleRequestItem>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("VehiclesSelectAllDetailsByVehicleTypeId", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@VehicleTypeId", vehicleTypeId);
cmd.Parameters.AddWithValue("@SearchQuery", DBNull.Value);
cmd.Parameters.AddWithValue("@MinPrice", DBNull.Value);
cmd.Parameters.AddWithValue("@MaxPrice", DBNull.Value);
cmd.Parameters.AddWithValue("@MinYear", DBNull.Value);
cmd.Parameters.AddWithValue("@MaxYear", DBNull.Value);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
VehicleRequestItem currentRow = new VehicleRequestItem();
currentRow.VehicleId = (int)dr["VehicleId"];
currentRow.VIN = dr["VIN"].ToString();
currentRow.ModelYear = (short)dr["ModelYear"];
currentRow.Model = dr["Model"].ToString();
currentRow.Make = dr["Make"].ToString();
currentRow.VehicleType = dr["VehicleType"].ToString();
currentRow.Mileage = (int)dr["Mileage"];
currentRow.TransmissionType = dr["TransmissionType"].ToString();
currentRow.BodyStyle = dr["BodyStyle"].ToString();
currentRow.Color = dr["Color"].ToString();
currentRow.ColorCode = dr["ColorCode"].ToString();
currentRow.InteriorColor = dr["InteriorColor"].ToString();
currentRow.InteriorColorCode = dr["InteriorColorCode"].ToString();
currentRow.Description = dr["Description"].ToString();
currentRow.ImageFileName = dr["ImageFileName"].ToString();
currentRow.MSRP = (decimal)dr["MSRP"];
currentRow.SalePrice = (decimal)dr["SalePrice"];
currentRow.IsSold = (bool)dr["IsSold"];
vehicles.Add(currentRow);
}
}
}
return(vehicles);
}
public VehicleRequestItem GetDetailsById(int vehicleId)
{
VehicleRequestItem vehicle = null;
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("VehiclesSelectAllDetailsById", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@VehicleId", vehicleId);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
vehicle = new VehicleRequestItem();
vehicle.VehicleId = (int)dr["VehicleId"];
vehicle.VIN = dr["VIN"].ToString();
vehicle.ModelYear = (short)dr["ModelYear"];
vehicle.Model = dr["Model"].ToString();
vehicle.Make = dr["Make"].ToString();
vehicle.VehicleType = dr["VehicleType"].ToString();
vehicle.Mileage = (int)dr["Mileage"];
vehicle.TransmissionType = dr["TransmissionType"].ToString();
vehicle.BodyStyle = dr["BodyStyle"].ToString();
vehicle.Color = dr["Color"].ToString();
vehicle.ColorCode = dr["ColorCode"].ToString();
vehicle.InteriorColor = dr["InteriorColor"].ToString();
vehicle.InteriorColorCode = dr["InteriorColorCode"].ToString();
vehicle.Description = dr["Description"].ToString();
vehicle.ImageFileName = dr["ImageFileName"].ToString();
vehicle.MSRP = (decimal)dr["MSRP"];
vehicle.SalePrice = (decimal)dr["SalePrice"];
vehicle.IsSold = (bool)dr["IsSold"];
}
}
}
return(vehicle);
}
public PurchaseVM()
{
Vehicle = new VehicleRequestItem();
StateItems = new List<SelectListItem>();
PurchaseTypeItems = new List<SelectListItem>();
}
