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