private void btnAdd_Click(object sender, EventArgs e)
{
var testDTO = new TestDTO
{
Id = Int32.Parse(tbxId.Text),
Name = tbxName.Text
};
_testService.Add(testDTO);
LoadTestDtosToListBox();
}
public void Add(TestDTO testDto)
{
using (SqlConnection conn = new SqlConnection(_connection))
{
var sql = @"insert into Test VALUES (@id, @name)";
var pararmeters = new DynamicParameters();
pararmeters.Add("id", testDto.Id);
pararmeters.Add("name", testDto.Name);
conn.Execute(sql, pararmeters);
}
}
