Exemple #1
0
        public static void hastaneEkle(Hastane hastane)
        {
            SqlConnection sqlbaglanti = openConnection();
            SqlCommand    veriOku     = new SqlCommand("INSERT INTO hastane (hastaneKodu,adi,adresi) VALUES (@hastaneKodu,@adi,@adresi)", sqlbaglanti);

            veriOku.Parameters.AddWithValue("@hastaneKodu", hastane.getHastaneKodu());
            veriOku.Parameters.AddWithValue("@adi", hastane.getAdi());
            veriOku.Parameters.AddWithValue("@adresi", hastane.getAdresi());

            try
            {
                veriOku.ExecuteNonQuery();
            }
            catch (Exception)
            {
            }
            finally
            {
                connectionClose(sqlbaglanti);
            }
        }
Exemple #2
0
        public static void hastaneGuncelle(Hastane hastane)
        {
            SqlConnection sqlbaglanti = openConnection();
            SqlCommand    veriOku     = new SqlCommand("UPDATE hastane SET adi=@adi,adresi=@adres where hastaneKodu=@hastaneKodu", sqlbaglanti);

            veriOku.Parameters.AddWithValue("@hastaneKodu", hastane.getHastaneKodu());
            veriOku.Parameters.AddWithValue("@adi", hastane.getAdi());
            veriOku.Parameters.AddWithValue("@adres", hastane.getAdresi());



            try
            {
                veriOku.ExecuteNonQuery();
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                connectionClose(sqlbaglanti);
            }
        }