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 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); } } }