public AspnetRoleCollection FetchByQuery(Query qry)
{
AspnetRoleCollection coll = new AspnetRoleCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public AspnetRoleCollection FetchAll()
{
AspnetRoleCollection coll = new AspnetRoleCollection();
Query qry = new Query(AspnetRole.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public static SignificantTradeSS.AspnetRoleCollection GetAspnetRoleCollection(Guid varUserId)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand("SELECT * FROM [dbo].[aspnet_Roles] INNER JOIN [aspnet_UsersInRoles] ON [aspnet_Roles].[RoleId] = [aspnet_UsersInRoles].[RoleId] WHERE [aspnet_UsersInRoles].[UserId] = @UserId", AspnetUser.Schema.Provider.Name);
cmd.AddParameter("@UserId", varUserId, DbType.Guid);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
AspnetRoleCollection coll = new AspnetRoleCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
