private void buttonAdd_Click(object sender, EventArgs e) { string Msg; if (!Validate(out Msg)) { MessageBox.Show(Msg); return; } BayWind.Address addr = new BayWind.Address() { Street = textBoxStreet.Text, City = textBoxCity.Text, State = textBoxState.Text, Country = textBoxCountry.Text, ZipCode = textBoxZip.Text, AddressID = (int)AddressStore.GetNextSequence() }; BayWind.Person p = new BayWind.Person() { FirstName = textBoxFirstName.Text, LastName = textBoxLastName.Text, PhoneNumber = textBoxPhone.Text, AddressID = addr.AddressID }; PeopleStore.Add(p.GetKey(), p); AddressStore.Add(addr.AddressID, addr); GoPreviousPage(); DisplayPage(); }
void Populate() { int ZipCodeCtr = 5000; for (int i = 0; i < MaxCount; i++) { int aid = (int)AddressStore.GetNextSequence(); Address addr = new Address() { AddressID = aid, Key = new AddressKey() { Street = string.Format("143{0} LoveLane", aid), City = "Fremont", Country = "USA", State = "California", ZipCode = ZipCodeCtr.ToString() } }; int pid = (int)PeopleStore.GetNextSequence(); Person p = new Person() { PersonID = pid, AddressID = addr.AddressID, Key = new PersonKey() { FirstName = string.Format("Joe{0}", pid), LastName = string.Format("Peter{0}", pid) }, PhoneNumber = "510-555-9999" }; AddressStore.Add(addr.AddressID, addr); PeopleStore.Add(p.PersonID, p); PeopleStoreByName.Add(p.Key, p.PersonID); AddressStoreByAddress.Add(addr.Key, addr.AddressID); if (i % 500 == 0) { ZipCodeCtr++; AddressStore.Flush(); PeopleStore.Flush(); PeopleStoreByName.Flush(); AddressStoreByAddress.Flush(); } } AddressStore.Flush(); PeopleStore.Flush(); PeopleStoreByName.Flush(); AddressStoreByAddress.Flush(); }
void DisplayFields(BayWind.Person p) { textBoxFirstName.Text = p.FirstName; textBoxLastName.Text = p.LastName; textBoxPhone.Text = p.PhoneNumber; if (AddressStore.Search(p.AddressID)) { BayWind.Address addr = AddressStore.CurrentValue; textBoxStreet.Text = addr.Street; textBoxCity.Text = addr.City; textBoxState.Text = addr.State; textBoxCountry.Text = addr.Country; textBoxZip.Text = addr.ZipCode; } }
void ReadAll() { PeopleStoreByName.MoveFirst(); PeopleStoreByName.HintBatchCount = 103; long[] Pids = new long[BatchCount]; int PidsIndex = 0; PersonKey[] pk = new PersonKey[BatchCount]; int Ctr = 0; do { Ctr++; pk[PidsIndex++] = PeopleStoreByName.CurrentKey; if (PidsIndex == BatchCount) { QueryResult <PersonKey>[] PeopleIDs; if (PeopleStoreByName.Query(QueryExpression <PersonKey> .Package(pk), out PeopleIDs)) { for (int i = 0; i < PeopleIDs.Length; i++) { Pids[i] = (long)PeopleIDs[i].Value; } QueryResult <long>[] PeopleFound; if (PeopleStore.Query(QueryExpression <long> .Package(Pids), out PeopleFound)) { long[] Aids = new long[PidsIndex]; int i = 0; foreach (QueryResult <long> pf in PeopleFound) { if (pf.Found) { Aids[i++] = ((Person)pf.Value).AddressID; } } QueryResult <long>[] AddressesFound; if (AddressStore.Query(QueryExpression <long> .Package(Aids), out AddressesFound)) { //** process found Address records here... } } } PidsIndex = 0; } } while (PeopleStoreByName.MoveNext()); }
void ReadAll() { PeopleStoreByName.MoveFirst(); PeopleStoreByName.HintBatchCount = 103; PersonKey pk; int Ctr = 0; do { Ctr++; pk = PeopleStoreByName.CurrentKey; long PersonID = PeopleStoreByName.CurrentValue; if (PeopleStore.Search(PersonID)) { Person p = PeopleStore.CurrentValue; if (AddressStore.Search(p.AddressID)) { Address addr = AddressStore.CurrentValue; } } } while (PeopleStoreByName.MoveNext()); }
void ReadAll() { PeopleStoreByName.MoveFirst(); PeopleStoreByName.HintBatchCount = 103; long[] Pids = new long[BatchCount]; int PidsIndex = 0; PersonKey[] pk = new PersonKey[BatchCount]; int Ctr = 0; do { Ctr++; pk[PidsIndex++] = PeopleStoreByName.CurrentKey; if (PidsIndex == BatchCount) { QueryResult <PersonKey>[] PeopleIDs; if (PeopleStoreByName.Query(QueryExpression <PersonKey> .Package(pk), out PeopleIDs)) { for (int i = 0; i < PeopleIDs.Length; i++) { Pids[i] = (long)PeopleIDs[i].Value; } QueryResult <long>[] PeopleFound; if (PeopleStore.Query(QueryExpression <long> .Package(Pids), out PeopleFound)) { long[] Aids = new long[PidsIndex]; int i = 0; foreach (QueryResult <long> pf in PeopleFound) { if (pf.Found) { Aids[i++] = ((Person)pf.Value).AddressID; } } QueryResult <long>[] AddressesFound; if (AddressStore.Query(QueryExpression <long> .Package(Aids), out AddressesFound)) { //** process found Address records here... int ctr2 = 0; foreach (var a in AddressesFound) { ctr2++; if (!a.Found) { Console.WriteLine("Failed to read {0}.", a.Key); } } if (ctr2 != 1000) { Console.WriteLine("Failed to read 1000 records, 'only read {0}.", ctr2); } } } } PidsIndex = 0; } } while (PeopleStoreByName.MoveNext()); if (Ctr != PeopleStore.Count) { Console.WriteLine("Failed! Read {0}, expected {1}", Ctr * 4, PeopleStore.Count * 4); } else { Console.WriteLine("Read {0} items.", Ctr * 4); } }
void Populate() { int ZipCodeCtr = 5000; CacheRecord[] BatchedRecords = new CacheRecord[BatchCount]; int BatchedIndex = 0; for (int i = 0; i < MaxCount; i++) { int aid = (int)AddressStore.GetNextSequence(); Address addr = new Address() { AddressID = aid, Key = new AddressKey() { Street = string.Format("143{0} LoveLane", aid), City = "Fremont", Country = "USA", State = "California", ZipCode = ZipCodeCtr.ToString() } }; int pid = (int)PeopleStore.GetNextSequence(); Person p = new Person() { PersonID = pid, AddressID = addr.AddressID, Key = new PersonKey() { FirstName = string.Format("Joe{0}", pid), LastName = string.Format("Peter{0}", pid) }, PhoneNumber = "510-555-9999" }; BatchedRecords[BatchedIndex++] = new CacheRecord() { p = p, pKey = p.Key, addr = addr, addrKey = addr.Key }; if (BatchedIndex == BatchCount) { for (int i2 = 0; i2 < BatchedIndex; i2++) { AddressStore.Add(BatchedRecords[i2].addr.AddressID, BatchedRecords[i2].addr); } AddressStore.Flush(); for (int i2 = 0; i2 < BatchedIndex; i2++) { PeopleStore.Add(BatchedRecords[i2].p.PersonID, BatchedRecords[i2].p); } PeopleStore.Flush(); for (int i2 = 0; i2 < BatchedIndex; i2++) { PeopleStoreByName.Add(BatchedRecords[i2].p.Key, BatchedRecords[i2].p.PersonID); } PeopleStoreByName.Flush(); for (int i2 = 0; i2 < BatchedIndex; i2++) { AddressStoreByAddress.Add(BatchedRecords[i2].addr.Key, BatchedRecords[i2].addr.AddressID); } AddressStoreByAddress.Flush(); if (i % 500 == 0) { ZipCodeCtr++; } BatchedIndex = 0; } } if (BatchedIndex > 0) { for (int i2 = 0; i2 < BatchedIndex; i2++) { AddressStore.Add(BatchedRecords[i2].addr.AddressID, BatchedRecords[i2].addr); } AddressStore.Flush(); for (int i2 = 0; i2 < BatchedIndex; i2++) { PeopleStore.Add(BatchedRecords[i2].p.PersonID, BatchedRecords[i2].p); } PeopleStore.Flush(); for (int i2 = 0; i2 < BatchedIndex; i2++) { PeopleStoreByName.Add(BatchedRecords[i2].p.Key, BatchedRecords[i2].p.PersonID); } PeopleStoreByName.Flush(); for (int i2 = 0; i2 < BatchedIndex; i2++) { AddressStoreByAddress.Add(BatchedRecords[i2].addr.Key, BatchedRecords[i2].addr.AddressID); } AddressStoreByAddress.Flush(); } }