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