/// <summary>
/// Find users by name.
/// </summary>
/// <param name="usernameToMatch">The username to match.</param>
/// <param name="pageIndex">The page index.</param>
/// <param name="pageSize">The page size.</param>
/// <param name="totalRecords">Total number of records.</param>
/// <returns>The membership user collection.</returns>
public System.Web.Security.MembershipUserCollection FindUsersByName(string usernameToMatch, int pageIndex, int pageSize, out int totalRecords)
{
System.Web.Security.MembershipUserCollection memShipUsers = new System.Web.Security.MembershipUserCollection();
Nequeo.DataAccess.ApplicationLogin.Data.Extension.User user = new Nequeo.DataAccess.ApplicationLogin.Data.Extension.User();
Nequeo.DataAccess.ApplicationLogin.Data.Extension.UserAddress userAddress = new Nequeo.DataAccess.ApplicationLogin.Data.Extension.UserAddress();
// Get all the users for the match.
long usersMatched = user.Select.
GetRecordCount(
u =>
(Nequeo.Data.TypeExtenders.SqlQueryMethods.Like(u.LoginUsername, ("%" + usernameToMatch + "%")))
);
// Get the total number of uses.
totalRecords = Int32.Parse(usersMatched.ToString());
int skipNumber = (pageIndex * pageSize);
DateTime createdDate = DateTime.Now;
// Get the current set on data.
IQueryable <Data.User> users = user.Select.QueryableProvider().
Where(u =>
(Nequeo.Data.TypeExtenders.SqlQueryMethods.Like(u.LoginUsername, ("%" + usernameToMatch + "%")))).
OrderBy(u => u.UserID).
Take(pageSize).
Skip(skipNumber);
// For each user found.
foreach (Data.User item in users)
{
// Get the current users address details
Data.UserAddress address = userAddress.Select.SelectDataEntity(u => u.UserAddressID == item.UserAddressID);
// Create the membership user.
System.Web.Security.MembershipUser memShipUser =
new System.Web.Security.MembershipUser(
ProviderName,
item.LoginUsername,
item.UserID,
address.EmailAddress,
"",
item.Comments,
true,
item.UserSuspended,
createdDate,
createdDate,
createdDate,
createdDate,
createdDate);
// Add the user to the collection.
memShipUsers.Add(memShipUser);
}
// Return the collection of membership users.
return(memShipUsers);
}
public List <OwnerPresentationStub> MapListUsername(System.Web.Security.MembershipUserCollection dbItems)
{
List <OwnerPresentationStub> retList = new List <OwnerPresentationStub>();
foreach (System.Web.Security.MembershipUser dbItem in dbItems)
{
retList.Add(new OwnerPresentationStub(dbItem));
}
return(retList);
}
/// <summary>
/// Find users by name.
/// </summary>
/// <param name="usernameToMatch">The username to match.</param>
/// <param name="pageIndex">The page index.</param>
/// <param name="pageSize">The page size.</param>
/// <param name="totalRecords">Total number of records.</param>
/// <returns>The membership user collection.</returns>
public System.Web.Security.MembershipUserCollection FindUsersByName(string usernameToMatch, int pageIndex, int pageSize, out int totalRecords)
{
System.Web.Security.MembershipUserCollection memShipUsers = new System.Web.Security.MembershipUserCollection();
Nequeo.DataAccess.CloudInteraction.Data.Extension.User user = new Nequeo.DataAccess.CloudInteraction.Data.Extension.User();
// Get all the users for the match.
long usersMatched = user.Select.
GetRecordCount(
u =>
(u.ApplicationName == ApplicationName) &&
(Nequeo.Data.TypeExtenders.SqlQueryMethods.Like(u.Username, ("%" + usernameToMatch + "%")))
);
// Get the total number of uses.
totalRecords = Int32.Parse(usersMatched.ToString());
int skipNumber = (pageIndex * pageSize);
// Get the current set on data.
IQueryable <Data.User> users = user.Select.QueryableProvider().
Where(u =>
(u.ApplicationName == ApplicationName) &&
(Nequeo.Data.TypeExtenders.SqlQueryMethods.Like(u.Username, ("%" + usernameToMatch + "%")))).
OrderBy(u => u.Username).
Take(pageSize).
Skip(skipNumber);
// For each user found.
foreach (Data.User item in users)
{
// Create the membership user.
System.Web.Security.MembershipUser memShipUser =
new System.Web.Security.MembershipUser(
ProviderName,
item.Username,
item.UserID,
item.Email,
item.PasswordQuestion,
item.Comments,
item.IsApproved,
item.UserSuspended,
item.CreationDate,
item.LastLoginDate,
item.LastActivityDate,
item.LastPasswordChangedDate,
item.UserSuspendedDate);
// Add the user to the collection.
memShipUsers.Add(memShipUser);
}
// Return the collection of membership users.
return(memShipUsers);
}
public override System.Web.Security.MembershipUserCollection FindUsersByName(string usernameToMatch, int pageIndex, int pageSize, out int totalRecords)
{
System.Web.Security.MembershipUserCollection list = new System.Web.Security.MembershipUserCollection();
using (SqlNullDataReader reader = SqlHelper.ExecuteReader(_connectionString, "dbo.lg_Users_FindUsersByName",
SqlHelper.CreateInputParam("@UserName", SqlDbType.NVarChar, usernameToMatch)))
{
while (reader.Read())
{
list.Add(this.GetUserFromReader(reader));
}
}
totalRecords = list.Count;
return(list);
}
public override System.Web.Security.MembershipUserCollection GetAllUsers(int pageIndex, int pageSize, out int totalRecords)
{
System.Web.Security.MembershipUserCollection list = new System.Web.Security.MembershipUserCollection();
using (SqlNullDataReader reader = SqlHelper.ExecuteReader(_connectionString, "dbo.lg_Users_GetAll",
SqlHelper.CreateInputParam("@StartRowIndex", SqlDbType.Int, pageIndex),
SqlHelper.CreateInputParam("@MaxRows", SqlDbType.Int, pageSize)))
{
while (reader.Read())
{
list.Add(this.GetUserFromReader(reader));
}
}
totalRecords = list.Count;
return(list);
}
private System.Web.Security.MembershipUserCollection ToMembershipUserCollection(IEnumerable <Models.User> users)
{
var mUsers = users.Select(user =>
new System.Web.Security.MembershipUser(
membershipName ?? Name,
user.UserName,
user.Id,
user.Email,
null,
null,
true,
false,
user.CreatedOn,
System.DateTime.MinValue,
System.DateTime.MinValue,
System.DateTime.MinValue,
System.DateTime.MinValue)).ToList();
var collection = new System.Web.Security.MembershipUserCollection();
mUsers.ForEach(collection.Add);
return(collection);
}
private System.Web.Security.MembershipUserCollection ToMembershipUserCollection(IEnumerable<Models.User> users)
{
var mUsers = users.Select(user =>
new System.Web.Security.MembershipUser(
membershipName ?? Name,
user.UserName,
user.Id,
user.Email,
null,
null,
true,
false,
user.CreatedOn,
System.DateTime.MinValue,
System.DateTime.MinValue,
System.DateTime.MinValue,
System.DateTime.MinValue)).ToList();
var collection = new System.Web.Security.MembershipUserCollection();
mUsers.ForEach(collection.Add);
return collection;
}
public override System.Web.Security.MembershipUserCollection GetAllUsers(int pageIndex, int pageSize, out int totalRecords)
{
var users = Provider.GetAllUsers(pageIndex, pageSize, out totalRecords);
System.Web.Security.MembershipUserCollection collection = new System.Web.Security.MembershipUserCollection();
users.ForEach(u => collection.Add(MembershipUser.NewMembershipUser(u, Provider)));
return collection;
}
public override System.Web.Security.MembershipUserCollection FindUsersByName(string usernameToMatch, int pageIndex, int pageSize, out int totalRecords)
{
var users = Provider.FindUsersByName(usernameToMatch, pageIndex, pageSize, out totalRecords);
System.Web.Security.MembershipUserCollection collection = new System.Web.Security.MembershipUserCollection();
users.ForEach(u => collection.Add(MembershipUser.NewMembershipUser(u, Provider)));
return collection;
}
