public List <getQuestList> GetQuest()
{
SQLBaglantisi sQ = new SQLBaglantisi();
MySqlConnection baglanti = sQ.getConStr();
baglanti.Open();
MySqlCommand cmd = new MySqlCommand("CALL getRemindQuests(" + uID + ");", baglanti);
MySqlDataReader myReader = cmd.ExecuteReader();
List <getQuestList> values = new List <getQuestList>();
while (myReader.Read())
{
//listeye sağlanan kelime id'si ve word id'yi ekliyoruz
values.Add(new getQuestList {
m_wordID = myReader.GetInt16(0), m_progressID = myReader.GetInt16(1)
});
//kayıt geldikce soru sayısını arttırıyor
SoruSayisi++;
}
baglanti.Close();
return(values);
}
public bool addToDb()
{
SQLBaglantisi sQ = new SQLBaglantisi();
MySqlConnection baglanti = sQ.getConStr();
baglanti.Open();
string querryString = "CALL ADD_WORD('" + YeniKelime.Kelime + "'," + YeniKelime.catID + ",'" + YeniKelime.Turkcesi + "','" + YeniKelime.exSent + "','" + YeniKelime.dataPath + "')";
MySqlCommand cmd = new MySqlCommand(querryString, baglanti);
cmd.ExecuteScalar();
baglanti.Close();
return(true);
}
public int Data(string word)
{
SQLBaglantisi sQ = new SQLBaglantisi();
MySqlConnection baglanti = sQ.getConStr();
baglanti.Open();
string querryString = "select id from dbenglish.users where Name='" + word + "';";
MySqlCommand cmd = new MySqlCommand(querryString, baglanti);
cmd.ExecuteScalar();
MySqlDataReader myReader = cmd.ExecuteReader();
int data = 0;
while (myReader.Read())
{
data = (myReader.GetInt16(0));
}
baglanti.Close();
return(data);
}
