protected override void Seed(MVCAuto.Library.DataAccess.MVCAutoContext context)
{
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data.
ColorVehicleData dataColor = new ColorVehicleData();
var colorsVehicle = dataColor.GetColorVehiclesOrderByName().ToList();
var listColorId = (from d in colorsVehicle
select d.ColorId).ToList();
// Generate vehicles
var vinGenerator = new RandomGenerator();
var priceGenerator = new RandomGenerator();
var daysGenerator = new RandomGenerator();
var itemCountGenerator = new RandomGenerator();
var colorIdGenerator = new RandomGenerator();
var vehicles = Builder <Vehicle> .CreateListOfSize(1000)
.All()
.With(v => v.Vin = vinGenerator.NextString(17, 17))
.With(v => v.Price = priceGenerator.Next(50, 500))
.With(v => v.OperDate = DateTime.Now.AddDays(-daysGenerator.Next(1, 100)))
.With(v => v.IntRowVer = itemCountGenerator.Next(1, 10))
//.With(v => v. = Pick<ColorVehicle>.RandomItemFrom(colorsVehicle))
.With(v => v.ColorId = Pick <int> .RandomItemFrom(listColorId))
.Build();
context.Vehicles.AddOrUpdate(v => v.ID, vehicles.ToArray());
}
// private ApplicationDbContext db = new ApplicationDbContext();
// GET: ColorVehicle
public ActionResult Index()
{
//return View(db.ColorVehicles.ToList());
ColorVehicleData data = new ColorVehicleData();
return(View(data.GetColorVehicles()));
}
// GET: Vehicle/Create
public ActionResult Create()
{
//ViewBag.ColorId = new SelectList(db.ColorVehicles, "ColorId", "Name");
ColorVehicleData dataColor = new ColorVehicleData();
ViewBag.ColorId = new SelectList(dataColor.GetColorVehicles(), "ColorId", "Name");
return(View());
}
//protected override void Dispose(bool disposing)
//{
// if (disposing)
// {
// db.Dispose();
// }
// base.Dispose(disposing);
//}
private void PopulateColorVehiclesDropDownList(object selectedColorVehicle = null)
{
//var colorVehicleQuery = from d in db.ColorVehicles
// orderby d.Name
// select d;
ColorVehicleData dataColor = new ColorVehicleData();
var colorVehicleQuery = dataColor.GetColorVehiclesOrderByName();
ViewBag.ColorId = new SelectList(colorVehicleQuery, "ColorId", "Name", selectedColorVehicle);
}
public ActionResult Edit([Bind(Include = "ColorId,Name")] ColorVehicle colorVehicle)
{
if (ModelState.IsValid)
{
//db.Entry(colorVehicle).State = EntityState.Modified;
//db.SaveChanges();
ColorVehicleData data = new ColorVehicleData();
data.EditColorVehicle(colorVehicle);
return(RedirectToAction("Index"));
}
return(View(colorVehicle));
}
public ActionResult Create([Bind(Include = "ColorId,Name")] ColorVehicle colorVehicle)
{
if (ModelState.IsValid)
{
// db.ColorVehicles.Add(colorVehicle);
// db.SaveChanges();
ColorVehicleData data = new ColorVehicleData();
data.AddColorVehicle(colorVehicle);
return(RedirectToAction("Index"));
}
return(View(colorVehicle));
}
public ActionResult DeleteConfirmed(int id)
{
//ColorVehicle colorVehicle = db.ColorVehicles.Find(id);
//db.ColorVehicles.Remove(colorVehicle);
//db.SaveChanges();
ColorVehicleData data = new ColorVehicleData();
ColorVehicle colorVehicle = data.FindColorVehicle(id);
data.DeleteColorVehicle(colorVehicle);
return(RedirectToAction("Index"));
}
// GET: ColorVehicle/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//ColorVehicle colorVehicle = db.ColorVehicles.Find(id);
ColorVehicleData data = new ColorVehicleData();
ColorVehicle colorVehicle = data.FindColorVehicle(id);
if (colorVehicle == null)
{
return(HttpNotFound());
}
return(View(colorVehicle));
}
// private ApplicationDbContext db = new ApplicationDbContext();
// GET: Vehicle
public ActionResult Index(int?id, int?SelectedColorVehicle, string sortOrder, string currentFilter, string searchString, int?page)
{
ViewBag.VinSortParm = String.IsNullOrEmpty(sortOrder) ? "vin_desc" : "";
ViewBag.ColorVehicleSortParm = sortOrder == "ColorVehicle" ? "colorVehicle_desc" : "ColorVehicle";
ViewBag.PriceSortParm = sortOrder == "Price" ? "price_desc" : "Price";
ViewBag.OperDateSortParm = sortOrder == "OperDate" ? "operDate_desc" : "OperDate";
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewBag.CurrentFilter = searchString;
VehicleData dataVehicle = new VehicleData();
ColorVehicleData dataColor = new ColorVehicleData();
var viewModel = new VehicleViews();
//var colorVehicleQuery = from d in db.ColorVehicles
// orderby d.Name
// select d;
var colorVehicleQuery = dataColor.GetColorVehiclesOrderByName();
ViewBag.ColorVehicles = new SelectList(colorVehicleQuery, "ColorId", "Name", SelectedColorVehicle);
int colorId = SelectedColorVehicle.GetValueOrDefault();
//viewModel.Vehicles = db.Vehicles
//.Where(v => !SelectedColorVehicle.HasValue || v.ColorId == colorId)
//.OrderBy(v => v.Vin)
//.Include(c => c.ColorVehicle).ToList();
//viewModel.Vehicles = dataVehicle.GetVehicles(colorId, SelectedColorVehicle);
var vehicles = from v in dataVehicle.GetVehicles(colorId, SelectedColorVehicle)
select v;
//search
if (!String.IsNullOrEmpty(searchString))
{
vehicles = vehicles.Where(v => v.Vin.Contains(searchString));
}
//sorting
switch (sortOrder)
{
case "vin_desc":
vehicles = vehicles.OrderByDescending(v => v.Vin);
break;
case "ColorVehicle":
vehicles = vehicles.OrderBy(v => v.ColorId);
break;
case "colorVehicle_desc":
vehicles = vehicles.OrderByDescending(v => v.ColorId);
break;
case "Price":
vehicles = vehicles.OrderBy(v => v.Price);
break;
case "price_desc":
vehicles = vehicles.OrderByDescending(v => v.Price);
break;
case "OperDate":
vehicles = vehicles.OrderBy(v => v.OperDate);
break;
case "operDate_desc":
vehicles = vehicles.OrderByDescending(v => v.OperDate);
break;
default:
vehicles = vehicles.OrderBy(v => v.Vin);
break;
}
// viewModel.Vehicles = vehicles;
//paging
int pageSize = 3;
int pageNumber = (page ?? 1);
viewModel.Vehicles = vehicles.ToPagedList(pageNumber, pageSize);
if (id != null)
{
ViewBag.ID = id.Value;
//Vehicle vehicle = db.Vehicles.Find(id);
Vehicle vehicle = dataVehicle.FindVehicle(id);
if (vehicle != null)
{
viewModel.SelVehicle = vehicle;
}
}
return(View(viewModel));
}
