private void Delete(Place place) { _context.Places.DeleteObject(new PlaceEntity { Id = place.Id }); _context.SaveChanges(); }
public void Add(Place place, long userId) { if (place == null) { throw new ArgumentNullException("place"); } if (string.IsNullOrEmpty(place.Description.Trim())) { throw new ArgumentNullException("place.Description"); } if (place.Location == null) { throw new ArgumentNullException("place.Location"); } // try to set the place page name var name = this.GetAscii(place.Description); if (!this.IsAvailable(name)) { // if it's not available, try to concat the location to the name name = GetAscii(name + place.Location.Description); // if it's not available, try to concat a number if (!this.IsAvailable(name)) { name = this.GetAscii(place.Description); int c = 1; while (!this.IsAvailable(name + c)) { c++; } name = name + c; } } var placeEntity = new PlaceEntity { Name = place.Description, Description = place.Info, Address = place.Address, LocationId = place.Location.Id, MapUa = place.MapUa, MapVa = place.MapVa, Phone = place.Phone, HowToArrive = place.HowToArrive, DateFrom = DateTime.Now, IsActive = false, Page = name, CreatedBy = userId, }; foreach (var s in place.Services) placeEntity.Services.Add(new Fulbaso.EntityFramework.PlaceService { Service = (byte)s }); _context.AddToPlaces(placeEntity); _context.SaveChanges(); place.Id = placeEntity.Id; place.Page = placeEntity.Page; _context.AddToUserPlaces(new UserPlaceEntity { PlaceId = place.Id, UserId = userId, Role = "Owner", }); _context.SaveChanges(); }
public IEnumerable<Tuple<Place, double?>> GetNearest(Place place, int count = 10, double distance = 0) { return GetNearest(place.MapUa, place.MapVa, count, distance); }
public void Update(Place place) { var entity = _context.Places.Where(p => p.Id == place.Id).ToList().First(); if (string.IsNullOrEmpty(place.Page)) { place.Page = entity.Page; } else { this.GetAscii(place.Page); } entity.Name = place.Description; entity.Description = place.Info; entity.Address = place.Address; entity.LocationId = place.Location.Id; entity.MapLocation = place.MapLocation; entity.MapUa = place.MapUa; entity.MapVa = place.MapVa; entity.Phone = place.Phone; entity.HowToArrive = place.HowToArrive; entity.Page = place.Page; while (entity.Services.Any()) _context.DeleteObject(entity.Services.First()); _context.SaveChanges(); place.Services.ToList().ForEach(s => entity.Services.Add(new Fulbaso.EntityFramework.PlaceService { Service = (byte)s })); _context.SaveChanges(); }
public Place Get(Place place, DateTime day) { place.CourtsInfo = CourtLogic.Get(_context.Courts.Where(c => c.PlaceId == place.Id)); var configs = _context.CourtConfigurations.Where(c => c.Court.PlaceId == place.Id).ToList(); var books = _bookService.GetByPlace(place.Id, day, day.AddDays(1).AddMilliseconds(-1)); foreach (var c in place.CourtsInfo) { c.Books = books.Where(cb => cb.Court.Id == c.Id).ToList(); c.Configuration = CourtConfigurationLogic.Get(configs.Where(cc => cc.CourtId == c.Id).ToList()); } return place; }