public List <Araba> Select() { List <Araba> list = new List <Araba>(); SQLiteCommand command = new SQLiteCommand { CommandText = "SELECT * FROM araba", }; DataTable dt = Utilty.RunDataReader(command); for (int i = 0; i < dt.Rows.Count; i++) { var row = dt.Rows[i]; int insanId = -1; if (row["insanId"] != DBNull.Value) { insanId = Convert.ToInt32(dt.Rows[i]["insanId"]); } list.Add( new Araba { insanId = Convert.ToInt32(dt.Rows[i]["id"]), InsanId = insanId, //Model = dt.Rows[i]["model"].ToString(), //Tip = dt.Rows[i]["tip"].ToString(), Plaka = dt.Rows[i]["plaka"].ToString(), } ); } return(list); }
public List <ArabaModel> Select() { List <ArabaModel> list = new List <ArabaModel>(); SQLiteCommand command = new SQLiteCommand { CommandText = "SELECT * FROM arac_modelleri", }; DataTable dt = Utilty.RunDataReader(command); for (int i = 0; i < dt.Rows.Count; i++) { list.Add( new ArabaModel { Id = Convert.ToInt32(dt.Rows[i]["id"]), Ad = dt.Rows[i]["ad"].ToString() } ); } return(list); }
public List <Musteri> Select() { List <Musteri> list = new List <Musteri>(); SQLiteCommand command = new SQLiteCommand { CommandText = "SELECT * FROM insan ", }; DataTable dt = Utilty.RunDataReader(command); for (int i = 0; i < dt.Rows.Count; i++) { list.Add( new Musteri { Id = Convert.ToInt32(dt.Rows[i]["id"]), isim = dt.Rows[i]["isim"].ToString(), telefon = Convert.ToInt32(dt.Rows[i]["telefon"]) } ); } return(list); }
public List <HizmetTip> Select() { List <HizmetTip> list = new List <HizmetTip>(); SQLiteCommand command = new SQLiteCommand { CommandText = "SELECT * FROM hizmet_tipi", }; DataTable dt = Utilty.RunDataReader(command); for (int i = 0; i < dt.Rows.Count; i++) { list.Add( new HizmetTip { Id = Convert.ToInt32(dt.Rows[i]["id"]), hizmetAdi = dt.Rows[i]["hizmetAdi"].ToString(), Ucret = Convert.ToInt32(dt.Rows[i]["ucret"]) } ); } return(list); }
public List <Admin> Select() { List <Admin> list = new List <Admin>(); SQLiteCommand command = new SQLiteCommand { CommandText = "SELECT * FROM admin", }; DataTable dt = Utilty.RunDataReader(command); for (int i = 0; i < dt.Rows.Count; i++) { list.Add( new Admin { Id = Convert.ToInt32(dt.Rows[i]["Id"]), Email = dt.Rows[i]["Email"].ToString(), Password = dt.Rows[i]["Password"].ToString() } ); } return(list); }
public List <Hizmet> Select() { List <Hizmet> list = new List <Hizmet>(); SQLiteCommand command = new SQLiteCommand { CommandText = @"SELECT h.*, am.ad as arabaAdi, ht.hizmetadi as hizmetAdi, i.isim as musteriAdi FROM hizmetler h Left Join arac_modelleri am on am.id = h.arabaId Left Join hizmet_tipi ht on ht.id = h.hizmetTipiId Left Join insan i on i.id = h.musteriId", }; DataTable dt = Utilty.RunDataReader(command); for (int i = 0; i < dt.Rows.Count; i++) { list.Add( new Hizmet { Id = Convert.ToInt32(dt.Rows[i]["id"]), ArabaId = Convert.ToInt32(dt.Rows[i]["arabaId"]), HizmetTipiId = Convert.ToInt32(dt.Rows[i]["hizmetTipiId"]), MusteriId = Convert.ToInt32(dt.Rows[i]["musteriId"]), OdemeTipi = dt.Rows[i]["odemeTipi"].ToString(), Ucret = Convert.ToInt32(dt.Rows[i]["ucret"]), Tarih = Convert.ToDateTime(dt.Rows[i]["tarih"]), Isim = dt.Rows[i]["musteriAdi"].ToString(), Ad = dt.Rows[i]["arabaAdi"].ToString(), HizmetAdi = dt.Rows[i]["hizmetAdi"].ToString(), } ); } return(list); }