public static int kelimeEkle(Kelime kelime)
{
int eklenmeDurumu = -1; // -1 basarisiz, 0 mevcut, 1 basarili
bool kelimeMevcut = kelimeMevcutMu(kelime);
if (kelimeMevcut)
{
eklenmeDurumu = 0;
}
else
{
DB_Main.dbBaglan();
cmd.Connection = DB_Main.con;
cmd.CommandText = "INSERT INTO kelimeler(tr, ing, tur, trCumle, ingCumle) " +
"VALUES ('" + kelime.tr + "','" +
kelime.ing + "','" + kelime.tur + "','" +
kelime.trCumle + "','" + kelime.ingCumle + "')";
int Count = Convert.ToInt32(cmd.ExecuteScalar());
if (Count == 0)
{
eklenmeDurumu = 1;
}
DB_Main.dbBaglantiKes();
}
return(eklenmeDurumu);
}
public static Kelime[] kelimeBelirle()
{
DB_Main.dbBaglan();
cmd.Connection = DB_Main.con;
int[] belirlenenIdler = randomIdBelirle();
Kelime[] kelimeler = new Kelime[Consts.OGRENILECEK_KELIME_SAYISI + DB_Main.prSorulacakKelimeSayisiBelirle()];
for (int i = 0; i < Consts.OGRENILECEK_KELIME_SAYISI; i++)
{
cmd.CommandText = "SELECT * FROM kelimeler WHERE id = " + belirlenenIdler[i];
reader = cmd.ExecuteReader();
while (reader.Read())
{
Kelime kelime = new Kelime();
kelime.id = Convert.ToInt32(reader["id"]);
kelime.tr = reader["tr"].ToString();
kelime.ing = reader["ing"].ToString();
kelime.tur = reader["tur"].ToString();
kelime.trCumle = reader["trCumle"].ToString();
kelime.ingCumle = reader["ingCumle"].ToString();
kelimeler[i] = kelime;
}
reader.Close();
}
DB_Main.dbBaglantiKes();
return(kelimeler);
}
public static bool kelimeMevcutMu(Kelime kelime)
{
bool mevcutMu = false;
DB_Main.dbBaglan();
cmd.Connection = DB_Main.con;
cmd.CommandText = "SELECT * FROM kelimeler " +
"WHERE tr = '" + kelime.tr + "'";
int Count = Convert.ToInt32(cmd.ExecuteScalar());
if (Count != 0)
{
mevcutMu = true;
}
DB_Main.dbBaglantiKes();
return(mevcutMu);
}
public static Kelime kelimeCek(int kelimeId)
{
DB_Main.dbBaglan();
cmd.Connection = DB_Main.con;
cmd.CommandText = "SELECT * FROM kelimeler WHERE id = " + kelimeId;
reader = cmd.ExecuteReader();
Kelime kelime = new Kelime();
while (reader.Read())
{
kelime.id = Convert.ToInt32(reader["id"]);
kelime.tr = reader["tr"].ToString();
kelime.ing = reader["ing"].ToString();
kelime.tur = reader["tur"].ToString();
kelime.trCumle = reader["trCumle"].ToString();
kelime.ingCumle = reader["ingCumle"].ToString();
}
reader.Close();
DB_Main.dbBaglantiKes();
return(kelime);
}
