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; } }
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; } } }