public static void GetListenPart2QuestionListById_full(ObservableCollection <ListeningPart2Question> ListeningPart2QuestionList, int turnNumber, string server)
{
dbLesson = new dbLesson(server);
DataTable temp = dbLesson.GetListenPart2QuestionListById_full(turnNumber);
foreach (DataRow i in temp.Rows)
{
ListeningPart2QuestionList.Add(new ListeningPart2Question {
Before = i["beforeText"].ToString(), After = i["afterText"].ToString(), Value = i["Value"].ToString()
});
}
}
public static void GetSentenceList(ObservableCollection <Sentence> SentenceList, int turnNumber, string server)
{
dbLesson = new dbLesson(server);
DataTable temp = dbLesson.GetSentenceListByLessonId(turnNumber);
foreach (DataRow i in temp.Rows)
{
SentenceList.Add(new Sentence {
Index = Int32.Parse(i["turnNumber"].ToString()) - 1, KeySentence = i["keySentence"].ToString(), VieMeanOfSentence = i["vieMeanOfSentence"].ToString(), HowToRead = i["howToRead"].ToString()
});
}
}
public static void GetKeyWordList(ObservableCollection <KeyWord> KeyWordList, int turnNumber, string server)
{
dbLesson = new dbLesson(server);
DataTable temp = dbLesson.GetKeyWordsLessonId(turnNumber);
foreach (DataRow row in temp.Rows)
{
KeyWordList.Add(new KeyWord
{
Index = Int32.Parse(row["turnNumber"].ToString()) - 1,
Word = row["keyWord"].ToString(),
VieWord = row["vieWord"].ToString(),
HowToReadWord = row["howToReadWord"].ToString(),
TypeOfWord = row["typeOfWord"].ToString(),
ExSentence = row["exSentence"].ToString(),
PictureOfWord = (byte[])row["pictureOfWord"]
});
}
}
public static void GetGrammarQuestionById_full(ObservableCollection <GrammarQuestion> GrammarQuestionList, int turnNumber, string server)
{
dbLesson = new dbLesson(server);
DataTable temp = dbLesson.GetGrammarQuestionById_full(turnNumber);
foreach (DataRow row in temp.Rows)
{
switch (row["rightAns"].ToString())
{
case "A":
GrammarQuestionList.Add(new GrammarQuestion
{
ChoseA = true,
ChoseB = false,
ChoseC = false,
ChoseD = false,
KeyWord = row["quesSentence"].ToString(),
AnsA = row["ansA"].ToString(),
AnsB = row["ansB"].ToString(),
AnsC = row["ansC"].ToString(),
AnsD = row["ansD"].ToString(),
RightAns = 1
});
break;
case "B":
GrammarQuestionList.Add(new GrammarQuestion
{
ChoseA = false,
ChoseB = true,
ChoseC = false,
ChoseD = false,
KeyWord = row["quesSentence"].ToString(),
AnsA = row["ansA"].ToString(),
AnsB = row["ansB"].ToString(),
AnsC = row["ansC"].ToString(),
AnsD = row["ansD"].ToString(),
RightAns = 2
});
break;
case "C":
GrammarQuestionList.Add(new GrammarQuestion
{
ChoseA = false,
ChoseB = false,
ChoseC = true,
ChoseD = false,
KeyWord = row["quesSentence"].ToString(),
AnsA = row["ansA"].ToString(),
AnsB = row["ansB"].ToString(),
AnsC = row["ansC"].ToString(),
AnsD = row["ansD"].ToString(),
RightAns = 3
});
break;
case "D":
GrammarQuestionList.Add(new GrammarQuestion
{
ChoseA = false,
ChoseB = false,
ChoseC = false,
ChoseD = true,
KeyWord = row["quesSentence"].ToString(),
AnsA = row["ansA"].ToString(),
AnsB = row["ansB"].ToString(),
AnsC = row["ansC"].ToString(),
AnsD = row["ansD"].ToString(),
RightAns = 4
});
break;
default:
break;
}
}
}
public static void GetListenQuestionByLessonId(ObservableCollection <ListeningQuestion> ListenQuestionList, int turnNumber, string server)
{
dbLesson = new dbLesson(server);
DataTable temp = dbLesson.GetListenQuestionByLessonId(turnNumber);
foreach (DataRow row in temp.Rows)
{
switch (row["rightAns"].ToString())
{
case "A":
ListenQuestionList.Add(new ListeningQuestion
{
ChoseA = false,
ChoseB = false,
ChoseC = false,
ChoseD = false,
QuestionContent = row["quesSentence"].ToString(),
AnsA = row["ansA"].ToString(),
AnsB = row["ansB"].ToString(),
AnsC = row["ansC"].ToString(),
AnsD = row["ansD"].ToString(),
RightAns = 1
});
break;
case "B":
ListenQuestionList.Add(new ListeningQuestion
{
ChoseA = false,
ChoseB = false,
ChoseC = false,
ChoseD = false,
QuestionContent = row["quesSentence"].ToString(),
AnsA = row["ansA"].ToString(),
AnsB = row["ansB"].ToString(),
AnsC = row["ansC"].ToString(),
AnsD = row["ansD"].ToString(),
RightAns = 2
});
break;
case "C":
ListenQuestionList.Add(new ListeningQuestion
{
ChoseA = false,
ChoseB = false,
ChoseC = false,
ChoseD = false,
QuestionContent = row["quesSentence"].ToString(),
AnsA = row["ansA"].ToString(),
AnsB = row["ansB"].ToString(),
AnsC = row["ansC"].ToString(),
AnsD = row["ansD"].ToString(),
RightAns = 3
});
break;
case "D":
ListenQuestionList.Add(new ListeningQuestion
{
ChoseA = false,
ChoseB = false,
ChoseC = false,
ChoseD = false,
QuestionContent = row["quesSentence"].ToString(),
AnsA = row["ansA"].ToString(),
AnsB = row["ansB"].ToString(),
AnsC = row["ansC"].ToString(),
AnsD = row["ansD"].ToString(),
RightAns = 4
});
break;
default:
break;
}
}
}
public static void GetSentenceExListByLessonId(ObservableCollection <SentenceEx> SentenceExList, int turnNumber, string server)
{
dbLesson = new dbLesson(server);
DataTable temp = dbLesson.GetSentenceExListByLessonId(turnNumber);
foreach (DataRow row in temp.Rows)
{
switch (row["rightAns"].ToString())
{
case "A":
SentenceExList.Add(new SentenceEx
{
ChoseA = false,
ChoseB = false,
ChoseC = false,
ChoseD = false,
KeyWord = row["keySentence"].ToString(),
AnsA = row["ansA"].ToString(),
AnsB = row["ansB"].ToString(),
AnsC = row["ansC"].ToString(),
AnsD = row["ansD"].ToString(),
RightAns = 1
});
break;
case "B":
SentenceExList.Add(new SentenceEx
{
ChoseA = false,
ChoseB = false,
ChoseC = false,
ChoseD = false,
KeyWord = row["keySentence"].ToString(),
AnsA = row["ansA"].ToString(),
AnsB = row["ansB"].ToString(),
AnsC = row["ansC"].ToString(),
AnsD = row["ansD"].ToString(),
RightAns = 2
});
break;
case "C":
SentenceExList.Add(new SentenceEx
{
ChoseA = false,
ChoseB = false,
ChoseC = false,
ChoseD = false,
KeyWord = row["keySentence"].ToString(),
AnsA = row["ansA"].ToString(),
AnsB = row["ansB"].ToString(),
AnsC = row["ansC"].ToString(),
AnsD = row["ansD"].ToString(),
RightAns = 3
});
break;
case "D":
SentenceExList.Add(new SentenceEx
{
ChoseA = false,
ChoseB = false,
ChoseC = false,
ChoseD = false,
KeyWord = row["keySentence"].ToString(),
AnsA = row["ansA"].ToString(),
AnsB = row["ansB"].ToString(),
AnsC = row["ansC"].ToString(),
AnsD = row["ansD"].ToString(),
RightAns = 4
});
break;
default:
break;
}
}
}
