public List <BodyStyles> GetAllBodyStyles()
{
List <BodyStyles> bodyStyles = new List <BodyStyles>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("BodyStylesSelectAll", cn);
cmd.CommandType = CommandType.StoredProcedure;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
BodyStyles currentRow = new BodyStyles();
currentRow.BodyStyleId = (int)dr["BodyStyleId"];
currentRow.BodyStyleDescription = dr["BodyStyleDescription"].ToString();
bodyStyles.Add(currentRow);
}
}
}
return(bodyStyles);
}
public void SetStyles(IEnumerable <BodyStyle> bodyStyle)
{
foreach (var body in bodyStyle)
{
BodyStyles.Add(new SelectListItem()
{
Value = body.BodyStyleId.ToString(),
Text = body.Description
});
}
}
public void SetBodyStyles(IEnumerable <BodyStyleModel> bodyStyles)
{
foreach (var bodystyle in bodyStyles)
{
BodyStyles.Add(new SelectListItem()
{
Value = bodystyle.BodyStyle,
Text = bodystyle.BodyStyle
});
}
}
public void SetBodyStyles(IEnumerable <LookupValue> bodyStyles)
{
foreach (var bs in bodyStyles)
{
BodyStyles.Add(new SelectListItem()
{
Value = bs.Description.ToString(),
Text = bs.Description.ToString()
});
}
}
public void EditVechicle(VechicleViewModel vechicle)
{
var editVehicle = Inventorys.Include("Mdles").Include("Typs").Include("BodyStyles")
.Include("Transmissions").Include("Colors").Include("Interiors")
.Include("PurchaseTypes").FirstOrDefault(p => p.Id == vechicle.InventoryId);
editVehicle.Id = vechicle.InventoryId;
editVehicle.Mdles.MakeId = Makes.FirstOrDefault(p => p.MakeName == vechicle.Make).MakeId;
editVehicle.MdleId = Models.FirstOrDefault(p => p.ModelName == vechicle.Model).MdleId;
editVehicle.BodyStyleId = BodyStyles.FirstOrDefault(p => p.BodyStyleName == vechicle.BodyStyle).BodyStyleId;
editVehicle.ColorId = Colors.SingleOrDefault(p => p.ColorName == vechicle.Color).ColorId;
editVehicle.TypId = Typs.SingleOrDefault(p => p.TypeName == vechicle.Type).TypId;
editVehicle.Year = vechicle.Year;
editVehicle.TransmissionId = Transmissions.SingleOrDefault(p => p.TransmissionName == vechicle.Transmission).TransmissionId;
editVehicle.InteriorId = Interiors.FirstOrDefault(p => p.InteriorName == vechicle.Interior).InteriorId;
editVehicle.Mileage = vechicle.Mileage;
editVehicle.VIN = vechicle.VIN;
editVehicle.MSRP = vechicle.MSRP;
editVehicle.SalesPrice = vechicle.SalesPrice;
editVehicle.Description = vechicle.Description;
editVehicle.FeatureVehicle = vechicle.FeatureVehicle;
if (editVehicle.Picture != null)
{
var oldFile = editVehicle.Picture;
string path = Path.Combine(HttpContext.Current.Server.MapPath("~/Images"),
Path.GetFileName(oldFile));
File.Delete(path);
}
if (vechicle.File != null && vechicle.File.ContentLength > 0)
{
string[] fileName = vechicle.File.FileName.Split('.');
string newName = "inventory-" + editVehicle.Id + "." + fileName.Last();
string path = Path.Combine(HttpContext.Current.Server.MapPath("~/Images"),
Path.GetFileName(newName));
vechicle.File.SaveAs(path);
editVehicle.Picture = newName;
}
(this).SaveChanges();
}
public BodyStyle GetBodyStyleById(int id)
{
return(BodyStyles.Where(i => i.BodyStyleId == id).FirstOrDefault());
}
