//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..!");
}
}
