/// <summary> /// Remove people from the people file /// </summary> private void RemovePeople_Click(object sender, EventArgs e) { try { openFileDialog1.FileName = PeopleFile.Text; openFileDialog1.Filter = "Microsoft Excel Files (*.xls;*.xlsx)|*.xls;*.xlsx|Comma-delimited Text Files (*.csv)|*.csv|All files (*.*)|*.*"; openFileDialog1.Title = "Select the People file to use for adding/updating"; openFileDialog1.CheckFileExists = true; openFileDialog1.CheckPathExists = true; DialogResult result = openFileDialog1.ShowDialog(); if (result == DialogResult.Cancel) { return; } Database DB = new Database(DSN.Text); int Count = PeopleMaintenance.Remove(DB, openFileDialog1.FileName); UpdateDatabaseStatus(); SetGUIEnabled(true); MessageBox.Show("Removed " + Count.ToString() + " people", "Add/Update Successful"); } catch (Exception ex) { MessageBox.Show(ex.Message, "Unable to remove people", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void TestAddUpdate() { ResetDatabase(); // Add/update the rows in "TestPeople/input1.xls" int Count = PeopleMaintenance.AddUpdate(DB, AppDomain.CurrentDomain.BaseDirectory + "\\Unit Tests\\TestPeople\\input1.xls" ); Assert.AreEqual(Count, 4); VerifyAddUpdateResults(); // Delete the rows in "different setnb.xls", verify that nothing happened PeopleMaintenance.Remove(DB, AppDomain.CurrentDomain.BaseDirectory + "\\Unit Tests\\TestPeopleMaintenance\\different setnb.xls" ); VerifyAddUpdateResults(); }
public void TestDelete() { ResetDatabase(); // Delete the rows in "TestPeople/test hyphens.xls" int Count = PeopleMaintenance.Remove(DB, AppDomain.CurrentDomain.BaseDirectory + "\\Unit Tests\\TestPeople\\test hyphens.xls" ); Assert.AreEqual(Count, 1); // Verify that Wassertheil-Smoller (A7809652) was deleted People PeopleFromDB = new People(DB); Assert.AreEqual(PeopleFromDB.PersonList.Count, 3); foreach (Person person in PeopleFromDB.PersonList) { string Setnb = person.Setnb; Assert.IsTrue( Setnb == "A6009400" || Setnb == "A5401532" || Setnb == "A5501586"); } // Delete the rows in "different setnb.xls", verify that nothing happened PeopleMaintenance.Remove(DB, AppDomain.CurrentDomain.BaseDirectory + "\\Unit Tests\\TestPeopleMaintenance\\different setnb.xls" ); PeopleFromDB = new People(DB); Assert.AreEqual(PeopleFromDB.PersonList.Count, 3); foreach (Person person in PeopleFromDB.PersonList) { string Setnb = person.Setnb; Assert.IsTrue( Setnb == "A6009400" || Setnb == "A5401532" || Setnb == "A5501586"); } }