public static DataTable TumunuGetirDataTable() { SQLiteDataAdapter da = new SQLiteDataAdapter("select * from ARIZA", DBCon.BaglantiYap()); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count != 0) { return(dt); } else { return(null); } }
public static DataTable KayitKumesiGetir(string sql) { SQLiteDataAdapter da = new SQLiteDataAdapter(sql, DBCon.BaglantiYap()); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count != 0) { return(dt); } else { return(null); } }
public static object TekDegerGetir(string sql) { SQLiteDataAdapter da = new SQLiteDataAdapter(sql, DBCon.BaglantiYap()); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count != 0) { return((object)dt.Rows[0][0]); } else { return(null); } }
public static int KasaSay(string sql) { SQLiteDataAdapter da = new SQLiteDataAdapter(sql, DBCon.BaglantiYap()); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count != 0) { int deger = 0; for (int i = 0; i < dt.Rows.Count; i++) { deger += Convert.ToInt32(dt.Rows[i][0]); } return(deger); } else { return(0); } }
public static ARIZA IdyeGoreARIZAGetir(int ID) { SQLiteDataAdapter da = new SQLiteDataAdapter("select * from ARIZA where ID=@ID", DBCon.BaglantiYap()); da.SelectCommand.Parameters.AddWithValue("@ID", ID); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count != 0) { ARIZA a = new ARIZA(); a.ID = Convert.ToInt32(dt.Rows[0]["ID"]); a.M_ID = Convert.ToInt32(dt.Rows[0]["M_ID"]); a.A_ID = Convert.ToInt32(dt.Rows[0]["A_ID"]); a.TAR = Convert.ToString(dt.Rows[0]["TAR"]); a.ONAY = Convert.ToString(dt.Rows[0]["ONAY"]); a.MSJ = Convert.ToString(dt.Rows[0]["MSJ"]); return(a); } else { return(null); } }
public static BASVURU IdyeGoreBASVURUGetir(int ID) { SQLiteDataAdapter da = new SQLiteDataAdapter("select * from BASVURU where ID=@ID", DBCon.BaglantiYap()); da.SelectCommand.Parameters.AddWithValue("@ID", ID); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count != 0) { BASVURU b = new BASVURU(); b.ID = Convert.ToInt32(dt.Rows[0]["ID"]); b.AD = Convert.ToString(dt.Rows[0]["AD"]); b.ADRES = Convert.ToString(dt.Rows[0]["ADRES"]); b.CEP_TEL = Convert.ToString(dt.Rows[0]["CEP_TEL"]); b.TEL = Convert.ToString(dt.Rows[0]["TEL"]); b.TARIFE = Convert.ToString(dt.Rows[0]["TARIFE"]); b.A_ID = Convert.ToInt32(dt.Rows[0]["A_ID"]); b.TAR = Convert.ToString(dt.Rows[0]["TAR"]); b.ONAY = Convert.ToString(dt.Rows[0]["ONAY"]); return(b); } else { return(null); } }
public static KASA IdyeGoreKASAGetir(int ID) { SQLiteDataAdapter da = new SQLiteDataAdapter("select * from KASA where ID=@ID", DBCon.BaglantiYap()); da.SelectCommand.Parameters.AddWithValue("@ID", ID); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count != 0) { KASA k = new KASA(); k.ID = Convert.ToInt32(dt.Rows[0]["ID"]); k.TUR = Convert.ToString(dt.Rows[0]["TUR"]); k.MIKTAR = Convert.ToInt32(dt.Rows[0]["MIKTAR"]); k.ACIKLA = Convert.ToString(dt.Rows[0]["ACIKLA"]); k.TAR = Convert.ToString(dt.Rows[0]["TAR"]); k.A_ID = Convert.ToInt32(dt.Rows[0]["A_ID"]); return(k); } else { return(null); } }
public static ADMIN IdyeGoreADMINGetir(int ID) { SQLiteDataAdapter da = new SQLiteDataAdapter("select * from ADMIN where ID=@ID", DBCon.BaglantiYap()); da.SelectCommand.Parameters.AddWithValue("@ID", ID); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count != 0) { ADMIN a = new ADMIN(); a.ID = Convert.ToInt32(dt.Rows[0]["ID"]); a.K_AD = Convert.ToString(dt.Rows[0]["K_AD"]); a.SFR = Convert.ToString(dt.Rows[0]["SFR"]); a.MAIL = Convert.ToString(dt.Rows[0]["MAIL"]); a.YET = Convert.ToString(dt.Rows[0]["YET"]); a.SON_GRS = Convert.ToString(dt.Rows[0]["SON_GRS"]); return(a); } else { return(null); } }
public static MUSTERI IdyeGoreMUSTERIGetir(int ID) { SQLiteDataAdapter da = new SQLiteDataAdapter("select * from MUSTERI where ID=@ID", DBCon.BaglantiYap()); da.SelectCommand.Parameters.AddWithValue("@ID", ID); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count != 0) { MUSTERI m = new MUSTERI(); m.ID = Convert.ToInt32(dt.Rows[0]["ID"]); m.K_AD = Convert.ToString(dt.Rows[0]["K_AD"]); m.AD = Convert.ToString(dt.Rows[0]["AD"]); m.ADRES = Convert.ToString(dt.Rows[0]["ADRES"]); m.CEP_TEL = Convert.ToString(dt.Rows[0]["CEP_TEL"]); m.TEL = Convert.ToString(dt.Rows[0]["TEL"]); return(m); } else { return(null); } }