public List <House> GetAllHouse(string sessionid)
{
List <House> list = new List <House>();
HouseManagerServer.Person person = dBSession.GetSessionBySessionID(sessionid).Person;
List <HouseManagerServer.PersonToHouse> houses = dBPersonToHouse.GetAllHouseForPerson(person.Id);
foreach (var item in houses)
{
HouseManagerServer.House house = dBHouse.GetHouseById(item.HouseId);
house.Address = dBAddress.GetAddressById(house.Address.Id);
List <PersonToHouse> people = new List <PersonToHouse>();
foreach (var personToHouse in dBPersonToHouse.GetAllPersonInHouse(house.Id))
{
people.Add(new PersonToHouse {
MoveInDate = personToHouse.MoveInDate, IsOwner = personToHouse.IsOwner, Person = new Person {
UserName = personToHouse.Person.UserName, DateOfBirth = personToHouse.Person.DateOfBirth, Email = personToHouse.Person.Email, FirstName = personToHouse.Person.FirstName, LastName = personToHouse.Person.LastName, Phone = personToHouse.Person.LastName
}
});
}
list.Add(new House {
People = people, Id = house.Id, InviteCode = house.InviteCode, Name = house.Name, Address = new Address {
Id = house.Address.Id, City = house.Address.City, DoorNo = house.Address.DoorNo, FloorNo = house.Address.FloorNo, HouseNo = house.Address.HouseNo, Street = house.Address.Street, ZipCode = house.Address.ZipCode
}
});
}
return(list);
}
public bool JoinHouse(string invitecode, string sessionid)
{
HouseManagerServer.Person person = dBSession.GetSessionBySessionID(sessionid).Person;
HouseManagerServer.House house = dBHouse.GetHouseByInvitecode(invitecode);
HouseManagerServer.PersonToHouse personToHouse = dBPersonToHouse.GetPersonToHouseByBothIdMovedOut(person.Id, house.Id);
if (personToHouse != null)
{
return(dBPersonToHouse.Update(new HouseManagerServer.PersonToHouse {
Person = person
}, house.Id));
}
return(dBPersonToHouse.JoinHouse(new HouseManagerServer.PersonToHouse {
IsOwner = false, Person = person
}, house.Id));
}
public bool DeleteHouse(House house, string sessionid)
{
HouseManagerServer.Person person = dBSession.GetSessionBySessionID(sessionid).Person;
HouseManagerServer.PersonToHouse personToHouse = dBPersonToHouse.GetPersonToHouseByBothId(person.Id, house.Id);
HouseManagerServer.House serverhouse = dBHouse.GetHouseById(house.Id);
if (personToHouse.IsOwner)
{
dBChore.DeleteChoreByHouseId(serverhouse.Id);
dBPersonToHouse.DeletePersonToHouseByHouseId(serverhouse.Id);
dBAddress.DeleteAddress(serverhouse.Address);
dBChatMessage.DeleteChatMessageByHouseId(serverhouse.Id);
dBHouse.DeleteHouse(serverhouse);
return(true);
}
else
{
return(false);
}
}
