public List <RegisteredSipDto> GetCachedRegisteredSips()
{
using (new TimeMeasurer("GetRegisteredSips from database."))
{
DateTime maxAge = DateTime.UtcNow.AddSeconds(-SettingsManager.MaxRegistrationAge);
List <MetaType> metaList = _metaRepository.GetAll();
using (var db = GetDbContext())
{
if (log.IsTraceEnabled)
{
db.Database.Log = s => { log.Trace("EF Log GetCachedRegisteredSips: {0}", s); };
}
IQueryable <Entities.RegisteredSipEntity> query = db.RegisteredSips
.Include(rs => rs.Location)
.Include(rs => rs.Location.Region)
.Include(rs => rs.Location.City)
.Include(rs => rs.Location.ProfileGroup)
.Include(rs => rs.Location.ProfileGroup.OrderedProfiles)
.Include(rs => rs.User)
.Include(rs => rs.User.Owner)
.Include(rs => rs.User.CodecType)
.Include(rs => rs.UserAgent)
.Include(rs => rs.UserAgent.OrderedProfiles)
.Where(r => r.Updated >= maxAge); // && r.User.UserType == UserType.SIP);
var dbResult = query.ToList();
var list = dbResult.Select(sip => MapToRegisteredSipDto(sip, metaList)).ToList();
AddCallInfoToCachedRegisteredSip(db, list);
return(list);
}
}
}
public ActionResult Index(string search = "")
{
var metaTypes = string.IsNullOrWhiteSpace(search) ? _metaRepository.GetAll() : _metaRepository.FindMetaTypes(search);
var model = metaTypes.Select(metaType => new MetaViewModel()
{
Id = metaType.Id, Name = metaType.Name
}).ToList();
ViewBag.SearchString = search;
return(View(model));
}
public IEnumerable <RegisteredUserAgentDiscovery> GetRegisteredUserAgentsDiscovery()
{
DateTime maxAge = DateTime.UtcNow.AddSeconds(-SettingsManager.MaxRegistrationAge);
// Get available meta data properties
List <MetaType> metaList = _metaRepository.GetAll();
using (var db = GetDbContext())
{
IEnumerable <RegisteredSipEntity> dbSip = db.RegisteredSips
.Include(rs => rs.Location)
.Include(rs => rs.Location.Region)
.Include(rs => rs.Location.City)
.Include(rs => rs.User)
.Include(rs => rs.User.Owner)
.Include(rs => rs.User.CodecType)
.Include(rs => rs.UserAgent)
.Where(r => r.Updated >= maxAge)
.ToList();
return(dbSip.Select(x =>
{
return new RegisteredUserAgentDiscovery(
id: x.Id,
updated: x.Updated,
sipUri: x.SIP,
displayName: x.DisplayName,
username: x.Username,
ipAddress: x.IP,
userAgentHeader: x.UserAgentHeader,
userAgentId: x.UserAgentId,
userAgentName: x.UserAgent?.Name,
locationId: x.Location_LocationId,
locationName: x.Location?.Name,
locationShortName: x.Location?.ShortName,
regionName: x.Location?.Region?.Name,
cityName: x.Location?.City?.Name,
userOwnerName: x.User?.Owner?.Name,
userDisplayName: x.User?.DisplayName,
codecTypeName: x.User?.CodecType?.Name,
metaData: GetMetaData(metaList, x));
})
.ToList());
}
}
public IEnumerable <TEntity> GetAll()
{
return(repository.GetAll());
}
