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)); }