public void Ekle()
{
MusteriDal dal = new MusteriDal();
Musteri m = new Musteri();
m.Adi = "atilla";
m.MusteriKey = Guid.NewGuid();
m.Soyadi = "ozgur";
dal.Ekle(m);
}
public void TransactionOrnek(Musteri pMusteri, BasitTablo pBasitTablo)
{
using (TransactionScope scope = new TransactionScope())
{
MusteriDal musteriDal = new MusteriDal();
BasitTabloDal basitTabloDal = new BasitTabloDal();
musteriDal.Ekle(pMusteri);
basitTabloDal.Ekle(pBasitTablo);
scope.Complete();
}
}
public void usp_MusteriSorgulaMusteriKeyIleTest()
{
Guid pk = Guid.NewGuid();
MusteriDal dal = new MusteriDal();
string ad = "DenemeAd";
string soyad = "DenemeSoyad";
Musteri m = new Musteri();
m.MusteriKey = pk;
m.Adi = ad;
m.Soyadi = soyad;
dal.Ekle(m);
DataTable dt = StoredProcedures.MusteriSorgulaMusteriKeyIle(pk);
Assert.AreEqual(dt.Rows[0][Musteri.PropertyIsimleri.Adi].ToString(), ad);
Assert.AreEqual(dt.Rows[0][Musteri.PropertyIsimleri.Soyadi].ToString(), soyad);
}
public void ornekMusteriEkleGuncelleSil()
{
MusteriDal dal = new MusteriDal();
Musteri m = ornekMusteriGetir();
dal.Ekle(m);
Musteri veritabanindakiRow = dal.SorgulaMusteriKeyIle(m.MusteriKey);
MusteriKolonlariEsitMi(m, veritabanindakiRow);
m.Adi = m.Adi + "d";
dal.Guncelle(m);
veritabanindakiRow = dal.SorgulaMusteriKeyIle(m.MusteriKey);
MusteriKolonlariEsitMi(m, veritabanindakiRow);
dal.Sil(m);
veritabanindakiRow = dal.SorgulaMusteriKeyIle(m.MusteriKey);
Assert.IsNull(veritabanindakiRow);
}
