public bool HavaalaniGuncelle(Havaalani ha)
{
try
{
SqlParameter[] p = { new SqlParameter("@Id_Yer", ha.Id_Yer), new SqlParameter("@Yer_Adi", ha.Yer_Adi) };
return(hlp.ExecuteNonQuery("Update tblKalkisVaris set Id_Yer=@Id_Yer,Yer_Adi=@Yer_Adi Where Id_Yer=@Id_Yer", p) > 0);
}
catch (SqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
public bool HavaalaniKaydet(Havaalani ha)
{
try
{
string cmdtext = "Insert into tblKalkisVaris values(@Id_Yer,@Yer_Adi)";
SqlParameter[] p = { new SqlParameter("@Id_Yer", ha.Id_Yer), new SqlParameter("@Yer_Adi", ha.Yer_Adi) };
return(hlp.ExecuteNonQuery(cmdtext, p) > 0);
}
catch (SqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
private void btnEkle_Click(object sender, EventArgs e)
{
try
{
HavaalaniBL hbl = new HavaalaniBL();
Havaalani ha = new Havaalani();
ha.Id_Yer = txtHavaalaniID.Text.Trim();
ha.Yer_Adi = txtHavaalaniAdi.Text.Trim();
if (id_havaalani == null)
{
MessageBox.Show(hbl.HavaalaniKaydet(ha) ? "Başarılı" : "Başarısız");
Temizle();
}
else
{
if (hbl.HavaalaniGuncelle(ha))
{
id_havaalani = null;
Temizle();
MessageBox.Show("Güncelleme Başarılı");
}
else
{
MessageBox.Show("Güncelleme Başarısız!");
}
}
}
catch (SqlException ex)
{
switch (ex.Number)
{
default:
MessageBox.Show("Veritabanı Hatası" + ex.Number);
break;
}
}
catch (Exception)
{
MessageBox.Show("Bilinmeyen Hata!!");
}
}
public Havaalani HavaalaniBul(string Id_Yer)
{
try
{
SqlParameter[] p = { new SqlParameter("@Id_Yer", Id_Yer) };
SqlDataReader dr = hlp.ExecuteReader("Select Id_Yer,Yer_Adi from tblKalkisVaris Where Id_Yer=@Id_Yer", p);
Havaalani ha = null;
if (dr.Read())
{
ha = new Havaalani();
ha.Id_Yer = dr["Id_Yer"].ToString();
ha.Yer_Adi = dr["Yer_Adi"].ToString();
}
dr.Close();
return(ha);
}
catch (Exception)
{
throw;
}
}
private void btnBul_Click(object sender, EventArgs e)
{
HavaalaniBL hbl = new HavaalaniBL();
Havaalani ha = hbl.HavaalaniBul((string)cmbHavaalani.SelectedValue);
if (ha == null)
{
MessageBox.Show("Havaalani Bulunamadı");
}
else
{
frm.txtHavaalaniID.Text = ha.Id_Yer;
frm.txtHavaalaniAdi.Text = ha.Yer_Adi;
frm.id_havaalani = ha.Id_Yer;
frm.btnVazgec.Visible = true;
frm.btnSil.Visible = true;
frm.lblID.Cursor = Cursors.No;
frm.txtHavaalaniID.Enabled = false;
frm.btnEkle.Text = "Guncelle";
this.Close();
}
}
private void btnKaydet_Click(object sender, EventArgs e)
{
HavaalaniBL hbl = new HavaalaniBL();
foreach (DataRow item in dt.Rows)
{
Havaalani h = new Havaalani();
if (item.RowState != DataRowState.Deleted)
{
h.Id_Yer = item[0].ToString();
h.Yer_Adi = item[2].ToString();
}
switch (item.RowState)
{
case DataRowState.Added:
hbl.HavaalaniKaydet(h);
MessageBox.Show("Eklendi");
break;
case DataRowState.Deleted:
hbl.HavaalaniSil((string)(item[0, DataRowVersion.Original]));
MessageBox.Show("Silindi");
break;
case DataRowState.Modified:
h.Id_Yer = item[0].ToString();
hbl.HavaalaniGuncelle(h);
MessageBox.Show("Guncellendi");
break;
default:
break;
}
}
}
