public void SaveTrip(Trip trip) { if (trip.Id == 0) { Db.Trips.Add(trip); } else { Trip dbEntry = Db.Trips.Find(trip.Id); if (dbEntry != null) { dbEntry.ClientID = trip.ClientID; dbEntry.CountryID = trip.CountryID; dbEntry.DaysCount = trip.DaysCount; dbEntry.FlightID = trip.FlightID; dbEntry.HotelID = trip.HotelID; dbEntry.ResortID = trip.ResortID; dbEntry.Vehicle = trip.Vehicle; dbEntry.Client = trip.Client; dbEntry.Country = trip.Country; dbEntry.Flight = trip.Flight; dbEntry.Hotel = trip.Hotel; dbEntry.Resort = trip.Resort; } } Db.SaveChanges(); }
public ActionResult Trips_Create([DataSourceRequest]DataSourceRequest request, TripGridInputModel trip) { var newId = 0; if (this.ModelState.IsValid) { var from = this.locations.GetAll().FirstOrDefault(x => x.Name == trip.From); var to = this.locations.GetAll().FirstOrDefault(x => x.Name == trip.To); var entity = new Trip { FromId = from.Id, ToId = to.Id, AvailableSeats = trip.AvailableSeats, StartDate = trip.StartDate, Description = trip.Description }; this.trips.Create(entity); newId = entity.Id; } var tripToDisplay = this.trips .GetAll() .To<TripGridViewModel>() .FirstOrDefault(x => x.Id == newId); return this.Json(new[] { tripToDisplay }.ToDataSourceResult(request, this.ModelState)); }
public void given_trip_with_date_not_after_today_when_checking_is_valid_should_be_false() { var results = new List<ValidationResult>(); var trip = new Trip { Date = 23.November(1972) }; trip.TryValidate(results).Should().BeFalse(); results.Should().NotBeEmpty(); }
public ActionResult Trips_Destroy([DataSourceRequest]DataSourceRequest request, Trip trip) { var tripToDelete = this.trips.GetByIntId(trip.Id); this.trips.Delete(tripToDelete); return this.Json(new[] { trip }.ToDataSourceResult(request, this.ModelState)); }
public ViewResult CreateTripAction(CreateTrip createTrip) { if (ModelState.IsValid) { Trip trip = new Trip { Description = createTrip.Description, Destination = createTrip.Destination, StartDate = createTrip.Begin.Date.ToString(), EndDate = createTrip.End.Date.ToString(), MyName = createTrip.MyName }; trip.TripUsers = new List<TripUser>(); TripUser userMe = new TripUser { DisplayName = createTrip.MyName, Phone = createTrip.MyPhone }; trip.TripUsers.Add(userMe); return View("InviteFriends", trip); } else { var errors = ModelState.Values.SelectMany(v => v.Errors); return View("CreateTrip", createTrip); } }
/// <summary> /// Initializes a new instance of the TripViewModel class. /// </summary> public CurrentTripViewModel() { Trip trip = new Trip(); trip.Name = "Australie en famille 2014"; trip.BeginDate = DateTime.Now.AddDays(-20); trip.EndDate = DateTime.Now.AddDays(-12); CurrentTrip = trip; }
public async Task EnsureSeedDataAsync() { if (await _userManager.FindByEmailAsync("*****@*****.**") == null) { //Add the user var newUser = new WorldUser() { UserName = "******", Email = "*****@*****.**" }; await _userManager.CreateAsync(newUser, "abcd1234"); } if (!_context.Trips.Any()) { //Add New Data var usTrip = new Trip() { Name = "US Trip", Created = DateTime.UtcNow, UserName = "******", Stops = new List <Stop>() { new Stop() {Name = "Atlanta, GA", Arrival = new DateTime(2014, 5, 21), Latitude = 33.7550, Longitude = 84.3900, Order = 0}, new Stop() {Name = "Phoenix, AZ", Arrival = new DateTime(2014, 5, 25), Latitude = 33.4500, Longitude = 112.0667, Order = 1}, new Stop() {Name = "Los Angeles, CA", Arrival = new DateTime(2014, 6, 10), Latitude = 34.0500, Longitude = 118.2500, Order = 2}, new Stop() {Name = "Dallas, TX", Arrival = new DateTime(2014, 6, 25), Latitude = 32.7767, Longitude = 96.7970, Order = 3}, new Stop() {Name = "Atlanta, GA", Arrival = new DateTime(2014, 7, 3), Latitude = 33.7550, Longitude = 84.3900, Order = 4} } }; _context.Trips.Add(usTrip); _context.Stops.AddRange(usTrip.Stops); var worldTrip = new Trip() { Name = "World Trip", Created = DateTime.UtcNow, UserName = "******", Stops = new List<Stop>() { new Stop() {Name = "Country 1", Arrival = new DateTime(2015, 4, 21), Latitude = 33.7550, Longitude = 84.3900, Order = 0}, new Stop() {Name = "Country 2", Arrival = new DateTime(2015, 4, 25), Latitude = 33.4500, Longitude = 112.0667, Order = 1}, new Stop() {Name = "Country 3", Arrival = new DateTime(2015, 5, 10), Latitude = 34.0500, Longitude = 118.2500, Order = 2}, new Stop() {Name = "Country 4", Arrival = new DateTime(2015, 5, 25), Latitude = 32.7767, Longitude = 96.7970, Order = 3}, new Stop() {Name = "Country 5", Arrival = new DateTime(2015, 6, 3), Latitude = 33.7550, Longitude = 84.3900, Order = 4} } }; _context.Trips.Add(worldTrip); _context.Stops.AddRange(worldTrip.Stops); _context.SaveChanges(); } }
public void ShouldReturnTripsByLoggedUser() { var friend = new User (); var trip = new Trip (); userSession.Setup (x => x.GetLoggedUser()).Returns(friend); var user = new Mock<User>(); user.Setup (x => x.GetFriends()).Returns (new List<User> {friend, friend}); tripDao.Setup (x => x.FindTripsByUser (It.IsAny<User> ())).Returns (new List<Trip> { trip }); var tripsOfFiends = tripService.GetTripsByUser (user.Object); Assert.AreEqual(1, tripsOfFiends.Count); }
public ActionResult Create(Trip trip) { try { // TODO: Add insert logic here db.AddTrip(trip); return RedirectToAction("Index"); } catch { return View(); } }
public void UpdateTrip(Trip trip) { var original = db.Trip.SingleOrDefault(m => m.IDTrip == trip.IDTrip); if (original != null) { original.Name = trip.Name; original.Includes = trip.Includes; original.Minimum = trip.Minimum; original.Operation = trip.Operation; original.PickupTime = trip.PickupTime; original.Price = trip.Price; db.SaveChanges(); } }
public ActionResult Create(Trip trip) { if (ModelState.IsValid) { trip.TripID = Guid.NewGuid(); repository.Add(trip); repository.Commit(); return RedirectToAction("Details", new RouteValueDictionary(new { id = trip.TripID})); } return View(trip); }
public ActionResult Index() { List<SelectListItem> items; lock (_sync) { items = _reportBuilder.GetReportWriters(). Select(writer => new SelectListItem { Text = writer.Key, Value = writer.Key }).ToList(); } var model = new Trip() { FormatTypes = items }; return View(model); }
public void AddView(Trip trip, string ip) { bool userAlreadySeenThisTrip = trip.Views .Where(v => v.TripId == trip.Id && v.Ip == ip) .Any(); if (!userAlreadySeenThisTrip) { View view = new View() { TripId = trip.Id, Ip = ip }; this.viewRepos.Add(view); this.viewRepos.Save(); } }
public static void Main(string[] args) { string s; while ((s = Console.ReadLine()) != "-1") { string[] ss = s.Split(' '); Trip trip = new Trip(int.Parse(ss[0])); int m = int.Parse(ss[1]); while (m-- > 0) { string[] input = Console.ReadLine().Split(' '); trip.AddEdge(int.Parse(input[0]) - 1, int.Parse(input[1]) - 1, int.Parse(input[2])); } trip.Gao(); } }
public TripControllerTest() { userTrip = new Trip(loggedInUser.UserID); userTrip.current_weight = 10; userTrip.description = "My Trip"; userTrip.destination = "Egypt"; userTrip.total_capacity = 15; userTrip.weather = "Sunny"; repository.Add(userTrip); notUserTrip = new Trip(Guid.NewGuid()); notUserTrip.current_weight = 15; notUserTrip.description = "Trip 1"; notUserTrip.destination = "Seattle"; notUserTrip.total_capacity = 20; notUserTrip.weather = "Rainy"; notUserRepository.Add(notUserTrip); provider = new MockAuthenticatedUserProvider(loggedInUser); }
private static void InsertDestination() { var destination = new Destination { Country = "Indonesia", Description = "EcoTourism at its best in exquisite Bali", Name = "Bali is the new place to be" }; var trip = new Trip { CostUSD = 800, StartDate = new DateTime(2011,9,1), EndDate = new DateTime(2011,9,14) }; var person = new Person { FirstName = "Hugo", LastName = "Girard", SocialSecurityNumber = 12345678 }; using (var context = new BreakAwayContext()) { context.Persons.Add(person); context.Trips.Add(trip); context.Destinations.Add(destination); context.SaveChanges(); } using (var context = new BreakAwayContext()) { // Here the update behind will add a where clause to the SocialSecurity number (page 50 book Code First) var people = context.Persons.FirstOrDefault(); people.FirstName = "John"; context.SaveChanges(); } }
public ActionResult CreateTrip(CreateTripViewModel tripToRegister) { if (!this.ModelState.IsValid) { return this.View(tripToRegister); } var locations = this.locations.GetAll().ToList(); this.ViewBag.Locations = new SelectList(locations, "Id", "Name"); var tripToCreate = new Trip() { Description = tripToRegister.Description, StartDate = tripToRegister.StartDate, AvailableSeats = tripToRegister.AvailableSeats, FromId = tripToRegister.From, ToId = tripToRegister.To, DriverId = this.User.Identity.GetUserId() }; this.trips.Create(tripToCreate); return this.RedirectToAction("Index", "Home", new { area = string.Empty }); }
public void AddTripTrails(Trip trip) { if (_tripTrailLayer != null) { _map.Layers.Remove(_tripTrailLayer); } if (_tripInfoLayer != null) { _map.Layers.Remove(_tripInfoLayer); } Features trailFeatures = new Features(); Features infoFeatures = new Features(); int lastSpeedColorIndex = -1; Point lastPoint = null; List <Point> points = new List <Point>(); double?firstLat = null; double?firstLon = null; foreach (Video video in trip.Videos) { foreach (KeyValuePair <int, TrailItem> kvp in video.TrailItems.ToList()) { var item = kvp.Value; if (item.Longitude == 0 && item.Latitude == 0) { continue; } if (firstLat == null) { firstLat = item.Latitude; firstLon = item.Longitude; } var location = SphericalMercator.FromLonLat(item.Longitude, item.Latitude); if (lastPoint != null && location.Distance(lastPoint) < 35) { continue; } infoFeatures.Add(new Feature() { Geometry = location, ["Video"] = video, ["Seconds"] = kvp.Key }); lastPoint = location; int index = MapColors.GetStyleIndexFromSpeed(item.SpeedMph); if (index != lastSpeedColorIndex) { if (lastSpeedColorIndex != -1) { points.Add(location); } if (points.Count > 0) { List <IStyle> styleList = new List <IStyle> { MapColors.LineStyles[lastSpeedColorIndex] }; trailFeatures.Add(new Feature() { Geometry = new LineString(points), Styles = styleList }); } points.Clear(); } points.Add(location); lastSpeedColorIndex = index; } } _tripTrailLayer = new MemoryLayer { DataSource = new MemoryProvider() { Features = trailFeatures }, Name = "TripLayer", Style = null }; _tripInfoLayer = new MemoryLayer { DataSource = new MemoryProvider() { Features = infoFeatures }, Name = "MoviesLayer", Style = new SymbolStyle { SymbolScale = 0.5, SymbolOffset = new Offset(0, 0), SymbolType = SymbolType.Ellipse, //Line = new Pen(Color.Black, 2), //Fill = new Brush(Color.White), //Opacity = 0.1 Line = new Pen(Color.White, 0), Fill = new Brush(Color.Transparent), Opacity = 0.0 } }; _map.Layers.Insert(1, _tripTrailLayer); //_map.Layers.Insert(1, _tripInfoLayer); _map.InfoLayers.Add(_tripInfoLayer); if (_positionLayer != null) { MemoryProvider dataSource = ((MemoryProvider)((MemoryLayer)_positionLayer).DataSource); dataSource.Features.Clear(); } if (firstLat != null && firstLon != null) { MoveToArea((double)firstLat, (double)firstLon, 0.001); } MapControl.RefreshData(); }
public void Remove(Trip trip) { _context.Trips.Remove(trip); }
public async Task ChangeArrivalDateAsync(Trip trip, DateTime arrivalDate) { trip.ArriavalDate = arrivalDate; await tripRepository.UpdateAsync(trip); }
public TripCategory(string name, Trip trip) { Name = name; Trip = trip; }
private bool grdInputsDocuments_Restore() { RFMCursorWait.Set(true); RFMCursorWait.LockWindowUpdate(FindForm().Handle); oInputDocumentCur.ClearOne(); oInputDocumentList.ClearError(); oInputDocumentList.ClearFilters(); oInputDocumentList.ID = null; oInputDocumentList.IDList = null; // собираем условия // даты if (!dtrDates.dtpBegDate.IsEmpty) { oInputDocumentList.FilterDateBeg = dtrDates.dtpBegDate.Value.Date; } if (!dtrDates.dtpEndDate.IsEmpty) { oInputDocumentList.FilterDateEnd = dtrDates.dtpEndDate.Value.Date; } // доставка? if (optDeliveryNeed.Checked) { oInputDocumentList.FilterDeliveryNeed = true; } if (optDeliveryNeedNot.Checked) { oInputDocumentList.FilterDeliveryNeed = false; } // клиенты-поставщики if (txtPartnerSourceNameContext.Text.Trim().Length > 0) { Partner oPartnerSource = new Partner(); oPartnerSource.FilterNameContext = txtPartnerSourceNameContext.Text.Trim(); oPartnerSource.FillData(); oInputDocumentList.FilterPartnersSourceList = ""; foreach (DataRow rcs in oPartnerSource.MainTable.Rows) { oInputDocumentList.FilterPartnersSourceList += rcs["ID"].ToString() + ","; } } if (ucSelectRecordID_PartnersSource.IsSelectedExist) { oInputDocumentList.FilterPartnersSourceList += ucSelectRecordID_PartnersSource.GetIdString(); } // клиенты-получатели if (txtPartnerTargetNameContext.Text.Trim().Length > 0) { Partner oPartnerTarget = new Partner(); oPartnerTarget.FilterNameContext = txtPartnerTargetNameContext.Text.Trim(); oPartnerTarget.FillData(); oInputDocumentList.FilterPartnersTargetList = ""; foreach (DataRow rct in oPartnerTarget.MainTable.Rows) { oInputDocumentList.FilterPartnersTargetList += rct["ID"].ToString() + ","; } } if (ucSelectRecordID_PartnersTarget.IsSelectedExist) { oInputDocumentList.FilterPartnersTargetList += ucSelectRecordID_PartnersTarget.GetIdString(); } // владельцы if (ucSelectRecordID_Owners.IsSelectedExist) { oInputDocumentList.FilterOwnersList = ucSelectRecordID_Owners.GetIdString(); } // рейс? if (optTripExists.Checked) { oInputDocumentList.FilterTripExists = true; } if (optTripExistsNot.Checked) { oInputDocumentList.FilterTripExists = false; } // выбранные товары if (sSelectedPackingsIDList.Length > 0) { oInputDocumentList.FilterPackingsList = sSelectedPackingsIDList; } // подтверждение if (optInputsDocumentsIsConfirmedNot.Checked) { oInputDocumentList.FilterIsConfirmed = false; } if (optInputsDocumentsIsConfirmed.Checked) { oInputDocumentList.FilterIsConfirmed = true; } // по рейсу string sTripsList = ""; if (txtTripAliasContext.Text.Trim().Length > 0) { Trip oTripFilter = new Trip(); oTripFilter.FilterAliasContext = txtTripAliasContext.Text.Trim(); oTripFilter.FillData(); if (oTripFilter.ErrorNumber == 0 && oTripFilter.MainTable != null) { foreach (DataRow tr in oTripFilter.MainTable.Rows) { sTripsList += tr["ID"].ToString() + ","; } } oInputDocumentList.FilterTripsList = sTripsList; } if (numTripID.Value > 0) { if (oInputDocumentList.FilterTripsList == null) { oInputDocumentList.FilterTripsList = Convert.ToInt32(numTripID.Value).ToString(); } else { oInputDocumentList.FilterTripsList += Convert.ToInt32(numTripID.Value).ToString(); } } // хосты if (nUserHostID.HasValue) { oInputDocumentList.FilterHostsList = nUserHostID.ToString(); } else { if (ucSelectRecordID_Hosts.IsSelectedExist) { oInputDocumentList.FilterHostsList = ucSelectRecordID_Hosts.GetIdString(); } } // начальные условия if (oInputDocument != null) { if (oInputDocument.FilterOwnersList != null) { oInputDocumentList.FilterOwnersList = oInputDocument.FilterOwnersList; } if (oInputDocument.FilterPartnersSourceList != null) { oInputDocumentList.FilterPartnersSourceList = oInputDocument.FilterPartnersSourceList; } if (oInputDocument.FilterPartnersTargetList != null) { oInputDocumentList.FilterPartnersTargetList = oInputDocument.FilterPartnersTargetList; } if (oInputDocument.FilterHostsList != null) { if (!nUserHostID.HasValue) { oInputDocumentList.FilterHostsList = oInputDocument.FilterHostsList; } else { if (!((string)("," + oInputDocument.FilterHostsList + ",")).Contains("," + nUserHostID.ToString().Trim() + ",")) { oInputDocumentList.FilterHostsList = "-1"; } } } } // grdInputsDocumentsGoods.DataSource = null; grdInputsDocuments.GetGridState(); oInputDocumentList.FillData(); grdInputsDocuments.IsLockRowChanged = true; grdInputsDocuments.Restore(oInputDocumentList.MainTable); tmrRestore.Enabled = true; RFMCursorWait.LockWindowUpdate(IntPtr.Zero); RFMCursorWait.Set(false); return(oInputDocumentList.ErrorNumber == 0); }
public void ChangeDepartureDate(Trip trip, DateTime departureDate) { trip.DepartureDate = departureDate; tripRepository.Update(trip); }
//static void Main() //{ // var locationsLists = GetLocationsLists(); // using (var sr = new StreamReader("App_Data\\Geo-Routes.txt")) // { // var lines = sr.ReadToEnd(); // MapTools.routes = JsonConvert.DeserializeObject<Dictionary<string, Route>>(lines) ?? // new Dictionary<string, Route>(); // } // using (var sr = new StreamReader("App_Data\\Geo-Location-Names.txt")) // { // var lines = sr.ReadToEnd(); // MapTools.locationNames = JsonConvert.DeserializeObject<Dictionary<string, string>>(lines) ?? // new Dictionary<string, string>(); // } // using (var sr = new StreamReader("App_Data\\Geo-Location-Addresses.txt")) // { // var lines = sr.ReadToEnd(); // MapTools.locationAddresses = JsonConvert.DeserializeObject<Dictionary<string, Pair<string, string>>>(lines) ?? // new Dictionary<string, Pair<string, string>>(); // } // int tripCount = 0; // foreach (LocationsList locationList in locationsLists) // foreach (Location location in locationList.locations) // foreach (Location l in locationList.locations.Where(l => !l.Equals(location))) // { // tripCount++; // System.Threading.Thread.Sleep(2000); // MapTools.GetRoute(location, l); // } // var routesString = JsonConvert.SerializeObject(MapTools.routes); // var locationNamesString = JsonConvert.SerializeObject(MapTools.locationNames); // var locationAddresses = JsonConvert.SerializeObject(MapTools.locationAddresses); // File.WriteAllText("App_Data\\Geo-Routes.txt", String.Empty); // using (var sr = new StreamWriter("App_Data\\Geo-Routes.txt")) // { // sr.Write(routesString); // } // File.WriteAllText("App_Data\\Geo-Location-Names.txt", String.Empty); // using (var sr = new StreamWriter("App_Data\\Geo-Location-Names.txt")) // { // sr.Write(locationNamesString); // } // File.WriteAllText("App_Data\\Geo-Location-Addresses.txt", String.Empty); // using (var sr = new StreamWriter("App_Data\\Geo-Location-Addresses.txt")) // { // sr.Write(locationAddresses); // } // Console.WriteLine(tripCount + " trips generated"); // Console.ReadKey(); //} static void Main() { const string host = "mongodb://SG-tripthru-3110.servers.mongodirector.com:27017/"; const string database = "TripThru"; const string nameCollection = "trips"; const string pathTripData = @"C:\Users\OscarErnesto\Downloads\tripData2013\trip_data_1.csv\trip_data_1.csv"; const string pathTripFare = @"C:\Users\OscarErnesto\Downloads\faredata2013\trip_fare_1.csv\trip_fare_1.csv"; const string pathRandomsNames = @"C:\Users\OscarErnesto\Documents\Visual Studio 2013\Projects\Gateway\Db\FakeName.csv"; MongoDB.Bson.Serialization.BsonClassMap.RegisterClassMap <Trip>(cm => { cm.AutoMap(); foreach (var mm in cm.AllMemberMaps) { mm.SetIgnoreIfNull(true); } cm.GetMemberMap(c => c.Status).SetRepresentation(BsonType.String); cm.GetMemberMap(c => c.PickupTime).SetIgnoreIfNull(true); cm.GetMemberMap(c => c.PickupLocation).SetIgnoreIfNull(true); cm.GetMemberMap(c => c.FleetId).SetIgnoreIfNull(true); cm.GetMemberMap(c => c.FleetName).SetIgnoreIfNull(true); cm.GetMemberMap(c => c.ETA).SetIgnoreIfNull(true); cm.GetMemberMap(c => c.DropoffLocation).SetIgnoreIfNull(true); cm.GetMemberMap(c => c.DropoffTime).SetIgnoreIfNull(true); cm.GetMemberMap(c => c.DriverRouteDuration).SetIgnoreIfNull(true); cm.GetMemberMap(c => c.DriverId).SetIgnoreIfNull(true); cm.GetMemberMap(c => c.OccupiedDistance).SetIgnoreIfNull(true); cm.GetMemberMap(c => c.DriverName).SetIgnoreIfNull(true); cm.GetMemberMap(c => c.Price).SetIgnoreIfNull(true); cm.GetMemberMap(c => c.ServicingPartnerName).SetIgnoreIfNull(true); cm.GetMemberMap(c => c.ServicingPartnerId).SetIgnoreIfNull(true); cm.GetMemberMap(c => c.VehicleType).SetIgnoreIfNull(true); cm.GetMemberMap(c => c.DriverLocation).SetIgnoreIfNull(true); cm.GetMemberMap(c => c.DriverInitiaLocation).SetIgnoreIfNull(true); cm.GetMemberMap(c => c.LastUpdate).SetIgnoreIfNull(true); cm.GetMemberMap(c => c.loc); }); MongoCollection <Trip> trips; var server = MongoServer.Create(host); var tripsDatabase = server.GetDatabase(database); trips = tripsDatabase.GetCollection <Trip>(nameCollection); var tripReader = new StreamReader(File.OpenRead(pathTripData)); var fareReader = new StreamReader(File.OpenRead(pathTripFare)); var namesReader = new StreamReader(File.OpenRead(pathRandomsNames)); var r = new Random(DateTime.Now.Millisecond); var listNames = new Dictionary <string, string>(); var listPassengerNames = new Dictionary <string, string>(); var countLines = 1; namesReader.ReadLine(); tripReader.ReadLine(); fareReader.ReadLine(); int re = 0; while (re < 1000) { tripReader.ReadLine(); fareReader.ReadLine(); re++; } while (countLines <= 5000) { var trip = new Trip(); var tripLine = tripReader.ReadLine(); var fareLine = fareReader.ReadLine(); if (tripLine == null) { continue; } var tripValues = tripLine.Split(','); if (fareLine == null) { continue; } var fareValues = fareLine.Split(','); if (!listNames.ContainsKey(tripValues[0])) { var identity = namesReader.ReadLine(); if (identity != null) { var name = identity.Split('\t'); var completeName = name[3] + " " + name[4] + " " + name[5]; listNames.Add(tripValues[0], completeName); } } if (!listPassengerNames.ContainsKey(tripValues[1])) { var identity = namesReader.ReadLine(); if (identity != null) { var name = identity.Split('\t'); var completeName = name[3] + " " + name[4] + " " + name[5]; listPassengerNames.Add(tripValues[1], completeName); } } try { trip.Id = countLines + "d@[email protected]"; trip.DriverName = listNames[tripValues[0]]; var lat = Convert.ToDouble(tripValues[13]); var lng = Convert.ToDouble(tripValues[12]); if (Math.Abs(lat) > 0 && Math.Abs(lng) > 0 && Math.Abs(lng) < 180 && Math.Abs(lat) < 180) { trip.DropoffLocation = new Location(lat, lng); } else { Console.WriteLine("Incomplete Trip"); continue; } trip.DriverInitiaLocation = new Location(40.769004, -73.981376); trip.DropoffTime = Convert.ToDateTime(tripValues[6]).AddYears(1).AddMonths(5); trip.DropoffTime = trip.DropoffTime.Value.AddDays(-1 * trip.DropoffTime.Value.Day); trip.DropoffTime = trip.DropoffTime.Value.AddDays(r.Next(1, 31)); trip.EnrouteDistance = Convert.ToDouble(tripValues[9]); trip.FleetId = "30"; trip.FleetName = "NY Taxi"; trip.OriginatingPartnerId = "*****@*****.**"; trip.OriginatingPartnerName = "NY Taxi"; trip.PassengerName = listPassengerNames[tripValues[1]]; lat = Convert.ToDouble(tripValues[11]); lng = Convert.ToDouble(tripValues[10]); if (Math.Abs(lat) > 0 && Math.Abs(lng) > 0 && Math.Abs(lng) < 180 && Math.Abs(lat) < 180) { trip.PickupLocation = new Location(lat, lng); } else { Console.WriteLine("Incomplete Trip"); continue; } trip.PickupTime = Convert.ToDateTime(tripValues[5]).AddYears(1).AddMonths(5); trip.PickupTime = trip.PickupTime.Value.AddDays(-1 * trip.PickupTime.Value.Day); trip.PickupTime = trip.PickupTime.Value.AddDays(trip.DropoffTime.Value.Day); trip.LastUpdate = trip.DropoffTime; trip.Price = Convert.ToDouble(fareValues[10]); trip.ServicingPartnerId = "*****@*****.**"; trip.ServicingPartnerName = "NY Taxi"; trip.Status = Status.Complete; trips.Insert(trip); Console.WriteLine(trip.Id); countLines++; } catch (Exception) { Console.WriteLine("ERROR Incomplete Trip"); } } foreach (var variable in listNames) { Console.WriteLine(variable.Value); } Console.WriteLine(listNames.Count); Console.WriteLine(listPassengerNames.Count); Console.ReadLine(); }
// GET: Trip/Details/5 public ActionResult Details(int?thisTripId) { if (thisTripId == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } // ViewBag value for holding part of google maps url data string ViewBag.Markers = ""; string[] colours = { "red", "green", "blue" }; Trip trip = dbcontext.Trips.Find(thisTripId); if (trip == null) { return(new HttpStatusCodeResult(HttpStatusCode.NotFound)); } ViewEditTripsViewModel model = new ViewEditTripsViewModel(); model.TripInstance = trip; var list = new List <TripLocationsInstanceViewModels>(); int i = 0; foreach (var item in dbcontext.Trip_Locations.ToList()) { if (item.Id_Trip == thisTripId) { foreach (var location in dbcontext.Locations.ToList()) { if (item.Id_Location == location.Id) { // Create a marker string using current location data; can be modified for any url string if needed depending on map provider ++i; // cycles the string array in a loop ViewBag.Markers += "&markers=color:" + colours[(i - 1) % 3] + "|label:" + i.ToString() + "|" + location.Name + "," + location.Town + "," + location.Country; // ******************** list.Add(new TripLocationsInstanceViewModels { Country = location.Country, Town = location.Town, Name = location.Name, Description = location.Description, LocationImage = location.LocationImage, Number = item.Number, RouteInstanceId = item.Id }); } } } } model.Route = new TripLocationsViewModels(); if (list.Count() > 0) { model.Route.ListElement = list; } if (thisTripId != null && dbcontext.Trips.Find(thisTripId) != null) { model.Route.Id_Trip = (int)thisTripId; } //return free spots left FOR NOW STATIC VALUES. Bookings controller is not implemented model.NumSpotsLeft = countFreeSpots((int)thisTripId); //return number of reservations model.NumberOfReservations = countReservavtionsMade((int)thisTripId); // add coach info to List foreach (var item in dbcontext.Coaches.ToList()) { if (trip.CoachNumberId == item.Id) { model.CoachBanner = item.VehScreenshot; model.CoachModel = item.Brand + " " + item.VehModel + " - no." + item.VehicleNumber; } } return(View(model)); }
public static List <Trip> FindTradeRoutes() { if (Market.Instance.OrdersByType == null) { return(null); } if (Market.Instance.OrdersByType.Count == 0) { return(null); } var profitableTx = new List <Transaction>(); // for each item type Parallel.ForEach(Market.Instance.OrdersByType, (orderGroup, state) => { var orders = orderGroup.ToList(); // query volume and name for this item type once var type = Db.Instance.Types.Where(t => t.typeID == orderGroup.Key).Select(t => new { typeVolume = t.volume, typeName = t.typeName }).FirstOrDefault(); // although typeId should return a result every time, an outdated static database may yield null if (type == null) { return; } var volume = type.typeVolume; var name = type.typeName; foreach (var o in orders) { o.TypeVolume = volume; o.TypeName = name; } var transactions = from s in orders join b in orders on s.TypeId equals b.TypeId where s.Bid == false && b.Bid == true && s.Price < b.Price //select new { sell = s, buy = b }; select new Transaction(s, b); foreach (var tx in transactions) { //var tx = new Transaction(t.sell, t.buy); if (Settings.Default.IsHighSec && tx.SellOrder.StationSecurity < 0.5) { continue; } if (tx.Profit < Settings.Default.MinBaseProfit) { continue; } tx.Waypoints = Map.Instance.FindRoute(tx.StartSystemId, tx.EndSystemId); if (tx.Waypoints == null) { continue; } tx.Jumps = tx.Waypoints.Count; tx.ProfitPerJump = tx.Jumps > 0 ? tx.Profit / (double)tx.Jumps : tx.Profit; if (tx.ProfitPerJump >= Settings.Default.MinProfitPerJump) { profitableTx.Add(tx); } //profitableTx.Add(tx); } }); // Parallel.ForEach if (profitableTx.Count == 0) { return(null); } var playerSystemId = Auth.Instance.GetLocation(); if (playerSystemId == 0) { playerSystemId = Settings.Default.DefaultLocation; } var stationPairGroups = profitableTx.GroupBy(x => new { x.StartStationId, x.EndStationId }). Select(y => y.OrderByDescending(x => x.Profit).ToList()); var trips = new List <Trip>(); Parallel.ForEach(stationPairGroups, tx => //foreach(var tx in stationPairGroups) { var selectedTx = new List <Transaction>(); // find the route once for this station pair var waypoints = tx.First().Waypoints; //Map.FindRoute(tx.First().StartSystemId, tx.First().EndSystemId); var isk = Settings.Default.Capital; var vol = Settings.Default.MaxCargo; var types = tx.GroupBy(x => x.TypeId).Select(x => x.Key); foreach (var typeId in types) { var buyOrders = tx.Where(x => x.TypeId == typeId).Select(x => x.BuyOrder).OrderByDescending(x => x.Price).GroupBy(x => x.OrderId).Select(x => x.First()).ToList(); var sellOrders = tx.Where(x => x.TypeId == typeId).Select(x => x.SellOrder).OrderBy(x => x.Price).GroupBy(x => x.OrderId).Select(x => x.First()).ToList(); var tracker = sellOrders.GroupBy(x => x.OrderId).Select(x => x.First()).ToDictionary(x => x.OrderId, x => x.VolumeRemaining); // try to fill buy orders foreach (var buyOrder in buyOrders) { var quantityToFill = Math.Max(buyOrder.MinVolume, buyOrder.VolumeRemaining); var temp = new List <Transaction>(); foreach (var sellOrder in sellOrders) { if (tracker[sellOrder.OrderId] <= 0) { continue; } var quantity = Math.Min(tracker[sellOrder.OrderId], quantityToFill); var partialTx = new Transaction(sellOrder, buyOrder, quantity); partialTx.Waypoints = waypoints; partialTx.Jumps = waypoints.Count; partialTx.ProfitPerJump = partialTx.Jumps > 0 ? partialTx.Profit / (double)partialTx.Jumps : partialTx.Profit; if (partialTx.Cost <= isk && partialTx.Weight <= vol) { quantityToFill -= partialTx.Quantity; isk -= partialTx.Cost; vol -= partialTx.Weight; temp.Add(partialTx); } else { //add partially var quantityIsk = (int)(isk / sellOrder.Price); var quantityWeight = (int)(vol / sellOrder.TypeVolume); var quantityPart = Math.Min(quantityIsk, quantityWeight); if (quantityPart > 0) { var partTx = new Transaction(sellOrder, buyOrder, quantityPart); partTx.Waypoints = waypoints; partTx.Jumps = waypoints.Count; partTx.ProfitPerJump = partTx.Jumps > 0 ? partTx.Profit / (double)partTx.Jumps : partTx.Profit; if (partTx.Profit > Settings.Default.MinFillerProfit) { quantityToFill -= partTx.Quantity; isk -= partTx.Cost; vol -= partTx.Weight; temp.Add(partTx); } } } // Filled buy order if (quantityToFill == 0) { break; } } // foreach sell order // Filling the buy order was successfull, commit if (quantityToFill == 0 || quantityToFill > buyOrder.MinVolume) { selectedTx.AddRange(temp); foreach (var t in temp) { //isk -= t.Cost; //vol -= t.Weight; tracker[t.SellOrder.OrderId] -= t.Quantity; //t.Waypoints = waypoints; } } else // could not fill buy order completely, undo { foreach (var t in temp) { isk += t.Cost; vol += t.Weight; } } } // foreach buy order } // for each type if (selectedTx.Count > 0) { // creating a trip out of transactions for this station pair var trip = new Trip(); trip.Transactions = selectedTx; trip.Profit = trip.Transactions.Sum(x => x.Profit); trip.Cost = trip.Transactions.Sum(x => x.Cost); trip.Weight = trip.Transactions.Sum(x => x.Weight); // change playerSystemId here to find remote routes trip.Waypoints = Map.Instance.FindRoute(playerSystemId, trip.Transactions.First().StartSystemId); if (trip.Waypoints != null) { trip.Jumps = trip.Waypoints.Count + trip.Transactions.First().Jumps; trip.ProfitPerJump = (trip.Jumps > 0 ? trip.Profit / (double)trip.Jumps : trip.Profit); var ssn = Db.Instance.Stations.First(s => s.stationID == trip.Transactions.First().StartStationId).stationName; var bsn = Db.Instance.Stations.First(s => s.stationID == trip.Transactions.First().EndStationId).stationName; // TODO: just save the station names once in the trip class foreach (var t in trip.Transactions) { t.SellOrder.StationName = ssn; t.BuyOrder.StationName = bsn; } trip.SecurityWaypoints = new List <SolarSystem>(); foreach (var systemId in trip.Waypoints.Concat(trip.Transactions.First().Waypoints)) { var sec = Db.Instance.SolarSystems.First(x => x.solarSystemID == systemId); trip.SecurityWaypoints.Add(sec); } if (trip.ProfitPerJump >= Settings.Default.MinProfitPerJump) { trips.Add(trip); } } } }); return(trips.OrderByDescending(x => x.ProfitPerJump).ToList()); }
public ActionResult Destroy([DataSourceRequest] DataSourceRequest request, Trip trip) { this.tripService.MarkAsDeleted(trip); return(Json(new[] { trip }.ToDataSourceResult(request, ModelState))); }
public List <Note> LoadNotesFromTrip(Trip trip) { return(db.notes.Where(x => x.Trip == trip).ToList()); }
public static string ImportTrips(StationsDbContext context, string jsonString) { var deserializedTrips = JsonConvert.DeserializeObject <TripDto[]>(jsonString); var validTrips = new List <Trip>(); var sb = new StringBuilder(); foreach (var tripDto in deserializedTrips) { if (!IsValid(tripDto)) { sb.AppendLine(FailureMessage); continue; } if (tripDto.Status == null) { tripDto.Status = "OnTime"; } bool trainExists = context.Trains.Any(t => t.TrainNumber == tripDto.Train); bool originStationExists = context.Stations.Any(s => s.Name == tripDto.OriginStation); bool destinationStationExists = context.Stations.Any(s => s.Name == tripDto.DestinationStation); DateTime arrivalTime = DateTime.ParseExact(tripDto.ArrivalTime, "dd/MM/yyyy HH:mm", CultureInfo.InvariantCulture); DateTime departureTime = DateTime.ParseExact(tripDto.DepartureTime, "dd/MM/yyyy HH:mm", CultureInfo.InvariantCulture); bool departureTimeIsBeforeArrivalTime = departureTime < arrivalTime; if (!trainExists || !originStationExists || !destinationStationExists || !departureTimeIsBeforeArrivalTime) { sb.AppendLine(FailureMessage); continue; } TimeSpan?timeDifference = null; if (tripDto.TimeDifference != null) { timeDifference = TimeSpan.ParseExact(tripDto.TimeDifference, @"hh\:mm", CultureInfo.InvariantCulture); } int trainId = context.Trains.AsNoTracking().SingleOrDefault(t => t.TrainNumber == tripDto.Train).Id; int originStationId = context.Stations.AsNoTracking().SingleOrDefault(s => s.Name == tripDto.OriginStation).Id; int destinationStationId = context.Stations.AsNoTracking().SingleOrDefault(s => s.Name == tripDto.DestinationStation).Id; var tripStatus = Enum.Parse <TripStatus>(tripDto.Status, true); Trip trip = new Trip { Status = tripStatus, TimeDifference = timeDifference, TrainId = trainId, OriginStationId = originStationId, DestinationStationId = destinationStationId, ArrivalTime = arrivalTime, DepartureTime = departureTime, }; validTrips.Add(trip); sb.AppendLine($"Trip from {tripDto.OriginStation} to {tripDto.DestinationStation} imported."); } context.Trips.AddRange(validTrips); context.SaveChanges(); string result = sb.ToString().TrimEnd(); return(result); }
public IActionResult UpdateTrip(int tripId, [FromBody] Trip trip) { _service.UpdateTrip(tripId, trip); return(Ok(trip)); }
public void Update(Trip trip) { _context.Trips.Update(trip); }
public async Task <Trip> AddTripAsync(User user, Trip trip) { trip.UserId = user.Id; return(await tripRepository.AddAsync(trip)); }
public ActionResult Create(MileageFormVM model, Trip trip) { var startAddress = ParseAddress(model.StartAddress); var endAddress = ParseAddress(model.EndAddress); string startCityValue = startAddress[2].Trim(); string startSiteName = startAddress[0].Trim(); string startStreetAddress = startAddress[1].Trim(); string endCityValue = endAddress[2].Trim(); string endSiteName = endAddress[0].Trim(); string endStreetAddress = endAddress[1].Trim(); //create the cities var startCity = new City { Name = startCityValue }; var endCity = new City { Name = endCityValue }; var startAddressCreate = new Address(); var endAddressCreate = new Address(); var checkStartCity = db.Cities.Where(c => c.Name == startCityValue); int startCityCount = 0; checkStartCity.ToList().ForEach(x => { startCityCount++; }); if (startCityCount < 1) { new CitiesController().Create(startCity); } startAddressCreate.CityID = db.Cities.Where(c => c.Name == startCityValue).SingleOrDefault().ID; var checkEndCity = db.Cities.Where(c => c.Name == endCityValue); int endCityCount = 0; checkEndCity.ToList().ForEach(x => { endCityCount++; }); if (endCityCount < 1) { new CitiesController().Create(endCity); } endAddressCreate.CityID = db.Cities.Where(c => c.Name == endCityValue).SingleOrDefault().ID; startAddressCreate.SiteName = startSiteName; startAddressCreate.StreetAddress = startStreetAddress; var checkStartAddress = db.Addresses.Where(c => c.SiteName == startSiteName); int startAddressCount = 0; checkStartAddress.ToList().ForEach(x => { startAddressCount++; }); if (startAddressCount < 1) { new AddressesController().Create(startAddressCreate); } trip.StartAddressID = db.Addresses.Where(a => a.SiteName == startSiteName).SingleOrDefault().ID; endAddressCreate.SiteName = endSiteName; endAddressCreate.StreetAddress = endStreetAddress; var checkEndAddress = db.Addresses.Where(c => c.SiteName == endSiteName); int endAddressCount = 0; checkEndAddress.ToList().ForEach(x => { endAddressCount++; }); if (endAddressCount < 1) { new AddressesController().Create(endAddressCreate); } trip.EndAddressID = db.Addresses.Where(a => a.SiteName == endSiteName).SingleOrDefault().ID; trip.Distance = model.Distance; trip.Date = model.Date; new TripController().Add(trip); return(RedirectToAction("Details", "MileageForms", new { id = trip.MileageFormID })); }
public void CURDCollectionNavigationPropertyAndRef() { this.TestClientContext.MergeOption = MergeOption.OverwriteChanges; Person person = new Person() { FirstName = "Sheldon", LastName = "Cooper", UserName = "******" }; this.TestClientContext.AddToPeople(person); this.TestClientContext.SaveChanges(); int personId = person.PersonId; var startDate = DateTime.Now; Trip trip1 = new Trip() { PersonId = personId, TrackGuid = Guid.NewGuid(), ShareId = new Guid("c95d15e8-582b-44cf-9e97-ff63a5f26091"), Name = "Honeymoon", Budget = 2000.0f, Description = "Happy honeymoon trip", StartsAt = startDate, EndsAt = startDate.AddDays(3), LastUpdated = DateTime.UtcNow, }; Trip trip2 = new Trip() { PersonId = personId, TrackGuid = Guid.NewGuid(), ShareId = new Guid("56947cf5-2133-43b8-81f0-b6c3f1e5e51a"), Name = "Honeymoon", Budget = 3000.0f, Description = "Happy honeymoon trip", StartsAt = startDate.AddDays(1), EndsAt = startDate.AddDays(5), LastUpdated = DateTime.UtcNow, }; this.TestClientContext.AddToTrips(trip1); this.TestClientContext.SaveChanges(); // Create a related entity by Navigation link this.TestClientContext.AddRelatedObject(person, "Trips", trip2); this.TestClientContext.SaveChanges(); // Query Navigation properties. var trips = this.TestClientContext.People .ByKey(new Dictionary <string, object> { { "PersonId", personId } }) .Trips.ToList(); Assert.Equal(2, trips.Count()); Assert.True(trips.Any(t => t.TripId == trip1.TripId)); Assert.True(trips.Any(t => t.TripId == trip2.TripId)); // Get $ref HttpWebRequestMessage request = new HttpWebRequestMessage( new DataServiceClientRequestMessageArgs( "Get", new Uri(string.Format(this.TestClientContext.BaseUri + "/People({0})/Trips/$ref", personId), UriKind.Absolute), false, false, new Dictionary <string, string>())); using (var response = request.GetResponse() as HttpWebResponseMessage) { Assert.Equal(200, response.StatusCode); using (var stream = response.GetStream()) { StreamReader reader = new StreamReader(stream); var expectedPayload = "{" + "\r\n" + @" ""@odata.context"":""http://*****:*****@" {" + "\r\n" + string.Format(@" ""@odata.id"":""http://*****:*****@" ""@odata.id"":""http://localhost:18384/api/Trippin/Trips({0})""", trip2.TripId) + "\r\n" + " }" + "\r\n" + " ]" + "\r\n" + "}"; var content = reader.ReadToEnd(); Assert.Equal(expectedPayload, content); } } // Delete $ref this.TestClientContext.DeleteLink(person, "Trips", trip2); this.TestClientContext.SaveChanges(); // Expand Navigation properties this.TestClientContext.Detach(trip1); person = this.TestClientContext.People .ByKey(new Dictionary <string, object> { { "PersonId", personId } }) .Expand(t => t.Trips) .GetValue(); Assert.Equal(1, person.Trips.Count); Assert.True(person.Trips.Any(t => t.TripId == trip1.TripId)); Person person2 = new Person() { FirstName = "Sheldon2", LastName = "Cooper2", UserName = "******" }; this.TestClientContext.AddToPeople(person2); this.TestClientContext.SaveChanges(); personId = person2.PersonId; // Add $ref this.TestClientContext.AddLink(person2, "Trips", trip2); this.TestClientContext.SaveChanges(); // Expand Navigation properties this.TestClientContext.Detach(trip1); this.TestClientContext.Detach(trip2); person = this.TestClientContext.People .ByKey(new Dictionary <string, object> { { "PersonId", personId } }) .Expand(t => t.Trips) .GetValue(); Assert.Equal(1, person.Trips.Count); Assert.True(person.Trips.Any(t => t.TripId == trip2.TripId)); }
protected override void OnCreate(Bundle savedInstanceState) { base.OnCreate(savedInstanceState); SetContentView(Resource.Layout.nItem_fragment); // DisplayMetrics dm = new DisplayMetrics(); // WindowManager.DefaultDisplay.GetMetrics(dm); // Window.SetLayout(dm.WidthPixels * 80 / 100, dm.HeightPixels * 60 / 100); //Window.SetGravity(GravityFlags.Top); //ColorDrawable dw = new ColorDrawable(Android.Graphics.Color.Black); //Window.SetBackgroundDrawable(dw); // this.setBackgroundDrawable(dw); var toolBar = FindViewById <Android.Support.V7.Widget.Toolbar>(Resource.Id.toolbar); SetSupportActionBar(toolBar); SupportActionBar.SetDisplayHomeAsUpEnabled(true); SupportActionBar.SetHomeButtonEnabled(true); ViewPager viewpager = (ViewPager)FindViewById(Resource.Id.viewPager); //Trip Spiner Spinner spinner_trip = FindViewById <Spinner>(Resource.Id.additem_trip_spinner); var trip_list = Trip.search(this, "complete_date = ?", new string[] { "" }, "registration_date ASC"); List <string> trip_list_array = new List <string>(); if (trip_list == null) { trip_list_array.Add(""); } else { foreach (Trip t in trip_list) { trip_list_array.Add(t.destiny); } } var adapter_trip = new ArrayAdapter(this, Android.Resource.Layout.SimpleSpinnerDropDownItem, trip_list_array); spinner_trip.Adapter = adapter_trip; //Category Spiner Spinner spinner_category = FindViewById <Spinner>(Resource.Id.additem_category_spinner); var category_list = Category.get_all(this); List <string> category_names = new List <string>(); foreach (Category c in category_list) { category_names.Add(c.name); } var adapter_category = new ArrayAdapter(this, Android.Resource.Layout.SimpleSpinnerDropDownItem, category_names.ToArray()); spinner_category.Adapter = adapter_category; Button add_item = FindViewById <Button>(Resource.Id.additem_buttonAdd); add_item.Click += delegate { var txtValue = FindViewById <TextView>(Resource.Id.additem_txtValue).Text; var txtDetails = FindViewById <TextView>(Resource.Id.additem_txtDetails).Text; var txtCategory = spinner_category.SelectedItem.ToString(); var txtTrip = spinner_trip.SelectedItem.ToString(); Item i = new Item(); i.value = txtValue == "" ? float.Parse("0.0") : float.Parse(txtValue); i.value *= -1; i.details = txtDetails == "" ? " -- " : txtDetails; i.trip_id = trip_list.Find(x => x.destiny == spinner_trip.SelectedItem.ToString()).id; i.category_id = category_list.Find(x => x.name == spinner_category.SelectedItem.ToString()).id; i.save(this); Resume_Fragment resumeFragment = MyFragmentAdapter.getLastResumeFragment(); if (resumeFragment != null) { resumeFragment.FillHashList(); resumeFragment.adapter.NotifyDataSetChanged(); } TripCurrent_Fragment tripcFragment = MyFragmentAdapter.getlastTripCurrentFragment(); if (tripcFragment != null) { tripcFragment.updateCurrentFragment(); } this.Finish(); }; }
public async Task ChangeDepartureDateAsync(Trip trip, DateTime departureDate) { trip.DepartureDate = departureDate; await tripRepository.UpdateAsync(trip); }
public Trip AddTrip(User user, Trip trip) { trip.UserId = user.Id; return(tripRepository.Add(trip)); }
public IEnumerable<SelectListItem> GetleftAvailableSeatsSelectList(Trip trip) { int carSeats = trip.Driver.Car.TotalSeats; int availableLeftSeatsCount = this.tripServices.GetTakenSeatsCount(trip.Id); int maxAvailableLeftSeats = carSeats - availableLeftSeatsCount; var leftAvailableSeatsSelectList = new List<SelectListItem>(); for (int i = 0; i <= maxAvailableLeftSeats; i++) { leftAvailableSeatsSelectList.Add(new SelectListItem() { Text = i.ToString(), Value = i.ToString() }); } return leftAvailableSeatsSelectList; }
protected override void LoadModel(object savedModel) { trip = (Trip)savedModel; }
partial void InsertTrip(Trip instance);
private void Load_Planning_Click(object sender, RoutedEventArgs e) { selectedTrips = new List <DataGridTrips>(); City city = new City(); Trip trip = new Trip(); //1. get the startCityID city.cityName = txtStartCity.Text; var startCityResult = city.GetCityName(city.cityName); if (startCityResult.Count != 0) { trip.startCityID = startCityResult[0].cityID; } else { trip.startCityID = ""; } //2. get the endCityID city.cityName = txtEndCity.Text; var endCityResult = city.GetCityName(city.cityName); if (endCityResult.Count != 0) { trip.endCityID = endCityResult[0].cityID; } else { trip.endCityID = ""; } //retreive order data var viewTrips = trip.GetTripsST(trip.startCityID, trip.endCityID); if (viewTrips.Count != 0) { for (int i = 0; i < viewTrips.Count; i++) { trip.orderID = txtOrderID.Text; trip.startCity = viewTrips[i].startCityID; trip.endCity = viewTrips[i].endCityID; if (viewTrips[i].startCityID == viewTrips[i].endCityID && viewTrips[i].startCityID == viewTrips[i].originalCityID) { viewTrips[i].tripStatus = "loading"; } else if ((viewTrips[i].startCityID == viewTrips[i].endCityID && viewTrips[i].endCityID == viewTrips[i].desCityID)) { viewTrips[i].tripStatus = "unloading"; } else { viewTrips[i].tripStatus = "driving"; } selectedTrips.Add(new DataGridTrips { TranNo = (i + 1).ToString(), startCityName = viewTrips[i].startCityName, endCityName = viewTrips[i].endCityName, distance = viewTrips[i].distance, workingTime = viewTrips[i].workingTime, tripStatus = viewTrips[i].tripStatus }); } tripResultDataGrid.ItemsSource = selectedTrips; tripResultDataGrid.Items.Refresh(); } else { MessageBox.Show("There is no plan information for the order. Please check the plan information first.", "Check the plan information."); } }
public void ChangeArivalDate(Trip trip, DateTime arrivalDate) { trip.ArriavalDate = arrivalDate; tripRepository.Update(trip); }
public BillingAndPlanning(Order order) { InitializeComponent(); var orderList = order.GetOrderDetailWithID(order.orderID); if (orderList.Count != 0) { txtCustomerName.Text = orderList[0].customerName; txtOrderID.Text = orderList[0].orderID; txtStartCity.Text = orderList[0].startCityName.ToString(); txtEndCity.Text = orderList[0].endCityName.ToString(); City city = new City(); Trip trip = new Trip(); //1. get the startCityID city.cityName = txtStartCity.Text; var startCityResult = city.GetCityName(city.cityName); trip.startCityID = startCityResult[0].cityID; //2. get the endCityID city.cityName = txtEndCity.Text; var endCityResult = city.GetCityName(city.cityName); trip.endCityID = endCityResult[0].cityID; //retreive order data var viewTrips = trip.GetTripsST(trip.startCityID, trip.endCityID); for (int i = 0; i < viewTrips.Count; i++) { trip.orderID = txtOrderID.Text; trip.startCity = viewTrips[i].startCityID; trip.endCity = viewTrips[i].endCityID; if (viewTrips[i].startCityID == viewTrips[i].endCityID && viewTrips[i].startCityID == viewTrips[i].originalCityID) { viewTrips[i].tripStatus = "loading"; } else if ((viewTrips[i].startCityID == viewTrips[i].endCityID && viewTrips[i].endCityID == viewTrips[i].desCityID)) { viewTrips[i].tripStatus = "unloading"; } else { viewTrips[i].tripStatus = "driving"; } selectedTrips.Add(new DataGridTrips { TranNo = (i + 1).ToString(), startCityName = viewTrips[i].startCityName, endCityName = viewTrips[i].endCityName, distance = viewTrips[i].distance, workingTime = viewTrips[i].workingTime, tripStatus = viewTrips[i].tripStatus }); } tripResultDataGrid.ItemsSource = selectedTrips; tripResultDataGrid.Items.Refresh(); } else { MessageBox.Show("There is no trip information for the order. Please check the trip information first.", "Check the trips information."); } }
public ViewResult InviteFriends(Trip trip) { return View(trip); }
public void Create_trip_adds_to_repository() { TripController controller = new TripController(repository, provider); Trip newTrip = new Trip(provider.AuthenticatedUser.UserID); newTrip.current_weight = 8; newTrip.description = "London Trip"; newTrip.destination = "London"; newTrip.total_capacity = 12; newTrip.weather = "Cloudy"; controller.Create(newTrip); ViewResult result = controller.Index() as ViewResult; IQueryable<Trip> model = result.Model as IQueryable<Trip>; Assert.IsTrue(model.Contains(newTrip)); Assert.AreEqual(2, model.Count()); }
partial void DeleteTrip(Trip instance);
/// <summary> /// Return a Trip object from session based on the provided trip ID. /// Does not do validation, but will create Trip if validation has been done. /// </summary> /// <param name="tripId">ID of trip to retrieve</param> /// <returns>Initialized trip pulled from session</returns> private Trip GetTrip(string tripId) { if (String.IsNullOrWhiteSpace(tripId)) { return null; } Trip trip; if (Session["trip"] != null) { trip = (Trip)Session["trip"]; if (trip.ID == tripId) { return trip; } } //TODO: Validate before creating trip try { trip = new Trip(tripId); } catch { return null; } return trip; }
partial void UpdateTrip(Trip instance);
public IHttpActionResult PutTripInPerson([FromODataUri] string key, [FromODataUri] int tripId, Trip trip) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (tripId != trip.TripId) { return(BadRequest("The TripId of Trip does not match the tripId.")); } var person = TripPinSvcDataSource.Instance.People.SingleOrDefault(item => item.UserName == key); if (person == null) { return(NotFound()); } var oldTrip = person.Trips.SingleOrDefault(item => item.TripId == tripId); if (oldTrip == null) { return(NotFound()); } person.Trips.Remove(oldTrip); person.Trips.Add(trip); return(Updated(trip)); }
protected override void InitializeModel() { trip = new Trip(); trip.Mode = TripMode.RoundTrip; trip.StartingFrom.Date = DateTime.Today; trip.ReturningFrom.Date = DateTime.Today.AddDays(1); }
public void Delete(Trip trip) { this.trips.Delete(trip); this.trips.Save(); }
private void Load_Billing_Btn_Click(object sender, RoutedEventArgs e) { //get Shipping Route Trip trip = new Trip(); trip.orderID = billingOrderID.Text; var billingTripData = trip.GetTripBilling(trip.orderID); if (billingTripData.Count != 0) { trip.carrierID = billingTripData[0].carrierID; var shippingRoute = trip.GetShowTripsForBillings(trip.orderID, trip.carrierID); //assign values for DataGrid IList <DataGridRoute> selectedTrips = new List <DataGridRoute>(); for (int i = 0; i < shippingRoute.Count; i++) { trip.tripID = shippingRoute[i].tripID; trip.startCityName = shippingRoute[i].startCityName; trip.endCityName = shippingRoute[i].endCityName; trip.distance = shippingRoute[i].distance; trip.workingTime = shippingRoute[i].workingTime; //FTL if (billingJobType.Text == "FTL") { trip.price = 4.985 * shippingRoute[i].distance + ((4.985 * shippingRoute[i].distance) * 8 / 100); trip.rate = shippingRoute[i].ftlRate; billingTotalAmount.Text = (Convert.ToDouble(billingTotalAmount.Text) + trip.price).ToString("0.##"); } //LTL else if (billingJobType.Text == "LTL") { trip.price = 0.2995 * shippingRoute[i].quantity * shippingRoute[i].distance + ((0.2995 * shippingRoute[i].quantity * shippingRoute[i].distance) * 5 / 100); trip.rate = shippingRoute[i].ltlRate; billingTotalAmount.Text = (Convert.ToDouble(billingTotalAmount.Text) + trip.price).ToString("0.##"); } selectedTrips.Add(new DataGridRoute { tripID = shippingRoute[i].tripID, startCityName = shippingRoute[i].startCityName, endCityName = shippingRoute[i].endCityName, distance = shippingRoute[i].distance, workingTime = shippingRoute[i].workingTime, tripStatus = shippingRoute[i].tripStatus, rate = trip.rate.ToString("0.##"), price = trip.price.ToString("0.##") }); } billingDataGrid.ItemsSource = selectedTrips; billingDataGrid.Items.Refresh(); } else { MessageBox.Show("There is no billing information for the order. Please check the billing information first.", "Check the billing information."); } }
// GET: Trip/Edit/5 public ActionResult Edit(int?thisTripId) { if (thisTripId == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } if (!UserRoleHelper.IsAdmin(User.Identity.GetUserId())) { if (!UserRoleHelper.IsEmployee(User.Identity.GetUserId()))// check if current user has admin or employee rights { return(RedirectToAction("AccessDenied", "Manage")); } } //check for reservations. Cannot edit while there are any. int NumberOfReservations = countReservavtionsMade((int)thisTripId); Trip trip = dbcontext.Trips.Find(thisTripId); //get current trip if (trip == null) { return(new HttpStatusCodeResult(HttpStatusCode.NotFound)); } ViewEditTripsViewModel model = new ViewEditTripsViewModel(); model.TripInstance = trip; //check for reservations. Cannot edit while there are any and trip is yet to end var currTime = DateTime.Now; if (NumberOfReservations > 0 && model.TripInstance.DateBack > currTime) { return(RedirectToAction("Index", new { Message = ManageMessageId.CannotEditEntry })); } //get a list of all sub-locations that this trip has var list = new List <TripLocationsInstanceViewModels>(); foreach (var item in dbcontext.Trip_Locations.ToList()) { if (item.Id_Trip == thisTripId) { foreach (var location in dbcontext.Locations.ToList()) { if (item.Id_Location == location.Id) { list.Add(new TripLocationsInstanceViewModels { Country = location.Country, Town = location.Town, Name = location.Name, Description = location.Description, LocationImage = location.LocationImage, Number = item.Number, RouteInstanceId = item.Id }); } } } } model.Route = new TripLocationsViewModels(); if (list.Count() > 0) { model.Route.ListElement = list; } if (thisTripId != null && dbcontext.Trips.Find(thisTripId) != null) { model.Route.Id_Trip = (int)thisTripId; } // list that has every coach in database var listOfCoaches = dbcontext.Coaches.ToList(); var currDate = DateTime.Now; // go through every trip in db that is in progress atm. A coach assigned to that trip will be removed from our list, so it cant be assigned //to this currently edited trip foreach (var coach in dbcontext.Coaches.ToList()) { foreach (var tripInstance in dbcontext.Trips.ToList()) { if (tripInstance.DateDeparture < model.TripInstance.DateDeparture && model.TripInstance.DateDeparture < tripInstance.DateBack) { if (coach.Id == tripInstance.CoachNumberId) { listOfCoaches.Remove(coach); } } } } ViewBag.DateDeparture = model.TripInstance.DateDeparture; ViewBag.DateBack = model.TripInstance.DateBack; model.CoachVehicleIdList = new SelectList(listOfCoaches, "Id", "VehicleNumber"); return(View(model)); }
public ViewResult InviteFriendsAction(Trip trip) { return View("TripDetails"); }
public async Task <bool> DeleteAddOn(int addOnId, int tripId) { using (_unitOfWork) { if (addOnId <= 0) { return(false); } AddOnDTO deletedAddOn = null; AddOn prevAddOn = null; Trip trip = await _unitOfWork.TripRepository.FindByID(tripId); AddOn currAddOn = await _unitOfWork.AddOnRepository.GetAddOnWithVotable(trip.AddOnId); while (true) { if (currAddOn.GetDecoratorId() == 0) { break; } if (currAddOn.AddOnId == addOnId) { if (prevAddOn == null) { trip.AddOnId = currAddOn.GetDecoratorId(); _unitOfWork.TripRepository.Update(trip); } else { prevAddOn.SetDecoratorId(currAddOn.GetDecoratorId()); _unitOfWork.AddOnRepository.Update(prevAddOn); } _unitOfWork.AddOnRepository.Delete(currAddOn.AddOnId); _unitOfWork.VotableRepository.Delete(currAddOn.VotableId); await _unitOfWork.Save(); deletedAddOn = _mapper.Map <AddOn, AddOnDTO>(currAddOn); break; } if (currAddOn.GetLvl1DependId() == addOnId || currAddOn.GetLvl2DependId() == addOnId) { if (prevAddOn == null) { trip.AddOnId = currAddOn.GetDecoratorId(); _unitOfWork.TripRepository.Update(trip); } else { prevAddOn.SetDecoratorId(currAddOn.GetDecoratorId()); _unitOfWork.AddOnRepository.Update(prevAddOn); } _unitOfWork.AddOnRepository.Delete(currAddOn.AddOnId); _unitOfWork.VotableRepository.Delete(currAddOn.VotableId); await _unitOfWork.Save(); } else { prevAddOn = currAddOn; } if (prevAddOn == null) { currAddOn = await _unitOfWork.AddOnRepository.GetAddOnWithVotable(trip.AddOnId); } else { currAddOn = await _unitOfWork.AddOnRepository.GetAddOnWithVotable(prevAddOn.GetDecoratorId()); } } await _messageControllerService.NotifyOnTripChanges(tripId, "RemoveAddOn", deletedAddOn); return(true); } }
public void Create(Trip trip) { this.trips.Add(trip); this.trips.Save(); }
public void AddTrip(Trip trip) { trips.Add(trip); }
public void Update(Trip trip) { this.trips.Save(); }
public async Task AddAsync(Trip trip) { await _context.Trips.AddAsync(trip); }