private void btnSarkiciGuncelle_Click(object sender, EventArgs e)
{
AdoNetHelper.Database ado = new AdoNetHelper.Database(ConnectionString);
Sarkici sarkici = lstSarkicilar.SelectedItem as Sarkici;
ado.RunProc("procSarkiciGuncelle", new SqlParameter("@SarkiciAdi", txtSarkiciAdi.Text), new SqlParameter("@SarkiciSoyadi", txtSarkiciSoyadi.Text), new SqlParameter("@TurId", sarkici.SarkiciTurID), new SqlParameter("@SarkiciID", sarkici.SarkiciID));
TurSarkicilariniGetir();
}
private void btnSarkiciSil_Click(object sender, EventArgs e)
{
AdoNetHelper.Database ado = new AdoNetHelper.Database(ConnectionString);
Sarkici sarkici = lstSarkicilar.SelectedItem as Sarkici;
ado.RunProc("procSarkiciSil", new SqlParameter("@SarkiciID", sarkici.SarkiciID));
TurSarkicilariniGetir();
}
private void lstSarkicilar_SelectedIndexChanged(object sender, EventArgs e)
{
if (lstSarkicilar.SelectedIndex > -1)
{
Sarkici srkc = lstSarkicilar.SelectedItem as Sarkici;
txtSarkiciAdi.Text = srkc.SarkiciAdi;
txtSarkiciSoyadi.Text = srkc.SarkiciSoyadi;
}
}
private void SarkiciAlbumleriniGetir()
{
lstAlbumler.Items.Clear();
AdoNetHelper.Database ado = new AdoNetHelper.Database(ConnectionString);
Sarkici sarkici = cmbSarkici.SelectedItem as Sarkici;
DataTable dt = ado.getProc("procAlbumGetir", new SqlParameter("@SarkiciID", sarkici.SarkiciID));
foreach (DataRow dr in dt.Rows)
{
Album album = new Album();
album.AlbumID = (int)dr["AlbumID"];
album.AlbumAdi = dr["AlbumAdi"].ToString();
album.AlbumAciklama = dr["AlbumAciklama"].ToString();
album.AlbumSarkiciID = (int)dr["AlbumSarkiciID"];
lstAlbumler.Items.Add(album);
}
}
private void TurSarkicilariniGetir()
{
lstSarkicilar.Items.Clear();
AdoNetHelper.Database ado = new AdoNetHelper.Database(ConnectionString);
Tur tur = cmbTurler.SelectedItem as Tur;
DataTable dt = ado.getProc("procSarkiciGetir", new SqlParameter("@TurID", tur.TurID));
foreach (DataRow dr in dt.Rows)
{
Sarkici sarkici = new Sarkici();
sarkici.SarkiciID = (int)dr["SarkiciID"];
sarkici.SarkiciAdi = dr["SarkiciAdi"].ToString();
sarkici.SarkiciSoyadi = dr["SarkiciSoyadi"].ToString();
sarkici.SarkiciTurID = (int)dr["SarkiciTurID"];
lstSarkicilar.Items.Add(sarkici);
}
}
