public static List<SystemGridRow> GetLastNSystems(Expedition currentExpedition, int numberToReturn = 20)
{
List<StarSystem> starSystems = null;
List<SystemGridRow> result = new List<SystemGridRow>();
using (var db = new EelContext()) {
starSystems = (from p in db.StarSystems.Include("Expeditions")
where p.Expedition.Id == currentExpedition.Id
orderby p.CreatedAt descending
select p).Take(numberToReturn).ToList();
foreach(var system in starSystems) {
int count = (from q in db.SystemObjects
where q.StarSystem.Id == system.Id
select q).Count();
var row = new SystemGridRow();
row.Date = system.CreatedAt;
row.Distance = system.DistToNext;
row.Name = system.Name;
row.HasSystemObjects = count > 0;
row.Id = system.Id;
result.Add(row);
}
}
return result;
}
public static StarSystem InsertStarSystem(StarSystem system)
{
if (null == system) throw new ArgumentNullException("expedition");
using (var db = new EelContext()) {
db.StarSystems.Add(system);
db.SaveChanges();
}
return system;
}
public static Settings GetSettings()
{
Settings settings = null;
using (var db = new EelContext()) {
settings = (from p in db.Settings
select p).FirstOrDefault();
}
return settings;
}
public static Settings InsertSettings(Settings settings)
{
if (null == settings) throw new ArgumentNullException("settings");
using (var db = new EelContext()) {
db.Settings.Add(settings);
db.SaveChanges();
}
return settings;
}
public static SystemObject InsertSystemObject(SystemObject systemObject)
{
if (null == systemObject) throw new ArgumentNullException("systemObject");
using (var db = new EelContext()) {
db.SystemObjects.Add(systemObject);
db.SaveChanges();
}
return systemObject;
}
public static Expedition InsertExpedition(Expedition expedition)
{
if (null == expedition) throw new ArgumentNullException("expedition");
using (var db = new EelContext()) {
db.Expeditions.Add(expedition);
db.SaveChanges();
}
return expedition;
}
public static List<Expedition> GetAll()
{
var exp = new List<Expedition>();
using (var db = new EelContext()) {
exp = (from p in db.Expeditions
select p).ToList();
}
return exp;
}
public static double GetTotalDistance(Expedition expedition)
{
double sum = 0;
using (var db = new EelContext()) {
sum = (from p in db.StarSystems.Include("Expeditions")
where p.Expedition.Id == expedition.Id
select p.DistToNext).Sum();
}
return sum;
}
public static StarSystem GetByStarSystemId(int id)
{
StarSystem starSystem = null;
using (var db = new EelContext()) {
starSystem = (from p in db.StarSystems.Include("Expedition")
where p.Id == id
select p).SingleOrDefault();
}
return starSystem;
}
public static List<SystemObject> GetByStarSystemId(int starSystemId)
{
List<SystemObject> systemObjects = null;
using (var db = new EelContext()) {
systemObjects = (from p in db.SystemObjects
where p.StarSystem.Id == starSystemId
select p
).ToList();
}
return systemObjects;
}
public static void ClearExpeditionCurrentFlags()
{
using (var db = new EelContext()) {
var exps = (from p in db.Expeditions
where p.Current
select p);
foreach(var exp in exps) {
exp.Current = false;
}
db.SaveChanges();
}
}
public static Settings UpdateSettings(Settings settings)
{
if (null == settings) throw new ArgumentNullException("expedition");
using (var db = new EelContext()) {
if (db.Settings.Count() > 0) {
db.Settings.Attach(settings);
db.Entry(settings).State = Microsoft.Data.Entity.EntityState.Modified;
} else {
db.Settings.Add(settings);
}
db.SaveChanges();
}
return settings;
}
public static bool SystemPreviouslyVisited(string name)
{
bool visited = false;
StarSystem system = null;
using (var db = new EelContext()) {
system = (from p in db.StarSystems
where p.Name.Trim() == name.Trim()
select p).FirstOrDefault();
if (null != system) {
system.Visits += 1;
UpdateStarSystem(system);
visited = true;
}
}
return visited;
}
public static StarSystem UpdateStarSystem(StarSystem system)
{
if (null == system) throw new ArgumentNullException("expedition");
using (var db = new EelContext()) {
system.UpdatedAt = DateTime.Now;
db.StarSystems.Attach(system);
db.Entry(system).State = Microsoft.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return system;
}
private void PopulateObjectTypes()
{
using (var db = new EelContext()) {
var objectTypes = (from p in db.ObjectTypes
orderby p.Order
select p).ToList();
ObjectTypesList.DataSource = objectTypes;
ObjectTypesList.DisplayMember = "Name";
ObjectTypesList.ValueMember = "Id";
}
}
/// <summary>
/// Initialize the database and seed the ObjectType table
/// </summary>
private void InitializeDb()
{
using (var db = new EelContext()) {
db.Database.EnsureCreated();
var objectTypes = new List<ObjectType> {
new ObjectType {Order = 1, Name = "Star (F/G/K/M)", LowValue=2400, HighValue = 6600, MedianValue=4500},
new ObjectType {Order = 2, Name = "Star (Other)", LowValue = 2400, HighValue=6600,MedianValue=4500},
new ObjectType {Order = 3, Name = "Black Hole" ,LowValue=38000, HighValue=50000,MedianValue=44000},
new ObjectType {Order = 4, Name = "Neutron Star" ,LowValue=36000, HighValue=38000,MedianValue=37000},
new ObjectType {Order = 5, Name = "White Dwarf" ,LowValue=26000, HighValue=26000,MedianValue=26000},
new ObjectType {Order = 6, Name = "Wolf-Rayet Star" ,LowValue=3000, HighValue=6600,MedianValue=4800},
new ObjectType {Order = 7, Name = "Carbon Star" ,LowValue=2400, HighValue=2400,MedianValue=2400},
new ObjectType {Order = 8, Name = "Proto Star (Ae/Be/T-Tauri)",LowValue=2400, HighValue=3000,MedianValue=2700 },
new ObjectType {Order = 9, Name = "Water World ",LowValue=18000, HighValue=36000,MedianValue=27000},
new ObjectType {Order = 10, Name = "Water World Terraformable",LowValue=27000, HighValue=65000,MedianValue=46000},
new ObjectType {Order = 11, Name = "Earth-like",LowValue=54000, HighValue=62000,MedianValue=58000},
new ObjectType {Order = 12, Name = "Ammonia",LowValue=33000, HighValue=35000,MedianValue=34000},
new ObjectType {Order = 13, Name = "Metal-Rich",LowValue=9000, HighValue=14000,MedianValue=11500},
new ObjectType {Order = 14, Name = "High Metal Content",LowValue=4100, HighValue=8500,MedianValue=6300},
new ObjectType {Order = 15, Name = "Terraformable High Metal",LowValue=30000, HighValue=45000,MedianValue=37500},
new ObjectType {Order = 16, Name = "Gas Giant Class I",LowValue=2200, HighValue=3800,MedianValue=3000},
new ObjectType {Order = 17, Name = "Gas Giant Class II",LowValue=7500, HighValue=12300,MedianValue=9900},
new ObjectType {Order = 18, Name = "Gas Giant Class III",LowValue=2200, HighValue=3800,MedianValue=3000},
new ObjectType {Order = 19, Name = "Gas Giant Class IV",LowValue=2200, HighValue=3800,MedianValue=3000},
new ObjectType {Order = 20, Name = "Gas Giant Class V",LowValue=2200, HighValue=3800,MedianValue=3000},
new ObjectType {Order = 21, Name = "Rocky/Icy Planet",LowValue=600, HighValue=1200,MedianValue=900},
};
for (var i = 0; i < objectTypes.Count; i++) {
db.ObjectTypes.Add(objectTypes[i]);
}
//objectTypes.ForEach(p => db.ObjectTypes.Add(p));
db.SaveChanges();
}
}
