@implementation OneView
@synthesize addressInfo;
@synthesize people;
@synthesize appliances;
@synthesize addressInfoKeys;
@synthesize peopleKeys;
@synthesize pid;

#pragma mark -
#pragma mark View lifecycle

- (void)viewDidLoad {
    [super viewDidLoad];

	self.title = @"Listing";

	NSMutableDictionary *addressInfoTMP = [[NSMutableDictionary alloc]init];
	NSMutableArray *addressInfoKeysTMP = [[NSMutableArray alloc]init];
	NSMutableDictionary *peopleTMP = [[NSMutableDictionary alloc]init];
	NSMutableArray *peopleKeysTMP = [[NSMutableArray alloc]init];



	PLSqliteDatabase *db = [[PLSqliteDatabase alloc] initWithPath:  @"myDataBase.sqlite"];
	if (![db open]){ NSLog(@"Could not open database"); } else { NSLog(@"Connected to DB fine"); }

	id<PLResultSet> results = [db executeQuery: @"SELECT username,password,viewingProperty FROM auth WHERE id=1"];
	while ([results next]) {
		NSString *sqlUsername = [results stringForColumn:@"username"];
		NSString *sqlPassword = [results stringForColumn:@"password"];
		pid = [results stringForColumn:@"viewingProperty"];
		NSLog(@"%@ %@ %@", sqlUsername, sqlPassword, pid);
	}
	[results close];

	NSString *q = @"SELECT * FROM properties WHERE propertyId=";
	q = [q stringByAppendingString:pid];
	id<PLResultSet> results2 = [db executeQuery: q];
	while ([results2 next]) {
		// addressInfo
		//[addressInfo setValue:[results2 stringForColumn:@"firstName"] forKey:@"firstName"];
		//[addressInfo setValue:[results2 stringForColumn:@"lastName"] forKey:@"lastName"];
		NSString *fullName = [results2 stringForColumn:@"firstName"];
		fullName = [fullName stringByAppendingString:@" "];
		fullName = [fullName stringByAppendingString:[results2 stringForColumn:@"lastName"]];
		[addressInfoTMP setValue:fullName forKey:@"fullName"];
		[addressInfoKeysTMP addObject:@"fullName"];
		if(![results2 isNullForColumn:@"phoneNumber"]){
			[addressInfoTMP setValue:[results2 stringForColumn:@"phoneNumber"] forKey:@"phoneNumber"];
			[addressInfoKeysTMP addObject:@"phoneNumber"];
		}
		if(![results2 isNullForColumn:@"street"]){
			[addressInfoTMP setValue:[results2 stringForColumn:@"street"] forKey:@"street"];
			[addressInfoKeysTMP addObject:@"street"];
		}
		if(![results2 isNullForColumn:@"city"]){
			[addressInfoTMP setValue:[results2 stringForColumn:@"city"] forKey:@"city"];
			[addressInfoKeysTMP addObject:@"city"];
		}
		if(![results2 isNullForColumn:@"state"]){
			[addressInfoTMP setValue:[results2 stringForColumn:@"state"] forKey:@"state"];
			[addressInfoKeysTMP addObject:@"state"];
		}
		if(![results2 isNullForColumn:@"zipcode"]){
			[addressInfoTMP setValue:[results2 stringForColumn:@"zipcode"] forKey:@"zipcode"];
			[addressInfoKeysTMP addObject:@"zipcode"];
		}
		if(![results2 isNullForColumn:@"inspectionDate"]){
			[addressInfoTMP setValue:[results2 stringForColumn:@"inspectionDate"] forKey:@"inspectionDate"];
			[addressInfoKeysTMP addObject:@"inspectionDate"];
		}
		if(![results2 isNullForColumn:@"pending"]){
			[addressInfoTMP setValue:[results2 stringForColumn:@"pending"] forKey:@"pending"];
			[addressInfoKeysTMP addObject:@"pending"];
		}
		// people
		if(![results2 isNullForColumn:@"emailClient"]){
			[peopleTMP setValue:[results2 stringForColumn:@"emailClient"] forKey:@"emailClient"];
			[peopleKeysTMP addObject:@"emailClient"];
		}
		if(![results2 isNullForColumn:@"emailListingAgent"]){
			[peopleTMP setValue:[results2 stringForColumn:@"emailListingAgent"] forKey:@"emailListingAgent"];
			[peopleKeysTMP addObject:@"emailListingAgent"];
		}
		if(![results2 isNullForColumn:@"emailBuyersAgent"]){
			[peopleTMP setValue:[results2 stringForColumn:@"emailBuyersAgent"] forKey:@"emailBuyersAgent"];
			[peopleKeysTMP addObject:@"emailBuyersAgent"];
		}
		if(![results2 isNullForColumn:@"emailSellersAgent"]){
			[peopleTMP setValue:[results2 stringForColumn:@"emailSellersAgent"] forKey:@"emailSellersAgent"];
			[peopleKeysTMP addObject:@"emailSellersAgent"];
		}
		if(![results2 isNullForColumn:@"emailBuyersAttorney"]){
			[peopleTMP setValue:[results2 stringForColumn:@"emailBuyersAttorney"] forKey:@"emailBuyersAttorney"];
			[peopleKeysTMP addObject:@"emailBuyersAttorney"];
		}
		if(![results2 isNullForColumn:@"emailSellersAttorney"]){
			[peopleTMP setValue:[results2 stringForColumn:@"emailSellersAttorney"] forKey:@"emailSellersAttorney"];
			[peopleKeysTMP addObject:@"emailSellersAttorney"];
		}
		if(![results2 isNullForColumn:@"emailEscrowAgent"]){
			[peopleTMP setValue:[results2 stringForColumn:@"emailEscrowAgent"] forKey:@"emailEscrowAgent"];
			[peopleKeysTMP addObject:@"emailEscrowAgent"];
		}
		if(![results2 isNullForColumn:@"emailOther"]){
			[peopleTMP setValue:[results2 stringForColumn:@"emailOther"] forKey:@"emailOther"];
			[peopleKeysTMP addObject:@"emailOther"];
		}

	}
	[results2 close];
	self.addressInfo = addressInfoTMP;
	self.addressInfoKeys = addressInfoKeysTMP;
	self.people = peopleTMP;
	self.peopleKeys = peopleKeysTMP;

	NSLog(@"%@", peopleKeysTMP);
}