void Button2Click(object sender, System.EventArgs e)
{
int myIndex = comboBox1.SelectedIndex;
string selectedIndex = "";
string selectedName = "";
dbResult localResult = new dbResult();
selectedIndex = localIndex[myIndex];
selectedName = localName[myIndex];
localResult.queryDatabase("WHERE ((MyNumber='" + selectedIndex + "')", ")", localResult, conn2);
localResult.ClearIndex();
localResult.ClearName();
for (int i = 0; i < localIndex.Count; i++)
{
localResult.SetIndex(localIndex[i]);
localResult.SetName(localName[i]);
}
//delete the entry we're going to edit
localResult.deleteFromDatabase(localIndex[myIndex], conn2);
//set up the extraction form and show
ExtractionForm editForm = new ExtractionForm(myDBPath, localResult);
editForm.Show();
}
void ComboBox1SelectedIndexChanged(object sender, EventArgs e)
{
//take the new index of the combobox and look up the index of the local list.
//use the local list value to search the database user IDs.
//then repopulate the form.
//access connections have already been set up and everything.
//TODO:after quert, point editResult to the localResult for use when button2 is pressed
string selectedIndex = "";
string selectedName = "";
int myIndex = comboBox1.SelectedIndex;
comboIndex = myIndex;
dbResult localResult = new dbResult();
selectedIndex = localIndex[myIndex];
selectedName = localName[myIndex];
localResult.queryDatabase("WHERE ((MyNumber='" + selectedIndex + "')", ")", localResult, conn2);
localResult.ClearIndex();
localResult.ClearName();
for (int i = 0; i < localIndex.Count; i++)
{
localResult.SetIndex(localIndex[i]);
localResult.SetName(localName[i]);
}
//editResult = localResult;
clearForm();
populateForm(localResult, myIndex);
//localResult = null;
}
public void queryDatabase(string whereClause, string endClause, dbResult findResult, System.Data.OleDb.OleDbConnection conn)
{
bool foundData = false;
string sqlString = "SELECT LastName, FirstName, MiddleName, PersonName, StreetAddress, " +
"Country, PlaceOfBirth, DateOfBirth, Passport, Notes, EyeColor, " +
"HairColor, Height, Weight, Ethnicity, MyNumber, Photo " +
"FROM tblPeeps " + whereClause + endClause;
OleDbCommand Com = new OleDbCommand();
Com.CommandText = sqlString;
Com.Connection = conn;
OleDbDataReader objDataReader = null;
objDataReader = Com.ExecuteReader();
if (objDataReader == null)
{
return;
}
while (objDataReader.Read())
{
findResult.SetLastName(objDataReader["LastName"].ToString());
findResult.SetFirstName(objDataReader["FirstName"].ToString());
findResult.SetMiddleName(objDataReader["MiddleName"].ToString());
findResult.SetCountry(objDataReader["Country"].ToString());
findResult.SetPOB(objDataReader["PlaceOfBirth"].ToString());
findResult.SetDOB(objDataReader["DateOfBirth"].ToString());
findResult.SetPassport(objDataReader["Passport"].ToString());
findResult.SetNotes(objDataReader["Notes"].ToString());
findResult.SetEyecolor(objDataReader["EyeColor"].ToString());
findResult.SetHaircolor(objDataReader["HairColor"].ToString());
findResult.SetHeight(objDataReader["Height"].ToString());
findResult.SetWeight(objDataReader["Weight"].ToString());
findResult.SetEthnicity(objDataReader["Ethnicity"].ToString());
findResult.SetPics(objDataReader["Photo"].ToString());
findResult.SetName(objDataReader["PersonName"].ToString());
findResult.SetIndex(objDataReader["MyNumber"].ToString());
foundData = true;
}
objDataReader.Close();
if (foundData)
{
sqlString = "SELECT Entries, Addresses, Technologies, DateOfAddresses, " +
"Associates, Universities, Degrees, FieldOfStudies, PlaceOfBiz, RoleInBiz, Links " +
"FROM tblOtherInfo " +
"WHERE (PersonID='" + findResult.GetIndex(findResult.GetIndexCount() - 1) + "')";
OleDbCommand Com2 = new OleDbCommand();
Com2.CommandText = sqlString;
Com2.Connection = conn;
OleDbDataReader objDataReader2 = null;
objDataReader2 = Com2.ExecuteReader();
if (objDataReader2 == null)
{
return;
}
while (objDataReader2.Read())
{
findResult.SetEntries(objDataReader2["Entries"].ToString());
findResult.SetAddress(objDataReader2["Addresses"].ToString() + "\t\t" + objDataReader2["DateOfAddresses"].ToString());
findResult.SetEducation(objDataReader2["Universities"].ToString() + "\t\t" + objDataReader2["Degrees"].ToString() + "\t\t" + objDataReader2["FieldOfStudies"].ToString());
findResult.SetTechnology(objDataReader2["Technologies"].ToString());
findResult.SetBusinesses(objDataReader2["PlaceOfBiz"].ToString() + "\t\t" + objDataReader2["RoleInBiz"].ToString());
findResult.SetAssociates(objDataReader2["Associates"].ToString());
findResult.SetLinks(objDataReader2["Links"].ToString());
}
objDataReader2.Close();
}
else
{
MessageBox.Show("Search Returned 0 matches.\nEnter * in LastName field to see all entries.");
}
}
