public async Task <User> GetUser(string userName)
{
using (var context = DomovoyContextFactory.CreateDbContext(ConnectionString))
{
return(await context.Users.SingleOrDefaultAsync(u => u.Login == userName));
}
}
public async Task <List <House> > GetHouses()
{
using (var context = DomovoyContextFactory.CreateDbContext(ConnectionString))
{
return(await context.Houses.ToListAsync());
}
}
public async Task <Auction> GetAuction(int id)
{
using (var context = DomovoyContextFactory.CreateDbContext(ConnectionString))
{
return(await context.Auctions
.SingleOrDefaultAsync(e => e.HouseId == id));
}
}
public async Task <House> GetHousesById(int id)
{
using (var context = DomovoyContextFactory.CreateDbContext(ConnectionString))
{
return(await context.Houses
.Include(e => e.UK)
.SingleOrDefaultAsync(h => h.HouseId == id));
}
}
public async Task <List <HouseWork> > GetHouseWorks(int id)
{
using (var context = DomovoyContextFactory.CreateDbContext(ConnectionString))
{
return(await context.HouseWorks
.Where(e => e.HouseId == id)
.OrderByDescending(e => e.WorkDate)
.ToListAsync());
}
}
public async Task <List <AuctionBid> > GetAuctionBids(int id)
{
using (var context = DomovoyContextFactory.CreateDbContext(ConnectionString))
{
return(await context.AuctionBids
.Include(e => e.Organization)
.Include(e => e.Auction)
.Where(e => e.Auction.HouseId == id)
.ToListAsync());
}
}
public async Task <User> CreateUser(string userName, string password)
{
using (var context = DomovoyContextFactory.CreateDbContext(ConnectionString))
{
var user = new User(userName, password);
await context.Users.AddAsync(user);
await context.SaveChangesAsync();
return(user);
}
}
public List <House> GetHousesByAddress(string address, int count)
{
using (var context = DomovoyContextFactory.CreateDbContext(ConnectionString))
{
var splitAddresses = address.ToLower().Split(" ");
var housesList = new List <House>();
foreach (var h in context.Houses)
{
var hAddress = h.Address.ToLower();
if (splitAddresses.All(sa => hAddress.Contains(sa)))
{
housesList.Add(h);
}
if (housesList.Count >= count)
{
break;
}
}
return(housesList);
}
}
