private void GetWordsFromDb(List <string> lstSelectedLetters, List <DiffLevel> lstSelectedDiffs)
{
lstWords.Clear();
DAWords dawords = new DAWords();
foreach (DiffLevel diffLvl in lstSelectedDiffs)
{
foreach (string lettedr in lstSelectedLetters)
{
DataTable dtWords = dawords.GetWordsByDiffAndLetter(lettedr, diffLvl.ID);
foreach (DataRow dr in dtWords.Rows)
{
int temp;
int.TryParse(dr["id"].ToString(), out temp);
Word w = new Word(temp, dr["word"].ToString(), DiffLevel.GetDifflvlByID(dr["diffID"].ToString()), dr["meaning"].ToString());
lstWords.Add(w);
}
}
}
// lstWords = SuffleList(lstWords);
if (lstWords.Count > 0)
{
frmQuiz quiz = new frmQuiz(lstWords, this);
Hide();
quiz.Show();
}
else
{
MessageBox.Show("אין מילים תחת הנתונים המבוקשים");
}
}
public void CmbFill()
{
try
{
List <string> lstStr = new List <string>();
DAWords daWords = new DAWords();
DataTable dt = daWords.GetAllLettersLst();
lstStr.Add("בחר אותיות לבחינה");
foreach (DataRow dr in dt.Rows)
{
lstStr.Add(dr["startingLet"].ToString());
}
cmbLetters.ItemsSource = lstStr;
// cmbLetters.SelectedIndex = 0;
//*****************Difflvl**************************
List <string> lstDif = new List <string>();
DADiffLevel daDiff = new DADiffLevel();
DataTable dtdiff = daDiff.GetDiffLevelData();
cmbDiffLvl.ItemsSource = DiffLevel.GetLstFromDb();
}
catch (Exception ex)
{
Globals.GetExData("CmbFill", "Frmmain", ex);
}
}
public static List <Word> GetLstFromDb()
{
try
{
List <Word> Reslst = new List <Word>();
DAWords daWords = new DAWords();
DataTable dt;
dt = daWords.GetWordsData();
foreach (DataRow dr in dt.Rows)
{
int tempid = 0;
int.TryParse(dr["id"].ToString(), out tempid);
DiffLevel df = DiffLevel.GetDifflvlByID(dr["diffID"].ToString());
Reslst.Add(new Word(tempid, dr["word"].ToString(), df, dr["meaning"].ToString()));
}
return(Reslst);
}
catch (Exception ex)
{
Globals.GetExData("GetLstFromDb", "word", ex);
return(null);
}
}
private void SaveMeaning()
{
if (GlobSelectedWord != null)
{
DAWords dawords = new DAWords();
dawords.UpdateMeaningOnly(txtMeaningUpdate.Text, (GlobSelectedWord.ID));
FillCmbData();
txtMeaningUpdate.Text = "";
}
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
DAWords dawords = new DAWords();
if (GlobSelectedWord != null)
{
txtMeaningUpdate.Text = "";
dawords.DeleteWordbyid(GlobSelectedWord.ID);
FillCmbData();
}
}
public bool IsRight(int WordID)
{
bool res = false;
DAWords dawords = new DAWords();
DataTable dt = dawords.GetMeaningByWordID(WordID);
if (dt.Rows[0]["meaning"].ToString() == txtMeaning.Text)
{
res = true;
}
return(res);
}
private void SaveWord()
{
if (GlobSelectedWord != null)
{
if (cmbwords.Text != "")
{
DAWords dawords = new DAWords();
dawords.UpdateTheWordOnly(cmbwords.Text, (GlobSelectedWord.ID));
FillCmbData();
}
else
{
MessageBox.Show("תחת !! אסור ללחוץ אנטר שהשורה ריקה !");
}
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if ((txtWord.Text != "") && (txtMeaning.Text != "") && (cmbDiff.SelectedIndex != 0))
{
DAWords dawords = new DAWords();
dawords.InsertWord(txtWord.Text, txtMeaning.Text, txtWord.Text.ToLower()[0].ToString(), diffGlob.ID);
txtMeaning.Clear();
txtWord.Clear();
txtWord.Focus();
// cmbDiff.SelectedIndex = 0;
FillCmbData();
}
else
{
MessageBox.Show("אחד מהנתונים לא תקין אנא בדוק");
}
}
