void populateForm(dbResult findResult, int nameBoxSel) { textBox1.Text = findResult.GetLastName(); textBox2.Text = findResult.GetFirstName(); textBox3.Text = findResult.GetMiddleName(); textBox5.Text = findResult.GetPassport(); textBox6.Text = findResult.GetCountry(); textBox9.Text = findResult.GetHaircolor(); textBox10.Text = findResult.GetEyecolor(); textBox8.Text = findResult.GetHeight(); textBox7.Text = findResult.GetWeight(); textBox4.Text = findResult.GetEthnicity(); richTextBox1.Text = findResult.GetNotes(); textBox12.Text = findResult.GetDOB(); textBox11.Text = findResult.GetPOB(); pictureBox1.ImageLocation = findResult.GetPics(); for (int i = 0; i < findResult.GetNameCount(); i++) { comboBox1.Items.Add(findResult.GetName(i)); } comboBox1.SelectedIndex = nameBoxSel; for (int i = 0; i < findResult.GetEntriesCount(); i++) { comboBox2.Items.Add(findResult.GetEntries(i)); } comboBox2.SelectedIndex = findResult.GetEntriesCount() - 1; for (int i = 0; i < findResult.GetAddressCount(); i++) { comboBox3.Items.Add(findResult.GetAddress(i)); } comboBox3.SelectedIndex = findResult.GetAddressCount() - 1; for (int i = 0; i < findResult.GetTechnologyCount(); i++) { comboBox6.Items.Add(findResult.GetTechnology(i)); } comboBox6.SelectedIndex = findResult.GetTechnologyCount() - 1; for (int i = 0; i < findResult.GetBusinessesCount(); i++) { comboBox5.Items.Add(findResult.GetBusinesses(i)); } comboBox5.SelectedIndex = findResult.GetBusinessesCount() - 1; for (int i = 0; i < findResult.GetAssociatesCount(); i++) { comboBox7.Items.Add(findResult.GetAssociates(i)); } comboBox7.SelectedIndex = findResult.GetAssociatesCount() - 1; for (int i = 0; i < findResult.GetLinksCount(); i++) { comboBox8.Items.Add(findResult.GetLinks(i)); } comboBox8.SelectedIndex = findResult.GetLinksCount() - 1; for (int i = 0; i < findResult.GetEducationCount(); i++) { comboBox4.Items.Add(findResult.GetEducation(i)); } comboBox4.SelectedIndex = findResult.GetEducationCount() - 1; }
public ExtractionForm(string dataBasePath, dbResult initWindow) { // // The InitializeComponent() call is required for Windows Forms designer support. // InitializeComponent(); // // TODO: Add constructor code after the InitializeComponent() call. // localDataBasePath = dataBasePath; //fill in textbox values from the initWindow object // textBox13.Text = initWindow.GetName(0); //never uncomment this again. it breaks the form. textBox1.Text = initWindow.GetLastName(); textBox2.Text = initWindow.GetFirstName(); textBox3.Text = initWindow.GetMiddleName(); textBox14.Text = initWindow.GetPics(); textBox6.Text = initWindow.GetCountry(); textBox5.Text = initWindow.GetPassport(); richTextBox1.Text = initWindow.GetNotes(); textBox10.Text = initWindow.GetEyecolor(); textBox9.Text = initWindow.GetHaircolor(); textBox8.Text = initWindow.GetHeight(); textBox7.Text = initWindow.GetWeight(); textBox4.Text = initWindow.GetEthnicity(); textBox12.Text = initWindow.GetDOB(); textBox11.Text = initWindow.GetPOB(); string entriesString = ""; for (int i = 0; i < initWindow.GetEntriesCount(); i++) { entriesString = entriesString + initWindow.GetEntries(i) + "\n"; } richTextBox8.Text = entriesString; string linksString = ""; for (int i = 0; i < initWindow.GetLinksCount(); i++) { linksString = linksString + initWindow.GetLinks(i) + "\n"; } richTextBox7.Text = linksString; string tempString = ""; for (int i = 0; i < initWindow.GetAddressCount(); i++) { tempString = tempString + initWindow.GetAddress(i) + "\n"; } richTextBox2.Text = tempString; tempString = ""; for (int i = 0; i < initWindow.GetTechnologyCount(); i++) { tempString = tempString + initWindow.GetTechnology(i) + "\n"; } richTextBox5.Text = tempString; string[] educString = new String[3]; string substring = ""; for (int i = 0; i < initWindow.GetEducationCount(); i++) { //since adding and editing a person's info creates different delimiters in the object, replace //with common delimiter before working string substring = initWindow.GetEducation(i).Replace("\t\t", ":"); string[] temp = substring.Split(':'); for (int j = 0; j < 3; j++) { educString[j] = educString[j] + temp[j] + "\n"; } } richTextBox3.Text = educString[0]; richTextBox9.Text = educString[1]; richTextBox10.Text = educString[2]; string[] busString = new String[2]; for (int i = 0; i < initWindow.GetBusinessesCount(); i++) { //since adding and editing a person's info creates different delimiters in the object, replace //with common delimiter before working string substring = initWindow.GetBusinesses(i).Replace("\t\t", ":"); string[] temp = substring.Split(':'); for (int j = 0; j < 2; j++) { busString[j] = busString[j] + temp[j] + "\n"; } } richTextBox4.Text = busString[0]; richTextBox11.Text = busString[1]; string[] addyString = new String[2]; for (int i = 0; i < initWindow.GetAddressCount(); i++) { //since adding and editing a person's info creates different delimiters in the object, replace //with common delimiter before working string substring = initWindow.GetAddress(i).Replace("\t\t", ":"); string[] temp = substring.Split(':'); for (int j = 0; j < 2; j++) { addyString[j] = addyString[j] + temp[j] + "\n"; } } richTextBox2.Text = addyString[0]; richTextBox12.Text = addyString[1]; string assocString = ""; for (int i = 0; i < initWindow.GetAssociatesCount(); i++) { assocString = assocString + initWindow.GetAssociates(i) + "\n"; } richTextBox6.Text = assocString; string techString = ""; for (int i = 0; i < initWindow.GetTechnologyCount(); i++) { techString = techString + initWindow.GetTechnology(i) + "\n"; } richTextBox5.Text = techString; }
public void insertDatabase(dbResult findResult, string myIndex, System.Data.OleDb.OleDbConnection conn) { //create INSERT command string insertCols1 = "PersonName, LastName, FirstName, MiddleName, Country, Photo, PlaceOfBirth, DateOfBirth, Passport, Notes, EyeColor, HairColor, Height, Weight, Ethnicity, MyNumber"; string sqlString = "INSERT INTO tblPeeps (" + insertCols1 + ") VALUES ("; string insertVals1 = "'" + findResult.GetName(0) + "', '" + findResult.GetLastName() + "', '" + findResult.GetFirstName() + "', '" + findResult.GetMiddleName() + "', '" + findResult.GetCountry() + "', '" + findResult.GetPics() + "', '" + findResult.GetPOB() + "', '" + findResult.GetDOB() + "', '" + findResult.GetPassport() + "', '" + findResult.GetNotes() + "', '" + findResult.GetEyecolor() + "', '" + findResult.GetHaircolor() + "', '" + findResult.GetHeight() + "', '" + findResult.GetWeight() + "', '" + findResult.GetEthnicity() + "', '" + myIndex + "'"; sqlString = sqlString + insertVals1 + ")"; //set up connection and run command for 1st table OleDbCommand Com = new OleDbCommand(); Com.CommandText = sqlString; Com.Connection = conn; OleDbDataReader objDataReader = null; objDataReader = Com.ExecuteReader(); objDataReader.Close(); //set up sql strings for each insertion to the second table int maxLines = findResult.GetEntriesCount(); if (findResult.GetAddressCount() > maxLines) { maxLines = findResult.GetAddressCount(); } if (findResult.GetAssociatesCount() > maxLines) { maxLines = findResult.GetAssociatesCount(); } if (findResult.GetBusinessesCount() > maxLines) { maxLines = findResult.GetBusinessesCount(); } if (findResult.GetEducationCount() > maxLines) { maxLines = findResult.GetEducationCount(); } if (findResult.GetEntriesCount() > maxLines) { maxLines = findResult.GetEntriesCount(); } if (findResult.GetLinksCount() > maxLines) { maxLines = findResult.GetLinksCount(); } if (findResult.GetTechnologyCount() > maxLines) { maxLines = findResult.GetTechnologyCount(); } //set up sql command, connection and run command for second table OleDbCommand Com2 = new OleDbCommand(); Com2.Connection = conn; OleDbDataReader objDataReader2 = null; string insertCols2 = "Entries, Addresses, DateOfAddresses, Technologies, " + "Associates, Universities, Degrees, FieldOfStudies, PlaceOfBiz, RoleInBiz, Links, PersonID"; string valueString = ""; //create individual rows and send them one at a time to DB for (int i = 0; i < maxLines; i++) { //create strings using values from form valueString = ""; if (i < findResult.GetEntriesCount()) { valueString = valueString + "'" + findResult.GetEntries(i) + "', "; } else { valueString = valueString + "'', "; } string[] words = findResult.GetAddress(0).Split(':'); if (i < findResult.GetAddressCount()) { words = findResult.GetAddress(i).Split(':'); valueString = valueString + "'" + words[0] + "', '" + words[1] + "', "; } else { valueString = valueString + "'', '', "; } if (i < findResult.GetTechnologyCount()) { valueString = valueString + "'" + findResult.GetTechnology(i) + "', "; } else { valueString = valueString + "'', "; } if (i < findResult.GetAssociatesCount()) { valueString = valueString + "'" + findResult.GetAssociates(i) + "', "; } else { valueString = valueString + "'', "; } if (i < findResult.GetEducationCount()) { words = findResult.GetEducation(i).Split(':'); valueString = valueString + "'" + words[0] + "', '" + words[1] + "', '" + words[2] + "', "; } else { valueString = valueString + "'', '', '', "; } if (i < findResult.GetBusinessesCount()) { words = findResult.GetBusinesses(i).Split(':'); valueString = valueString + "'" + words[0] + "', '" + words[1] + "', "; } else { valueString = valueString + "'', '', "; } if (i < findResult.GetLinksCount()) { valueString = valueString + "'" + findResult.GetLinks(i) + "', "; } else { valueString = valueString + "'', "; } valueString = valueString + "'" + myIndex + "'"; //put together SQL string and send to database sqlString = "INSERT INTO tblOtherInfo (" + insertCols2 + ") VALUES (" + valueString + ")"; Com2.CommandText = sqlString; objDataReader2 = Com2.ExecuteReader(); objDataReader2.Close(); objDataReader2 = null; } }