public void Test1()
{
//SqlLiteDataAccess sqllitedataacces = new SqlLiteDataAccess();
var employees = SqlLiteDataAccess.GetEmployees();
Assert.IsTrue(employees.Count > 0);
}
public List <CurrencyModel> GetAll()
{
SqlLiteDataAccess data_access = new SqlLiteDataAccess();
var result = data_access.GetAll(_table);
return(MapVarToList(result));
}
public void LoadConnectionString_ShouldReturnConnectionString()
{
string expected = @"Data Source=.\MyTestDatabase.sqlite;Version=3;";
string actual = SqlLiteDataAccess.LoadConnectionString();
Assert.Equal(expected, actual);
}
private void addPersonButton_Click(object sender, EventArgs e)
{
PersonModel p = new PersonModel();
p.FirstName = firstNameTextBox.Text;
p.LastName = lastNameTextBox.Text;
SqlLiteDataAccess.SavePerson(p);
WireUpPeopleList();
firstNameTextBox.Text = "";
lastNameTextBox.Text = "";
}
private void LoadPeopleList()
{
people = SqlLiteDataAccess.LoadPeople();
WireUpPeopleList();
}
public void Save(CurrencyModel cm)
{
SqlLiteDataAccess data_access = new SqlLiteDataAccess();
data_access.SaveData(_table, ToListOfKeyValuePairs(cm));
}
