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