// USER & USER ACCOUNT methods
public UserAccount GetUserAccountByUserName(string userName)
{
Entities.UserAccess userAccessData = _dataAccessObjects.GetUserAccountByUserName(userName);
UserAccount userAccount = Translators.UserAccount.ToBusinessObject(userAccessData);
return(userAccount);
}
public static UserAccess GetByUserName(string userName)
{
UserAccess userAccess = new UserAccess();
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (GetUserAccessByUserNameCommand objectCommand = new GetUserAccessByUserNameCommand(objectConnection))
{
objectCommand.UserName = userName;
objectConnection.Open();
using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader())
{
if (!sqlDataReader.HasRows)
{
return null;
}
using (UserAccessSqlDataReader objectSqlDataReader = new UserAccessSqlDataReader(sqlDataReader))
{
while (objectSqlDataReader.Read())
{
userAccess = objectSqlDataReader.UserAccess;
}
}
}
}
}
return userAccess;
}
public static int Delete(UserAccess user)
{
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (DeleteUserAccessByUsernameCommand objectCommand = new DeleteUserAccessByUsernameCommand(objectConnection))
{
objectCommand.Username = user.UserName;
objectConnection.Open();
objectCommand.ExecuteNonQuery();
return objectCommand.ReturnValue;
}
}
}
public static Entities.UserAccess ToEntity(BusinessObject.UserAccount businessObject)
{
if (businessObject == null)
return null;
Entities.UserAccess entity = new Entities.UserAccess
{
UserId = businessObject.UserAccountId,
PersonId = businessObject.PersonId,
UserName = businessObject.UserName,
UserPassword = businessObject.PasswordHash,
PermissionToken = businessObject.PermissionSet.Token
};
return entity;
}
public static BusinessObject.UserAccount ToBusinessObject(Entities.UserAccess entity)
{
if (entity == null)
{
return(null);
}
BusinessObject.UserAccount businessObject = new BusinessObject.UserAccount(
entity.UserId,
entity.PersonId,
entity.UserName,
entity.UserPassword,
new PermissionSet(entity.PermissionToken),
true);
return(businessObject);
}
public static Entities.UserAccess ToEntity(BusinessObject.UserAccount businessObject)
{
if (businessObject == null)
{
return(null);
}
Entities.UserAccess entity = new Entities.UserAccess
{
UserId = businessObject.UserAccountId,
PersonId = businessObject.PersonId,
UserName = businessObject.UserName,
UserPassword = businessObject.PasswordHash,
PermissionToken = businessObject.PermissionSet.Token
};
return(entity);
}
public static int UpdateByUserId(UserAccess userAccess)
{
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (UpdateUserAccessByUserIdCommand objectCommand = new UpdateUserAccessByUserIdCommand(objectConnection))
{
objectCommand.UserId = userAccess.UserId;
objectCommand.UserName = userAccess.UserName;
objectCommand.UserPassword = userAccess.UserPassword;
objectCommand.PersonId = userAccess.PersonId;
objectCommand.PermissionToken = userAccess.PermissionToken;
objectConnection.Open();
objectCommand.ExecuteNonQuery();
return objectCommand.ReturnValue;
}
}
}
