Exemple #1
0
 public static User GetFirst()
 {
     NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString);
     var dbUser = newAppsCnn.Sec_Users.FirstOrDefault();
     if (dbUser != null)
     {
         User user = new User();
         user.FromDbUser(dbUser);
         user.LoadDbUserGroups(dbUser);
         return user;
     }
     else
         return null;
 }
Exemple #2
0
 public static User GetPrev(User _user)
 {
     if (_user == null)
         return GetFirst();
     NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString);
     var dbUsers = from u in newAppsCnn.Sec_Users where u.UserID < _user.UserID orderby u.UserID descending select u;
     if (dbUsers.Count() > 0)
     {
         var dbUser = dbUsers.FirstOrDefault();
         User user = new User();
         user.FromDbUser(dbUser);
         user.LoadDbUserGroups(dbUser);
         return user;
     }
     else
         return null;
 }
Exemple #3
0
 public static User FindByUserID(int _userID)
 {
     NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString);
     var dbUsers = from u in newAppsCnn.Sec_Users where u.UserID == _userID select u;
     if (dbUsers.Count() > 0)
     {
         Sec_Users dbUser = dbUsers.First();
         User user = new User();
         user.FromDbUser(dbUser);
         user.LoadDbUserGroups(dbUser);
         return user;
     }
     else
         return null;
 }