using System;
\nusing System.Collections.Generic;
\nusing System.ComponentModel;
\nusing System.Data;
\nusing System.Data.SqlClient;
\nusing System.Drawing;
\nusing System.IO;
\nusing System.Linq;
\nusing System.Text;
\nusing System.Threading.Tasks;
\nusing System.Windows.Forms;<\/p>\n
namespace kutuphane
\n{
\npublic partial class Form1 : Form
\n{
\npublic Form1()
\n{
\nInitializeComponent();
\n}
\nSqlConnection baglanti = new SqlConnection(@”Data Source=LAB3OGRTMEN\\SQLEXPRESS01;Initial Catalog=KutuphaneDB;Integrated Security=True”);<\/p>\n
string secilenResimYolu = “”;<\/p>\n
void Listele()
\n{
\ntry
\n{
\nbaglanti.Open();
\nSqlDataAdapter da = new SqlDataAdapter(“SELECT * FROM Kitaplar”, baglanti);
\nDataTable dt = new DataTable();
\nda.Fill(dt);
\ndataGridView1.DataSource = dt;
\nbaglanti.Close();
\n}
\ncatch (Exception ex)
\n{
\nMessageBox.Show(“Hata: ” + ex.Message);
\nbaglanti.Close();
\n}
\n}<\/p>\n
private void Form1_Load(object sender, EventArgs e)
\n{
\nListele();<\/p>\n
\/\/ Sat\u0131rlar\u0131n genel g\u00f6r\u00fcn\u00fcm\u00fc
\ndataGridView1.BorderStyle = BorderStyle.None;
\ndataGridView1.AlternatingRowsDefaultCellStyle.BackColor = Color.FromArgb(238, 239, 249); \/\/ Bir dolu bir bo\u015f sat\u0131r rengi
\ndataGridView1.CellBorderStyle = DataGridViewCellBorderStyle.SingleHorizontal;
\ndataGridView1.DefaultCellStyle.SelectionBackColor = Color.DarkTurquoise; \/\/ Se\u00e7ili sat\u0131r rengi
\ndataGridView1.DefaultCellStyle.SelectionForeColor = Color.WhiteSmoke;
\ndataGridView1.BackgroundColor = Color.White;<\/p>\n
\/\/ Ba\u015fl\u0131k (Header) tasar\u0131m\u0131
\ndataGridView1.EnableHeadersVisualStyles = false;
\ndataGridView1.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.None;
\ndataGridView1.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(20, 25, 72); \/\/ Ba\u015fl\u0131k arka plan (Lacivert)
\ndataGridView1.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; \/\/ Ba\u015fl\u0131k yaz\u0131 rengi
\ndataGridView1.ColumnHeadersHeight = 40; \/\/ Ba\u015fl\u0131k y\u00fcksekli\u011fi<\/p>\n
\/\/ Sat\u0131r y\u00fcksekli\u011fi ve yaz\u0131 tipi
\ndataGridView1.RowTemplate.Height = 35;
\ndataGridView1.DefaultCellStyle.Font = new Font(“Segoe UI”, 10);<\/p>\n
\/\/ Otomatik boyutland\u0131rma
\ndataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; \/\/ S\u00fctunlar\u0131 geni\u015fli\u011fe yay<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
\/\/ Proje i\u00e7inde Resimler klas\u00f6r\u00fc yoksa olu\u015fturur
\nstring resimKlasoru = Path.Combine(Application.StartupPath, “Resimler”);
\nif (!Directory.Exists(resimKlasoru))
\n{
\nDirectory.CreateDirectory(resimKlasoru);
\n}
\n}<\/p>\n
private void btnResimSec_Click(object sender, EventArgs e)
\n{
\nOpenFileDialog ofd = new OpenFileDialog();
\nofd.Filter = “Resim Dosyalar\u0131 (*.jpg;*.jpeg;*.png)|*.jpg;*.jpeg;*.png”;<\/p>\n
if (ofd.ShowDialog() == DialogResult.OK)
\n{
\npictureBox1.ImageLocation = ofd.FileName;
\nsecilenResimYolu = ofd.FileName;
\n}
\n}<\/p>\n
private void button1_Click(object sender, EventArgs e)
\n{<\/p>\n
try
\n{
\nstring yeniResimYolu = “”;<\/p>\n
\/\/ E\u011fer resim se\u00e7ildiyse kopyalama yap
\nif (!string.IsNullOrEmpty(secilenResimYolu))
\n{
\nstring dosyaAdi = Guid.NewGuid().ToString() + Path.GetExtension(secilenResimYolu); \/\/ \u0130sim \u00e7ak\u0131\u015fmas\u0131 olmamas\u0131 i\u00e7in benzersiz isim
\nyeniResimYolu = Path.Combine(Application.StartupPath, “Resimler”, dosyaAdi);
\nFile.Copy(secilenResimYolu, yeniResimYolu);
\n}<\/p>\n
baglanti.Open();
\nSqlCommand komut = new SqlCommand(“INSERT INTO Kitaplar (KitapAd, Yazar, SayfaSayisi, Ozet, KitapKapakYolu, ISBN, RafYeri, Adet) VALUES (@p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8)”, baglanti);<\/p>\n
komut.Parameters.AddWithValue(“@p1”, txtKitapAd.Text);
\nkomut.Parameters.AddWithValue(“@p2”, txtYazar.Text);
\nkomut.Parameters.AddWithValue(“@p3”, string.IsNullOrEmpty(txtSayfa.Text) ? 0 : int.Parse(txtSayfa.Text));
\nkomut.Parameters.AddWithValue(“@p4”, txtOzet.Text);
\nkomut.Parameters.AddWithValue(“@p5”, yeniResimYolu); \/\/ Kopyalanan yeni adres
\nkomut.Parameters.AddWithValue(“@p6”, txtISBN.Text);
\nkomut.Parameters.AddWithValue(“@p7”, txtRaf.Text);
\nkomut.Parameters.AddWithValue(“@p8”, string.IsNullOrEmpty(txtAdet.Text) ? 0 : int.Parse(txtAdet.Text));<\/p>\n
komut.ExecuteNonQuery();
\nbaglanti.Close();<\/p>\n
MessageBox.Show(“Kitap ba\u015far\u0131yla kaydedildi!”);
\nListele();
\nTemizle();
\n}
\ncatch (Exception ex)
\n{
\nMessageBox.Show(“Hata olu\u015ftu: ” + ex.Message);
\nbaglanti.Close();
\n}
\n}<\/p>\n
void Temizle()
\n{
\ntxtKitapAd.Clear();
\ntxtYazar.Clear();
\ntxtSayfa.Clear();
\ntxtOzet.Clear();
\ntxtISBN.Clear();
\ntxtRaf.Clear();
\ntxtAdet.Clear();
\npictureBox1.Image = null;
\nsecilenResimYolu = “”;
\n}<\/p>\n
<\/p>\n
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
\n{
\nint secilen = dataGridView1.SelectedCells[0].RowIndex;<\/p>\n
txtKitapAd.Text = dataGridView1.Rows[secilen].Cells[1].Value.ToString();
\ntxtYazar.Text = dataGridView1.Rows[secilen].Cells[2].Value.ToString();
\ntxtOzet.Text = dataGridView1.Rows[secilen].Cells[4].Value.ToString();<\/p>\n
string resimYolu = dataGridView1.Rows[secilen].Cells[5].Value.ToString();
\nif (File.Exists(resimYolu))
\n{
\npictureBox1.ImageLocation = resimYolu;
\n}
\nelse
\n{
\npictureBox1.Image = null;
\n}
\n}<\/p>\n
private void dataGridView1_SelectionChanged(object sender, EventArgs e)
\n{<\/p>\n
\/\/ HATA \u00d6NLEY\u0130C\u0130 KONTROL:
\n\/\/ E\u011fer sat\u0131r se\u00e7ili de\u011filse veya sat\u0131r say\u0131s\u0131 0 ise i\u015flem yapma ve metoddan \u00e7\u0131k
\nif (dataGridView1.CurrentRow == null || dataGridView1.SelectedRows.Count == 0)
\n{
\nreturn;
\n}<\/p>\n
try
\n{
\nDataGridViewRow satir = dataGridView1.SelectedRows[0];<\/p>\n
\/\/ H\u00fccre de\u011ferlerini al\u0131rken bo\u015f (null) kontrol\u00fc eklemek daha g\u00fcvenlidir
\ntxtKitapAd.Text = satir.Cells[“KitapAd”].Value?.ToString();
\ntxtYazar.Text = satir.Cells[“Yazar”].Value?.ToString();
\ntxtSayfa.Text = satir.Cells[“SayfaSayisi”].Value?.ToString();
\ntxtOzet.Text = satir.Cells[“Ozet”].Value?.ToString();
\ntxtISBN.Text = satir.Cells[“ISBN”].Value?.ToString();
\ntxtRaf.Text = satir.Cells[“RafYeri”].Value?.ToString();
\ntxtAdet.Text = satir.Cells[“Adet”].Value?.ToString();<\/p>\n
string resimYolu = satir.Cells[“KitapKapakYolu”].Value?.ToString();
\nif (!string.IsNullOrEmpty(resimYolu) && File.Exists(resimYolu))
\n{
\npictureBox1.ImageLocation = resimYolu;
\n}
\nelse
\n{
\npictureBox1.Image = null;
\n}
\n}
\ncatch (Exception)
\n{
\n\/\/ Hata durumunda program\u0131n \u00e7\u00f6kmesini engellemek i\u00e7in bo\u015f b\u0131rak\u0131labilir
\n}
\n}<\/p>\n
private void txtArama_TextChanged(object sender, EventArgs e)
\n{
\n\/\/ Arama kutusu bo\u015fsa t\u00fcm listeyi getir, doluysa filtrele
\ntry
\n{
\nif (baglanti.State == ConnectionState.Closed)
\nbaglanti.Open();<\/p>\n
\/\/ SQL’deki “LIKE” operat\u00f6r\u00fc ile i\u00e7inde ge\u00e7en kelimeleri ar\u0131yoruz
\n\/\/ ‘%’ i\u015fareti aranan kelimenin ba\u015f\u0131nda veya sonunda herhangi bir karakter olabilece\u011fini s\u00f6yler
\nstring sorgu = “SELECT * FROM Kitaplar WHERE KitapAd LIKE @p1 OR Yazar LIKE @p1”;<\/p>\n
SqlDataAdapter da = new SqlDataAdapter(sorgu, baglanti);
\nda.SelectCommand.Parameters.AddWithValue(“@p1”, “%” + txtArama.Text + “%”);<\/p>\n
DataTable dt = new DataTable();
\nda.Fill(dt);
\ndataGridView1.DataSource = dt;<\/p>\n
baglanti.Close();
\n}
\ncatch (Exception ex)
\n{
\nMessageBox.Show(“Arama s\u0131ras\u0131nda hata olu\u015ftu: ” + ex.Message);
\nif (baglanti.State == ConnectionState.Open)
\nbaglanti.Close();
\n}
\n}<\/p>\n
private void button2_Click(object sender, EventArgs e)
\n{<\/p>\n
\/\/ 1. Kontrol: Se\u00e7ili sat\u0131r var m\u0131?
\nif (dataGridView1.SelectedRows.Count > 0)
\n{
\n\/\/ Kullan\u0131c\u0131dan onay alal\u0131m
\nDialogResult onay = MessageBox.Show(“Bu kitab\u0131 silmek istedi\u011finize emin misiniz?”, “Silme Onay\u0131”, MessageBoxButtons.YesNo, MessageBoxIcon.Question);<\/p>\n
if (onay == DialogResult.Yes)
\n{
\ntry
\n{
\n\/\/ Se\u00e7ili sat\u0131rdaki KitapID de\u011ferini al\u0131yoruz (S\u00fctun ad\u0131 veya indeksi do\u011fru olmal\u0131)
\nint seciliId = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[“KitapID”].Value);<\/p>\n
baglanti.Open();
\nSqlCommand komutSil = new SqlCommand(“DELETE FROM Kitaplar WHERE KitapID = @p1”, baglanti);
\nkomutSil.Parameters.AddWithValue(“@p1”, seciliId);<\/p>\n
komutSil.ExecuteNonQuery();
\nbaglanti.Close();<\/p>\n
MessageBox.Show(“Kitap ba\u015far\u0131yla silindi.”);<\/p>\n
\/\/ Listeyi yenile ve kutular\u0131 temizle
\nListele();
\nTemizle();
\n}
\ncatch (Exception ex)
\n{
\nMessageBox.Show(“Silme hatas\u0131: ” + ex.Message);
\nbaglanti.Close();
\n}
\n}
\n}
\nelse
\n{
\nMessageBox.Show(“L\u00fctfen silmek istedi\u011finiz kitab\u0131 tablodan se\u00e7in.”);
\n}
\n}<\/p>\n
private void button4_Click(object sender, EventArgs e)
\n{
\ntxtKitapAd.Clear();
\ntxtYazar.Clear();
\ntxtOzet.Clear();
\ntxtRaf.Clear();
\ntxtSayfa.Clear();
\ntxtISBN.Clear();
\ntxtAdet.Clear();
\ntxtKitapAd.Focus();
\npictureBox1.Image=null;<\/p>\n
}<\/p>\n
private void button3_Click(object sender, EventArgs e)
\n{
\nif (dataGridView1.SelectedRows.Count > 0)
\n{
\ntry
\n{
\nbaglanti.Open();
\n\/\/ SQL Sorgusu: Sadece se\u00e7ili ID’ye sahip olan kitab\u0131 g\u00fcnceller
\nstring sorgu = “UPDATE Kitaplar SET KitapAd=@p1, Yazar=@p2, SayfaSayisi=@p3, Ozet=@p4, ISBN=@p5, RafYeri=@p6, Adet=@p7 WHERE KitapID=@p0”;<\/p>\n
SqlCommand komutGuncelle = new SqlCommand(sorgu, baglanti);<\/p>\n
\/\/ De\u011ferleri parametre olarak ekliyoruz
\nkomutGuncelle.Parameters.AddWithValue(“@p1”, txtKitapAd.Text);
\nkomutGuncelle.Parameters.AddWithValue(“@p2”, txtYazar.Text);
\nkomutGuncelle.Parameters.AddWithValue(“@p3”, int.Parse(txtSayfa.Text));
\nkomutGuncelle.Parameters.AddWithValue(“@p4”, txtOzet.Text);
\nkomutGuncelle.Parameters.AddWithValue(“@p5”, txtISBN.Text);
\nkomutGuncelle.Parameters.AddWithValue(“@p6”, txtRaf.Text);
\nkomutGuncelle.Parameters.AddWithValue(“@p7”, int.Parse(txtAdet.Text));<\/p>\n
\/\/ Hangi sat\u0131r\u0131n g\u00fcncellenece\u011fini belirleyen ID (SelectionChanged ile gelen ID)
\nint seciliId = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[“KitapID”].Value);
\nkomutGuncelle.Parameters.AddWithValue(“@p0”, seciliId);<\/p>\n
komutGuncelle.ExecuteNonQuery();
\nbaglanti.Close();<\/p>\n
MessageBox.Show(“Kitap bilgileri ba\u015far\u0131yla g\u00fcncellendi!”);
\nListele(); \/\/ Tabloyu yenile
\n}
\ncatch (Exception ex)
\n{
\nMessageBox.Show(“G\u00fcncelleme hatas\u0131: ” + ex.Message);
\nbaglanti.Close();
\n}
\n}
\nelse
\n{
\nMessageBox.Show(“L\u00fctfen g\u00fcncellemek istedi\u011finiz kitab\u0131 listeden se\u00e7in!”);
\n}
\n}<\/p>\n
private void button5_Click(object sender, EventArgs e)
\n{
\nApplication.Exit();
\n}
\n}
\n}<\/p>\n
<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.IO; using System.Linq; using System.Text; using System.Threading.Tasks; […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2700","post","type-post","status-publish","format-standard","hentry","category-genel"],"_links":{"self":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2700","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/comments?post=2700"}],"version-history":[{"count":3,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2700\/revisions"}],"predecessor-version":[{"id":2703,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2700\/revisions\/2703"}],"wp:attachment":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/media?parent=2700"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/categories?post=2700"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/tags?post=2700"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}