public AspnetUserCollection FetchByQuery(Query qry)
{
AspnetUserCollection coll = new AspnetUserCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public AspnetUserCollection FetchAll()
{
AspnetUserCollection coll = new AspnetUserCollection();
Query qry = new Query(AspnetUser.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public static SignificantTradeSS.AspnetUserCollection GetAspnetUserCollection(Guid varRoleId)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand("SELECT * FROM [dbo].[aspnet_Users] INNER JOIN [aspnet_UsersInRoles] ON [aspnet_Users].[UserId] = [aspnet_UsersInRoles].[UserId] WHERE [aspnet_UsersInRoles].[RoleId] = @RoleId", AspnetRole.Schema.Provider.Name);
cmd.AddParameter("@RoleId", varRoleId, DbType.Guid);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
AspnetUserCollection coll = new AspnetUserCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static void SaveAspnetUserMap(Guid varRoleId, AspnetUserCollection items)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM [aspnet_UsersInRoles] WHERE [aspnet_UsersInRoles].[RoleId] = @RoleId", AspnetRole.Schema.Provider.Name);
cmdDel.AddParameter("@RoleId", varRoleId, DbType.Guid);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (AspnetUser item in items)
{
AspnetUsersInRole varAspnetUsersInRole = new AspnetUsersInRole();
varAspnetUsersInRole.SetColumnValue("RoleId", varRoleId);
varAspnetUsersInRole.SetColumnValue("UserId", item.GetPrimaryKeyValue());
varAspnetUsersInRole.Save();
}
}
public AspnetUserCollection FetchByID(object UserId)
{
AspnetUserCollection coll = new AspnetUserCollection().Where("UserId", UserId).Load();
return(coll);
}
