// 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; } } }