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 Public.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); }