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