Esempio n. 1
0
        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();
        }
Esempio n. 2
0
        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();
        }