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); } }