private void btnKaydet_Click(object sender, EventArgs e)
{
try
{
MusteriAdisyonBL mabl = new MusteriAdisyonBL();
foreach (DataRow item in dt.Rows)
{
MusteriAdisyon ma = new MusteriAdisyon();
if (item.RowState != DataRowState.Deleted)
{
ma.MusteriID = Convert.ToInt32(item[0]);
ma.AdisyonID = Convert.ToInt32(item[1]);
ma.AdisyonAdet = Convert.ToInt32(item[2]);
Adisyon a = new Adisyon();
AdisyonBL abl = new AdisyonBL();
a.AdisyonID = ma.AdisyonID;
a = abl.FiyatGetir(a);
ma = mabl.ToplamFiyatiBelirle(a, ma);
}
switch (item.RowState)
{
case DataRowState.Added:
mabl.MusAdisEkle(ma);
break;
case DataRowState.Deleted:
mabl.MusAdisSil(Convert.ToInt32(item[1, DataRowVersion.Original]), Convert.ToInt32(item[0, DataRowVersion.Original]));
break;
case DataRowState.Modified:
mabl.MusAdisGuncelle(ma);
break;
default:
break;
}
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
VeriCek();
btnYenile.Visible = false;
}
}
void VeriCek()
{
MusteriAdisyonBL mabl = new MusteriAdisyonBL();
dt = mabl.MusteriAdisGetir();
gridMusteriAdisyon.DataSource = dt;
clmMusteri.ValueMember = "MusteriKayitID";
clmMusteri.DisplayMember = "AdSoyad";
clmAdisyon.ValueMember = "AdisyonID";
clmAdisyon.DisplayMember = "AdisyonAd";
clmMusteri.DataSource = mabl.MusteriGetir();
clmAdisyon.DataSource = mabl.AdisyonGetir();
}
