コード例 #1
0
 public IEnumerable <View_UserDetails> GetAllUserDetailsByUserRoleAndStatus(int roleId, int userStatusId)
 {
     try
     {
         using (var context = _dbContextFactory.CreateConnection())
         {
             return(context.View_UserDetails.Where(a => (a.RoleId == roleId.ToString() || roleId == 0) && (a.UserStatus == userStatusId || userStatusId == 3)).ToList());
         }
     }
     catch (Exception ex)
     {
         _Logger.Error(ex.Message, ex);
         throw ex;
     }
 }
コード例 #2
0
 public IEnumerable <Alumini.Core.Salutation> GetSaluations()
 {
     using (var context = _dbContextFactory.CreateConnection())
     {
         try
         {
             return(context.Salutations.ToList());
         }
         catch (Exception ex)
         {
             _Logger.Error(ex.Message, ex);
             throw ex;
         }
     }
 }