/// <summary>
/// Imports data from the raw person information to the correct tables in the database
/// </summary>
private void ImportData()
{
_view.StatusTextBox.Text = "";
try
{
var dataTransformer = new DataTransformer();
dataTransformer.TransformData();
ShowSuccess("Data was successfully imported.");
}
catch (Exception ex)
{
ShowError(ex.Message + ". Data could not be imported.");
}
}
public void TestDataTransform()
{
var u = VoterListApp.CurrentUser;
var dt = new DataTransformer();
dt.TransformData();
// 13 persons in row data, 4 persons in in current, one overlap (Jens) = 16 total
var select = new MySqlCommand("SELECT COUNT(*) FROM person;", this._conn);
object o = select.ExecuteScalar();
Assert.That(Convert.ToInt32(o) == 16, "Did not import expected amount of people.");
MySqlCommand selectData = new MySqlCommand("SELECT COUNT(*) FROM person WHERE name='Mik Thomasen'", this._conn);
var i = Convert.ToInt32(selectData.ExecuteScalar());
Assert.That(i == 1, "Mik Thomasen was not insert into data");
select = new MySqlCommand("SELECT COUNT(*) FROM person WHERE eligible_to_vote=1;", this._conn);
i = Convert.ToInt32(select.ExecuteScalar());
Assert.That(i > 5);
}