public async Task <List <ConstellationBoundary> > GetConstellationBoundaries(CancellationToken token)
{
var constellationBoundaries = new List <ConstellationBoundary>();
try {
using (var context = new NINADbContext(connectionString)) {
var rows = await context.ConstellationBoundariesSet.OrderBy(x => x.constellation).ThenBy(x => x.position).ToListAsync(token);
ConstellationBoundary boundary = null;
var prevName = string.Empty;
foreach (var row in rows)
{
var name = row.constellation;
if (prevName != name)
{
prevName = name;
boundary = new ConstellationBoundary();
constellationBoundaries.Add(boundary);
boundary.Name = name;
}
boundary.Boundaries.Add(new Coordinates(row.ra, row.dec, Epoch.J2000, Coordinates.RAType.Hours));
}
}
} catch (OperationCanceledException) {
} catch (Exception ex) {
if (!ex.Message.Contains("Execution was aborted by the user"))
{
Logger.Error(ex);
Notification.ShowError(ex.Message);
}
}
return(constellationBoundaries);
}
public async Task <List <FocusTarget> > GetBrightStars()
{
var brightStars = new List <FocusTarget>();
try {
using (var context = new NINADbContext(connectionString)) {
var rows = await context.BrightStarsSet.ToListAsync();
foreach (var row in rows)
{
var brightStar = new FocusTarget(row.name);
var coords = new Coordinates(row.ra, row.dec, Epoch.J2000, Coordinates.RAType.Degrees);
brightStar.Coordinates = coords;
brightStar.Magnitude = row.magnitude;
brightStars.Add(brightStar);
}
}
} catch (OperationCanceledException) {
} catch (Exception ex) {
if (!ex.Message.Contains("Execution was aborted by the user"))
{
Logger.Error(ex);
Notification.ShowError(ex.Message);
}
}
return(brightStars);
}
public async Task <ICollection <string> > GetObjectTypes(CancellationToken token)
{
try {
using (var context = new NINADbContext(connectionString)) {
return(await context.DsoDetailSet.Select(x => x.dsotype).Distinct().ToListAsync(token));
}
} catch (OperationCanceledException) {
} catch (Exception ex) {
if (!ex.Message.Contains("Execution was aborted by the user"))
{
Logger.Error(ex);
Notification.ShowError(ex.Message);
}
}
return(new List <string>());
}
public async Task <double> GetUT1_UTC(DateTime date, CancellationToken token)
{
var unixTimestamp = Utility.Utility.DateTimeToUnixTimeStamp(date);
try {
using (var context = new NINADbContext(connectionString)) {
var rows = await context.EarthRotationParameterSet.OrderBy(x => Math.Abs(x.date - unixTimestamp)).Take(1).ToListAsync(token);
return(rows.First().ut1_utc);
}
} catch (OperationCanceledException) {
} catch (Exception ex) {
if (!ex.Message.Contains("Execution was aborted by the user"))
{
Logger.Error(ex);
}
}
return(double.NaN);
}
public async Task <List <DeepSkyObject> > GetDeepSkyObjects(
string imageRepository,
DeepSkyObjectSearchParams searchParams,
CancellationToken token)
{
using (MyStopWatch.Measure()) {
if (searchParams == null)
{
throw new ArgumentNullException(nameof(searchParams));
}
var dsos = new List <DeepSkyObject>();
try {
using (var context = new NINADbContext(connectionString)) {
var query = from dso in context.DsoDetailSet
select new {
dso.id,
dso.ra,
dso.dec,
dso.dsotype,
dso.magnitude,
dso.sizemin,
dso.sizemax,
dso.constellation,
dso.surfacebrightness
};
if (!string.IsNullOrEmpty(searchParams.Constellation))
{
query = query.Where(x => x.constellation == searchParams.Constellation);
}
if (searchParams.RightAscension.From != null)
{
query = query.Where(x => x.ra >= searchParams.RightAscension.From);
}
if (searchParams.RightAscension.Thru != null)
{
query = query.Where(x => x.ra <= searchParams.RightAscension.Thru);
}
if (searchParams.Declination.From != null)
{
query = query.Where(x => x.dec >= searchParams.Declination.From);
}
if (searchParams.Declination.Thru != null)
{
query = query.Where(x => x.dec <= searchParams.Declination.Thru);
}
if (searchParams.Size.From.HasValue)
{
query = query.Where(x => x.sizemin >= searchParams.Size.From);
}
if (searchParams.Size.Thru.HasValue)
{
query = query.Where(x => x.sizemax <= searchParams.Size.Thru);
}
if (searchParams.Brightness.From.HasValue)
{
query = query.Where(x => x.surfacebrightness >= searchParams.Brightness.From);
}
if (searchParams.Brightness.Thru.HasValue)
{
query = query.Where(x => x.surfacebrightness <= searchParams.Brightness.Thru);
}
if (searchParams.Magnitude.From.HasValue)
{
query = query.Where(x => x.magnitude >= searchParams.Magnitude.From);
}
if (searchParams.Magnitude.Thru.HasValue)
{
query = query.Where(x => x.magnitude <= searchParams.Magnitude.Thru);
}
if (searchParams.DsoTypes?.Count > 0)
{
query = query.Where(x => searchParams.DsoTypes.Contains(x.dsotype));
}
if (!string.IsNullOrEmpty(searchParams.ObjectName))
{
var name = searchParams.ObjectName.ToLower();
var idQuery = context.CatalogueNrSet.Where(x => x.dsodetailid.ToLower().Contains(name) || (x.catalogue + x.designation).ToLower().Contains(name) || (x.catalogue + " " + x.designation).ToLower().Contains(name)).Select(x => x.dsodetailid).Distinct();
query = query.Join(idQuery, dsoDetail => dsoDetail.id, e => e, (dsoDetail, id) => dsoDetail);
}
if (searchParams.SearchOrder.Direction == "ASC")
{
query = query.OrderBy(searchParams.SearchOrder.Field);
}
else
{
query = query.OrderByDescending(searchParams.SearchOrder.Field);
}
if (searchParams.Limit != null)
{
query = query.Take(searchParams.Limit.Value);
}
var dsosTask = query.ToListAsync(token);
var catalogueTask = (from q in query
join cat in context.CatalogueNrSet on q.id equals cat.dsodetailid
select new { cat.dsodetailid, designation = cat.catalogue == "NAME" ? cat.designation : cat.catalogue + " " + cat.designation })
.GroupBy(x => x.dsodetailid)
.ToDictionaryAsync(x => x.Key, x => x.ToList(), token);
await Task.WhenAll(dsosTask, catalogueTask);
var dsoResult = dsosTask.Result;
var catalogueResult = catalogueTask.Result;
foreach (var row in dsoResult)
{
var id = row.id;
var coords = new Coordinates(row.ra, row.dec, Epoch.J2000, Coordinates.RAType.Degrees);
var dso = new DeepSkyObject(row.id, coords, imageRepository);
dso.DSOType = row.dsotype;
if (row.magnitude.HasValue)
{
dso.Magnitude = (double?)row.magnitude;
}
if (row.sizemax.HasValue)
{
dso.Size = (double?)row.sizemax;
}
dso.AlsoKnownAs = catalogueResult[row.id].Select(x => x.designation).ToList();
var longestName = dso.AlsoKnownAs.Aggregate("", (max, cur) => max.Length > cur.Length ? max : cur);
dso.Name = longestName;
if (!string.IsNullOrEmpty(row.constellation))
{
dso.Constellation = row.constellation;
}
if (row.surfacebrightness.HasValue)
{
dso.SurfaceBrightness = (double?)row.surfacebrightness;
}
dsos.Add(dso);
}
}
} catch (OperationCanceledException) {
} catch (Exception ex) {
if (!ex.Message.Contains("Execution was aborted by the user"))
{
Logger.Error(ex);
Notification.ShowError(ex.Message);
}
}
return(dsos);
}
}
public async Task <List <Model.Constellation> > GetConstellationsWithStars(CancellationToken token)
{
var starList = new List <Star>();
var constellations = new List <Model.Constellation>();
try {
using (var context = new NINADbContext(connectionString)) {
var starlist = await context.ConstellationStarSet.ToListAsync(token);
starList = starlist.Select(x => new Star(x.id, x.name, new Coordinates(x.ra, x.dec, Epoch.J2000, Coordinates.RAType.Degrees), x.mag)).ToList();
var rows = await context.ConstellationSet.OrderBy(x => x.constellationid).ToListAsync(token);
foreach (var row in rows)
{
var constId = row.constellationid;
var constellation = constellations.SingleOrDefault(c => c.Id == constId);
if (constellation == null)
{
constellation = new Model.Constellation(constId);
constellations.Add(constellation);
}
Star star1 = starList.First(s => s.Id == row.starid);
Star star2 = starList.First(s => s.Id == row.followstarid);
constellation.StarConnections.Add(new Tuple <Star, Star>(star1, star2));
}
// make a list of unique stars
foreach (var constellation in constellations)
{
constellation.Stars = new List <Star>(
constellation.StarConnections
.Select(t => t.Item1)
.Concat(constellation.StarConnections.Select(t => t.Item2))
.GroupBy(b => b.Name)
.Select(b => b.First())
.ToList()
);
bool goesOver0 = false;
foreach (var pair in constellation.StarConnections)
{
goesOver0 = Math.Max(pair.Item1.Coords.RADegrees, pair.Item2.Coords.RADegrees) -
Math.Min(pair.Item1.Coords.RADegrees, pair.Item2.Coords.RADegrees) > 180;
if (goesOver0)
{
break;
}
}
constellation.GoesOverRaZero = goesOver0;
}
}
} catch (OperationCanceledException) {
} catch (Exception ex) {
if (!ex.Message.Contains("Execution was aborted by the user"))
{
Logger.Error(ex);
Notification.ShowError(ex.Message);
}
}
return(constellations);
}