/// <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");
}
}
