protected void btnCount_Click(object sender, EventArgs e) { OperationDataContext od = new OperationDataContext(); tblSizes2 tblSizes2 = new tblSizes2(); var counts = }
public MenuController() { context = new OperationDataContext(); }
public UserModelController() { context = new OperationDataContext(); }
public UserRoleController() { context = new OperationDataContext(); }
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(); } } }
public GenreController() { context = new OperationDataContext(); }
public QorderController() { context = new OperationDataContext(); }
public ReservationController() { context = new OperationDataContext(); }
public KasirController() { context = new OperationDataContext(); }
public AdminController() { context = new OperationDataContext(); }
public HandlerController() { context = new OperationDataContext(); }
public PemesananController() { context = new OperationDataContext(); }
public SongController() { context = new OperationDataContext(); }
public BooksController() { context = new OperationDataContext(); }
public PesawatController() { context = new OperationDataContext(); }
public RouteController() { context = new OperationDataContext(); }
public InstructorController() { context = new OperationDataContext(); }
public BusVehicleController() { context = new OperationDataContext(); }
public PlaceController() { context = new OperationDataContext(); }
public CartController() { context = new OperationDataContext(); }
public MaskapaiController() { context = new OperationDataContext(); }
public InvoiceController() { context = new OperationDataContext(); }
public PassengerController() { context = new OperationDataContext(); }