public bool JoinHouse(PersonToHouse personToHouse, int houseid) { string sql = "insert into PersonToHouse (personid, houseid, moveindate, isowner) values (@personid, @houseid, @moveindate, @isowner)"; command = DBConnection.GetDbConn().CreateCommand(); command.CommandText = sql; command.Parameters.Clear(); SqlParameter personidParam = new SqlParameter("@personid", SqlDbType.Int); personidParam.Value = personToHouse.Person.Id; SqlParameter houseidParam = new SqlParameter("@houseid", SqlDbType.Int); houseidParam.Value = houseid; SqlParameter isownerParam = new SqlParameter("@isowner", SqlDbType.TinyInt); isownerParam.Value = personToHouse.IsOwner; SqlParameter moveindateParam = new SqlParameter("@moveindate", SqlDbType.DateTime); moveindateParam.Value = DateTime.Now; command.Parameters.Add(moveindateParam); command.Parameters.Add(personidParam); command.Parameters.Add(houseidParam); command.Parameters.Add(isownerParam); command.ExecuteNonQuery(); return(true); }
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); } }
public bool LeaveHouse(PersonToHouse personToHouse, int houseid) { string sql = "update PersonToHouse set moveoutdate = @moveoutdate where personid = @personid and houseid = @houseid"; command = DBConnection.GetDbConn().CreateCommand(); command.CommandText = sql; command.Parameters.Clear(); SqlParameter moveoutdateParam = new SqlParameter("@moveoutdate", SqlDbType.DateTime); moveoutdateParam.Value = DateTime.Now; SqlParameter personidParam = new SqlParameter("@personid", SqlDbType.Int); personidParam.Value = personToHouse.Person.Id; SqlParameter houseidParam = new SqlParameter("@houseid", SqlDbType.Int); houseidParam.Value = houseid; command.Parameters.Add(moveoutdateParam); command.Parameters.Add(personidParam); command.Parameters.Add(houseidParam); command.ExecuteNonQuery(); return(true); }