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); }