public OrdersController(OrderContext orderContext, AddressContext addressContext, ProductContext productContext, DeliveryAreaContext deliveryAreaContext) { _orderContext = orderContext; _addressContext = addressContext; _productContext = productContext; _deliveryAreaContext = deliveryAreaContext; }
public IEnumerable <County> GetCounty() { using (var db = new AddressContext()) { return(db.Countys.ToArray()); } }
public static void InitializeDbForTests(AddressContext db) { List <Domain.Address> addresses = GetSeedingAddresses(); db.Addresses.AddRange(addresses); db.SaveChanges(); }
public void Post(Address value) { using (var dataContext = new AddressContext()) { dataContext.Addresses.Add(value); dataContext.SaveChanges(); } }
public void Connect() { if (_isConnecting.CompareAndSet(false, true)) { try { AddressContext context = _addressManager.AddressContext; if (!context.IsAvailable) { return; } WebSocket currentWebSocket = new WebSocket(context.WebSocketEndpoint); currentWebSocket.OnOpen += (o, e) => { WebSocket oldWebSocket = _session.GetAndSet(currentWebSocket); _lastUpdateTime = DateTimeUtils.CurrentTimeInMilliseconds; _addressContext.Value = context; if (_onOpen != null) { _onOpen(currentWebSocket); } Disconnect(oldWebSocket); }; currentWebSocket.OnMessage += (o, e) => { if (_onMessage != null) { _onMessage(currentWebSocket, e); } }; currentWebSocket.OnError += (o, e) => { if (typeof(WebSocket).IsInstanceOfType(o)) { Markdown(); } _log.Info("WebSocket error:", e.Exception); }; currentWebSocket.OnClose += (o, e) => { _log.Info("WebSocket closed:" + e.Reason); CheckHealth(); }; currentWebSocket.Connect(); } catch (Exception e) { _log.Warn("connect websocket endpoint failed", e); } finally { _isConnecting.Value = false; } } }
public void Delete(int cityCode) { using (var db = new AddressContext()) { var city = db.CityInfo.Include(y => y.County).First(x => x.CityCode.Equals(cityCode)); db.Remove(city); db.SaveChanges(); } }
public City GetCityById(int cityCode) { City city; using (var db = new AddressContext()) { city = db.CityInfo.Where(x => x.CityCode.Equals(cityCode)).Single(); } return(city); }
public List <Address> EagerLoadingWithThen() { using (var db = new AddressContext()) { return(db.Address .Include(x => x.City) .ThenInclude(x => x.County) .ToList()); } }
public County GetCountyById(int countyId) { County county; using (var db = new AddressContext()) { county = db.Countys.Where(x => x.CountyId.Equals(countyId)).Single(); } return(county); }
public List <City> EagerLoading() { using (var db = new AddressContext()) { var citys = db.CityInfo //.Include(x => x.County.Where(x => x.Equals.Equals...)) .Include(x => x.County) .ToList(); return(citys); } }
public void ChangeRelationship() { using (var db = new AddressContext()) { var county = db.Countys.Single(x => x.FullName.Equals("Thanh Trì")); var city = db.CityInfo.Single(x => x.CityCode == 2); county.City = city; db.SaveChanges(); } }
public IEnumerable <Address> Get() { var values = new List <Address>(); using (var dataContext = new AddressContext()) { values = dataContext.Addresses.ToList(); } return(values); }
public Address Get(int id) { var value = new Address(); using (var dataContext = new AddressContext()) { value = dataContext.Addresses.FirstOrDefault(item => item.AddressId == id); } return(value); }
public void Add(List <City> citys) { if (citys == null || citys.Count == 0) { return; } using (var db = new AddressContext()) { db.CityInfo.AddRange(citys); db.SaveChanges(); } }
public void ExplicitLoadding() { using (var db = new AddressContext()) { var citys = db.CityInfo .Single(x => x.CityCode == 1); db.Entry(citys) .Collection(b => b.County) .Load(); } }
public void DeleteRange(List <City> citys) { if (citys == null || citys.Count == 0) { return; } using (var db = new AddressContext()) { db.RemoveRange(citys); db.SaveChanges(); } }
public AddressControllerTest() { _dbOptions = new DbContextOptionsBuilder <AddressContext>() .UseInMemoryDatabase(databaseName: "in-memory") .Options; using (var dbContext = new AddressContext(_dbOptions)) { dbContext.AddRange(AddressContextDbSeed.GetData()); dbContext.SaveChanges(); } }
public void Delete(County county) { if (county == null) { return; } using (var db = new AddressContext()) { db.Remove(county); db.SaveChanges(); } }
public void Delete(int id) { using (var dataContext = new AddressContext()) { var updateValue = dataContext.Addresses.FirstOrDefault(item => item.AddressId == id); if (null != updateValue) { dataContext.Addresses.Remove(updateValue); dataContext.SaveChanges(); } } }
static void Main(string[] args) { var db = new AddressContext(); while (!Console.KeyAvailable) { foreach (var addr in db.MyAddresses.ToList()) { Console.WriteLine(addr.Address); } } Console.ReadLine(); }
public void Update(County countyNew) { if (countyNew == null) { return; } using (var db = new AddressContext()) { var cityOld = db.Countys .Single(x => x.CountyId.Equals(countyNew.CountyId)); cityOld = countyNew; db.SaveChanges(); } }
static void Main(string[] args) { var db = new AddressContext(); while (!Console.KeyAvailable) { foreach (var addr in db.Myaddresses.ToList()) //ToList: igy csak 1x fordul az adatbazishoz, utana a memoriabol dolgozik minden iteracioban { Console.WriteLine(addr.Address); } } Console.ReadLine(); }
public void Update(City cityNew) { if (cityNew == null) { return; } using (var db = new AddressContext()) { var cityOld = db.CityInfo .Single(x => x.CityCode.Equals(cityNew.CityCode)); cityOld = cityNew; db.SaveChanges(); } }
public Address(AddressContext addressContext, int AdressId) { var address = addressContext.Address.FirstOrDefault(x => x.Id == AdressId); if (address != null) { this.Id = address.Id; this.City = address.City; this.DeliveryAreaId = address.DeliveryAreaId; this.Email = address.Email; this.Phone = address.Phone; this.Street = address.Street; } }
static void Main(string[] args) { var phone = new Phone { EntryId = 1, Number = "1234567", Type = 0 }; using (var db = new AddressContext()) { db.Phones.Add(phone); db.SaveChanges(); } }
public void TestInvalidDeleteAddressById() { //Arrange var options = new DbContextOptionsBuilder <AddressContext>().UseInMemoryDatabase(databaseName: "Addresses").Options; var context = new AddressContext(options); context.Addresses.Add(a); var repository = new AddressRepository(context); // Assert Assert.Throws <ArgumentNullException>(() => repository.DeleteAddressById(2)); context.Database.EnsureDeleted(); }
public void RemoveRelationship() { using (var db = new AddressContext()) { var city = db.CityInfo //.Include(x => x.County.Where(x => x.Equals.Equals...)) .Include(x => x.County) .First(x => x.CityCode == 2); var county = city.County.First(countys => countys.FullName.Equals("Thanh Trì")); city.County.Remove(county); db.SaveChanges(); } }
public void ProjectingRalatedCity() { using (var db = new AddressContext()) { var citys = db.CityInfo .Select(x => new { x.FullName, County = x.County .Where(county => county.FullName.Equals("Thanh Trì")) .ToList(), x.CityCode, }) .ToList(); } }
public void Put(int id, Address value) { using (var dataContext = new AddressContext()) { var updateValue = dataContext.Addresses.FirstOrDefault(item => item.AddressId == id); updateValue.AddressLineOne = value.AddressLineOne; updateValue.AddressLineTwo = value.AddressLineTwo; updateValue.City = value.City; updateValue.AddressState = value.AddressState; updateValue.Zip = value.Zip; updateValue.Country = value.Country; dataContext.SaveChanges(); } }
public void InsertAddress() { //Arrange var options = new DbContextOptionsBuilder <AddressContext>().UseInMemoryDatabase(databaseName: "database_name").Options; var context = new AddressContext(options); var repository = new Mock <AddressRepository>(context); // Act repository.Object.InsertAddress(a); //Assert Assert.AreEqual(1, context.Addresses.Count()); context.Database.EnsureDeleted(); }