private void btnSarkiGuncelle_Click(object sender, EventArgs e) { AdoNetHelper.Database ado = new AdoNetHelper.Database(ConnectionString); Sarki sarki = lstSarkilar.SelectedItem as Sarki; ado.RunProc("procSarkiGuncelle", new SqlParameter("@SarkiSozleri", txtSarkiSozu.Text), new SqlParameter("@SarkiAdi", txtSarkiAdi.Text), new SqlParameter("@Besteci", txtSarkiBesteci.Text), new SqlParameter("@SozYazari", txtSarkiSozYazari.Text), new SqlParameter("@AlbumID", sarki.AlbumID), new SqlParameter("@Cikis", dtpSarkiCikisTarihi.Value), new SqlParameter("@SarkiID", sarki.SarkiID)); AlbumSarkilariGetir(); }
private void btnSarkiSil_Click(object sender, EventArgs e) { AdoNetHelper.Database ado = new AdoNetHelper.Database(ConnectionString); Album album = cmbAlbum.SelectedItem as Album; Sarki sarki = lstSarkilar.SelectedItem as Sarki; ado.RunProc("procSarkiSil", new SqlParameter("@SarkiID", sarki.SarkiID)); AlbumSarkilariGetir(); }
private void lstSarkilar_SelectedIndexChanged(object sender, EventArgs e) { if (lstSarkilar.SelectedIndex > -1) { Sarki sarki = lstSarkilar.SelectedItem as Sarki; txtSarkiAdi.Text = sarki.SarkiAdi; txtSarkiBesteci.Text = sarki.Besteci; txtSarkiSozu.Text = sarki.SarkiSozleri; txtSarkiSozYazari.Text = sarki.SozYazari; dtpSarkiCikisTarihi.Value = sarki.CikisTarihi; } }
public void AlbumSarkilariGetir() { lstSarkilar.Items.Clear(); AdoNetHelper.Database ado = new AdoNetHelper.Database(ConnectionString); Album album = cmbAlbum.SelectedItem as Album; DataTable dt = ado.getProc("procSarkiGetir", new SqlParameter("@AlbumID", album.AlbumID)); foreach (DataRow dr in dt.Rows) { Sarki sarki = new Sarki(); sarki.SarkiID = (int)dr["SarkiID"]; sarki.SarkiAdi = dr["SarkiAdi"].ToString(); sarki.SarkiSozleri = dr["SarkiSozleri"].ToString(); sarki.Besteci = dr["Besteci"].ToString(); sarki.SozYazari = dr["SozYazari"].ToString(); sarki.AlbumID = (int)dr["AlbumID"]; sarki.CikisTarihi = (DateTime)dr["CikisTarihi"]; lstSarkilar.Items.Add(sarki); } }