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