public int CreateEntity(BlogUser blogUserToCreate)
{
using (var cmd = UnitOfWork.CreateCommand())
{
try
{
cmd.CommandText = "CreateBlogUser";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@UserName", SqlDbType.VarChar, 50)
{
Value = blogUserToCreate.UserName
});
cmd.Parameters.Add(new SqlParameter("@UserPassword", SqlDbType.VarChar, 50)
{
Value = blogUserToCreate.UserPassword
});
var outPutParameter = new SqlParameter("@CreatedUserId", SqlDbType.Int, 50,
ParameterDirection.InputOutput, false, 0, 0, "@CreatedUserId", DataRowVersion.Original, null);
outPutParameter.Value = ParameterDirection.InputOutput;
cmd.Parameters.Add(outPutParameter);
cmd.ExecuteNonQuery();
int createdUserId = Convert.ToInt32(outPutParameter.Value);
_blogUserBuilder.SetBlogUserId(blogUserToCreate, createdUserId);
return(createdUserId);
}
catch (SqlException ex)
{
throw new ApplicationException(ex.Message, ex);
}
}
}
public AnswerStatus UpdateUser(BlogUserDto userDTO)
{
using (var uow = _unitOfWorkFactory.Create())
{
try
{
var userToUpdate = _blogUserBuilder.CreateBlogUser(userDTO.UserName, userDTO.UserPassword);
_blogUserBuilder.SetBlogUserId(userToUpdate, userDTO.Id);
var userRepository = _repositoryFactory.CreateUserRepository(uow);
userRepository.UpdateEntity(userToUpdate);
uow.SaveChanges();
return(AnswerStatus.Successfull);
}
catch (Exception exc)
{
_logger.Log(exc.ToString());
return(AnswerStatus.Failed);
}
}
}