public bool HavayoluGuncelle(Havayolu h) { bool Sonuc = false; SqlCommand comm = new SqlCommand("update havayollari set HavayoluAdi=@HavayoluAdi, UlkeID=@UlkeID, aciklama=@Aciklama, Kisaltmasi=@kisaltma where havayoluId=@HavayoluID", conn); comm.Parameters.Add("@HavayoluAdi", SqlDbType.VarChar).Value = h._havayoluAdi; comm.Parameters.Add("@UlkeID", SqlDbType.Int).Value = h._ulkeID; comm.Parameters.Add("@Aciklama", SqlDbType.VarChar).Value = h._aciklama; comm.Parameters.Add("@kisaltma", SqlDbType.VarChar).Value = h._kisaltmasi; comm.Parameters.Add("@HavayoluID", SqlDbType.Int).Value = h._havayoluID; if (conn.State == ConnectionState.Closed) { conn.Open(); } try { Sonuc = Convert.ToBoolean(comm.ExecuteNonQuery()); } catch (SqlException ex) { string hata = ex.Message; } finally { conn.Close(); } return(Sonuc); }
public bool HavayoluEkle(Havayolu h) { bool Sonuc = false; SqlCommand comm = new SqlCommand("insert into havayollari (HavayoluAdi, UlkeID, FotografID, Aciklama, Kisaltmasi) values (@HavayoluAdi, @UlkeID, @FotografID, @Aciklama, @Kisaltmasi)", conn); comm.Parameters.Add("@HavayoluAdi", SqlDbType.VarChar).Value = h._havayoluAdi; comm.Parameters.Add("@UlkeID", SqlDbType.Int).Value = h._ulkeID; comm.Parameters.Add("@Aciklama", SqlDbType.VarChar).Value = h._aciklama; comm.Parameters.Add("@FotografID", SqlDbType.Int).Value = h._fotografID; comm.Parameters.Add("@Kisaltmasi", SqlDbType.VarChar).Value = h._kisaltmasi; if (conn.State == ConnectionState.Closed) { conn.Open(); } try { Sonuc = Convert.ToBoolean(comm.ExecuteNonQuery()); } catch (SqlException ex) { string hata = ex.Message; } finally { conn.Close(); } return(Sonuc); }