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