Changeset 7380 for branches/ClientUserManagement/HeuristicLab.Services.Access/3.3/AccessService.cs

Timestamp:

01/20/12 13:24:10 (12 years ago)

Author:

ascheibe

Message:

#1648

• fixed user query ws methods
• improved user view

File:

• branches/ClientUserManagement/HeuristicLab.Services.Access/3.3/AccessService.cs (modified) (5 diffs)

branches/ClientUserManagement/HeuristicLab.Services.Access/3.3/AccessService.cs

@@ -278 +278 @@
       DA.User accessUser = null;
 
-      using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
-        var query = from u in context.UserGroupBases.OfType<DA.User>()
-                    where u.Id == userId
-                    select u;
-        if (query.Count() == 1) {
-          accessUser = query.First();
-        } else {
-          //if the user is not in the access db at it
-          DA.User user = new DA.User();
-          user.Id = userId;
-          user.FullName = "Not set";
-          context.UserGroupBases.InsertOnSubmit(user);
-          context.SubmitChanges();
-          accessUser = user;
-        }
-      }
-
       using (DA.ASPNETAuthenticationDataContext context = new DA.ASPNETAuthenticationDataContext()) {
         var userQuery = from u in context.aspnet_Users
@@ -311 +294 @@
       }
 
+      if (aspUser == null || aspMembership == null) {
+        using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
+          var query = from u in context.UserGroupBases.OfType<DA.User>()
+                      where u.Id == userId
+                      select u;
+          if (query.Count() == 1) {
+            accessUser = query.First();
+          } else {
+            //if the user is not in the access db add it (this makes it easy to upgrade with an existing asp.net authentication db)
+            DA.User user = new DA.User();
+            user.Id = userId;
+            user.FullName = "Not set";
+            context.UserGroupBases.InsertOnSubmit(user);
+            context.SubmitChanges();
+            accessUser = user;
+          }
+        }
+      }
+
       if (aspUser == null || aspMembership == null || accessUser == null) {
-        //TODO: error handling
-        return null;
+        throw new Exception("User with id " + userId + " not found.");
       } else {
         return Convert.ToDto(accessUser, aspUser, aspMembership);
@@ -332 +333 @@
       }
 
-      using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
-        var query = from u in context.UserGroupBases.OfType<DA.User>()
-                    where u.Id == userId
-                    select u;
-        if (query.Count() == 1) {
-          accessUser = query.First();
-        } else {
-          //if the user is not in the access db at it
-          DA.User user = new DA.User();
-          user.Id = userId;
-          user.FullName = "Not set";
-          context.UserGroupBases.InsertOnSubmit(user);
-          context.SubmitChanges();
-          accessUser = user;
+      if (aspUser != null) {
+        using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
+          var query = from u in context.UserGroupBases.OfType<DA.User>()
+                      where u.Id == userId
+                      select u;
+          if (query.Count() == 1) {
+            accessUser = query.First();
+          } else {
+            //if the user is not in the access db add it (this makes it easy to upgrade with an existing asp.net authentication db)
+            DA.User user = new DA.User();
+            user.Id = userId;
+            user.FullName = "Not set";
+            context.UserGroupBases.InsertOnSubmit(user);
+            context.SubmitChanges();
+            accessUser = user;
+          }
         }
       }
 
       if (aspUser == null || accessUser == null) {
-        //TODO: error handling
-        return null;
+        throw new Exception("User with id " + userId + " not found.");
       } else {
         return Convert.ToDto(accessUser, aspUser);
@@ -365 +367 @@
       List<Guid> accessUserGuids = null;
 
-      using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
-        var query = from u in context.UserGroupBases.OfType<DA.User>()
-                    select u.Id;
+      using (DA.ASPNETAuthenticationDataContext context = new DA.ASPNETAuthenticationDataContext()) {
+        var query = from u in context.aspnet_Users
+                    select u.UserId;
         accessUserGuids = query.ToList();
       }
-
       return accessUserGuids.Select(x => BuildLightweightUserDto(x));
     }
@@ -377 +378 @@
       List<Guid> accessUserGuids = null;
 
-      using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
-        var query = from u in context.UserGroupBases.OfType<DA.User>()
-                    select u.Id;
+      using (DA.ASPNETAuthenticationDataContext context = new DA.ASPNETAuthenticationDataContext()) {
+        var query = from u in context.aspnet_Users
+                    select u.UserId;
         accessUserGuids = query.ToList();
       }