SQL Server’da StokDB veritaban\u0131n\u0131 ve tablolar\u0131n\u0131 olu\u015fturmak.<\/p>\n
\r\nKategoriler Urunler\r\n----------- -------\r\nKategoriID (PK) \u2190\u2500\u2500 KategoriID (FK)\r\nKategoriAdi UrunID (PK)\r\n UrunAdi\r\n Barkod\r\n Fiyat\r\n StokMiktari\r\n EklenmeTarihi\r\n<\/pre>\nSQL Script \u2014 SSMS veya Azure Data Studio’da \u00e7al\u0131\u015ft\u0131r\u0131n<\/p>\n
\r\n-- 1. Veritaban\u0131 olu\u015ftur\r\nCREATE DATABASE StokDB;\r\nGO\r\n\r\nUSE StokDB;\r\nGO\r\n\r\n-- 2. Kategoriler tablosu\r\nCREATE TABLE Kategoriler (\r\n KategoriID INT IDENTITY(1,1) PRIMARY KEY,\r\n KategoriAdi NVARCHAR(100) NOT NULL\r\n);\r\nGO\r\n\r\n-- 3. \u00dcr\u00fcnler tablosu\r\nCREATE TABLE Urunler (\r\n UrunID INT IDENTITY(1,1) PRIMARY KEY,\r\n UrunAdi NVARCHAR(200) NOT NULL,\r\n Barkod NVARCHAR(50) UNIQUE,\r\n Fiyat DECIMAL(10,2) NOT NULL DEFAULT 0,\r\n StokMiktari INT NOT NULL DEFAULT 0,\r\n KategoriID INT FOREIGN KEY REFERENCES Kategoriler(KategoriID),\r\n EklenmeTarihi DATETIME DEFAULT GETDATE()\r\n);\r\nGO\r\n\r\n-- 4. \u00d6rnek kategoriler\r\nINSERT INTO Kategoriler (KategoriAdi) VALUES\r\n('Elektronik'),\r\n('G\u0131da'),\r\n('Giyim'),\r\n('K\u0131rtasiye'),\r\n('Kozmetik');\r\nGO\r\n\r\n-- 5. \u00d6rnek \u00fcr\u00fcnler\r\nINSERT INTO Urunler (UrunAdi, Barkod, Fiyat, StokMiktari, KategoriID) VALUES\r\n('Laptop', '8680001', 15000.00, 10, 1),\r\n('\u015eeker 1kg', '8680002', 25.50, 50, 2),\r\n('Beyaz G\u00f6mlek', '8680003', 350.00, 30, 3),\r\n('T\u00fckenmez Kalem', '8680004', 5.00,100, 4),\r\n('\u015eampuan', '8680005', 45.00, 40, 5);\r\nGO\r\n\r\n-- 6. Kontrol sorgusu\r\nSELECT u.UrunID, u.UrunAdi, u.Barkod, u.Fiyat, u.StokMiktari,\r\n k.KategoriAdi, u.EklenmeTarihi\r\nFROM Urunler u\r\nJOIN Kategoriler k ON u.KategoriID = k.KategoriID;\r\n\r\n<\/pre>\nVisual Studio’da projeyi kurmak ve SQL Server ba\u011flant\u0131s\u0131n\u0131 test etmek.<\/p>\n
\r\nStokYonetimi\/\r\n\u251c\u2500\u2500 Forms\/\r\n\u2502 \u251c\u2500\u2500 AnaSayfa.cs \u2190 Ana men\u00fc\r\n\u2502 \u251c\u2500\u2500 UrunListeFormu.cs \u2190 Listeleme + Silme\r\n\u2502 \u251c\u2500\u2500 UrunEkleFormu.cs \u2190 Ekleme\r\n\u2502 \u2514\u2500\u2500 UrunGuncelleFormu.cs \u2190 G\u00fcncelleme\r\n\u251c\u2500\u2500 Helpers\/\r\n\u2502 \u2514\u2500\u2500 DbHelper.cs \u2190 Veritaban\u0131 ba\u011flant\u0131 s\u0131n\u0131f\u0131\r\n\u2514\u2500\u2500 Program.cs\r\n\r\n<\/pre>\nPM> Install-Package Microsoft.Data.SqlClient<\/p>\n
Helpers klas\u00f6r\u00fc olu\u015fturun, i\u00e7ine DbHelper.cs ekleyin<\/p>\n
\r\nusing Microsoft.Data.SqlClient;\r\n\r\nnamespace StokYonetimi.Helpers\r\n{\r\n public static class DbHelper\r\n {\r\n \/\/ \u26a0\ufe0f Kendi sunucu ad\u0131n\u0131za g\u00f6re de\u011fi\u015ftirin\r\n private static readonly string ConnectionString =\r\n "Server=.\\\\SQLEXPRESS; Database=StokDB; Trusted_Connection=True; TrustServerCertificate=True;";\r\n\r\n public static SqlConnection GetConnection()\r\n {\r\n return new SqlConnection(ConnectionString);\r\n }\r\n }\r\n}\r\n\r\n<\/pre>\nNot: Sunucu ad\u0131 i\u00e7in SSMS’te ba\u011fland\u0131\u011f\u0131n\u0131z ad\u0131 kullan\u0131n.
\n\u00d6rnek: Server=BILGISAYAR-ADI\\\\SQLEXPRESS<\/p>\nAnaSayfa.cs formunun Load olay\u0131na ekleyin:<\/p>\n
\r\nusing Microsoft.Data.SqlClient;\r\nusing StokYonetimi.Helpers;\r\n\r\nprivate void AnaSayfa_Load(object sender, EventArgs e)\r\n{\r\n try\r\n {\r\n using (var conn = DbHelper.GetConnection())\r\n {\r\n conn.Open();\r\n MessageBox.Show("\u2705 Veritaban\u0131 ba\u011flant\u0131s\u0131 BA\u015eARILI!", "Ba\u011flant\u0131 Testi",\r\n MessageBoxButtons.OK, MessageBoxIcon.Information);\r\n }\r\n }\r\n catch (Exception ex)\r\n {\r\n MessageBox.Show("\u274c Ba\u011flant\u0131 hatas\u0131: " + ex.Message, "Hata",\r\n MessageBoxButtons.OK, MessageBoxIcon.Error);\r\n }\r\n}\r\n\r\n<\/pre>\nAna Sayfa Tasar\u0131m\u0131 (AnaSayfa.cs)<\/p>\n
Ana Sayfa Tasar\u0131m\u0131 (AnaSayfa.cs)
\nDesigner’da \u015fu kontrollar\u0131 ekleyin:<\/p>\nKontrol Name Text
\nLabel lblBaslik STOK Y\u00d6NET\u0130M S\u0130STEM\u0130
\nButton btnUrunler \ud83d\udccb \u00dcr\u00fcn Listesi
\nButton btnEkle \u2795 Yeni \u00dcr\u00fcn Ekle
\nButton btnCikis \ud83d\udeaa \u00c7\u0131k\u0131\u015f
\n\u2705 Saat 2 Kontrol Listesi
\nWinForms projesi olu\u015fturuldu
\nMicrosoft.Data.SqlClient paketi y\u00fcklendi
\nDbHelper.cs olu\u015fturuldu
\nBa\u011flant\u0131 testi ba\u015far\u0131l\u0131
\nAna sayfa tasarland\u0131
\n\u23f1\ufe0f 3. SAAT \u2014 \u00dcr\u00fcn Ekleme Formu
\n\ud83d\udccc Hedef
\nUrunEkleFormu.cs ile veritaban\u0131na yeni \u00fcr\u00fcn eklemek.<\/p>\n\ud83c\udfa8 Form Tasar\u0131m\u0131
\nKontrol Name Text\/\u00d6zellik
\nLabel \u2014 \u00dcr\u00fcn Ad\u0131:
\nTextBox txtUrunAdi \u2014
\nLabel \u2014 Barkod:
\nTextBox txtBarkod \u2014
\nLabel \u2014 Fiyat:
\nTextBox txtFiyat \u2014
\nLabel \u2014 Stok Miktar\u0131:
\nTextBox txtStokMiktari \u2014
\nLabel \u2014 Kategori:
\nComboBox cmbKategori DropDownStyle: DropDownList
\nButton btnKaydet \ud83d\udcbe Kaydet
\nButton btnTemizle \ud83d\uddd1\ufe0f Temizle
\nButton btnIptal \u2716\ufe0f \u0130ptal
\n\ud83d\udcbb UrunEkleFormu.cs \u2014 Tam Kod
\ncsharp
\nusing System;
\nusing System.Windows.Forms;
\nusing Microsoft.Data.SqlClient;
\nusing StokYonetimi.Helpers;
\nnamespace StokYonetimi.Forms
\n{
\npublic partial class UrunEkleFormu : Form
\n{
\npublic UrunEkleFormu()
\n{
\nInitializeComponent();
\n}
\n\/\/ Form a\u00e7\u0131l\u0131rken kategorileri y\u00fckle
\nprivate void UrunEkleFormu_Load(object sender, EventArgs e)
\n{
\nKategorileriYukle();
\n}
\nprivate void KategorileriYukle()
\n{
\ntry
\n{
\nusing (var conn = DbHelper.GetConnection())
\n{
\nconn.Open();
\nstring sql = “SELECT KategoriID, KategoriAdi FROM Kategoriler ORDER BY KategoriAdi”;
\nusing (var cmd = new SqlCommand(sql, conn))
\nusing (var reader = cmd.ExecuteReader())
\n{
\ncmbKategori.Items.Clear();
\nwhile (reader.Read())
\n{
\ncmbKategori.Items.Add(new
\n{
\nID = reader.GetInt32(0),
\nAd = reader.GetString(1)
\n});
\n}
\n}
\n}
\ncmbKategori.DisplayMember = “Ad”;
\ncmbKategori.ValueMember = “ID”;
\n}
\ncatch (Exception ex)
\n{
\nMessageBox.Show(“Kategori y\u00fckleme hatas\u0131: ” + ex.Message, “Hata”,
\nMessageBoxButtons.OK, MessageBoxIcon.Error);
\n}
\n}
\n\/\/ Kaydet butonu
\nprivate void btnKaydet_Click(object sender, EventArgs e)
\n{
\n\/\/ —– Validasyon —–
\nif (string.IsNullOrWhiteSpace(txtUrunAdi.Text))
\n{
\nMessageBox.Show(“\u00dcr\u00fcn ad\u0131 bo\u015f olamaz!”, “Uyar\u0131”,
\nMessageBoxButtons.OK, MessageBoxIcon.Warning);
\ntxtUrunAdi.Focus();
\nreturn;
\n}
\nif (!decimal.TryParse(txtFiyat.Text, out decimal fiyat) || fiyat < 0)
\n{
\nMessageBox.Show(“Ge\u00e7erli bir fiyat girin!”, “Uyar\u0131”,
\nMessageBoxButtons.OK, MessageBoxIcon.Warning);
\ntxtFiyat.Focus();
\nreturn;
\n}
\nif (!int.TryParse(txtStokMiktari.Text, out int stok) || stok < 0)
\n{
\nMessageBox.Show(“Ge\u00e7erli bir stok miktar\u0131 girin!”, “Uyar\u0131”,
\nMessageBoxButtons.OK, MessageBoxIcon.Warning);
\ntxtStokMiktari.Focus();
\nreturn;
\n}
\nif (cmbKategori.SelectedItem == null)
\n{
\nMessageBox.Show(“L\u00fctfen bir kategori se\u00e7in!”, “Uyar\u0131”,
\nMessageBoxButtons.OK, MessageBoxIcon.Warning);
\nreturn;
\n}
\n\/\/ —– Veritaban\u0131na Kaydet —–
\ntry
\n{
\n\/\/ Se\u00e7ilen kategorinin ID’sini al
\ndynamic seciliKategori = cmbKategori.SelectedItem;
\nint kategoriId = seciliKategori.ID;
\nusing (var conn = DbHelper.GetConnection())
\n{
\nconn.Open();
\nstring sql = @”INSERT INTO Urunler
\n(UrunAdi, Barkod, Fiyat, StokMiktari, KategoriID)
\nVALUES
\n(@UrunAdi, @Barkod, @Fiyat, @StokMiktari, @KategoriID)”;
\nusing (var cmd = new SqlCommand(sql, conn))
\n{
\ncmd.Parameters.AddWithValue(“@UrunAdi”, txtUrunAdi.Text.Trim());
\ncmd.Parameters.AddWithValue(“@Barkod”, string.IsNullOrWhiteSpace(txtBarkod.Text)
\n? DBNull.Value
\n: (object)txtBarkod.Text.Trim());
\ncmd.Parameters.AddWithValue(“@Fiyat”, fiyat);
\ncmd.Parameters.AddWithValue(“@StokMiktari”, stok);
\ncmd.Parameters.AddWithValue(“@KategoriID”, kategoriId);
\ncmd.ExecuteNonQuery();
\n}
\n}
\nMessageBox.Show(“\u2705 \u00dcr\u00fcn ba\u015far\u0131yla eklendi!”, “Ba\u015far\u0131l\u0131”,
\nMessageBoxButtons.OK, MessageBoxIcon.Information);
\nFormTemizle();
\n}
\ncatch (SqlException ex) when (ex.Number == 2627) \/\/ Unique constraint (Barkod)
\n{
\nMessageBox.Show(“Bu barkod zaten kay\u0131tl\u0131! Farkl\u0131 bir barkod girin.”, “Hata”,
\nMessageBoxButtons.OK, MessageBoxIcon.Error);
\n}
\ncatch (Exception ex)
\n{
\nMessageBox.Show(“Kay\u0131t hatas\u0131: ” + ex.Message, “Hata”,
\nMessageBoxButtons.OK, MessageBoxIcon.Error);
\n}
\n}
\n\/\/ Temizle butonu
\nprivate void btnTemizle_Click(object sender, EventArgs e)
\n{
\nFormTemizle();
\n}
\nprivate void FormTemizle()
\n{
\ntxtUrunAdi.Clear();
\ntxtBarkod.Clear();
\ntxtFiyat.Clear();
\ntxtStokMiktari.Clear();
\ncmbKategori.SelectedIndex = -1;
\ntxtUrunAdi.Focus();
\n}
\n\/\/ \u0130ptal butonu
\nprivate void btnIptal_Click(object sender, EventArgs e)
\n{
\nthis.Close();
\n}
\n}
\n}
\n\u2705 Saat 3 Kontrol Listesi
\nUrunEkleFormu tasarland\u0131
\nKategoriler ComboBox’a y\u00fckleniyor
\nValidasyonlar \u00e7al\u0131\u015f\u0131yor
\n\u00dcr\u00fcn veritaban\u0131na kaydediliyor
\nBarkod \u00e7ak\u0131\u015fmas\u0131 hatas\u0131 yakalan\u0131yor
\n\u23f1\ufe0f 4. SAAT \u2014 \u00dcr\u00fcnleri Listeleme & Silme
\n\ud83d\udccc Hedef
\nUrunListeFormu.cs ile t\u00fcm \u00fcr\u00fcnleri listelemek ve se\u00e7ilen \u00fcr\u00fcn\u00fc silmek.<\/p>\n\ud83c\udfa8 Form Tasar\u0131m\u0131
\nKontrol Name \u00d6zellik
\nTextBox txtArama PlaceholderText: “\ud83d\udd0d \u00dcr\u00fcn ad\u0131 veya barkod ara…”
\nButton btnAra \ud83d\udd0d Ara
\nButton btnTumunuGoster \ud83d\udccb T\u00fcm\u00fcn\u00fc G\u00f6ster
\nDataGridView dgvUrunler FullRowSelect, ReadOnly
\nButton btnSil \ud83d\uddd1\ufe0f Se\u00e7ileni Sil
\nButton btnDuzenle \u270f\ufe0f D\u00fczenle
\nLabel lblToplamKayit \u2014
\n\ud83d\udcbb UrunListeFormu.cs \u2014 Tam Kod
\ncsharp
\nusing System;
\nusing System.Data;
\nusing System.Windows.Forms;
\nusing Microsoft.Data.SqlClient;
\nusing StokYonetimi.Helpers;
\nnamespace StokYonetimi.Forms
\n{
\npublic partial class UrunListeFormu : Form
\n{
\npublic UrunListeFormu()
\n{
\nInitializeComponent();
\n}
\nprivate void UrunListeFormu_Load(object sender, EventArgs e)
\n{
\nDataGridViewAyarla();
\nUrunleriYukle();
\n}
\n\/\/ DataGridView g\u00f6rsel ayarlar\u0131
\nprivate void DataGridViewAyarla()
\n{
\ndgvUrunler.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
\ndgvUrunler.MultiSelect = false;
\ndgvUrunler.ReadOnly = true;
\ndgvUrunler.AllowUserToAddRows = false;
\ndgvUrunler.AllowUserToDeleteRows = false;
\ndgvUrunler.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
\n}
\n\/\/ T\u00fcm \u00fcr\u00fcnleri y\u00fckle
\nprivate void UrunleriYukle(string aramaMetni = “”)
\n{
\ntry
\n{
\nusing (var conn = DbHelper.GetConnection())
\n{
\nconn.Open();
\nstring sql = @”
\nSELECT
\nu.UrunID AS [ID],
\nu.UrunAdi AS [\u00dcr\u00fcn Ad\u0131],
\nu.Barkod AS [Barkod],
\nk.KategoriAdi AS [Kategori],
\nu.Fiyat AS [Fiyat (\u20ba)],
\nu.StokMiktari AS [Stok],
\nu.EklenmeTarihi AS [Eklenme Tarihi]
\nFROM Urunler u
\nJOIN Kategoriler k ON u.KategoriID = k.KategoriID
\nWHERE u.UrunAdi LIKE @Arama OR u.Barkod LIKE @Arama
\nORDER BY u.UrunAdi”;
\nusing (var cmd = new SqlCommand(sql, conn))
\n{
\ncmd.Parameters.AddWithValue(“@Arama”, “%” + aramaMetni + “%”);
\nvar adapter = new SqlDataAdapter(cmd);
\nvar tablo = new DataTable();
\nadapter.Fill(tablo);
\ndgvUrunler.DataSource = tablo;
\nlblToplamKayit.Text = $”Toplam: {tablo.Rows.Count} kay\u0131t”;
\n}
\n}
\n}
\ncatch (Exception ex)
\n{
\nMessageBox.Show(“Veri y\u00fckleme hatas\u0131: ” + ex.Message, “Hata”,
\nMessageBoxButtons.OK, MessageBoxIcon.Error);
\n}
\n}
\n\/\/ Ara butonu
\nprivate void btnAra_Click(object sender, EventArgs e)
\n{
\nUrunleriYukle(txtArama.Text.Trim());
\n}
\n\/\/ T\u00fcm\u00fcn\u00fc G\u00f6ster butonu
\nprivate void btnTumunuGoster_Click(object sender, EventArgs e)
\n{
\ntxtArama.Clear();
\nUrunleriYukle();
\n}
\n\/\/ Enter tu\u015fuyla arama
\nprivate void txtArama_KeyDown(object sender, KeyEventArgs e)
\n{
\nif (e.KeyCode == Keys.Enter)
\nUrunleriYukle(txtArama.Text.Trim());
\n}
\n\/\/ Sil butonu
\nprivate void btnSil_Click(object sender, EventArgs e)
\n{
\nif (dgvUrunler.SelectedRows.Count == 0)
\n{
\nMessageBox.Show(“L\u00fctfen silmek istedi\u011finiz \u00fcr\u00fcn\u00fc se\u00e7in!”, “Uyar\u0131”,
\nMessageBoxButtons.OK, MessageBoxIcon.Warning);
\nreturn;
\n}
\n\/\/ Se\u00e7ilen sat\u0131rdan ID ve ad\u0131 al
\nvar seciliSatir = dgvUrunler.SelectedRows[0];
\nint urunId = Convert.ToInt32(seciliSatir.Cells[“ID”].Value);
\nstring urunAdi = seciliSatir.Cells[“\u00dcr\u00fcn Ad\u0131”].Value.ToString();
\n\/\/ Onay sor
\nvar sonuc = MessageBox.Show(
\n$”‘{urunAdi}’ \u00fcr\u00fcn\u00fcn\u00fc silmek istedi\u011finizden emin misiniz?”,
\n“Silme Onay\u0131”,
\nMessageBoxButtons.YesNo,
\nMessageBoxIcon.Question);
\nif (sonuc != DialogResult.Yes) return;
\n\/\/ Veritaban\u0131ndan sil
\ntry
\n{
\nusing (var conn = DbHelper.GetConnection())
\n{
\nconn.Open();
\nstring sql = “DELETE FROM Urunler WHERE UrunID = @UrunID”;
\nusing (var cmd = new SqlCommand(sql, conn))
\n{
\ncmd.Parameters.AddWithValue(“@UrunID”, urunId);
\ncmd.ExecuteNonQuery();
\n}
\n}
\nMessageBox.Show(“\u2705 \u00dcr\u00fcn ba\u015far\u0131yla silindi!”, “Ba\u015far\u0131l\u0131”,
\nMessageBoxButtons.OK, MessageBoxIcon.Information);
\nUrunleriYukle(); \/\/ Listeyi yenile
\n}
\ncatch (Exception ex)
\n{
\nMessageBox.Show(“Silme hatas\u0131: ” + ex.Message, “Hata”,
\nMessageBoxButtons.OK, MessageBoxIcon.Error);
\n}
\n}
\n\/\/ D\u00fczenle butonu
\nprivate void btnDuzenle_Click(object sender, EventArgs e)
\n{
\nif (dgvUrunler.SelectedRows.Count == 0)
\n{
\nMessageBox.Show(“L\u00fctfen d\u00fczenlemek istedi\u011finiz \u00fcr\u00fcn\u00fc se\u00e7in!”, “Uyar\u0131”,
\nMessageBoxButtons.OK, MessageBoxIcon.Warning);
\nreturn;
\n}
\nint urunId = Convert.ToInt32(dgvUrunler.SelectedRows[0].Cells[“ID”].Value);
\nvar guncelleFormu = new UrunGuncelleFormu(urunId);
\nguncelleFormu.ShowDialog();
\nUrunleriYukle(); \/\/ G\u00fcncelleme sonras\u0131 listeyi yenile
\n}
\n}
\n}
\n\u2705 Saat 4 Kontrol Listesi
\nDataGridView \u00fcr\u00fcnleri listeliyor
\nArama kutusu \u00e7al\u0131\u015f\u0131yor
\nEnter tu\u015fuyla arama yap\u0131l\u0131yor
\nSilme onay penceresi \u00e7\u0131k\u0131yor
\nSilme sonras\u0131 liste yenileniyor
\n\u23f1\ufe0f 5. SAAT \u2014 \u00dcr\u00fcn G\u00fcncelleme
\n\ud83d\udccc Hedef
\nSe\u00e7ilen \u00fcr\u00fcn\u00fcn bilgilerini d\u00fczenleyip veritaban\u0131n\u0131 g\u00fcncellemek.<\/p>\n\ud83c\udfa8 Form Tasar\u0131m\u0131
\nUrunEkleFormu ile ayn\u0131 kontroller \u2014 sadece ba\u015fl\u0131k ve buton metni farkl\u0131.<\/p>\nKontrol Name A\u00e7\u0131klama
\nTextBox txtUrunAdi \u2014
\nTextBox txtBarkod \u2014
\nTextBox txtFiyat \u2014
\nTextBox txtStokMiktari \u2014
\nComboBox cmbKategori \u2014
\nButton btnGuncelle \ud83d\udcbe G\u00fcncelle
\nButton btnIptal \u2716\ufe0f \u0130ptal
\n\ud83d\udcbb UrunGuncelleFormu.cs \u2014 Tam Kod
\ncsharp
\nusing System;
\nusing System.Windows.Forms;
\nusing Microsoft.Data.SqlClient;
\nusing StokYonetimi.Helpers;
\nnamespace StokYonetimi.Forms
\n{
\npublic partial class UrunGuncelleFormu : Form
\n{
\nprivate readonly int _urunId;
\n\/\/ Constructor: g\u00fcncellenecek \u00fcr\u00fcn\u00fcn ID’si parametre olarak gelir
\npublic UrunGuncelleFormu(int urunId)
\n{
\nInitializeComponent();
\n_urunId = urunId;
\n}
\nprivate void UrunGuncelleFormu_Load(object sender, EventArgs e)
\n{
\nKategorileriYukle();
\nUrunBilgileriniGetir();
\n}
\nprivate void KategorileriYukle()
\n{
\ntry
\n{
\nusing (var conn = DbHelper.GetConnection())
\n{
\nconn.Open();
\nstring sql = “SELECT KategoriID, KategoriAdi FROM Kategoriler ORDER BY KategoriAdi”;
\nusing (var cmd = new SqlCommand(sql, conn))
\nusing (var reader = cmd.ExecuteReader())
\n{
\ncmbKategori.Items.Clear();
\nwhile (reader.Read())
\n{
\ncmbKategori.Items.Add(new
\n{
\nID = reader.GetInt32(0),
\nAd = reader.GetString(1)
\n});
\n}
\n}
\n}
\ncmbKategori.DisplayMember = “Ad”;
\ncmbKategori.ValueMember = “ID”;
\n}
\ncatch (Exception ex)
\n{
\nMessageBox.Show(“Kategori y\u00fckleme hatas\u0131: ” + ex.Message);
\n}
\n}
\n\/\/ Mevcut \u00fcr\u00fcn bilgilerini forma getir
\nprivate void UrunBilgileriniGetir()
\n{
\ntry
\n{
\nusing (var conn = DbHelper.GetConnection())
\n{
\nconn.Open();
\nstring sql = @”SELECT UrunAdi, Barkod, Fiyat, StokMiktari, KategoriID
\nFROM Urunler WHERE UrunID = @UrunID”;
\nusing (var cmd = new SqlCommand(sql, conn))
\n{
\ncmd.Parameters.AddWithValue(“@UrunID”, _urunId);
\nusing (var reader = cmd.ExecuteReader())
\n{
\nif (reader.Read())
\n{
\ntxtUrunAdi.Text = reader[“UrunAdi”].ToString();
\ntxtBarkod.Text = reader[“Barkod”] == DBNull.Value
\n? “” : reader[“Barkod”].ToString();
\ntxtFiyat.Text = reader[“Fiyat”].ToString();
\ntxtStokMiktari.Text = reader[“StokMiktari”].ToString();
\n\/\/ Kategoriye ait ComboBox \u00f6\u011fesini se\u00e7
\nint kategoriId = Convert.ToInt32(reader[“KategoriID”]);
\nfor (int i = 0; i < cmbKategori.Items.Count; i++)
\n{
\ndynamic item = cmbKategori.Items[i];
\nif (item.ID == kategoriId)
\n{
\ncmbKategori.SelectedIndex = i;
\nbreak;
\n}
\n}
\n}
\n}
\n}
\n}
\n}
\ncatch (Exception ex)
\n{
\nMessageBox.Show(“Veri getirme hatas\u0131: ” + ex.Message, “Hata”,
\nMessageBoxButtons.OK, MessageBoxIcon.Error);
\n}
\n}
\n\/\/ G\u00fcncelle butonu
\nprivate void btnGuncelle_Click(object sender, EventArgs e)
\n{
\n\/\/ —– Validasyon —–
\nif (string.IsNullOrWhiteSpace(txtUrunAdi.Text))
\n{
\nMessageBox.Show(“\u00dcr\u00fcn ad\u0131 bo\u015f olamaz!”, “Uyar\u0131”,
\nMessageBoxButtons.OK, MessageBoxIcon.Warning);
\nreturn;
\n}
\nif (!decimal.TryParse(txtFiyat.Text, out decimal fiyat) || fiyat < 0)
\n{
\nMessageBox.Show(“Ge\u00e7erli bir fiyat girin!”, “Uyar\u0131”,
\nMessageBoxButtons.OK, MessageBoxIcon.Warning);
\nreturn;
\n}
\nif (!int.TryParse(txtStokMiktari.Text, out int stok) || stok < 0)
\n{
\nMessageBox.Show(“Ge\u00e7erli bir stok miktar\u0131 girin!”, “Uyar\u0131”,
\nMessageBoxButtons.OK, MessageBoxIcon.Warning);
\nreturn;
\n}
\nif (cmbKategori.SelectedItem == null)
\n{
\nMessageBox.Show(“L\u00fctfen bir kategori se\u00e7in!”, “Uyar\u0131”,
\nMessageBoxButtons.OK, MessageBoxIcon.Warning);
\nreturn;
\n}
\n\/\/ —– Veritaban\u0131n\u0131 G\u00fcncelle —–
\ntry
\n{
\ndynamic seciliKategori = cmbKategori.SelectedItem;
\nint kategoriId = seciliKategori.ID;
\nusing (var conn = DbHelper.GetConnection())
\n{
\nconn.Open();
\nstring sql = @”UPDATE Urunler SET
\nUrunAdi = @UrunAdi,
\nBarkod = @Barkod,
\nFiyat = @Fiyat,
\nStokMiktari = @StokMiktari,
\nKategoriID = @KategoriID
\nWHERE UrunID = @UrunID”;
\nusing (var cmd = new SqlCommand(sql, conn))
\n{
\ncmd.Parameters.AddWithValue(“@UrunAdi”, txtUrunAdi.Text.Trim());
\ncmd.Parameters.AddWithValue(“@Barkod”, string.IsNullOrWhiteSpace(txtBarkod.Text)
\n? DBNull.Value
\n: (object)txtBarkod.Text.Trim());
\ncmd.Parameters.AddWithValue(“@Fiyat”, fiyat);
\ncmd.Parameters.AddWithValue(“@StokMiktari”, stok);
\ncmd.Parameters.AddWithValue(“@KategoriID”, kategoriId);
\ncmd.Parameters.AddWithValue(“@UrunID”, _urunId);
\ncmd.ExecuteNonQuery();
\n}
\n}
\nMessageBox.Show(“\u2705 \u00dcr\u00fcn ba\u015far\u0131yla g\u00fcncellendi!”, “Ba\u015far\u0131l\u0131”,
\nMessageBoxButtons.OK, MessageBoxIcon.Information);
\nthis.Close();
\n}
\ncatch (SqlException ex) when (ex.Number == 2627)
\n{
\nMessageBox.Show(“Bu barkod zaten kay\u0131tl\u0131!”, “Hata”,
\nMessageBoxButtons.OK, MessageBoxIcon.Error);
\n}
\ncatch (Exception ex)
\n{
\nMessageBox.Show(“G\u00fcncelleme hatas\u0131: ” + ex.Message, “Hata”,
\nMessageBoxButtons.OK, MessageBoxIcon.Error);
\n}
\n}
\n\/\/ \u0130ptal butonu
\nprivate void btnIptal_Click(object sender, EventArgs e)
\n{
\nthis.Close();
\n}
\n}
\n}
\n\u2705 Saat 5 Kontrol Listesi
\nG\u00fcncelleme formu a\u00e7\u0131l\u0131yor
\nMevcut \u00fcr\u00fcn bilgileri forma geliyor
\nKategori do\u011fru se\u00e7ili geliyor
\nG\u00fcncelleme veritaban\u0131na yans\u0131yor
\nListe otomatik yenileniyor
\n\u23f1\ufe0f 6. SAAT \u2014 Son Dokunu\u015flar & Test
\n\ud83d\udccc Hedef
\nStok durumuna g\u00f6re renklendirme, kategori bazl\u0131 filtreleme, genel test.<\/p>\n\ud83c\udfa8 \u00d6zellik 1 \u2014 Stok Uyar\u0131s\u0131 (K\u0131rm\u0131z\u0131 Renk)
\nUrunListeFormu.cs’e ekleyin \u2014 DataGridView’in CellFormatting olay\u0131na:<\/p>\ncsharp
\nprivate void dgvUrunler_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
\n{
\nif (e.RowIndex < 0) return;
\nvar satir = dgvUrunler.Rows[e.RowIndex];
\nvar stokHucresi = satir.Cells[“Stok”];
\nif (stokHucresi.Value != null && int.TryParse(stokHucresi.Value.ToString(), out int stok))
\n{
\nif (stok == 0)
\n{
\n\/\/ Stok yok \u2192 k\u0131rm\u0131z\u0131
\nsatir.DefaultCellStyle.BackColor = Color.FromArgb(255, 200, 200);
\nsatir.DefaultCellStyle.ForeColor = Color.DarkRed;
\n}
\nelse if (stok < 5)
\n{
\n\/\/ Stok az \u2192 sar\u0131
\nsatir.DefaultCellStyle.BackColor = Color.FromArgb(255, 255, 180);
\nsatir.DefaultCellStyle.ForeColor = Color.DarkOliveGreen;
\n}
\nelse
\n{
\nsatir.DefaultCellStyle.BackColor = Color.White;
\nsatir.DefaultCellStyle.ForeColor = Color.Black;
\n}
\n}
\n}
\n\ud83d\udcca \u00d6zellik 2 \u2014 Stok \u00d6zet Raporu
\nAna sayfaya veya liste formuna ekleyebilirsiniz:<\/p>\ncsharp
\nprivate void StokRaporuGoster()
\n{
\ntry
\n{
\nusing (var conn = DbHelper.GetConnection())
\n{
\nconn.Open();
\nstring sql = @”
\nSELECT
\nCOUNT(*) AS ToplamUrun,
\nSUM(StokMiktari) AS ToplamStok,
\nCOUNT(CASE WHEN StokMiktari = 0 THEN 1 END) AS TukenenUrun,
\nCOUNT(CASE WHEN StokMiktari < 5 AND StokMiktari > 0 THEN 1 END) AS KritikStok
\nFROM Urunler”;
\nusing (var cmd = new SqlCommand(sql, conn))
\nusing (var reader = cmd.ExecuteReader())
\n{
\nif (reader.Read())
\n{
\nlblToplamUrun.Text = $”Toplam \u00dcr\u00fcn: {reader[“ToplamUrun”]}”;
\nlblToplamStok.Text = $”Toplam Stok: {reader[“ToplamStok”]}”;
\nlblTukenenUrun.Text = $”T\u00fckenen: {reader[“TukenenUrun”]}”;
\nlblKritikStok.Text = $”Kritik Stok: {reader[“KritikStok”]}”;
\n}
\n}
\n}
\n}
\ncatch (Exception ex)
\n{
\nMessageBox.Show(“Rapor hatas\u0131: ” + ex.Message);
\n}
\n}
\n\ud83e\uddea Final Test Senaryolar\u0131
\n# Test Ad\u0131m\u0131 Beklenen Sonu\u00e7
\n1 Uygulama ba\u015flat DB ba\u011flant\u0131s\u0131 ba\u015far\u0131l\u0131
\n2 Yeni \u00fcr\u00fcn ekle (bo\u015f ad ile) “\u00dcr\u00fcn ad\u0131 bo\u015f olamaz!” uyar\u0131s\u0131
\n3 Ayn\u0131 barkodla 2. \u00fcr\u00fcn ekle “Barkod zaten kay\u0131tl\u0131!” hatas\u0131
\n4 Ge\u00e7ersiz fiyat gir (harf) “Ge\u00e7erli bir fiyat girin!” uyar\u0131s\u0131
\n5 \u00dcr\u00fcn ekle (ge\u00e7erli verilerle) “Ba\u015far\u0131yla eklendi!” mesaj\u0131
\n6 Listede \u00fcr\u00fcn\u00fc arayla Sadece e\u015fle\u015fenler gelsin
\n7 \u00dcr\u00fcn\u00fc d\u00fczenle & kaydet Listede de\u011fi\u015fsin
\n8 \u00dcr\u00fcn\u00fc sil (Evet ile) Listeden kalks\u0131n
\n9 \u00dcr\u00fcn\u00fc sil (Hay\u0131r ile) Silinmesin
\n10 Stok=0 olan \u00fcr\u00fcn K\u0131rm\u0131z\u0131 renk g\u00f6sterin
\n\u2705 Saat 6 Kontrol Listesi
\nStok renklendirme \u00e7al\u0131\u015f\u0131yor (k\u0131rm\u0131z\u0131\/sar\u0131\/beyaz)
\nStok raporu do\u011fru say\u0131lar\u0131 g\u00f6steriyor
\nT\u00fcm test senaryolar\u0131 ge\u00e7ti
\nUygulama hatas\u0131z \u00e7al\u0131\u015f\u0131yor
\n\ud83d\udcc1 SQL Script \u2014 H\u0131zl\u0131 Referans
\nsql
\n— T\u00fcm \u00fcr\u00fcnleri listele
\nSELECT u.*, k.KategoriAdi FROM Urunler u JOIN Kategoriler k ON u.KategoriID = k.KategoriID;
\n— T\u00fckenen \u00fcr\u00fcnler
\nSELECT * FROM Urunler WHERE StokMiktari = 0;
\n— Kritik stok (5’ten az)
\nSELECT * FROM Urunler WHERE StokMiktari > 0 AND StokMiktari < 5;
\n— Kategoriye g\u00f6re \u00fcr\u00fcn say\u0131s\u0131
\nSELECT k.KategoriAdi, COUNT(u.UrunID) AS UrunSayisi
\nFROM Kategoriler k LEFT JOIN Urunler u ON k.KategoriID = u.KategoriID
\nGROUP BY k.KategoriAdi;
\n— En pahal\u0131 5 \u00fcr\u00fcn
\nSELECT TOP 5 UrunAdi, Fiyat FROM Urunler ORDER BY Fiyat DESC;
\n\ud83d\udea8 S\u0131k Yap\u0131lan Hatalar & \u00c7\u00f6z\u00fcmleri
\nHata Sebep \u00c7\u00f6z\u00fcm
\nCannot open server Sunucu ad\u0131 yanl\u0131\u015f Connection string’de server ad\u0131n\u0131 kontrol et
\nLogin failed Windows auth \u00e7al\u0131\u015fm\u0131yor Trusted_Connection=True ekle
\nSSL connection error Sertifika sorunu TrustServerCertificate=True ekle
\nObject reference null ComboBox se\u00e7ilmedi SelectedItem == null kontrol\u00fc ekle
\nInput string not in correct format TryParse kullan\u0131lmad\u0131 decimal.TryParse ile kontrol et
\nDuplicate key error Ayn\u0131 barkod SqlException.Number == 2627 yakala<\/p>\n","protected":false},"excerpt":{"rendered":"SQL Server’da StokDB veritaban\u0131n\u0131 ve tablolar\u0131n\u0131 olu\u015fturmak. Kategoriler Urunler ———– ——- KategoriID (PK) \u2190\u2500\u2500 KategoriID (FK) KategoriAdi UrunID (PK) UrunAdi […]<\/p>\n","protected":false},"author":1,"featured_media":2327,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,180],"tags":[],"class_list":["post-2704","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-programlama","category-sql"],"_links":{"self":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2704","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=2704"}],"version-history":[{"count":1,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2704\/revisions"}],"predecessor-version":[{"id":2705,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2704\/revisions\/2705"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/media\/2327"}],"wp:attachment":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/media?parent=2704"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/categories?post=2704"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/tags?post=2704"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}