public static string EntityErrorsToString(EntityError[] EntityErrors)
{
string entityErrors = string.Empty;
foreach (var error in EntityErrors)
{
entityErrors += error.ErrorMessage + "; ";
}
if (!String.IsNullOrEmpty(entityErrors))
{
entityErrors = entityErrors.Remove(entityErrors.Length - 2);
}
return entityErrors;
}
public IResult Insert(User user, Guid userId)
{
string connectionString = ConfigurationManager.ConnectionStrings["default"].ConnectionString;
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
using (SqlTransaction transaction = connection.BeginTransaction(IsolationLevel.ReadCommitted))
{
try
{
Guid? id;
if (user.Id == null)
{
id = Guid.NewGuid();
}
else
{
// jhj - id = user.Id;
id = userId;
}
user.UtcCreatedDate = DateTime.Now;
UserDb.Insert(transaction,
id,
user.Username,
user.PasswordHash,
user.PasswordHint,
user.Language_Code,
user.Description,
user.UserGroup_Id,
(int)user.StatusId,
user.CreatedUserId,
user.UtcCreatedDate);
PersonDb.Insert(transaction,
ref id,
user.FirstName,
user.Surname,
user.EmailAddress,
user.PhoneHome,
user.PhoneMobile,
user.PhoneOffice,
user.Fax,
user.Description,
user.Gender,
user.Disability,
user.DisabilityNote,
user.PreferredName,
(int) ActiveStatus.Active,
userId);
transaction.Commit();
return new InsertResult();
}
catch (Exception ex)
{
transaction.Rollback();
var entityError = new EntityError("UserBll", "Insert", ex.Message);
return new InsertResult(entityError);
}
}
}
}