protected override void OnCreate(Bundle savedInstanceState) { journeyRepository = new JourneyRepository(); tripRepository = new TripRepository(); base.OnCreate(savedInstanceState); SelectedTripId = tripRepository.GetActiveTrip(); SetContentView(Resource.Layout.chart_reporting_layout); DrawTopImageInPurple(); GetData(); timeChart = FindViewById <ChartView>(Resource.Id.timeChartView); timeByDayChart = FindViewById <ChartView>(Resource.Id.timeByDayChartView); distanceChart = FindViewById <ChartView>(Resource.Id.distanceChartView); distanceByDayChart = FindViewById <ChartView>(Resource.Id.distanceByDayChartView); distanceByDayChart.Chart = new BarChart() { Entries = _distanceByDayEntries }; distanceChart.Chart = new DonutChart() { Entries = _distanceEntries }; timeChart.Chart = new DonutChart() { Entries = _timeEntries }; timeByDayChart.Chart = new BarChart() { Entries = _timeByDayEntries }; }
public async Task <bool> DeleteUser(string userName) { var logger = LogManager.GetCurrentClassLogger(); return(await Task.Run(() => { var userStore = new UserStore <ApplicationUser>(new ApplicationDbContext()); var manager = new UserManager <ApplicationUser>(userStore); var user = manager.FindByName(userName); manager.Delete(user); var repo = new TripRepository(new TripsContext("TripConnection")); var trips = repo.Find(t => t.User == userName); foreach (var trip in trips) { repo.Delete(trip.Id); } logger.Info($"AccountController -> handled request : DeleteUser -> success"); return true; })); }
public ActionResult _GetAllActiveTripsPartial() { TripRepository repo = new TripRepository(); IList <Trip> activeTrips = repo.GetAllActiveTrips(); return(PartialView(activeTrips)); }
private async void BtnFinishPassengerTrip_Clicked(object sender, EventArgs e) { try { using (TripRepository tripRepository = new TripRepository()) { var tripState = await tripRepository.GetStatusTrip(Trip.TripId); if (tripState.Equals("Posted")) { await DisplayAlert("Alert", "The trip has not started yet", "Ok"); return; } var passenger = (sender as Button).CommandParameter as User; await tripRepository.FinishPassengerTrip(passenger, Trip.TripId); _passengersList.Remove(passenger); if (_passengersList.Count == 0) { await tripRepository.FinishTrip(Trip.TripId); await Navigation.PopAsync(); stopWatch.Stop(); } } } catch { await DisplayAlert("Error", "An unexpected error has occurred", "Ok"); } }
public void DeleteTrip_WhenValid_ShouldCommit() { var trip = ModelTestHelper.CreateTrip(-1, "deleteTripCommit"); var services = new TripServices(); services.CreateTrip(trip, 1); Assert.IsFalse(services.HasErrors); var reloadedTrip = services.GetTrip(trip.Id); Assert.IsNotNull(reloadedTrip); var pot = reloadedTrip.TripPot; Assert.IsNotNull(pot); var participants = reloadedTrip.Participants; Assert.AreEqual(1, participants.Count()); var potUsers = pot.Participants; Assert.AreEqual(1, potUsers.Count()); var tripRepo = new TripRepository(); var potRepo = new PotRepository(); var userTripRepo = new UserTripRepository(); var potUserRepo = new PotUserRepository(); var tripParticipantRepo = new TripParticipantRepository(); services.DeleteTrip(reloadedTrip); Assert.IsFalse(services.HasErrors); Assert.IsNull(tripRepo.GetTrip(reloadedTrip.Id)); Assert.IsNull(potRepo.GetPot(pot.Id)); Assert.AreEqual(0, userTripRepo.GetUserTripsByTrip(reloadedTrip.TripName).Count()); Assert.AreEqual(0, potUserRepo.GetPotUsers(pot.Id).Count()); Assert.AreEqual(0, tripParticipantRepo.GetTripParticipants(reloadedTrip.Id).Count()); }
private async void RemovePassenger_Clicked(object sender, EventArgs e) { try { using (TripRepository tripRepository = new TripRepository()) { var tripState = await tripRepository.GetStatusTrip(Trip.TripId); if (tripState.Equals("OnWay")) { await DisplayAlert("Alert", "The trip is on way, please Finish the trip by passenger", "Ok"); return; } var passenger = (sender as MenuItem).CommandParameter as User; await tripRepository.RemovePassenger(passenger, Trip.TripId); _passengersList.Remove(passenger); } } catch (Exception) { await DisplayAlert("Error", "An unexpected error has occurred", "Ok"); } }
static CacheImplementor() { dbHelper = new MySqlDbHelper(new MySqlConnectionManager()); tripRepository = new TripRepository(dbHelper); loginRepository = new LoginRepository(dbHelper); cacheContext = new Context(ConfigurationManager.AppSettings["RedisCache"]); }
public static async Task <IActionResult> CreateTrip([HttpTrigger(AuthorizationLevel.Function, "post", Route = null)] HttpRequest req) { req.IsValidToken(); string requestBody = new StreamReader(req.Body).ReadToEnd(); Trip trip = JsonConvert.DeserializeObject <Trip>(requestBody); await TripRepository <Trip> .Initialize(); if (trip == null) { return((ActionResult) new OkObjectResult("Trip cannot be null or empty")); } try { dynamic u = await TripRepository <Trip> .CreateItemAsync(trip); return((ActionResult) new OkObjectResult("Trip Created Successfully")); } catch (Exception ex) { return((ActionResult) new OkObjectResult("An error has occured")); } }
public static async Task <IActionResult> AddTripRating([HttpTrigger("post", Route = null)] HttpRequest req) { req.IsValidToken(); string requestBody = new StreamReader(req.Body).ReadToEnd(); dynamic data = JsonConvert.DeserializeObject(requestBody); if (string.IsNullOrEmpty((string)data.id)) { return((ActionResult) new OkObjectResult("An Id is needed for this request")); } await TripRepository <Trip> .Initialize(); Trip trip = await TripRepository <Trip> .GetItemAsync(data.id); if (trip != null) { return((ActionResult) new OkObjectResult("No trip available by that id")); } trip.Comment = data.Comment; trip.Rating = data.Rating; var updateTrip = await TripRepository <Trip> .UpdateItemAsync(trip.id, trip); if (updateTrip == null) { return((ActionResult) new OkObjectResult("Failed to update trip")); } return((ActionResult) new OkObjectResult("Thank you for your service")); }
private async void GetPassengersWaiting(Trip trip) { try { using (TripRepository tripRepository = new TripRepository()) { _passengersList = new ObservableCollection <User>(); var tripInDB = await tripRepository.GetTripById(trip.TripId); if (tripInDB.Passengers == null) { passengersListView.ItemsSource = _passengersList; return; } tripInDB.Passengers .Where(p => p.State) .ToList() .ForEach(p => _passengersList.Add(p)); passengersListView.ItemsSource = _passengersList; } } catch (Exception ex) { await DisplayAlert("Error", "An unexpected error has occurred" + ex.Message, "Ok"); } }
public BookingListBLL() { BookingRepository = new BookingRepository(); CruiseRepository = new CruiseRepository(); TripRepository = new TripRepository(); CustomerRepository = new CustomerRepository(); }
public RoomServiceBLL() { RoomClassRepository = new RoomClassRepository(); RoomTypeRepository = new RoomTypeRepository(); CruiseRepository = new CruiseRepository(); TripRepository = new TripRepository(); }
public void Should_Return_All_Trips() { using (var repos = new TripRepository(DataFilePath)) { var result = repos.GetAllTrips(); Assert.That(result.Count(t => t!=null), Is.EqualTo(DataFileRowCountMinusHeader)); } }
public void EnterExpense() { var db = new InMemoryDB(); var personRepository = new PersonRepository(db); var expenseRepository = new ExpenseRepository(db); var tripRepository = new TripRepository(db); var personService = new PersonService(personRepository); var expenseTracking = new ExpenseTracking(personRepository, tripRepository, expenseRepository ); var expenseService = new ExpenseService(expenseRepository); expenseService.CreateExpense("Lunch", "Lunch"); var Personlist = personService.CreatePerson(new string[] { "Suresh", "Sakthivel", "Saravanan" }); var trip = expenseTracking.CreateTrip("trip1", Personlist.Select(p => p.ID)); expenseTracking.EnterExpense(trip.TripID, 1, new int[] { 2, 3 }, "Lunch", 100); var payer = Personlist.Where(p => p.ID == 1).FirstOrDefault(); var payee = Personlist.Where(p => p.ID != 1).FirstOrDefault(); Assert.AreEqual(100, payer.AmountToGet()); Assert.AreEqual(50, payee.AmountToGive()); }
public IHttpActionResult TripPaymentId(string tripId, string orderId) { using (TripRepository tripRepo = new TripRepository()) { return(Ok(tripRepo.TripPaymentId(int.Parse(tripId), int.Parse(orderId)))); } }
public static void SendRapport(int inCons, int inDest, DateTime inStart) { var xmlList = Serializer.Load(); for (int i = 0; i < xmlList.Count; i++) { if (xmlList[i].myTrip.User == inCons && xmlList[i].myTrip.Destination == inDest && xmlList[i].myTrip.Start == inStart) { FullTrip full = xmlList[i]; Trip trip = ModelTransformer.TripModel2Trip(full.myTrip); TripRepository.AddTrip(trip); foreach (var vac in full.myVacation) { vac.tripID = trip.tripID; VacationsRepository.AddVacation(ModelTransformer.VacationModel2Vacation(vac)); } foreach (var item in full.myVerifications) { item.tripID = trip.tripID; VerificationRepository.AddVerification(ModelTransformer.VerificationModel2Verification(item)); } xmlList.RemoveAt(i); } } Serializer.Overwrite(xmlList); }
public ActionResult AddNewPosting(NewPostingViewModel viewModel) { TripRepository tripRepository = new TripRepository(); tripRepository.AddTrip(viewModel, UserAccountsManager.Instance.CurrentUser); return(RedirectToAction("Index")); }
public ActionResult GetTrips(int clientId) { using (TripRepository tripRepo = new TripRepository()) { return(View(tripRepo.GetAllByUser(clientId).ReturnedObject)); } }
public void ReservationCountForTripReturnsCorrectNumber() { var context = new FakeBreakAwayContext(); var tripOne = new Trip { Identifier = Guid.NewGuid() }; var tripTwo = new Trip { Identifier = Guid.NewGuid() }; context.Reservations.Add(new Reservation { Trip = tripOne }); context.Reservations.Add(new Reservation { Trip = tripOne }); context.Reservations.Add(new Reservation { Trip = tripTwo }); var rep = new TripRepository(context); Assert.AreEqual(2, rep.ReservationCountForTrip(tripOne)); }
public HttpResponseMessage VehiclStatus1() { var requestParams = Request.Content.ReadAsStringAsync().Result; bool inRide = false; requestParams = UnescapeCodes(requestParams); List <string> splitedParam = requestParams.Trim().Split(',').ToList(); if (splitedParam.Count > 0) { using (VehicleStatusRepository vsRepo = new VehicleStatusRepository()) { inRide = vsRepo.UpdateCordinates(splitedParam[0], decimal.Parse(splitedParam[1]), splitedParam[4], splitedParam[3]); if (inRide) { int?currentTripId = 0; using (TripRepository tRepo = new TripRepository()) { currentTripId = tRepo.GetLastVehicalOpenTrip(splitedParam[0]); } if (currentTripId != null) { using (TripCoordinatesRepository tripCorrRepo = new TripCoordinatesRepository()) { tripCorrRepo.AddUpdate(new DomainModel.TripCoordinates() { DateTime = DateTime.Now, TripId = currentTripId.Value, LatV = splitedParam[3], LongV = splitedParam[4], }); } } } } } //var vs = new TempRepository().AddUpdate(new DomainModel.TempStatus() //{ // CreatedDate = DateTime.Now, // DataStr =" sss >>> " + sss //}); string result = inRide ? "onn" : "off"; var resp = new HttpResponseMessage(HttpStatusCode.OK); resp.Content = new StringContent(result, System.Text.Encoding.UTF8, "text/plain"); return(resp); //return "on"; }
public UnitOfWork(TripContext context, ILogger <TripRepository> tripLogger, ILogger <StopRepository> stopLogger) { _context = context; _tripLogger = tripLogger; _stopLogger = stopLogger; Trips = new TripRepository(_context, _tripLogger); Stops = new StopRepository(_context, _stopLogger); }
public void Dispose() { if (BookingRepository != null) { BookingRepository.Dispose(); BookingRepository = null; } if (TripRepository != null) { TripRepository.Dispose(); TripRepository = null; } if (CruiseRepository != null) { CruiseRepository.Dispose(); CruiseRepository = null; } if (AgencyRepository != null) { AgencyRepository.Dispose(); AgencyRepository = null; } if (BookingRoomRepository != null) { BookingRoomRepository.Dispose(); BookingRoomRepository = null; } if (BookingHistoryRepository != null) { BookingHistoryRepository.Dispose(); BookingHistoryRepository = null; } if (LockedRepository != null) { LockedRepository.Dispose(); LockedRepository = null; } if (CustomerRepository != null) { CustomerRepository.Dispose(); CustomerRepository = null; } if (UserBLL != null) { UserBLL.Dispose(); UserBLL = null; } if (SeriesRepository != null) { SeriesRepository.Dispose(); SeriesRepository = null; } if (BusTypeRepository != null) { BusTypeRepository.Dispose(); BusTypeRepository = null; } }
public TripServicesImpl(AccountRepository accountRepository, TripRepository tripRepository, BookingRepository bookingRepository, AccountValidator accountValidator, TripValidator tripValidator, BookingValidator bookingValidator) { this.accountRepository = accountRepository; this.tripRepository = tripRepository; this.bookingRepository = bookingRepository; this.accountValidator = accountValidator; this.tripValidator = tripValidator; this.bookingValidator = bookingValidator; }
public PointsController( PointRepository pointRepository, TripRepository tripRepository, PlaceRepository placeRepository ) { _pointRepository = pointRepository; _tripRepository = tripRepository; _placeRepository = placeRepository; }
public IHttpActionResult RateTripByIdPost(string tripId, int rate, bool isRepair) { using (TripRepository vehiclesRepo = new TripRepository()) { RequestResponse returnData = vehiclesRepo.UpdateTripRate(int.Parse(tripId), rate, isRepair); return(Ok(returnData)); } // return Ok(new { IsDone = true, Messages = areaModel.farLeft.lat }); }
public IHttpActionResult GetTripByIdPost(string tripId) { using (TripRepository vehiclesRepo = new TripRepository()) { RequestResponse returnData = vehiclesRepo.GetTripStatus(int.Parse(tripId)); return(Ok(returnData)); } // return Ok(new { IsDone = true, Messages = areaModel.farLeft.lat }); }
public TripsController( UserManager <ApplicationUser> userManager, TripRepository tripRepository, PointRepository pointRepository) { _userManager = userManager; _tripRepository = tripRepository; _pointRepository = pointRepository; }
public void FakeGetCustomersOnFutureTripDoesNotReturnNull() { var trip = new Trip { StartDate = DateTime.Today.AddDays(1) }; var context = new FakeBreakAwayContext(); var rep = new TripRepository(context); Assert.IsNotNull(rep.GetTravelersOnFutureTrip(trip)); }
public async void GetDriverFinishedTrips() { using (TripRepository tripRepository = new TripRepository()) { var driverFinishedTrips = await tripRepository.GetDriverFinishedTrips(_driver); _driverTripsList = new ObservableCollection <Trip>(driverFinishedTrips); driverTripsListView.ItemsSource = _driverTripsList; } }
public async void GetPassengerFinishedTrips() { using (TripRepository tripRepository = new TripRepository()) { var passengerFinishedTrips = await tripRepository.GetPassengerFinishedTrips(_passenger); _passengerTripsList = new ObservableCollection <Trip>(passengerFinishedTrips); passengerTripsListView.ItemsSource = _passengerTripsList; } }
public async void BtnPostTrip_Clicked(object sender, EventArgs e) { try { using (TripRepository tripRepository = new TripRepository()) { if (IsValidForm()) { var result = await DisplayAlert("Warning", "Are you sure ?", "Yes", "No"); if (result) { EnableDisableActivityIndicator(true); EnableDisableControls(false); var trip = new Trip { TripId = Guid.NewGuid().ToString(), Driver = _driver, TripRoute = new TripRoute { MeetingPointLongitude = route.MeetingPoint.Position.Longitude, MeetingPoitnLatitude = route.MeetingPoint.Position.Latitude, MeetingPoitnAddress = route.MeetingPoint.Address, TargetPointLongitude = route.TargetPoint.Position.Longitude, TargetPointLatitude = route.TargetPoint.Position.Latitude, TargetPoitnAddress = route.TargetPoint.Address }, MeetingTime = tpMeetingTime.Time.ToString(), TimestampMeetingDate = Util.SetMeetingDate(tpMeetingTime.Time.ToString()), MeetingDate = Util.FormatMeetingDate(tpMeetingTime.Time.ToString()), Price = Convert.ToDecimal(txtPrice.Text), SeatsAvailables = Convert.ToInt16(txtSeatsAvailables.Text), State = "Posted" }; await tripRepository.AddTrip(trip); EnableDisableActivityIndicator(false); await DisplayAlert("Info", "Route posted successfully", "Ok"); workingPointFlag = string.Empty; RemovePoint(); CleanEntries(); EnableDisableControls(true); await Navigation.PushAsync(new TripWaitingRoomPage(trip)); } } } } catch { EnableDisableActivityIndicator(false); await DisplayAlert("Error", "An unexpected error has occurred", "Ok"); } }
/// <summary> /// When implemented in a derived class, executes the scheduled job asynchronously. Implementations that want to know whether /// the scheduled job is being cancelled can get a <see cref="P:Microsoft.WindowsAzure.Mobile.Service.ScheduledJob.CancellationToken"/> from the <see cref="M:CancellationToken"/> property. /// </summary> /// <returns> /// A <see cref="T:System.Threading.Tasks.Task"/> representing the asynchronous operation. /// </returns> public override async Task ExecuteAsync() { // Load Feed Message var dbConnStr = ConfigurationManager.ConnectionStrings["MTA_DB"].ConnectionString; var combinedUrl = string.Format(Url, ApiKey); var service = new FeedMessageService(combinedUrl); var msgIrt = await service.GetCurrentRealtimeFeedMessage(SubwayLines.RED_GREEN_S); var msgL = await service.GetCurrentRealtimeFeedMessage(SubwayLines.L); var alertFactory = new AlertFactory(); var stopTimeFactory = new StopTimeUpdateFactory(); var tripFactory = new TripFactory(); var vehicleFactory = new VehiclePositionFactory(); var alertsIrt = alertFactory.CreateItemsFromFeedMessage(msgIrt); var alertsL = alertFactory.CreateItemsFromFeedMessage(msgL); using (SqlConnection conn = new SqlConnection(dbConnStr)) { conn.Open(); using (var alertRepos = new AlertRepository() {Connection = conn}) { // Clear Tables alertRepos.ClearAll(); // Load Tables alertRepos.AddRange(alertsIrt); alertRepos.AddRange(alertsL); } var stopsIrt = stopTimeFactory.CreateItemsFromFeedMessage(msgIrt); var stopsL = stopTimeFactory.CreateItemsFromFeedMessage(msgL); using (var stopsRepos = new StopTimeUpdateRepository() { Connection = conn }) { // Clear Tables stopsRepos.ClearAll(); // Load Tables stopsRepos.AddRange(stopsIrt); stopsRepos.AddRange(stopsL); } var tripsIrt = tripFactory.CreateItemsFromFeedMessage(msgIrt); var tripsL = tripFactory.CreateItemsFromFeedMessage(msgL); using (var tripsRepos = new TripRepository() { Connection = conn }) { // Clear Tables tripsRepos.ClearAll(); // Load Tables tripsRepos.AddRange(tripsIrt); tripsRepos.AddRange(tripsL); } var vehiclesIrt = vehicleFactory.CreateItemsFromFeedMessage(msgIrt); var vehiclesL = vehicleFactory.CreateItemsFromFeedMessage(msgL); using (var vehiclesRepos = new VehiclePositionRepository() { Connection = conn }) { // Clear Tables vehiclesRepos.ClearAll(); // Load Tables vehiclesRepos.AddRange(vehiclesIrt); vehiclesRepos.AddRange(vehiclesL); } using (var cmd = new SqlCommand("sp_CreateRealtimeSchedule", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.ExecuteNonQuery(); } } //return Task.FromResult(true); }
public async void Should_Fill_All_Tables() { var msgL = await _mtaFeedService.GetCurrentRealtimeFeedMessage(SubwayLines.L); var msgIrt = await _mtaFeedService.GetCurrentRealtimeFeedMessage(SubwayLines.RED_GREEN_S); var alertFactory = new AlertFactory(); var stopTimeFactory = new StopTimeUpdateFactory(); var tripFactory = new TripFactory(); var vehicleFactory = new VehiclePositionFactory(); var alertsIrt = alertFactory.CreateItemsFromFeedMessage(msgIrt); var alertsL = alertFactory.CreateItemsFromFeedMessage(msgL); using (var alertRepos = new AlertRepository() { Connection = _connection }) { // Clear Tables alertRepos.ClearAll(); // Load Tables alertRepos.AddRange(alertsIrt); alertRepos.AddRange(alertsL); } var stopsIrt = stopTimeFactory.CreateItemsFromFeedMessage(msgIrt); var stopsL = stopTimeFactory.CreateItemsFromFeedMessage(msgL); using (var stopsRepos = new StopTimeUpdateRepository() { Connection = _connection }) { // Clear Tables stopsRepos.ClearAll(); // Load Tables stopsRepos.AddRange(stopsIrt); stopsRepos.AddRange(stopsL); } var tripsIrt = tripFactory.CreateItemsFromFeedMessage(msgIrt); var tripsL = tripFactory.CreateItemsFromFeedMessage(msgL); using (var tripsRepos = new TripRepository() { Connection = _connection }) { // Clear Tables tripsRepos.ClearAll(); // Load Tables tripsRepos.AddRange(tripsIrt); tripsRepos.AddRange(tripsL); } var vehiclesIrt = vehicleFactory.CreateItemsFromFeedMessage(msgIrt); var vehiclesL = vehicleFactory.CreateItemsFromFeedMessage(msgL); using (var vehiclesRepos = new VehiclePositionRepository() { Connection = _connection }) { // Clear Tables vehiclesRepos.ClearAll(); // Load Tables vehiclesRepos.AddRange(vehiclesIrt); vehiclesRepos.AddRange(vehiclesL); } }
/// <summary> /// When implemented in a derived class, executes the scheduled job asynchronously. Implementations that want to know whether /// the scheduled job is being cancelled can get a <see cref="P:Microsoft.WindowsAzure.Mobile.Service.ScheduledJob.CancellationToken"/> from the <see cref="M:CancellationToken"/> property. /// </summary> /// <returns> /// A <see cref="T:System.Threading.Tasks.Task"/> representing the asynchronous operation. /// </returns> public override async Task ExecuteAsync() { // Load Feed Message var dbConnStr = ConfigurationManager.ConnectionStrings["MTA_DB"].ConnectionString; var service = new StaticFileService(new StaticFileDownloader()); StringBuilder sb = new StringBuilder(); List<string> tableNames = new List<string>() { "agency", "calendar", "calendar_dates", "shapes", "stop_times", "transfers", "trips", "routes", "stops", }; tableNames.ForEach(s => sb.AppendFormat("TRUNCATE TABLE {0};", s)); using (var conn = new SqlConnection(dbConnStr)) { using (var cmd = new SqlCommand(sb.ToString(), conn)) { conn.Open(); cmd.ExecuteNonQuery(); } //Agency using (var repository = new AgencyRepository() {Connection = conn}) { // Load Tables repository.AddRange(await service.GetAgencies()); } // using (var repository = new CalendarDateRepository(dbConnStr)) // { // // Load Tables // repository.AddRange(service.GetCalendarDates()); // } //Calendars using (var repository = new CalendarRepository() {Connection = conn}) { // Load Tables repository.AddRange(await service.GetCalendars()); } //Route using (var repository = new RouteRepository() {Connection = conn}) { // Load Tables repository.AddRange(await service.GetRoutes()); } //Shape using (var repository = new ShapeRepository() {Connection = conn}) { // Load Tables repository.AddRange(await service.GetShapes()); } //Stop using (var repository = new StopRepository() {Connection = conn}) { // Load Tables repository.AddRange(await service.GetStops()); } //Stop Time using (var repository = new StopTimeRepository() {Connection = conn}) { // Load Tables repository.AddRange(await service.GetStopTimes()); } //Transfer using (var repository = new TransferRepository() {Connection = conn}) { // Load Tables repository.AddRange(await service.GetTransfers()); } //Trip using (var repository = new TripRepository() {Connection = conn}) { // Load Tables repository.AddRange(await service.GetTrips()); } // Build Stations using (var cmd = new SqlCommand("sp_BuildStations", conn)) { cmd.CommandType = CommandType.StoredProcedure; // conn.Open(); cmd.ExecuteNonQuery(); } using (var cmd = new SqlCommand("sp_CreateStaticSchedule", conn)) { cmd.CommandTimeout = 120; cmd.CommandType = CommandType.StoredProcedure; // conn.Open(); TimeZoneInfo easternZone = TimeZoneInfo.FindSystemTimeZoneById("Eastern Standard Time"); DateTime easternTimeNow = TimeZoneInfo.ConvertTime(DateTime.UtcNow, TimeZoneInfo.Utc, easternZone); cmd.Parameters.AddWithValue("@today", easternTimeNow); cmd.ExecuteNonQuery(); } } }
public void InsertSubList_ExistingEntity_Successfull() { UserEntity Entity = new UserEntity() { ID = Guid.Parse("B42B1A1E-9DD5-4904-B7CE-9D55FD9A547A"), FirstName = "SecondEntity", LastName = "SecondEntity", DateOfBirth = new DateTime(1994, 08, 05, 10, 0, 0), Email = "SecondEntity", UserPassword = "******", Registered = DateTime.Now, LastLogin = DateTime.Now, InvalidPasswordDate = DateTime.Now }; Trip trip = new Trip() { ID = Guid.Parse("053340CE-EE99-48B2-9687-693879933AFE"), TripName = "Trip", TripDescription = "Desc", TripLocation = "Location", RelationID = this.TestUser.ID }; UserEntityRepository Repository = new UserEntityRepository(helper); Entity.Trips.Add(trip); Repository.Update(Entity, true); IList<Trip> trips = Repository.GetByID(this.TestUser.ID).Trips .Where(o => o.ID == trip.ID) .ToList(); Assert.That(Entity.Trips.Any(o => o.ID == trip.ID)); TripRepository RepositoryTrip = new TripRepository(helper); RepositoryTrip.Delete(trip); }
private static async Task AsyncMain() { // Load Feed Message var dbConnStr = ConfigurationManager.ConnectionStrings["DbConnStr"].ConnectionString; var combinedUrl = string.Format(Url, ApiKey); var service = new FeedMessageService(combinedUrl); var msgIrt = await service.GetCurrentRealtimeFeedMessage(SubwayLines.RED_GREEN_S); var msgL = await service.GetCurrentRealtimeFeedMessage(SubwayLines.L); var alertFactory = new AlertFactory(); var stopTimeFactory = new StopTimeUpdateFactory(); var tripFactory = new TripFactory(); var vehicleFactory = new VehiclePositionFactory(); var alertsIrt = alertFactory.CreateItemsFromFeedMessage(msgIrt); var alertsL = alertFactory.CreateItemsFromFeedMessage(msgL); using (SqlConnection conn = new SqlConnection(dbConnStr)) { using (var alertRepos = new AlertRepository() {Connection = conn}) { // Clear Tables alertRepos.ClearAll(); // Load Tables alertRepos.AddRange(alertsIrt); alertRepos.AddRange(alertsL); } var stopsIrt = stopTimeFactory.CreateItemsFromFeedMessage(msgIrt); var stopsL = stopTimeFactory.CreateItemsFromFeedMessage(msgL); using (var stopsRepos = new StopTimeUpdateRepository() { Connection = conn }) { // Clear Tables stopsRepos.ClearAll(); // Load Tables stopsRepos.AddRange(stopsIrt); stopsRepos.AddRange(stopsL); } var tripsIrt = tripFactory.CreateItemsFromFeedMessage(msgIrt); var tripsL = tripFactory.CreateItemsFromFeedMessage(msgL); using (var tripsRepos = new TripRepository() { Connection = conn }) { // Clear Tables tripsRepos.ClearAll(); // Load Tables tripsRepos.AddRange(tripsIrt); tripsRepos.AddRange(tripsL); } var vehiclesIrt = vehicleFactory.CreateItemsFromFeedMessage(msgIrt); var vehiclesL = vehicleFactory.CreateItemsFromFeedMessage(msgL); using (var vehiclesRepos = new VehiclePositionRepository() { Connection = conn }) { // Clear Tables vehiclesRepos.ClearAll(); // Load Tables vehiclesRepos.AddRange(vehiclesIrt); vehiclesRepos.AddRange(vehiclesL); } } }