// get entries for VSA dropdown public static List<VSAs> GetVSAs() { using (emsDBDataContext db = new emsDBDataContext()) { var q = from c in db.VSAs where c.Active == true select c; return q.ToList(); } }
//get entries for Symptom Relief dropdown public static List<SymptomReliefs> GetSymptomReliefs() { using (emsDBDataContext db = new emsDBDataContext()) { var q = from c in db.SymptomReliefs where c.Active == true select c; return q.ToList(); } }
// get entries for IV Attempts dropdown public static List<IVAttempts> GetIVAttempts() { using (emsDBDataContext db = new emsDBDataContext()) { var q = from c in db.IVAttempts where c.Active == true select c; return q.ToList(); } }
public static Entry GetEntry(int ID) { using (emsDBDataContext db = new emsDBDataContext()) { var q = (from e in db.Entries where e.ID == ID select e).SingleOrDefault(); return q; } }
public static ReportResults GetSuddenCariacArrest(DateTime start, DateTime end) { using (emsDBDataContext db = new emsDBDataContext()) { int limit = 6 * 60; // in seconds ReportResults results = new ReportResults(); results.NumberOnTime = db.EntryDetails.Where(c => c.Date >= start && c.Date <= end && c.CTAS_raw == 1 && c.VSA_raw > 1 && c.TDiff <= limit).Count(); results.NumberOfCalls = db.EntryDetails.Where(c => c.Date >= start && c.Date <= end && c.CTAS_raw == 1 && c.VSA_raw > 1).Count(); return results; } }
public static ReportResults GetCTAS(int CTAS, int minutes, DateTime start, DateTime end) { using (emsDBDataContext db = new emsDBDataContext()) { int limit = minutes * 60; // in seconds ReportResults results = new ReportResults(); results.NumberOnTime = db.EntryDetails.Where(c => c.Date >= start && c.Date <= end && c.CTAS_raw == CTAS && c.TDiff <= limit).Count(); results.NumberOfCalls = db.EntryDetails.Where(c => c.Date >= start && c.Date <= end && c.CTAS_raw == CTAS).Count(); return results; } }