public void Update(EmployeeDataModel dataModel)
{
var query = @"spUpdateEmployees
@Id,
@FirstName,
@LastName,
@ComplexDetails,
@StreetName,
@Suburb,
@Province,
@Country,
@PostalCode,
@ContactCountryCode,
@ContactNumber,
@ContactExtension,
@EmailAddress,
@TwitterHandle,
@GithubPage";
_dbConnection.Execute(query, dataModel);
}
public int Add(EmployeeDataModel dataModel)
{
var query = @"spAddEmployees
@FirstName,
@LastName,
@ComplexDetails,
@StreetName,
@Suburb,
@Province,
@Country,
@PostalCode,
@ContactCountryCode,
@ContactNumber,
@ContactExtension,
@EmailAddress,
@TwitterHandle,
@GithubPage";
var result = _dbConnection.Query <int>(query, dataModel);
return(result.FirstOrDefault());
}