private void btnBuy_Click(object sender, EventArgs e) { BuyProduct buyProduct = new BuyProduct(users, UserIndex); buyProduct.Show(); this.Hide(); }
private void btnTalepOlustur_Click(object sender, EventArgs e) { SqlCommand talepEkle = new SqlCommand("insert into TalepEdilenUrunler (TalepEdenId,UrunAdi,UrunFiyati,UrunBirimi) values (@p1,@p2,@p3,@p4)", sqlConnect.Connection()); talepEkle.Parameters.AddWithValue("@p1", UserIndex + 1); talepEkle.Parameters.AddWithValue("@p2", cmbUrunTipi.SelectedItem); talepEkle.Parameters.AddWithValue("@p3", txtBirimFiyati.Text); talepEkle.Parameters.AddWithValue("@p4", txtUrunMiktar.Text); talepEkle.ExecuteNonQuery(); sqlConnect.Connection().Close(); MessageBox.Show("Talebiniz başarıyla alınmıştır!"); BuyProduct buyProduct = new BuyProduct(users, UserIndex); buyProduct.Show(); this.Hide(); }
private void btnSatinAl_Click(object sender, EventArgs e) { int istenenUrunBirimi = Convert.ToInt32(txtUrunMiktar.Text); int kucukFiyat = 5000; int secilenUrunBirimi = 0; int a = 0, b = 0; int urunSahibiIndex; while (istenenUrunBirimi > 0) { b = 0; foreach (var product in products) { if (products[b].UrunAdi == Convert.ToString(cmbUrunTipi.SelectedItem) && Convert.ToInt32(products[b].UrunFiyati) < kucukFiyat && Convert.ToInt32(products[b].UrunBirimi) > 0) { kucukFiyat = Convert.ToInt32(products[b].UrunFiyati); secilenUrunBirimi = Convert.ToInt32(products[b].UrunBirimi); a = b; } b++; } urunSahibiIndex = Convert.ToInt32(products[a].UrunSahibiId) - 1; if (Convert.ToInt32(users[UserIndex].GuncelBakiye) >= Convert.ToInt32(lblFiyat.Text)) { users[UserIndex].GuncelBakiye = Convert.ToString(Convert.ToInt32(users[UserIndex].GuncelBakiye) - Convert.ToInt32(lblFiyat.Text)); SqlCommand buyerWallet = new SqlCommand("update KullaniciBilgileri SET GuncelBakiye=@p1 where ıd=@p2", sqlConnect.Connection()); buyerWallet.Parameters.AddWithValue("@p1", users[UserIndex].GuncelBakiye); buyerWallet.Parameters.AddWithValue("@p2", UserIndex + 1); buyerWallet.ExecuteNonQuery(); sqlConnect.Connection().Close(); users[urunSahibiIndex].GuncelBakiye = Convert.ToString(Convert.ToInt32(users[urunSahibiIndex].GuncelBakiye) + Convert.ToInt32(lblFiyat.Text)); SqlCommand sellerWallet = new SqlCommand("update KullaniciBilgileri SET GuncelBakiye=@p1 where ıd=@p2", sqlConnect.Connection()); sellerWallet.Parameters.AddWithValue("@p1", users[urunSahibiIndex].GuncelBakiye); sellerWallet.Parameters.AddWithValue("@p2", urunSahibiIndex + 1); sellerWallet.ExecuteNonQuery(); sqlConnect.Connection().Close(); if (istenenUrunBirimi <= secilenUrunBirimi) { istenenUrunBirimiYedek = istenenUrunBirimi; istenenUrunBirimi = istenenUrunBirimi - secilenUrunBirimi; products[a].UrunBirimi = Convert.ToString(Convert.ToInt32(products[a].UrunBirimi) - istenenUrunBirimiYedek); SqlCommand buyProductUnit = new SqlCommand("update Urunler SET UrunBirimi=@p1 where UrunId=@p2", sqlConnect.Connection()); buyProductUnit.Parameters.AddWithValue("@p1", products[a].UrunBirimi); buyProductUnit.Parameters.AddWithValue("@p2", products[a].UrunId); buyProductUnit.ExecuteNonQuery(); sqlConnect.Connection().Close(); SqlCommand gecmiseEkle = new SqlCommand("insert into SatinAlmaGecmisi (Tarih,UrunAdi,UrunAliciId,UrunFiyati,UrunBirimi,UrunId,UrunSaticiId) values (@p1,@p2,@p3,@p4,@p5,@p6,@p7)", sqlConnect.Connection()); gecmiseEkle.Parameters.AddWithValue("@p1", DateTime.Now.ToShortDateString()); gecmiseEkle.Parameters.AddWithValue("@p2", products[a].UrunAdi); gecmiseEkle.Parameters.AddWithValue("@p3", UserIndex + 1); gecmiseEkle.Parameters.AddWithValue("@p4", kucukFiyat); gecmiseEkle.Parameters.AddWithValue("@p5", istenenUrunBirimiYedek); gecmiseEkle.Parameters.AddWithValue("@p6", products[a].UrunId); gecmiseEkle.Parameters.AddWithValue("@p7", urunSahibiIndex + 1); gecmiseEkle.ExecuteNonQuery(); sqlConnect.Connection().Close(); break; } else if (istenenUrunBirimi > secilenUrunBirimi) { istenenUrunBirimi = istenenUrunBirimi - secilenUrunBirimi; products[a].UrunBirimi = "0"; SqlCommand buyProductUnit = new SqlCommand("update Urunler SET UrunBirimi=@p1 where UrunId=@p2", sqlConnect.Connection()); buyProductUnit.Parameters.AddWithValue("@p1", products[a].UrunBirimi); buyProductUnit.Parameters.AddWithValue("@p2", products[a].UrunId); buyProductUnit.ExecuteNonQuery(); sqlConnect.Connection().Close(); SqlCommand gecmiseEkle = new SqlCommand("insert into SatinAlmaGecmisi (Tarih,UrunAdi,UrunAliciId,UrunFiyati,UrunBirimi,UrunId,UrunSaticiId) values (@p1,@p2,@p3,@p4,@p5,@p6,@p7)", sqlConnect.Connection()); gecmiseEkle.Parameters.AddWithValue("@p1", DateTime.Now.ToShortDateString()); gecmiseEkle.Parameters.AddWithValue("@p2", products[a].UrunAdi); gecmiseEkle.Parameters.AddWithValue("@p3", UserIndex + 1); gecmiseEkle.Parameters.AddWithValue("@p4", kucukFiyat); gecmiseEkle.Parameters.AddWithValue("@p5", istenenUrunBirimiYedek); gecmiseEkle.Parameters.AddWithValue("@p6", products[a].UrunId); gecmiseEkle.Parameters.AddWithValue("@p7", urunSahibiIndex + 1); gecmiseEkle.ExecuteNonQuery(); sqlConnect.Connection().Close(); } kucukFiyat = 5000; } else { MessageBox.Show("Yeterli Bakiyeniz bulunmamaktadır!"); BuyProduct buyProduct = new BuyProduct(users, UserIndex); buyProduct.Show(); this.Hide(); break; } } BuyProduct buyProduct1 = new BuyProduct(users, UserIndex); buyProduct1.Show(); this.Hide(); }