private void btnGiris_Click(object sender, EventArgs e)
{
UserManager userManager = new UserManager();
List <User> users = new List <User>();
users = userManager.GetList();
AdminManager adminManager = new AdminManager();
List <Admin> admins = new List <Admin>();
admins = adminManager.GetList();
AccountingManager accountingManager = new AccountingManager();
List <Accounting> accountings = new List <Accounting>();
accountings = accountingManager.GetList();
int i = 0;
foreach (var admin in admins)
{
if (txtKullaniciAdi.Text == admin.AdminTcNo && txtSifre.Text == admin.AdminSifre)
{
AdminForm adminForm = new AdminForm(users, i);
adminForm.Show();
this.Hide();
}
i++;
}
i = 0;
foreach (var user in users)
{
if (txtKullaniciAdi.Text == user.KullaniciAdi && txtSifre.Text == user.Sifre)
{
UserForm userForm = new UserForm(users, i);
userForm.Show();
this.Hide();
}
i++;
}
i = 0;
foreach (var account in accountings)
{
if (txtKullaniciAdi.Text == account.KullaniciAdi && txtSifre.Text == account.Sifre)
{
AccountingForm accountingForm = new AccountingForm(accountings, i);
accountingForm.Show();
this.Hide();
}
i++;
}
}
private void btnOnayla_Click(object sender, EventArgs e)
{
accountings = accountingManager.GetList();
demandedProducts = demandedProductManager.GetList();
int secilen = dataGridView1.SelectedCells[0].RowIndex;
int urunId = Convert.ToInt32(dataGridView1.Rows[secilen].Cells[4].Value.ToString());
SqlCommand komutUrunOnayla = new SqlCommand("Update Urunler SET UrunOnay=@p1,EskiUrunBirimi=@p2,EskiUrunFiyati=@p3 where UrunId=@p4", sqlConnect.Connection());
komutUrunOnayla.Parameters.AddWithValue("@p1", true);
komutUrunOnayla.Parameters.AddWithValue("@p2", 0);
komutUrunOnayla.Parameters.AddWithValue("@p3", 0);
komutUrunOnayla.Parameters.AddWithValue("@p4", urunId);
komutUrunOnayla.ExecuteNonQuery();
sqlConnect.Connection().Close();
MessageBox.Show("Ürün onaylama işlemi başarıyla gerçekleştirildi!");
products = productManager.GetList();
int secilenUrunBirimi = Convert.ToInt32(dataGridView1.Rows[secilen].Cells[2].Value.ToString());
decimal secilenUrunFiyati = Convert.ToDecimal(dataGridView1.Rows[secilen].Cells[3].Value.ToString());
decimal toplamFiyat;
int urunSahibiIndex = Convert.ToInt32(dataGridView1.Rows[secilen].Cells[0].Value.ToString());
string UrunAdi = dataGridView1.Rows[secilen].Cells[1].Value.ToString();
int a = Convert.ToInt32(dataGridView1.Rows[secilen].Cells[4].Value.ToString()) - 1;
foreach (var demanded in demandedProducts)
{
if (demanded.UrunFiyati >= secilenUrunFiyati && demanded.UrunAdi == UrunAdi && Convert.ToInt32(demanded.UrunBirimi) <= secilenUrunBirimi)
{
toplamFiyat = Convert.ToDecimal(demanded.UrunBirimi) * secilenUrunFiyati;
if (users[Convert.ToInt32(demanded.TalepEdenId) - 1].GuncelBakiye >= toplamFiyat)
{
accountings[0].MuhasebeBakiye = accountings[0].MuhasebeBakiye + (toplamFiyat / 100);
MessageBox.Show("Test: " + accountings[0].MuhasebeBakiye);
SqlCommand accountingWallet = new SqlCommand("update Muhasebe SET MuhasebeBakiye=@p1 where MuhasebeId=@p2", sqlConnect.Connection());
accountingWallet.Parameters.AddWithValue("@p1", Convert.ToString(accountings[0].MuhasebeBakiye));
accountingWallet.Parameters.AddWithValue("@p2", 1);
accountingWallet.ExecuteNonQuery();
sqlConnect.Connection().Close();
users[Convert.ToInt32(demanded.TalepEdenId) - 1].GuncelBakiye = users[Convert.ToInt32(demanded.TalepEdenId) - 1].GuncelBakiye - toplamFiyat - (toplamFiyat);
SqlCommand buyerWallet = new SqlCommand("update KullaniciBilgileri SET GuncelBakiye=@p1 where ıd=@p2", sqlConnect.Connection());
buyerWallet.Parameters.AddWithValue("@p1", Convert.ToString(users[Convert.ToInt32(demanded.TalepEdenId) - 1].GuncelBakiye));
buyerWallet.Parameters.AddWithValue("@p2", demanded.TalepEdenId);
buyerWallet.ExecuteNonQuery();
sqlConnect.Connection().Close();
users[urunSahibiIndex - 1].GuncelBakiye = users[urunSahibiIndex - 1].GuncelBakiye + toplamFiyat;
SqlCommand sellerWallet = new SqlCommand("update KullaniciBilgileri SET GuncelBakiye=@p1 where ıd=@p2", sqlConnect.Connection());
sellerWallet.Parameters.AddWithValue("@p1", Convert.ToString(users[urunSahibiIndex - 1].GuncelBakiye));
sellerWallet.Parameters.AddWithValue("@p2", urunSahibiIndex);
sellerWallet.ExecuteNonQuery();
sqlConnect.Connection().Close();
int demandedUrunBirimiYedek;
if (Convert.ToInt32(demanded.UrunBirimi) <= secilenUrunBirimi && Convert.ToInt32(demanded.UrunBirimi) > 0)
{
demandedUrunBirimiYedek = Convert.ToInt32(demanded.UrunBirimi);
demanded.UrunBirimi = Convert.ToString(Convert.ToInt32(demanded.UrunBirimi) - Convert.ToInt32(secilenUrunBirimi));
products[a].UrunBirimi = Convert.ToString(Convert.ToInt32(products[a].UrunBirimi) - demandedUrunBirimiYedek);
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", Convert.ToString(demanded.UrunFiyati));
gecmiseEkle.Parameters.AddWithValue("@p5", demandedUrunBirimiYedek);
gecmiseEkle.Parameters.AddWithValue("@p6", products[a].UrunId);
gecmiseEkle.Parameters.AddWithValue("@p7", urunSahibiIndex + 1);
gecmiseEkle.ExecuteNonQuery();
sqlConnect.Connection().Close();
if (Convert.ToInt32(demanded.UrunBirimi) < 0)
{
demanded.UrunBirimi = "0";
}
SqlCommand urunGuncelle = new SqlCommand("update TalepEdilenUrunler SET UrunBirimi=@p1 where TalepEdilenUrunId=@p2", sqlConnect.Connection());
urunGuncelle.Parameters.AddWithValue("@p1", demanded.UrunBirimi);
urunGuncelle.Parameters.AddWithValue("@p2", demanded.TalepEdilenUrunId);
urunGuncelle.ExecuteNonQuery();
sqlConnect.Connection().Close();
break;
}
}
else
{
break;
}
}
}
}
private void btnSatinAl_Click(object sender, EventArgs e)
{
accountings = accountingManager.GetList();
int istenenUrunBirimi = Convert.ToInt32(txtUrunMiktar.Text);
decimal 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) && (products[b].UrunFiyati) < kucukFiyat && Convert.ToInt32(products[b].UrunBirimi) > 0)
{
kucukFiyat = products[b].UrunFiyati;
secilenUrunBirimi = Convert.ToInt32(products[b].UrunBirimi);
a = b;
}
b++;
}
urunSahibiIndex = Convert.ToInt32(products[a].UrunSahibiId) - 1;
if (users[UserIndex].GuncelBakiye >= Convert.ToDecimal(lblFiyat.Text))
{
accountings[0].MuhasebeBakiye = accountings[0].MuhasebeBakiye + (Convert.ToDecimal(lblFiyat.Text) / 100);
SqlCommand accountingWallet = new SqlCommand("update Muhasebe SET MuhasebeBakiye=@p1 where MuhasebeId=@p2", sqlConnect.Connection());
accountingWallet.Parameters.AddWithValue("@p1", Convert.ToString(accountings[0].MuhasebeBakiye));
accountingWallet.Parameters.AddWithValue("@p2", 1);
accountingWallet.ExecuteNonQuery();
sqlConnect.Connection().Close();
users[UserIndex].GuncelBakiye = (users[UserIndex].GuncelBakiye) - Convert.ToDecimal(lblFiyat.Text) - (Convert.ToDecimal(lblFiyat.Text) / 100);
SqlCommand buyerWallet = new SqlCommand("update KullaniciBilgileri SET GuncelBakiye=@p1 where ıd=@p2", sqlConnect.Connection());
buyerWallet.Parameters.AddWithValue("@p1", Convert.ToString(users[UserIndex].GuncelBakiye));
buyerWallet.Parameters.AddWithValue("@p2", UserIndex + 1);
buyerWallet.ExecuteNonQuery();
sqlConnect.Connection().Close();
users[urunSahibiIndex].GuncelBakiye = (users[urunSahibiIndex].GuncelBakiye) + Convert.ToDecimal(lblFiyat.Text);
SqlCommand sellerWallet = new SqlCommand("update KullaniciBilgileri SET GuncelBakiye=@p1 where ıd=@p2", sqlConnect.Connection());
sellerWallet.Parameters.AddWithValue("@p1", Convert.ToString(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", Convert.ToString(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", Convert.ToString(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();
}