public void Add(BlogUser entity)
{
var sqlConnectionString = _configuration[KeyChain.SqlServerDataAccess_ConnectionString];
var storedProcedure = _configuration[KeyChain.SqlServerDataAccess_StoredProcedure_BlogUser_Add];
var listOfSqlParameters = new List <SqlParameter>();
listOfSqlParameters.Add(_sqlParameterBuilder.BuildSqlParameter <BlogUser>("Permissions", entity.Permissions));
listOfSqlParameters.Add(_sqlParameterBuilder.BuildSqlParameter <BlogUser>("TimeRegistered", entity.TimeRegistered));
listOfSqlParameters.Add(_sqlParameterBuilder.BuildSqlParameter <BlogUser>("UserId", entity.UserId));
listOfSqlParameters.Add(_sqlParameterBuilder.BuildSqlParameter <BlogUser>("UserName", entity.UserName));
var rowsAffected = _sqlserver.ExecuteNonQueryStoredProcedure(sqlConnectionString, storedProcedure, listOfSqlParameters);
}
public void Add(BlogPost entity)
{
var sqlConnectionString = _configuration[KeyChain.SqlServerDataAccess_ConnectionString];
var storedProcedure = _configuration[KeyChain.SqlServerDataAccess_StoredProcedure_BlogPost_Add];
var listOfSqlParameters = new List <SqlParameter>();
listOfSqlParameters.Add(_sqlParameterBuilder.BuildSqlParameter <BlogPost>("AuthorId", entity.AuthorId));
listOfSqlParameters.Add(_sqlParameterBuilder.BuildSqlParameter <BlogPost>("PostBody", entity.PostBody));
listOfSqlParameters.Add(_sqlParameterBuilder.BuildSqlParameter <BlogPost>("PostId", entity.PostId));
listOfSqlParameters.Add(_sqlParameterBuilder.BuildSqlParameter <BlogPost>("PostTitle", entity.PostTitle));
listOfSqlParameters.Add(_sqlParameterBuilder.BuildSqlParameter <BlogPost>("TimeCreated", entity.TimeCreated));
listOfSqlParameters.Add(_sqlParameterBuilder.BuildSqlParameter <BlogPost>("TimeLastModified", entity.TimeLastModified));
var rowsAffected = _sqlServerDataAccess.ExecuteNonQueryStoredProcedure(sqlConnectionString, storedProcedure, listOfSqlParameters);
}
