private void btnGuncelle_Click(object sender, EventArgs e)
{
using (var uow = (AdoNetUnitOfWork)UnitOfWorkFactory.Create(UnitOfWorkFactory.connectiontype.SQL))
{
try
{
var repos = new Uyeler.UyelerRepository(uow);
string[] degerler = new string[5];
int ID = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString());
degerler[0] = dataGridView1.CurrentRow.Cells[1].Value.ToString();
degerler[1] = dataGridView1.CurrentRow.Cells[2].Value.ToString();
degerler[2] = dataGridView1.CurrentRow.Cells[3].Value.ToString();
degerler[3] = dataGridView1.CurrentRow.Cells[4].Value.ToString();
degerler[4] = dataGridView1.CurrentRow.Cells[5].Value.ToString();
repos.Guncelle(degerler, ID);
List <Uyeler.Uyeler> uyeler = repos.GetAll();
uow.SaveChanges();
dataGridView1.DataSource = uyeler;
TextleriBosalt();
}
catch (Exception ex)
{
}
}
//string secili = dataGridView1.CurrentRow.Cells[1].Value.ToString();
//string sec = dataGridView1.CurrentRow.Cells[0].Value.ToString();
}
private void btnGeriYukle_Click(object sender, EventArgs e)
{
using (var uow = (AdoNetUnitOfWork)UnitOfWorkFactory.Create(UnitOfWorkFactory.connectiontype.SQL))
{
try
{
var repos = new Uyeler.UyelerRepository(uow);
List <Uyeler.Uyeler> uyeler = repos.GetAll();
uow.SaveChanges();
dataGridView1.DataSource = uyeler;
}
catch (Exception ex)
{
}
}
}
private void btnSil_Click(object sender, EventArgs e)
{
using (var uow = (AdoNetUnitOfWork)UnitOfWorkFactory.Create(UnitOfWorkFactory.connectiontype.SQL))
{
try
{
var repos = new Uyeler.UyelerRepository(uow);
int ID = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value);
repos.Sil(ID);
List <Uyeler.Uyeler> uyeler = repos.GetAll();
uow.SaveChanges();
dataGridView1.DataSource = uyeler;
TextleriBosalt();
}
catch (Exception ex)
{
}
}
}
private void btnAra_Click(object sender, EventArgs e)
{
using (var uow = (AdoNetUnitOfWork)UnitOfWorkFactory.Create(UnitOfWorkFactory.connectiontype.SQL))
{
try
{
var repos = new Uyeler.UyelerRepository(uow);
List <Uyeler.Uyeler> uyeler = repos.Ara(txtAd.Text, txtEposta.Text);
uow.SaveChanges();
dataGridView1.DataSource = uyeler;
txtAd.Text = "";
txtEposta.Text = "";
}
catch (Exception ex)
{
}
}
}
private void btnEkle_Click(object sender, EventArgs e)
{
using (var uow = (AdoNetUnitOfWork)UnitOfWorkFactory.Create(UnitOfWorkFactory.connectiontype.SQL))
{
try
{
var repos = new Uyeler.UyelerRepository(uow);
string[] degerler = { txtAdi.Text, txtSoyad.Text, txtTelefon.Text, txtEpostaa.Text, txtAdres.Text };
repos.Ekle(degerler);
List <Uyeler.Uyeler> uyeler = repos.GetAll();
uow.SaveChanges();
dataGridView1.DataSource = uyeler;
TextleriBosalt();
}
catch (Exception ex)
{
}
}
}
