public bool RunSimpleQuery() { exam_auditEntities examAuditDb = new exam_auditEntities(); try { var recCount = (from rec in examAuditDb.exam_report select rec).ToList(); return(true); } catch (Exception ex) { Message = "Exception in running a simple record count query. " + ex.Message; return(false); } }
public bool CheckIfConnectionIsGood() { exam_auditEntities examAuditDb = new exam_auditEntities(); try { examAuditDb.Database.Connection.Open(); examAuditDb.Database.Connection.Close(); return(true); } catch (Exception ex) { Message = "Exception in opening a connection to the exam_audit database. " + ex.Message; return(false); } }
public int NumberOfNewTestResults(DateTime lastRunDateTime) { exam_auditEntities examAuditDb = new exam_auditEntities(); try { DateTime currentDateTime = DateTime.UtcNow; var records = (from rec in examAuditDb.exam_report where rec.status == "received" && (rec.created_at >= lastRunDateTime && rec.created_at <= currentDateTime) select rec).ToList(); return(records.Count); } catch (Exception ex) { Message = "Exception in finding the number of new test results. " + ex.Message; return(-1); } }