protected void ButtonSave_Click(object sender, EventArgs e)
{
VehicleDetailModel vdm = new VehicleDetailModel();
vdm.saveRemark(tdLicense.InnerText, remarksText.InnerText);
UpdatePanelVehicleDetailsModal.Visible = false;
}
/// <summary>
/// Shows advanced details of a vehicle including its clock and damage history
/// </summary>
/// <param name="lPlate">liscence plate number</param>
/// <returns>View</returns>
public async Task <IActionResult> Details(string lPlate)
{
//Get vehicle details
VehicleDTO dto = await _beService.GetVehicleAsync(lPlate);
//Get Clock History for vehicle
IEnumerable <ClockHistoryDTO> clkdtos = await _beService.GetClockHistoriesAsync(lPlate);
//Get damage history for vehicle
IEnumerable <DamageHistoryDTO> dmgdtos = await _beService.GetDamageAsync(lPlate);
//Create model
VehicleDetailModel model = VehicleDetailModel.CreateModel(dto, dmgdtos, clkdtos);
return(View("VehicleDetails", model));
}
public List <VehicleDetailModel> GetFeatured()
{
List <VehicleDetailModel> _vehicles = new List <VehicleDetailModel>();
using (var conn = new SqlConnection())
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString();
SqlCommand cmd = new SqlCommand("GetFeatured", conn);
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
VehicleDetailModel row = new VehicleDetailModel();
row.VehicleID = (int)reader["VehicleID"];
row.MakeName = reader["Make"].ToString();
row.ModelName = reader["Model"].ToString();
row.Year = (int)reader["Year"];
row.Mileage = (int)reader["Mileage"];
row.VIN = reader["VIN"].ToString();
row.IntColor = reader["IntColor"].ToString();
row.ExtColor = reader["ExtColor"].ToString();
row.MSRP = (decimal)reader["MSRP"];
row.Price = (decimal)reader["SalePrice"];
row.Featured = (bool)reader["Featured"];
row.Sold = (bool)reader["Sold"];
row.New = (bool)reader["New"];
row.TransType = reader["Type"].ToString();
row.BodyStyle = reader["BodyStyle"].ToString();
row.Image = reader["Image"].ToString();
_vehicles.Add(row);
}
}
}
return(_vehicles);
}
public VehicleDetailModel GetDetail(int ID)
{
VehicleDetailModel _vehicle = new VehicleDetailModel();
using (var conn = new SqlConnection())
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString();
SqlCommand cmd = new SqlCommand("VehicleDetailByID", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", ID);
conn.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
reader.Read();
_vehicle.VehicleID = (int)reader["VehicleID"];
_vehicle.MakeName = reader["Make"].ToString();
_vehicle.ModelName = reader["Model"].ToString();
_vehicle.Year = (int)reader["Year"];
_vehicle.Mileage = (int)reader["Mileage"];
_vehicle.VIN = reader["VIN"].ToString();
_vehicle.IntColor = reader["IntColor"].ToString();
_vehicle.ExtColor = reader["ExtColor"].ToString();
_vehicle.MSRP = (decimal)reader["MSRP"];
_vehicle.Price = (decimal)reader["SalePrice"];
_vehicle.Featured = (bool)reader["Featured"];
_vehicle.Sold = (bool)reader["Sold"];
_vehicle.New = (bool)reader["New"];
_vehicle.TransType = reader["Type"].ToString();
_vehicle.BodyStyle = reader["BodyStyle"].ToString();
_vehicle.Image = reader["Image"].ToString();
_vehicle.Description = reader["Description"].ToString();
}
}
return(_vehicle);
}
public IEnumerable <VehicleDetailModel> SearchUnsold(VehicleSearchParametersModel parameters)
{
List <VehicleDetailModel> _vehicles = new List <VehicleDetailModel>();
using (var conn = new SqlConnection())
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString();
string query = "SELECT TOP 20 v.VehicleID, Make, Model, Year, Mileage, VIN, IntC.Color as IntColor, ExtC.Color as ExtColor, MSRP, SalePrice, Featured, Description, Sold, New, Type, BodyStyle, Image FROM Vehicle v " +
" JOIN Make mk on v.MakeID = mk.MakeID" +
" JOIN Model ml on v.ModelID = ml.ModelID" +
" JOIN Color intC on v.IntColorID = intC.ColorID JOIN Color extC on v.ExtColorID = extC.ColorID" +
" JOIN TransmissionType t on v.TransTypeID = t.TransTypeID" +
" JOIN BodyStyle b on v.BodyStyleID = b.BodyStyleID" +
" WHERE Sold = 0";
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
if (parameters.MinPrice.HasValue)
{
query += "AND SalePrice >= @MinPrice ";
cmd.Parameters.AddWithValue("@MinPrice", parameters.MinPrice.Value);
}
if (parameters.MaxPrice.HasValue)
{
query += "AND SalePrice <= @MaxPrice ";
cmd.Parameters.AddWithValue("@MaxPrice", parameters.MaxPrice.Value);
}
if (parameters.MinYear.HasValue)
{
query += "AND Year >= @MinYear ";
cmd.Parameters.AddWithValue("@MinYear", parameters.MinYear.Value);
}
if (parameters.MaxYear.HasValue)
{
query += "AND Year <= @MaxYear ";
cmd.Parameters.AddWithValue("@MaxYear", parameters.MaxYear.Value);
}
if (!string.IsNullOrEmpty(parameters.MakeModelOrYear))
{
query += "AND (Year LIKE @MakeModelOrYear OR Make LIKE @MakeModelOrYear OR Model LIKE @MakeModelOrYear)";
cmd.Parameters.AddWithValue("@MakeModelOrYear", parameters.MakeModelOrYear);
}
query += "ORDER BY MSRP DESC";
cmd.CommandText = query;
conn.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
VehicleDetailModel row = new VehicleDetailModel();
row.VehicleID = (int)reader["VehicleID"];
row.MakeName = reader["Make"].ToString();
row.ModelName = reader["Model"].ToString();
row.Year = (int)reader["Year"];
row.Mileage = (int)reader["Mileage"];
row.VIN = reader["VIN"].ToString();
row.IntColor = reader["IntColor"].ToString();
row.ExtColor = reader["ExtColor"].ToString();
row.MSRP = (decimal)reader["MSRP"];
row.Price = (decimal)reader["SalePrice"];
row.Featured = (bool)reader["Featured"];
row.Sold = (bool)reader["Sold"];
row.New = (bool)reader["New"];
row.TransType = reader["Type"].ToString();
row.BodyStyle = reader["BodyStyle"].ToString();
row.Image = reader["Image"].ToString();
_vehicles.Add(row);
}
}
}
return(_vehicles);
}
