public Rota(int ID)
{
SqlConnection bag = new SqlConnection(@"Data Source=DESKTOP-19QN280\SQLEXPRESS;Initial Catalog=SaS; Integrated Security=True");
bag.Open();
SqlCommand sqlCommand = new SqlCommand("SELECT * FROM Rota WHERE Rota_ID=" + ID.ToString(), bag);
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
rota_ID = sqlDataReader.GetInt32(0);
rota_BaslangicID = sqlDataReader.GetInt32(1);
rota_VarisID = sqlDataReader.GetInt32(2);
firma = new Firma(sqlDataReader.GetInt32(3));
rota_Ucret = sqlDataReader.GetInt32(4);
rota_Tarih = sqlDataReader.GetDateTime(5);
rota_Saat = sqlDataReader.GetString(6);
rota_Seyahat = sqlDataReader.GetInt32(7);
tur = new Tur(sqlDataReader.GetInt32(8));
sehir_baslangic = new Sehir(rota_BaslangicID);
sehir_varis = new Sehir(rota_VarisID);
}
sqlDataReader.Close();
bag.Dispose();
bag.Close();
}
public Firma(int ID)
{
SqlConnection bag = new SqlConnection(@"Data Source=DESKTOP-19QN280\SQLEXPRESS;Initial Catalog=SaS; Integrated Security=True");
bag.Open();
SqlCommand sqlCommand = new SqlCommand("SELECT * FROM Firma WHERE firma_ID=" + ID.ToString(), bag);
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
firma_ID = sqlDataReader.GetInt32(0);
firma_Adi = sqlDataReader.GetString(1);
tur = new Tur(sqlDataReader.GetInt32(2));
firma_Web = sqlDataReader.GetString(3);
}
sqlDataReader.Close();
bag.Dispose();
bag.Close();
}