/// <summary>
/// Inserts a new row into the Person table with the supplied parameters.
/// </summary>
/// <param name="lastName"></param>
/// <param name="firstName"></param>
/// <param name="emailAddress">optional</param>
/// <param name="birthDate">optional</param>
public Task InsertPerson(string lastName, string firstName, string emailAddress = null, string birthDate = null)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(ConfigurationManagerHelper.DBConn("Person")))
{
List <Person> people = new List <Person>();
//Todo: figure out the mumbo jumbo about converting a string to a date or just f*****g make the prop a date?
people.Add(new Person {
LastName = lastName, FirstName = firstName, EmailAddress = emailAddress, BirthDate = birthDate
});
//the parameters are filled in by the properties in the class if the names match up.
//returning this instead of awaiting it frees up this singleton to handle other requests.
return(connection.ExecuteAsync("dbo.PERSON_INSERTPERSON @LastName, @FirstName, @emailAddress, @BirthDate", people));
}
}
