public PersonalData getPersonalDataById(long id) { using (var context = new RoomRentEntities()) { PersonalData personal = context.PersonalData .Where(c => c.id == id) .FirstOrDefault(); return(personal); } }
public List <Rents> getUserNotRatedRents(long userId) { List <Rents> rents = new List <Rents>(); using (var context = new RoomRentEntities()) { rents = context.Rents .Where(c => c.user_id == userId && !c.isRated) .ToList(); } return(rents); }
public PersonalData getPersonalDataByPhone(long phoneNumber) { PersonalData personal = new PersonalData(); using (var context = new RoomRentEntities()) { personal = context.PersonalData .Where(c => c.phone_number == phoneNumber) .FirstOrDefault(); } return(personal); }
public string getSalt(string username) { Users user = new Users(); using (var context = new RoomRentEntities()) { user = context.Users .Where(c => c.username == username) .FirstOrDefault(); } return(user.salt); }
public List <Rents> getRenterFutureRents(List <long> ids) { List <Rents> rents = new List <Rents>(); using (var context = new RoomRentEntities()) { rents = context.Rents .Where(c => ids.Contains(c.address_id)) .ToList(); } return(rents); }
public Users getUser(long userId) { Users user = new Users(); using (var context = new RoomRentEntities()) { user = context.Users .Where(c => c.id == userId) .FirstOrDefault(); } return(user); }
public List <Rents> getUserRents(long userId) { List <Rents> rents = new List <Rents>(); using (var context = new RoomRentEntities()) { rents = context.Rents .Where(c => c.user_id == userId) .Where(c => c.startDate < DateTime.Now) .ToList(); } return(rents); }
public Users getUserByHash(string username, string hash) { Users user = new Users(); using (var context = new RoomRentEntities()) { user = context.Users .Where(c => c.username == username) .Where(c => c.password == hash) .FirstOrDefault(); } return(user); }
public List <long> getRentsByDate(FlatSearchCriteria criteria) { List <long> rents = new List <long>(); using (var context = new RoomRentEntities()) { rents = context.Rents .Where(c => (c.startDate <= criteria.startDate && c.endDate >= criteria.startDate) || (c.startDate <= criteria.endDate && c.endDate >= criteria.endDate) || (c.startDate >= criteria.startDate && c.endDate <= criteria.endDate)) .Select(c => c.address_id) .ToList(); } return(rents); }
public List <Addresses> getUserAddresses(long userId) { List <long> userAddressesIds = new List <long>(); List <Addresses> addresses = new List <Addresses>(); using (var context = new RoomRentEntities()) { userAddressesIds = context.UserAddresses .Where(c => c.usr_id == userId) .Select(c => c.addr_id) .ToList(); addresses = context.Addresses.Where(c => userAddressesIds.Contains(c.id)).ToList(); } return(addresses); }
public string getAddress(long addressId) { Addresses temp = new Addresses(); using (var context = new RoomRentEntities()) { temp = context.Addresses .Where(c => c.id == addressId).FirstOrDefault(); } string str = temp.country + ", " + temp.city + " " + temp.street + " " + temp.house; if (temp.flat != null) { str += "/" + temp.flat; } return(str); }
public string getPerson(long userId) { Users temp = new Users(); PersonalData temp2 = new PersonalData(); using (var context = new RoomRentEntities()) { temp = context.Users .Where(c => c.id == userId).FirstOrDefault(); temp2 = context.PersonalData .Where(d => d.id == temp.personal_id).FirstOrDefault(); } string str = temp2.name + " " + temp2.surname; return(str); }
public List <Addresses> getFreeAddresses(List <long> rentIds, FlatSearchCriteria criteria) { List <Addresses> addresses = new List <Addresses>(); using (var context = new RoomRentEntities()) { var temp = context.Addresses .Where(c => !rentIds.Contains(c.id)); if (!criteria.city.Equals("")) { temp = temp.Where(c => c.city.Contains(criteria.city)); } addresses = temp.ToList(); } return(addresses); }
public List <UserAddresses> getUserAddressList(List <long> addressIds, FlatSearchCriteria criteria) { List <UserAddresses> addresses = new List <UserAddresses>(); using (var context = new RoomRentEntities()) { var temp = context.UserAddresses .Where(c => addressIds.Contains(c.addr_id)); if (criteria.kitchen) { temp = temp.Where(c => c.kitchen == true); } if (criteria.parking) { temp = temp.Where(c => c.parking == true); } if (criteria.animals) { temp = temp.Where(c => c.animals == true); } if (criteria.bedCount != null) { temp = temp.Where(c => c.bed_count >= criteria.bedCount); } if (criteria.price != null) { if (criteria.over) { temp = temp.Where(c => c.price >= criteria.price); } else { temp = temp.Where(c => c.price <= criteria.price); } } addresses = temp.ToList(); } return(addresses); }