private void KitapIslemleri_Load(object sender, EventArgs e)
{
using (var uow = (AdoNetUnitOfWork)UnitOfWorkFactory.Create(UnitOfWorkFactory.connectiontype.SQL))
{
try
{
var repos = new Kitaplar.KitaplarRepository(uow);
List <Kitaplar.Kitaplar> kitaplar = repos.GetAll();
List <Kitaplar.Kategory> kategories = repos.GetAllKategory();
List <Kitaplar.Yayinevi> yayinevleri = repos.TumYayinevi();
List <Kitaplar.Yazarlar> yazarlar = repos.TumYazarlar();
uow.SaveChanges();
dataGridView1.DataSource = kitaplar;
//////kategori
BindKategory(kategories, cmbKategori);
BindKategory(kategories, cmbKategoriAra);
//////yayınevi
cmbYayınevi.DisplayMember = "YayıneviAdi";
cmbYayınevi.ValueMember = "ID";
cmbYayınevi.DataSource = yayinevleri;
cmbYayınevi.SelectedItem = null;
cmbYayınevi.Text = "Seçiniz";
///////yazarlar
BindYazar(yazarlar, cmbYazar);
BindYazar(yazarlar, cmbYazarAra);
}
catch (Exception ex)
{
}
}
}
private void btnGeriYukle_Click(object sender, EventArgs e)
{
using (var uow = (AdoNetUnitOfWork)UnitOfWorkFactory.Create(UnitOfWorkFactory.connectiontype.SQL))
{
try
{
var repos = new Kitaplar.KitaplarRepository(uow);
List <Kitaplar.Kitaplar> kitaplar = repos.GetAll();
uow.SaveChanges();
dataGridView1.DataSource = kitaplar;
}
catch (Exception ex)
{
}
}
}
private void btnSil_Click(object sender, EventArgs e)
{
using (var uow = (AdoNetUnitOfWork)UnitOfWorkFactory.Create(UnitOfWorkFactory.connectiontype.SQL))
{
try
{
var repos = new Kitaplar.KitaplarRepository(uow);
int ID = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value);
repos.Sil(ID);
List <Kitaplar.Kitaplar> kitaplar = repos.GetAll();
uow.SaveChanges();
dataGridView1.DataSource = kitaplar;
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 Kitaplar.KitaplarRepository(uow);
List <Kitaplar.Kitaplar> kitaplar = repos.KitapAra(txtKitapAdiAra.Text, Convert.ToInt32(cmbYazarAra.SelectedValue), Convert.ToInt32(cmbKategoriAra.SelectedValue));
uow.SaveChanges();
dataGridView1.DataSource = kitaplar;
txtKitapAdiAra.Text = "";
cmbKategoriAra.Text = "Seçiniz";
cmbYazarAra.Text = "Seçiniz";
}
catch (Exception ex)
{
}
}
}
private void btnGuncelle_Click(object sender, EventArgs e)
{
using (var uow = (AdoNetUnitOfWork)UnitOfWorkFactory.Create(UnitOfWorkFactory.connectiontype.SQL))
{
try
{
var repos = new Kitaplar.KitaplarRepository(uow);
//ArrayList arr = new ArrayList();
string[] stringArr = { dataGridView1.CurrentRow.Cells[1].Value.ToString(), dataGridView1.CurrentRow.Cells[6].Value.ToString(), dataGridView1.CurrentRow.Cells[9].Value.ToString() };
int[] intArr = { Convert.ToInt32(dataGridView1.CurrentRow.Cells[2].Value.ToString()), Convert.ToInt32(dataGridView1.CurrentRow.Cells[3].Value.ToString()), Convert.ToInt32(dataGridView1.CurrentRow.Cells[4].Value.ToString()), Convert.ToInt32(dataGridView1.CurrentRow.Cells[5].Value.ToString()), Convert.ToInt32(dataGridView1.CurrentRow.Cells[8].Value.ToString()), Convert.ToInt32(dataGridView1.CurrentRow.Cells[10].Value.ToString()) };
int ID = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString());
repos.Guncelle(stringArr, intArr, ID);
List <Kitaplar.Kitaplar> kitaplar = repos.GetAll();
uow.SaveChanges();
dataGridView1.DataSource = kitaplar;
}
catch (Exception ex)
{
//throw new Exception("Put your error message here.", ex);
}
}
}
private void btnKaydet_Click(object sender, EventArgs e)
{
using (var uow = (AdoNetUnitOfWork)UnitOfWorkFactory.Create(UnitOfWorkFactory.connectiontype.SQL))
{
try
{
var repos = new Kitaplar.KitaplarRepository(uow);
//ArrayList arr = new ArrayList();
string[] stringArr = { txtAd.Text, cmbDili.SelectedItem.ToString(), txtAciklama.Text };
int[] intArr = { Convert.ToInt32(cmbKategori.SelectedValue), Convert.ToInt32(cmbYazar.SelectedValue), Convert.ToInt32(txtBaskiYili.Text), Convert.ToInt32(txtSayfaSayisi.Text), Convert.ToInt32(cmbYayınevi.SelectedValue) };
//byte[] resim= ImageByteArray(pictureBox1);
repos.KitapEkle(stringArr, intArr, ImageByteArray(pictureBox1));
List <Kitaplar.Kitaplar> kitaplar = repos.GetAll();
uow.SaveChanges();
dataGridView1.DataSource = kitaplar;
}
catch (Exception ex)
{
throw new Exception("Put your error message here.", ex);
}
}
}
