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