public ActionResult Edit(int id, BusVehicleModel model) { try { // TODO: Add update logic here // Get all states again var times = GetAllTimesPerHour(); // Set these states on the model. We need to do this because // only the selected value from the DropDownList is posted back, not the whole // list of states. model.DepartureTimes = GetSelectListItems(times); BusVehicle busVehicle = context.BusVehicles.Where(some => some.Id == model.Id).Single <BusVehicle>(); busVehicle.Name = model.Name; busVehicle.AC = model.AC; busVehicle.Fare = model.Fare; busVehicle.DepartureTime = model.DepartureTime; busVehicle.RouteID = model.RouteID; context.SubmitChanges(); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Delete(int id, BusVehicleModel model) { try { // TODO: Add delete logic here BusVehicle busVehicle = context.BusVehicles.Where(some => some.Id == model.Id).Single <BusVehicle>(); context.BusVehicles.DeleteOnSubmit(busVehicle); context.SubmitChanges(); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create(BusVehicleModel model) { try { // TODO: Add insert logic here // Get all states again var times = AppConstants.HOURS; var classes = AppConstants.BusClasses; // Set these states on the model. We need to do this because // only the selected value from the DropDownList is posted back, not the whole // list of states. //model.DepartureTimes = GetSelectListItems(times.Keys); //ViewBag.Hours = times; model.Classes = GetSelectListItems(classes); BusVehicle busVehicle = new BusVehicle() { Name = model.Name, Class = model.Class, Capacity = model.Capacity, Fare = model.Fare, DepartureTime = DateTime.Parse(model.DepartureTime), RouteID = model.RouteID }; context.BusVehicles.InsertOnSubmit(busVehicle); context.SubmitChanges(); return(RedirectToAction("Index")); } catch { model = new BusVehicleModel(); PrepareBusVehicle(model); // Create a list of SelectListItems so these can be rendered on the page //model.DepartureTimes = GetSelectListItems(AppConstants.HOURS); //ViewBag.Hours = AppConstants.HOURS; model.Classes = GetSelectListItems(AppConstants.BusClasses); return(View(model)); } }
public ActionResult Create(BusVehicleModel model) { try { // TODO: Add insert logic here // Get all states again var times = GetAllTimesPerHour(); // Set these states on the model. We need to do this because // only the selected value from the DropDownList is posted back, not the whole // list of states. model.DepartureTimes = GetSelectListItems(times); BusVehicle busVehicle = new BusVehicle() { Name = model.Name, AC = model.AC, Fare = model.Fare, DepartureTime = model.DepartureTime, RouteID = model.RouteID }; context.BusVehicles.InsertOnSubmit(busVehicle); context.SubmitChanges(); return(RedirectToAction("Index")); } catch { model = new BusVehicleModel(); PrepareBusVehicle(model); // Create a list of SelectListItems so these can be rendered on the page model.DepartureTimes = GetSelectListItems(GetAllTimesPerHour()); return(View(model)); } }
private void BusVehicleSeed() { OperationDataContext context = new OperationDataContext(); var bandung = new PlaceModel { Name = "Bandung" }; var yogyakarta = new PlaceModel { Name = "Yogyakarta" }; var curup = new PlaceModel { Name = "Curup" }; var surabaya = new PlaceModel { Name = "Surabaya" }; var denpasar = new PlaceModel { Name = "Denpasar" }; var places = new List <PlaceModel>() { bandung, yogyakarta, curup, surabaya, denpasar }; List <RouteModel> busRoutes = new List <RouteModel>(); // Generate list of busRoute foreach (var origin in places) { foreach (var destination in places) { if (origin != destination) { busRoutes.Add(new RouteModel { OriginName = origin.Name, DestinationName = destination.Name }); } } } if (context.Places.Count() == 0) { // Insert all places above to database foreach (var item in places) { Place place = new Place() { Name = item.Name }; context.Places.InsertOnSubmit(place); context.SubmitChanges(); } // Insert all busRoute to database foreach (var item in busRoutes) { Route route = new Route() { Origin = item.OriginName, Destination = item.DestinationName }; context.Routes.InsertOnSubmit(route); context.SubmitChanges(); } } if (context.BusVehicles.Count() == 0) { var dates = DateTimeGenerator.GetDaysInRange(DateTime.Today, DateTime.Today.AddDays(60)); var busses = new List <BusVehicleModel>(); var busNames = new List <string>() { "Primajasa", "MGI", "Budiman", "Putra Raflesia", "Lorena", "Haryanto" }; var busClasses = AppConstants.BusClasses; foreach (DateTime date in dates) { //var tes = date; for (double i = 0; i < 24; i += 2) { foreach (var route in busRoutes) { int randName = rand.Next(busNames.Count); int randClass = rand.Next(busClasses.Count); busses.Add(BusGenerator.GenerateBus(route, date.AddHours(rand.Next(0, 24)).AddMinutes(rand.Next(0, 60)), busNames[randName], busClasses[randClass])); } } } // Insert all busvehicle to database // Belum bisa, masih ada errornya foreach (var item in busses) { BusVehicle busVehicle = new BusVehicle() { Name = item.Name, Class = item.Class, DepartureTime = DateTime.Parse(item.DepartureTime), RouteID = item.RouteID }; //context.BusVehicles.InsertOnSubmit(busVehicle); //context.SubmitChanges(); } } }