//kategoriye göre kelime alıyor public List <newWord> getWords(int catID) { List <newWord> Kelimeler = new List <newWord>(); baglanti.Open(); string querryString = "Call GET_WORDS_BY_CATEGORY(" + catID + ")"; MySqlCommand cmd = new MySqlCommand(querryString, baglanti); cmd.ExecuteScalar(); MySqlDataReader myReader = cmd.ExecuteReader(); while (myReader.Read()) { newWord nW = new newWord(); nW.WordID = myReader.GetInt16(0); nW.Kelime = myReader.GetString(1); nW.catID = myReader.GetInt16(2); nW.Turkcesi = myReader.GetString(3); nW.exSent = myReader.GetString(4); nW.dataPath = myReader.GetString(5); Kelimeler.Add(nW); } baglanti.Close(); return(Kelimeler); }
//sorulacak sorunun bilgilerini alıyor public newWord GetFromDb(int wordID) { newWord nW = new newWord(); baglanti.Open(); try { string querryString = "CALL GET_WORD_BY_ID(" + wordID.ToString() + ");"; MySqlCommand cmd = new MySqlCommand(querryString, baglanti); MySqlDataReader myReader = cmd.ExecuteReader(); while (myReader.Read()) { nW.WordID = (myReader.GetInt16(0)); nW.Kelime = (myReader.GetString(1)); nW.catID = (myReader.GetInt16(2)); nW.Turkcesi = (myReader.GetString(3)); nW.exSent = (myReader.GetString(4)); nW.dataPath = (myReader.GetString(5)); } baglanti.Close(); } catch { System.Windows.Forms.MessageBox.Show("Veritabanı hatası..!"); } return(nW); }
//öğrenmek için yeni kelime oluşturuyor public newWord getWord() { baglanti.Open(); string querryString = "CALL generateWord(" + userID.ToString() + ");"; MySqlCommand cmd = new MySqlCommand(querryString, baglanti); cmd.ExecuteScalar(); newWord nW = new newWord(); MySqlDataReader myReader = cmd.ExecuteReader(); while (myReader.Read()) { nW.WordID = (myReader.GetInt16(0)); nW.Kelime = (myReader.GetString(1)); nW.catID = (myReader.GetInt16(2)); nW.Turkcesi = (myReader.GetString(3)); nW.exSent = (myReader.GetString(4)); nW.dataPath = (myReader.GetString(5)); } baglanti.Close(); return(nW); }
private void btnAddWord_Click(object sender, EventArgs e) { newWord nW = new newWord(); nW.Kelime = txtNewWord.Text; nW.Turkcesi = txtNewToTurkish.Text; nW.exSent = txtExmSentence.Text; nW.dataPath = txtNewDataPath.Text; nW.catID = cmbCategories.SelectedIndex + 1; addWord aW = new addWord(nW); aW.addToDb(); g_word = txtNewWord.Text; }
// dogru cevabın uzantısını string olarak donduren bir dizi public string DogruCevap() { baglanti.Open(); string querryString = "CALL ShowTrueDataPath(" + m_wordID.ToString() + ");"; MySqlCommand cmd = new MySqlCommand(querryString, baglanti); cmd.ExecuteScalar(); newWord nW = new newWord(); MySqlDataReader myReader = cmd.ExecuteReader(); while (myReader.Read()) { m_CevapDataPath = (myReader.GetString(0)); } baglanti.Close(); return(m_CevapDataPath); }
//yanlış cevapları tutan bir dizi public string[] getFalseAnswers() { string[] falseArray = new string[3]; baglanti.Open(); string querryString = "CALL getImageQuest(" + m_wordID.ToString() + ");"; MySqlCommand cmd = new MySqlCommand(querryString, baglanti); cmd.ExecuteScalar(); newWord nW = new newWord(); MySqlDataReader myReader = cmd.ExecuteReader(); int i = 0; while (myReader.Read()) { falseArray[i++] = myReader.GetString(0); } baglanti.Close(); return(falseArray); }
public addWord(newWord nW) { YeniKelime = nW; }
void ResimSorulariBindlama() { newWord nW = new newWord(); learnNewWord lW = new learnNewWord(userID); nW = lW.GetFromDb(g_Sorular[y, 0]); txtImageQuest.Text = "Hangisi '" + nW.Kelime + "' ?"; txtQuest.Text = "'" + nW.Kelime + "' Türkçe karşılığını seçin.."; string ResimDogruCevap = gImageQuests.DogruCevap(); Random rastgele = new Random(); int sayi = rastgele.Next(4); //rastgele sayı üretip fotoğrafı bindledik g_imageTrueNumber = sayi; if (sayi == 0) { try { var request = WebRequest.Create(ResimDogruCevap); using (var response = request.GetResponse()) using (var stream = response.GetResponseStream()) { pBAnswerOne.ImageLocation = ResimDogruCevap; pBAnswerOne.Image = Bitmap.FromStream(stream); } } catch { pBAnswerOne.Image = Image.FromFile("C:\\notFound.png"); } } else if (sayi == 1) { try { var request = WebRequest.Create(ResimDogruCevap); using (var response = request.GetResponse()) using (var stream = response.GetResponseStream()) { pBAnswerTwo.Image = Bitmap.FromStream(stream); pBAnswerTwo.ImageLocation = ResimDogruCevap; } } catch { pBAnswerTwo.Image = Image.FromFile("C:\\notFound.png"); } } else if (sayi == 2) { try { var request = WebRequest.Create(ResimDogruCevap); using (var response = request.GetResponse()) using (var stream = response.GetResponseStream()) { pbAnswerThree.ImageLocation = ResimDogruCevap; pbAnswerThree.Image = Bitmap.FromStream(stream); } } catch { pbAnswerThree.Image = Image.FromFile("C:\\notFound.png"); } } else if (sayi == 3) { try { var request = WebRequest.Create(ResimDogruCevap); using (var response = request.GetResponse()) using (var stream = response.GetResponseStream()) { pbAnswerFour.ImageLocation = ResimDogruCevap; pbAnswerFour.Image = Bitmap.FromStream(stream); } } catch { pbAnswerFour.Image = Image.FromFile("C:\\notFound.png"); } } else { MessageBox.Show("Hata oluştu..!"); } }