public List <pilot> ReadPilots()
{
using (var db = new DbSimaer())
{
return(db.pilot.Include("grade").ToList());
}
}
public attribute Find(int attribute_id)
{
using (var db = new DbSimaer())
{
return(db.attribute.Find(attribute_id));
}
}
public List <action> ReadActions()
{
using (var db = new DbSimaer())
{
return(db.action.ToList());
}
}
public List <system> ReadSystems()
{
using (var db = new DbSimaer())
{
return(db.system.ToList());
}
}
public List <procedure> ReadProcedures()
{
using (var db = new DbSimaer())
{
return(db.procedure.ToList());
}
}
public List <grade> ReadGrades()
{
using (var db = new DbSimaer())
{
return(db.grade.OrderBy(ograde => ograde.grade_id).ToList());
}
}
public action Find(int action_id)
{
using (var db = new DbSimaer())
{
return(db.action.Find(action_id));
}
}
public List <report> ReadReports()
{
using (var db = new DbSimaer())
{
return(db.report.ToList());
}
}
public List <scenario> ReadScenarios()
{
using (var db = new DbSimaer())
{
return(db.scenario.Include("time_day").Include("runway_tol").ToList());
}
}
public List <exercise> ReadExercises()
{
using (var db = new DbSimaer())
{
return(db.exercise.ToList());
}
}
public List <attribute> ReadAttributes()
{
using (var db = new DbSimaer())
{
return(db.attribute.ToList());
}
}
public List <procedure> ReadProceduresBySystemProcType(system i_system, procedure_type i_procedureType)
{
using (var db = new DbSimaer())
{
return(db.procedure.Include("procedure_type").Include("system").Include("action")
.Where(oprocedure => oprocedure.procedure_type_id == i_procedureType.procedure_type_id)
.Where(oprocedure => oprocedure.system_id == i_system.system_id).OrderBy(oprocedure => oprocedure.procedure_id).ToList());
}
}
public bool DeleteExercise(exercise DeleteExercise)
{
using (var db = new DbSimaer())
{
db.exercise.Remove(DeleteExercise);
db.SaveChanges();
return(true);
}
}
public bool CreateExercise(exercise InsertExercise)
{
using (var db = new DbSimaer())
{
db.exercise.Add(InsertExercise);
db.SaveChanges();
return(true);
}
}
public bool DeletePilot(pilot DeletePilot)
{
using (var db = new DbSimaer())
{
//db.pilot.Remove(DeletePilot);
//db.SaveChanges();
return(true);
}
}
public bool UpdateReport(report UpdateReport)
{
using (var db = new DbSimaer())
{
db.report.AddOrUpdate(UpdateReport);
db.SaveChanges();
return(true);
}
}
public bool DeleteReport(report DeleteReport)
{
using (var db = new DbSimaer())
{
db.report.Remove(DeleteReport);
db.SaveChanges();
return(true);
}
}
public bool CreateReport(report InsertReport)
{
using (var db = new DbSimaer())
{
db.report.Add(InsertReport);
db.SaveChanges();
return(true);
}
}
public bool UpdateExercise(exercise UpdateExercise)
{
using (var db = new DbSimaer())
{
db.exercise.AddOrUpdate(UpdateExercise);
db.SaveChanges();
return(true);
}
}
public bool UpdatePilot(pilot UpdatePilot)
{
using (var db = new DbSimaer())
{
db.pilot.AddOrUpdate(UpdatePilot);
db.SaveChanges();
return(true);
}
}
