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();
}
