public List <Earned_CE_Table> earnedList(int caseID, int userID) { List <Earned_CE_Table> earned = new List <Earned_CE_Table>(); using (var db = new ModelDbContext()) { earned = db.EarnedCE .Where(x => x.Case_Id == caseID && x.User_Id == userID) .ToList(); } return(earned); }
public List <Case_Table> activityData(int caseID) { List <Case_Table> activity = new List <Case_Table>(); using (var db = new ModelDbContext()) { activity = db.Cases .Where(x => x.Case_Id == caseID) .ToList(); } return(activity); }
public List <int?> accountPrePostHistory(int?userID, int prePostNumber) { List <int?> history = new List <int?>(); using (var db = new ModelDbContext()) { history = db.DataCollectionTable.Where(x => x.User_Id == userID && x.Pre_Test == prePostNumber ).Select(x => x.Case_Id).Distinct().ToList(); } //history = history.Where(x => x.Value == 28).ToList(); return(history); }
public bool IsEmail(string email) { bool checkForExistingEmail = false; using (var db = new ModelDbContext()) { checkForExistingEmail = db.Users .Where(x => x.Email == email) .Select(x => x.User_Id) .Any(); } return(checkForExistingEmail); }
public bool checkIfUniqueIDExists(int uID) { bool ifExists = false; using (var db = new ModelDbContext()) { ifExists = db.Users .Where(X => X.UId == uID) .Select(x => x.UId) .Any(); } return(ifExists); }
public List <int?> accountEvaluationHistory(int?userID, int caseID) { List <int?> history = new List <int?>(); using (var db = new ModelDbContext()) { history = db.EvalCollector .Where(x => x.EvalId == caseID && x.UserId == userID) .Select(x => x.EvalId) .Distinct() .ToList(); } return(history); }
public int countPostAttempts(int caseID, int userID) { int attemptCount = 0; using (var db = new ModelDbContext()) { attemptCount = db.DataCollectionTable .Where(x => x.User_Id == userID && x.Case_Id == caseID && x.Pre_Test == 0) .Select(x => x.Attempt) .Distinct() .Count(); } return(attemptCount); }