private void button10_Click(object sender, EventArgs e)
{
a = "guncelleme";
siparisfrm siparis = new siparisfrm();
siparis.button1.Visible = false;
siparis.button2.Location = new Point(312, 102);
siparis.ShowDialog();
}
public void siparissil()
{
DialogResult kayıt = MessageBox.Show("Siparişi silmek istediğinizden emin misiniz ?", "Silme Onayı", MessageBoxButtons.YesNo);
if (DialogResult.Yes == kayıt)
{
siparisfrm ms = (siparisfrm)Application.OpenForms["siparisfrm"];
kmt = new SqlCommand("select adet from urunler where urun=@urun", baglanti);
kmt.Parameters.AddWithValue("@urun", urun);
baglanti.Open();
SqlDataReader hesap = kmt.ExecuteReader();
while (hesap.Read())
{
sonadet = hesap["adet"].ToString();
}
baglanti.Close();
kmt = new SqlCommand("update urunler set adet=@adet where urun=@urun", baglanti);
kmt.Parameters.AddWithValue("@urun", urun);
kmt.Parameters.AddWithValue("@adet", adet + Convert.ToInt16(sonadet));
baglanti.Open();
kmt.ExecuteNonQuery();
baglanti.Close();
kmt = new SqlCommand("delete from siparis where mtc=@tc and id=@id", baglanti);
kmt.Parameters.AddWithValue("@tc", tc);
kmt.Parameters.AddWithValue("@id", id);
baglanti.Open();
kmt.ExecuteNonQuery();
baglanti.Close();
ms.textBox1.Clear();
ms.textBox2.Clear();
ms.textBox3.Clear();
ms.textBox4.Clear();
ms.textBox5.Clear();
ms.textBox7.Clear();
ms.richTextBox1.Clear();
ana.gridsiparisTedilmemis();
ms.comboBox1.Items.Clear();
ms.combobox();
}
}
private void button3_Click(object sender, EventArgs e)
{
try
{
if (musterigrid.SelectedCells.Count > 0)
{
int secilensatir = musterigrid.SelectedCells[0].RowIndex;
if (musterigrid.Rows[secilensatir].IsNewRow == false)
{
tc = musterigrid.Rows[secilensatir].Cells[0].Value.ToString();
baglanti.Open();
SqlCommand kmt = new SqlCommand("select * from musteri where tc=@tc", baglanti);
kmt.Parameters.AddWithValue("@tc", tc);
SqlDataReader okuyucu = kmt.ExecuteReader();
if (okuyucu.Read())
{
tc = okuyucu["tc"].ToString();
ad = okuyucu["adsoyad"].ToString();
tel = okuyucu["tel"].ToString();
bolge = okuyucu["bolge"].ToString();
adres = okuyucu["adres"].ToString();
baglanti.Close();
}
siparisfrm siparis = new siparisfrm();
a = "ekleme";
siparis.button2.Visible = false;
siparis.label4.Visible = false;
siparis.dateTimePicker1.Visible = false;
siparis.ShowDialog();
}
else
{
MessageBox.Show("Müşteri Seçiniz");
}
}
else
{
MessageBox.Show("Müşteri seçmeniz gerekiyor");
}
}
catch { }
}
public void siparisguncelle()
{
siparisfrm ms1 = (siparisfrm)Application.OpenForms["siparisfrm"];
kmt = new SqlCommand(" select *from siparis where mtc=@tc and id=@id", baglanti);
kmt.Parameters.AddWithValue("@tc", tc);
kmt.Parameters.AddWithValue("@id", id);
baglanti.Open();
SqlDataReader hesap = kmt.ExecuteReader();
if (hesap.Read())
{
if (urun == hesap["urun"].ToString())
{
tut = Convert.ToInt32(hesap["adet"].ToString());
baglanti.Close();
baglanti.Open();
SqlCommand kmt3 = new SqlCommand("select adet from urunler where urun=@urun", baglanti);
kmt3.Parameters.AddWithValue("@urun", urun);
SqlDataReader hesap1 = kmt3.ExecuteReader();
if (hesap1.Read())
{
stok = tut + Convert.ToInt32(hesap1["adet"].ToString());
yenistok = stok - (Convert.ToInt16(ms1.textBox5.Text));
}
baglanti.Close();
if (yenistok >= 0)
{
DialogResult kayıt = MessageBox.Show("Siparişi güncellemek istediğinizden emin misiniz ?", "Güncelleme Onayı", MessageBoxButtons.YesNo);
if (DialogResult.Yes == kayıt)
{
siparisfrm ms = (siparisfrm)Application.OpenForms["siparisfrm"];
kmt = new SqlCommand("update siparis set mtc=@tc,urun=@urun,fiyat=@fiyat,adet=@adet where mtc=@tc and id=@id", baglanti);
kmt.Parameters.AddWithValue("@tc", tc);
kmt.Parameters.AddWithValue("@durum", durum);
kmt.Parameters.AddWithValue("@id", id);
kmt.Parameters.AddWithValue("@urun", urun);
kmt.Parameters.AddWithValue("@fiyat", fiyat);
kmt.Parameters.AddWithValue("@adet", adet);
baglanti.Open();
kmt.ExecuteNonQuery();
baglanti.Close();
MessageBox.Show("Sipariş kayıdı başarıyla güncellenmiştir.");
ms.textBox1.Clear();
ms.textBox2.Clear();
ms.textBox3.Clear();
ms.textBox4.Clear();
ms.textBox5.Clear();
ms.textBox7.Clear();
ms.richTextBox1.Clear();
SqlCommand kmt2 = new SqlCommand("update urunler set adet=@adet where urun=@urun", baglanti);
kmt2.Parameters.AddWithValue("@urun", urun);
kmt2.Parameters.AddWithValue("@adet", yenistok);
baglanti.Open();
kmt2.ExecuteNonQuery();
baglanti.Close();
ana.gridsiparisTedilmemis();
ms.comboBox1.Items.Clear();
ms.combobox();
}
}
else
{
MessageBox.Show("Stok yetersiz");
}
}
else
{
baglanti.Close();
SqlCommand kmt1 = new SqlCommand("select adet from urunler where urun=@urun", baglanti);
kmt1.Parameters.AddWithValue("@urun", urun);
baglanti.Open();
SqlDataReader hesap1 = kmt1.ExecuteReader();
if (hesap1.Read() == true)
{
stok = Convert.ToInt32(hesap1["adet"].ToString()) - adet;
baglanti.Close();
if (stok >= 0)
{
DialogResult kayıt = MessageBox.Show("Siparişi kaydetmek istediğinizden emin misiniz ?", "Kaydetme Onayı", MessageBoxButtons.YesNo);
if (DialogResult.Yes == kayıt)
{
siparisfrm ms = (siparisfrm)Application.OpenForms["siparisfrm"];
kmt = new SqlCommand("select adet from urunler where urun=@urun", baglanti);
kmt.Parameters.AddWithValue("@urun", urun2);
baglanti.Open();
SqlDataReader hesap2 = kmt.ExecuteReader();
while (hesap2.Read())
{
sonadet = hesap2["adet"].ToString();
}
baglanti.Close();
kmt = new SqlCommand("update urunler set adet=@adet where urun=@urun", baglanti);
kmt.Parameters.AddWithValue("@urun", urun2);
kmt.Parameters.AddWithValue("@adet", adet2 + Convert.ToInt16(sonadet));
baglanti.Open();
kmt.ExecuteNonQuery();
baglanti.Close();
kmt = new SqlCommand("delete from siparis where mtc=@tc and id=@id", baglanti);
kmt.Parameters.AddWithValue("@tc", tc);
kmt.Parameters.AddWithValue("@id", id);
baglanti.Open();
kmt.ExecuteNonQuery();
baglanti.Close();
kmt = new SqlCommand("insert into siparis(mtc,madsoyad,mtel,mbolge,madres,durum,tarih,urun,fiyat,adet) values (@tc,@ad,@tel,@bolge,@adres,@durum,@tarih,@urun,@fiyat,@adet)", baglanti);
kmt.Parameters.AddWithValue("@tc", tc);
kmt.Parameters.AddWithValue("@ad", adsoyad);
kmt.Parameters.AddWithValue("@tel", tel);
kmt.Parameters.AddWithValue("@bolge", bolge);
kmt.Parameters.AddWithValue("@adres", adres);
kmt.Parameters.AddWithValue("@durum", durum);
kmt.Parameters.AddWithValue("@tarih", tarih);
kmt.Parameters.AddWithValue("@urun", urun);
kmt.Parameters.AddWithValue("@fiyat", fiyat);
kmt.Parameters.AddWithValue("@adet", adet);
baglanti.Open();
kmt.ExecuteNonQuery();
baglanti.Close();
MessageBox.Show("Sipariş kayıdı başarıyla tamamlanmıştır.");
ms.textBox1.Clear();
ms.textBox2.Clear();
ms.textBox3.Clear();
ms.textBox4.Clear();
ms.textBox5.Clear();
ms.textBox7.Clear();
ms.richTextBox1.Clear();
SqlCommand kmt2 = new SqlCommand("update urunler set adet=@adet where urun=@urun", baglanti);
kmt2.Parameters.AddWithValue("@urun", urun);
kmt2.Parameters.AddWithValue("@adet", stok);
baglanti.Open();
kmt2.ExecuteNonQuery();
baglanti.Close();
ana.gridsiparisTedilmemis();
ms.comboBox1.Items.Clear();
ms.combobox();
}
}
else
{
MessageBox.Show("Stok yetersiz");
}
}
else
{
baglanti.Close();
MessageBox.Show("Ürün bulunamadı");
}
}
}
else
{
baglanti.Close();
MessageBox.Show("Sipariş Kaydı bulunamadı");
}
}
