public bool studentHasActivities(string phoneNumber, long roomId)
{
List <AnswerByPhoneData> answersData = AnswersByPhone.Where(record => record.Phone == phoneNumber && record.RoomID == roomId).ToList();
if (answersData.Count != 0)
{
return(true);
}
return(false);
}
public void DeleteAllActivitiesOfStudent(string phoneNumber, long roomID)
{
List <AnswerByPhoneData> answersData = AnswersByPhone.Where(record => record.Phone == phoneNumber && record.RoomID == roomID).ToList();
foreach (AnswerByPhoneData answer in answersData)
{
answer.RoomID = -1;
}
SaveChanges();
}
public void deleteAnswers(ICollection <AnswerByPhoneData> answersData)
{
if (answersData.Count == 0)
{
return;
}
AnswersByPhone.Remove(answersData.First());
deleteAnswers(answersData);
}
public AnswerByPhoneData getAnswerByPhoneAndActivityID(long ActivityID, string StudentPhone, long RoomId)
{
List <AnswerByPhoneData> allAnswersByPhone = AnswersByPhone.ToList();
foreach (AnswerByPhoneData sData in allAnswersByPhone)
{
if (sData.ActivityId == ActivityID && sData.Phone == StudentPhone && sData.RoomID == RoomId)
{
return(sData);
}
}
return(null);
}
public void clearAllTables()
{
Groups.RemoveRange(Groups);
AnswersByPhone.RemoveRange(AnswersByPhone);
//Rooms.RemoveRange(Rooms);
//Teachers.RemoveRange(Teachers);
MeasureInstructionsData.RemoveRange(MeasureInstructionsData);
OneMeasuresEvalData.RemoveRange(OneMeasuresEvalData);
OneMeasuresByGroupId.RemoveRange(OneMeasuresByGroupId);
MeasurementsByGroupId.RemoveRange(MeasurementsByGroupId);
Measurements.RemoveRange(Measurements);
ActiveExperiments.RemoveRange(ActiveExperiments);
Experiments.RemoveRange(Experiments);
Activities.RemoveRange(Activities);
ActivityLogs.RemoveRange(ActivityLogs);
//Students.RemoveRange(Students);
SaveChanges();
}
public List <ActivityData> getActivitiesByStudentPhone(string studentPhone, long RoomID)
{
List <ActivityData> lstData = new List <ActivityData>();
List <AnswerByPhoneData> allAnswersByPhone = AnswersByPhone.ToList();
// Add all the questions activities of a student
foreach (AnswerByPhoneData sData in allAnswersByPhone)
{
if (sData.Phone == studentPhone && sData.RoomID == RoomID)
{
ActivityData ad = getActivity(sData.ActivityId);
if (ad.expID == -1)
{
lstData.Add(ad);
}
}
}
// TODO Add all the experiments activities of a student
return(lstData);
}