public TripController() { dbContext = new TripContext(); if (!dbContext.Trips.Any()) { dbContext.Trips.AddRange(Trips); dbContext.SaveChanges(); } }
public IActionResult Post([FromBody] Trip values) { // we are specifying Trips here because we don't // need the db _context to automatically assume it knows // which object. If we had multiple objects, we could leave it // as something like _context.Add(values); // if no workie if (!ModelState.IsValid) { return(BadRequest(ModelState)); } // if workie _context.Trips.Add(values); _context.SaveChanges(); return(Ok()); }
public static void DeleteVehicle(int Id) { using (var db = new TripContext()) { List <Vehicle> vehicles = new List <Vehicle>(); var collection = db.Vehicles. Where(v => v.VehicleId == Id); foreach (var item in collection) { vehicles.Add(item); } db.Vehicles.Remove(vehicles.ElementAt(0)); db.SaveChanges(); } }
public IActionResult Delete(int id) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var myTrip = _context.Trips.Find(id); if (myTrip == null) { return(NotFound()); } _context.Trips.Remove(myTrip); _context.SaveChanges(); return(NoContent()); }
public UnitOfWorkResult <DTO.Trip> Execute(DTO.TripForCreation input) { if (input == null) { return(new UnitOfWorkResult <DTO.Trip>(null, UnitOfWorkStatus.Invalid)); } if (_ownerId == null) { // cannot create a trip when there's no owner id return(new UnitOfWorkResult <DTO.Trip>(null, UnitOfWorkStatus.Forbidden)); } // map to entity var tripEntity = Mapper.Map <DTO.TripForCreation, Repository.Entities.Trip>(input); // create guid var id = Guid.NewGuid(); tripEntity.Id = id; tripEntity.OwnerId = _ownerId; // save the array of bytes on disk // file name (limited/assumes JPG) var fileSystem = new Microsoft.Owin.FileSystems.PhysicalFileSystem("images"); string fileName = Guid.NewGuid().ToString() + ".jpg"; // write and auto-close File.WriteAllBytes(fileSystem.Root + "/" + fileName, input.MainPictureBytes); // fill out URI tripEntity.MainPictureUri = "images/" + fileName; _tripRepository.InsertTrip(tripEntity); // commit _ctx.SaveChanges(); // return a dto var dto = Mapper.Map <Repository.Entities.Trip, DTO.Trip>(tripEntity); return(new UnitOfWorkResult <DTO.Trip>(dto, UnitOfWorkStatus.Ok)); }
public static void DeleteEmployee(int EmployeeId_) { using (var db = new TripContext()) { List <Employee> employees = new List <Employee>(); var result = db.Employees.Where( e => e.EmployeeId == EmployeeId_); foreach (var item in result) { employees.Add(item); } db.Employees.Remove(employees.ElementAt(0)); db.SaveChanges(); } }
private void YesBt_Click(object sender, RoutedEventArgs e) { using (TripContext db = new TripContext()) { Trip trip = db.Trips.Where(t => t.Id == id).FirstOrDefault(); if (trip != null) { if (b) { trip.State = "Завершена"; } else { trip.State = "Отменена"; } } db.SaveChanges(); using (UserContext udb = new UserContext()) { User user = udb.Users.Where(u => u.Name == trip.Name).FirstOrDefault(); if (user != null) { user.state = "Свободен"; } udb.SaveChanges(); } using (CarContext cdb = new CarContext()) { Car car = cdb.Cars.Where(c => c.CarName == trip.CarName).FirstOrDefault(); if (car != null) { car.State = "Свободна"; } cdb.SaveChanges(); } } em.UpdateTripsList(); this.Close(); }
public UnitOfWorkResult <DTO.Trip> Execute(JsonPatchDocument <DTO.Trip> input) { if (input == null) { return(new UnitOfWorkResult <DTO.Trip>(null, UnitOfWorkStatus.Invalid)); } // get the trip var tripEntity = _tripRepository.GetTrip(_tripId); if (tripEntity == null) { return(new UnitOfWorkResult <DTO.Trip>(null, UnitOfWorkStatus.NotFound)); } // we're updating. Only the user that created the trip can update it. if (string.IsNullOrWhiteSpace(tripEntity.OwnerId) || tripEntity.OwnerId != _ownerId) { return(new UnitOfWorkResult <DTO.Trip>(null, UnitOfWorkStatus.Forbidden)); } // convert entity to DTO var dtoForPatch = Mapper.Map <TripGallery.Repository.Entities.Trip, DTO.Trip>(tripEntity); // apply the patchdoc to the DTO input.ApplyTo(dtoForPatch); // update entity tripEntity = Mapper.Map <DTO.Trip, TripGallery.Repository.Entities.Trip> (dtoForPatch); _tripRepository.UpdateTrip(tripEntity); // save _ctx.SaveChanges(); // return DTO var dto = Mapper.Map <Repository.Entities.Trip, DTO.Trip>(tripEntity); return(new UnitOfWorkResult <DTO.Trip>(dto, UnitOfWorkStatus.Ok)); }
//could be served as a service, and then we could use async internal static User EnsureUser(TripContext db, ClaimsPrincipal user) { if (user == null) { return(null); } var u = db.Users.FirstOrDefault(x => x.Name == user.Identity.Name); if (u == null) { //register new user u = new User { Name = user.Identity.Name }; db.Users.Add(u); db.SaveChanges(); } return(u); }
public ActionResult AddTrip(Trip t) { TripContext ts = new TripContext(); if (t.carAvailable == false) { t.vacant_seats = -1; } AspNetUsersContext us = new AspNetUsersContext(); AspNetUsers asp = us.AspNetUsers.Single(a => a.Email == User.Identity.Name); t.created_by = asp.Id; ts.Trips.Add(t); ts.SaveChanges(); TripGroupContext t_gc = new TripGroupContext(); TripGroup tg = new TripGroup(); tg.Id = t.id; tg.People = User.Identity.Name; tg.TripAdmin = t.carAvailable; t_gc.TripGroups.Add(tg); t_gc.SaveChanges(); //if similar trip exists send mail to those people List <Trip> similarTrips = new List <Trip>(); similarTrips = ts.Trips.Where(s => s.source == t.source && s.destination == t.destination).ToList(); foreach (var s in similarTrips) { AspNetUsers aspnetusers = us.AspNetUsers.Single(u => u.Id == s.created_by); if (aspnetusers.Email != User.Identity.Name) { TripController tp = new TripController(); tp.SMTPSendEmail(aspnetusers.Email, User.Identity.Name + " has created a new trip similar to yours", "A trip similar to yours has been created on CarpoolManagementSystem"); } } return(RedirectToAction("TripDetails/" + t.id, "Trip")); }
public ActionResult Create([Bind(Include = "SequenceID,Name,RegionID")] SequenceDisp sDisp) { if (ModelState.IsValid) { Sequence sequence = new Sequence(); sequence.CopyData(sDisp); db.Sequences.Add(sequence); db.SaveChanges(); return(RedirectToAction("Index")); } sDisp.Region = (from r in db.Regions where r.RegionID == sDisp.RegionID select r).First(); ViewBag.RegionID = new SelectList(db.Regions, "RegionID", "Name", sDisp.RegionID); return(View(sDisp)); }
public string JoinTrip(string id) { if (User.Identity.IsAuthenticated) { try { TripGroupContext g = new TripGroupContext(); var tg = g.TripGroups.Where(b => b.Id.ToString() == id).ToArray(); foreach (var d in tg) { if (d.People == User.Identity.Name) { return("2"); } } TripGroup t_g = new TripGroup(); t_g.Id = Int32.Parse(id); t_g.People = User.Identity.Name; t_g.TripAdmin = false; g.TripGroups.Add(t_g); g.SaveChanges(); TripContext t_s = new TripContext(); Trip t = t_s.Trips.Single(d => d.id.ToString() == id); t.vacant_seats = t.vacant_seats - 1; t_s.SaveChanges(); return("3"); } catch { return("3"); } } else { return("1"); } }
public async Task <JsonResult> Post(TripViewModel trip, StopViewModel stop) { var aTrip = Mapper.Map <Trip>(trip); var aStop = Mapper.Map <Stop>(stop); var coord = await cs.Lookup(aStop.Name); if (coord.Success) { aStop.Longitude = coord.Longitude; aStop.Latitude = coord.Latitude; } aTrip.Stops.Add(aStop); if (ModelState.IsValid) { db.Trips.Update(aTrip); db.SaveChanges(); } var result = Mapper.Map <TripViewModel>(aTrip); return(Json(result)); }
public bool Save() { return(_context.SaveChanges() >= 0); }
public void Save() { db.SaveChanges(); }
public void AddTrip(Trip trip) { Context.Trips.Add(trip); Context.SaveChanges(); }
public void InsertSeedData() { // If database does not contain any data, add some if (!db.Trips.Any()) { var aTrip = new Trip() { Name = "Coast to Coast", DateCreated = DateTime.Now, UserName = "", Stops = new List <Stop>() { new Stop() { Name = "Philadelphia, PA", ArrivalDate = new DateTime(2015, 10, 20), Latitude = 39.94907, Longitude = -75.16059, Order = 0 }, new Stop() { Name = "New York, NY", ArrivalDate = new DateTime(2015, 10, 23), Latitude = 40.712784, Longitude = -74.005941, Order = 1 }, new Stop() { Name = "Chicago, IL", ArrivalDate = new DateTime(2015, 10, 30), Latitude = 41.878114, Longitude = -87.629798, Order = 2 }, new Stop() { Name = "Seattle, WA", ArrivalDate = new DateTime(2015, 11, 1), Latitude = 47.606209, Longitude = -122.332071, Order = 3 }, new Stop() { Name = "Philadelphia, PA", ArrivalDate = new DateTime(2015, 11, 20), Latitude = 39.94907, Longitude = -75.16059, Order = 4 } } }; db.Trips.Add(aTrip); db.Stops.AddRange(aTrip.Stops); var bigTrip = new Trip() { Name = "Around the World", DateCreated = DateTime.Now, UserName = "", Stops = new List <Stop>() { new Stop() { Order = 0, Latitude = 39.94907, Longitude = -75.16059, Name = "Philadelphia, PA", ArrivalDate = DateTime.Parse("June 1, 2014") }, new Stop() { Order = 1, Latitude = 48.856614, Longitude = 2.352222, Name = "Paris, France", ArrivalDate = DateTime.Parse("Jun 4, 2014") }, new Stop() { Order = 2, Latitude = 50.850000, Longitude = 4.350000, Name = "Brussels, Belgium", ArrivalDate = DateTime.Parse("Jun 25, 2014") }, new Stop() { Order = 3, Latitude = 51.209348, Longitude = 3.224700, Name = "Bruges, Belgium", ArrivalDate = DateTime.Parse("Jun 28, 2014") }, new Stop() { Order = 4, Latitude = 48.856614, Longitude = 2.352222, Name = "Paris, France", ArrivalDate = DateTime.Parse("Jun 30, 2014") }, new Stop() { Order = 5, Latitude = 51.508515, Longitude = -0.125487, Name = "London, UK", ArrivalDate = DateTime.Parse("Jul 8, 2014") }, new Stop() { Order = 6, Latitude = 51.454513, Longitude = -2.587910, Name = "Bristol, UK", ArrivalDate = DateTime.Parse("Jul 24, 2014") }, new Stop() { Order = 7, Latitude = 52.954783, Longitude = -1.158109, Name = "Nottingham, UK", ArrivalDate = DateTime.Parse("Jul 31, 2014") }, new Stop() { Order = 8, Latitude = 55.953252, Longitude = -3.188267, Name = "Edinburgh, UK", ArrivalDate = DateTime.Parse("Aug 5, 2014") }, new Stop() { Order = 9, Latitude = 55.864237, Longitude = -4.251806, Name = "Glasgow, UK", ArrivalDate = DateTime.Parse("Aug 6, 2014") }, new Stop() { Order = 10, Latitude = 55.953252, Longitude = -3.188267, Name = "Edinburgh, UK", ArrivalDate = DateTime.Parse("Aug 8, 2014") }, new Stop() { Order = 11, Latitude = 51.508515, Longitude = -0.125487, Name = "London, UK", ArrivalDate = DateTime.Parse("Aug 10, 2014") }, new Stop() { Order = 12, Latitude = 52.370216, Longitude = 4.895168, Name = "Amsterdam, Netherlands", ArrivalDate = DateTime.Parse("Aug 14, 2014") }, new Stop() { Order = 13, Latitude = 48.583148, Longitude = 7.747882, Name = "Strasbourg, France", ArrivalDate = DateTime.Parse("Aug 17, 2014") }, new Stop() { Order = 14, Latitude = 46.519962, Longitude = 6.633597, Name = "Lausanne, Switzerland", ArrivalDate = DateTime.Parse("Aug 19, 2014") }, new Stop() { Order = 15, Latitude = 46.021073, Longitude = 7.747937, Name = "Zermatt, Switzerland", ArrivalDate = DateTime.Parse("Aug 27, 2014") }, new Stop() { Order = 16, Latitude = 46.519962, Longitude = 6.633597, Name = "Lausanne, Switzerland", ArrivalDate = DateTime.Parse("Aug 29, 2014") }, new Stop() { Order = 17, Latitude = 54.597285, Longitude = -5.930120, Name = "Belfast, Northern Ireland", ArrivalDate = DateTime.Parse("Sep 7, 2014") }, new Stop() { Order = 18, Latitude = 53.349805, Longitude = -6.260310, Name = "Dublin, Ireland", ArrivalDate = DateTime.Parse("Sep 9, 2014") }, new Stop() { Order = 19, Latitude = 47.368650, Longitude = 8.539183, Name = "Zurich, Switzerland", ArrivalDate = DateTime.Parse("Sep 16, 2014") }, new Stop() { Order = 20, Latitude = 48.135125, Longitude = 11.581981, Name = "Munich, Germany", ArrivalDate = DateTime.Parse("Sep 19, 2014") }, new Stop() { Order = 21, Latitude = 51.050409, Longitude = 13.737262, Name = "Dresden, Germany", ArrivalDate = DateTime.Parse("Oct 1, 2014") }, new Stop() { Order = 22, Latitude = 50.075538, Longitude = 14.437800, Name = "Prague, Czech Republic", ArrivalDate = DateTime.Parse("Oct 4, 2014") }, new Stop() { Order = 23, Latitude = 42.697708, Longitude = 23.321868, Name = "Sofia, Bulgaria", ArrivalDate = DateTime.Parse("Oct 16, 2014") }, new Stop() { Order = 24, Latitude = 41.005270, Longitude = 28.976960, Name = "Istanbul, Turkey", ArrivalDate = DateTime.Parse("Nov 1, 2014") }, new Stop() { Order = 25, Latitude = 45.815011, Longitude = 15.981919, Name = "Zagreb, Croatia", ArrivalDate = DateTime.Parse("Nov 11, 2014") }, new Stop() { Order = 26, Latitude = 41.005270, Longitude = 28.976960, Name = "Istanbul, Turkey", ArrivalDate = DateTime.Parse("Nov 15, 2014") }, new Stop() { Order = 27, Latitude = 50.850000, Longitude = 4.350000, Name = "Brussels, Belgium", ArrivalDate = DateTime.Parse("Nov 25, 2014") }, new Stop() { Order = 28, Latitude = 50.937531, Longitude = 6.960279, Name = "Cologne, Germany", ArrivalDate = DateTime.Parse("Nov 30, 2014") }, new Stop() { Order = 29, Latitude = 48.208174, Longitude = 16.373819, Name = "Vienna, Austria", ArrivalDate = DateTime.Parse("Dec 4, 2014") }, new Stop() { Order = 30, Latitude = 47.497912, Longitude = 19.040235, Name = "Budapest, Hungary", ArrivalDate = DateTime.Parse("Dec 28,2014") }, new Stop() { Order = 31, Latitude = 37.983716, Longitude = 23.729310, Name = "Athens, Greece", ArrivalDate = DateTime.Parse("Jan 2, 2015") }, new Stop() { Order = 32, Latitude = 43.771033, Longitude = 11.248001, Name = "Florence, Italy", ArrivalDate = DateTime.Parse("Feb 1, 2015") }, new Stop() { Order = 33, Latitude = 41.872389, Longitude = 12.480180, Name = "Rome, Italy", ArrivalDate = DateTime.Parse("Feb 17, 2015") }, new Stop() { Order = 34, Latitude = 28.632244, Longitude = 77.220724, Name = "New Delhi, India", ArrivalDate = DateTime.Parse("Mar 4, 2015") }, new Stop() { Order = 35, Latitude = 27.700000, Longitude = 85.333333, Name = "Kathmandu, Nepal", ArrivalDate = DateTime.Parse("Mar 10, 2015") }, new Stop() { Order = 36, Latitude = 22.1667, Longitude = 113.5500, Name = "Macau", ArrivalDate = DateTime.Parse("Mar 21, 2015") }, new Stop() { Order = 37, Latitude = 22.396428, Longitude = 114.109497, Name = "Hong Kong", ArrivalDate = DateTime.Parse("Mar 24, 2015") }, new Stop() { Order = 38, Latitude = 39.904030, Longitude = 116.407526, Name = "Beijing, China", ArrivalDate = DateTime.Parse("Apr 19, 2015") }, new Stop() { Order = 39, Latitude = 1.352083, Longitude = 103.819836, Name = "Singapore", ArrivalDate = DateTime.Parse("Apr 30, 2015") }, new Stop() { Order = 40, Latitude = 3.139003, Longitude = 101.686855, Name = "Kuala Lumpor, Malaysia", ArrivalDate = DateTime.Parse("May 7, 2015") }, new Stop() { Order = 41, Latitude = 13.727896, Longitude = 100.524123, Name = "Bangkok, Thailand", ArrivalDate = DateTime.Parse("May 24, 2015") }, new Stop() { Order = 42, Latitude = 39.94907, Longitude = -75.16059, Name = "Philadelphia, PA", ArrivalDate = DateTime.Parse("Jun 1, 2015") }, } }; db.Trips.Add(bigTrip); db.Stops.AddRange(bigTrip.Stops); db.SaveChanges(); } }