public PausedMission GetMissionDetails(int pausedMissionId)
{
using (var ctx = new WarframeResDemoContext())
{
return(ctx.PausedMissions.First(x => x.Id == pausedMissionId));
}
}
public Resource GetResourceDetails(int resourceId)
{
using (var ctx = new WarframeResDemoContext())
{
return(ctx.Resources.Include(r => r.PlanetResource).First(x => x.Id == resourceId));
}
}
public List <Fraction> GetAllFractions()
{
using (var ctx = new WarframeResDemoContext())
{
return(ctx.Fractions.ToList());
}
}
public List <PausedMission> GetAllMissions()
{
using (var ctx = new WarframeResDemoContext())
{
return(ctx.PausedMissions.ToList());
}
}
public EndedMissions GetMissionDetails(int endedMissionId)
{
using (var ctx = new WarframeResDemoContext())
{
return(ctx.EndedMissions.First(x => x.Id == endedMissionId));
}
}
public List <Planet> GetAllPlanets()
{
using (var ctx = new WarframeResDemoContext())
{
return(ctx.Planets.Include(p => p.PlanetResource).Include(p => p.Missions).ToList());
}
}
public Planet GetPlanetDetails(int planetId)
{
using (var ctx = new WarframeResDemoContext())
{
return(ctx.Planets.Include(p => p.PlanetResource).Include(p => p.Missions).First(x => x.Id == planetId));
}
}
public List <Mission> GetAllMissions()
{
using (var ctx = new WarframeResDemoContext())
{
return(ctx.Missions.Include(m => m.Fraction).Include(m => m.MissionType).ToList());
}
}
public Fraction GetFractionDetails(int fractionId)
{
using (var ctx = new WarframeResDemoContext())
{
return(ctx.Fractions.First(x => x.Id == fractionId));
}
}
public MissionType GetTypeDetails(int typeId)
{
using (var ctx = new WarframeResDemoContext())
{
return(ctx.MissionTypes.First(t => t.Id == typeId));
}
}
public List <MissionType> GetAllTypes()
{
using (var ctx = new WarframeResDemoContext())
{
return(ctx.MissionTypes.ToList());
}
}
public List <Resource> GetAllResources()
{
using (var ctx = new WarframeResDemoContext())
{
return(ctx.Resources.Include(r => r.PlanetResource).ToList());
}
}
public Mission GetMissionDetails(int missionId)
{
using (var ctx = new WarframeResDemoContext())
{
return(ctx.Missions.Include(m => m.Fraction).Include(m => m.MissionType).First(x => x.Id == missionId));
}
}
public void CreateMission(PausedMission pausedMission)
{
using (var ctx = new WarframeResDemoContext())
{
ctx.PausedMissions.Add(pausedMission);
ctx.SaveChanges();
}
}
public void CreatePlanet(Data.Entities.Planet planet)
{
using (var ctx = new WarframeResDemoContext())
{
ctx.Planets.Add(planet);
ctx.SaveChanges();
}
}
public void CreateResource(Resource resource)
{
using (var ctx = new WarframeResDemoContext())
{
ctx.Resources.Add(resource);
ctx.SaveChanges();
}
}
public void CreateFraction(Fraction fraction)
{
using (var ctx = new WarframeResDemoContext())
{
ctx.Fractions.Add(fraction);
ctx.SaveChanges();
}
}
public void CreateType(MissionType type)
{
using (var ctx = new WarframeResDemoContext())
{
ctx.MissionTypes.Add(type);
ctx.SaveChanges();
}
}
public void CreateMission(Mission mission)
{
using (var ctx = new WarframeResDemoContext())
{
ctx.Missions.Add(mission);
ctx.SaveChanges();
}
}
public void UpdateFraction(MissionType type)
{
using (var ctx = new WarframeResDemoContext())
{
ctx.MissionTypes.Attach(type);
ctx.Entry(type).State = EntityState.Modified;
ctx.SaveChanges();
}
}
public void DeleteMission(int missionId)
{
using (var ctx = new WarframeResDemoContext())
{
var mission = ctx.Missions.Find(missionId);
ctx.Missions.Remove(mission);
ctx.SaveChanges();
}
}
public void UpdateMission(Mission mission)
{
using (var ctx = new WarframeResDemoContext())
{
ctx.Missions.Attach(mission);
ctx.Entry(mission).State = EntityState.Modified;
ctx.SaveChanges();
}
}
public void UpdateFraction(Fraction fraction)
{
using (var ctx = new WarframeResDemoContext())
{
ctx.Fractions.Attach(fraction);
ctx.Entry(fraction).State = EntityState.Modified;
ctx.SaveChanges();
}
}
public void DeletePlanet(int planetId)
{
using (var ctx = new WarframeResDemoContext())
{
var planet = ctx.Planets.Find(planetId);
ctx.Planets.Remove(planet);
ctx.SaveChanges();
}
}
public void UpdatePlanet(Planet planet)
{
using (var ctx = new WarframeResDemoContext())
{
ctx.Planets.Attach(planet);
ctx.Entry(planet).State = EntityState.Modified;
ctx.SaveChanges();
}
}
public void DeleteFraction(int fractionId)
{
using (var ctx = new WarframeResDemoContext())
{
var fraction = ctx.Fractions.Find(fractionId);
ctx.Fractions.Remove(fraction);
ctx.SaveChanges();
}
}
public void UpdateResource(Resource resource)
{
using (var ctx = new WarframeResDemoContext())
{
ctx.Resources.Attach(resource);
ctx.Entry(resource).State = EntityState.Modified;
ctx.SaveChanges();
}
}
public void DeleteFraction(int typeId)
{
using (var ctx = new WarframeResDemoContext())
{
var type = ctx.MissionTypes.Find(typeId);
ctx.MissionTypes.Remove(type);
ctx.SaveChanges();
}
}
public void DeleteResource(int resourceId)
{
using (var ctx = new WarframeResDemoContext())
{
var resource = ctx.Resources.Find(resourceId);
ctx.Resources.Remove(resource);
ctx.SaveChanges();
}
}
