private void listView1_DoubleClick(object sender, EventArgs e) { satis satis = new satis(); satis.idyiBulVeGetir = int.Parse(listView1.SelectedItems[0].SubItems[0].Text); satis.adiBulVeGetir = listView1.SelectedItems[0].SubItems[1].Text; this.Close(); }
private void button1_Click(object sender, EventArgs e) { satis satis = (satis)Application.OpenForms["satis"]; decimal tfiyat = 0; for (int i = 0; i < dataGridView2.Rows.Count; i++) { int id = Convert.ToInt32(dataGridView2.Rows[i].Cells[0].Value); int musterikodu = Convert.ToInt32(dataGridView2.Rows[i].Cells[1].Value); string barkod = dataGridView2.Rows[i].Cells[2].Value.ToString(); string urunAciklamasi = dataGridView2.Rows[i].Cells[3].Value.ToString(); decimal fiyat = Convert.ToDecimal(dataGridView2.Rows[i].Cells[4].Value.ToString()); tfiyat = tfiyat + fiyat; string odemeSekli = dataGridView2.Rows[i].Cells[5].Value.ToString(); DateTime tarih = Convert.ToDateTime(dataGridView2.Rows[i].Cells[6].Value); satis.groupBoxdegisim.Visible = true; satis.dataGridView2.Rows.Add(id, musterikodu, barkod, urunAciklamasi, fiyat, odemeSekli, tarih); } satis.degisecekurunfiyati.Text = tfiyat.ToString(); decimal odenecektutar = Convert.ToDecimal(satis.lblFiyat.Text) - tfiyat; satis.odenecektutar.Text = odenecektutar.ToString(); this.Close(); }
private void button2_Click(object sender, EventArgs e) { OleDbConnection baglan = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=veritabani.xlsx; Extended Properties='Excel 12.0 xml;HDR=YES;'"); if (groupBoxdegisim.Visible == false) { if (txtMusteri_adi.Text != "" && textMusteriID.Text != "") { string odemesekli = ""; string kartturu = ""; if (radioButton1.Checked) { odemesekli = "kk"; kartturu = comboBox1.Text; odemesekli = odemesekli + " " + kartturu; } else if (radioButton2.Checked) { odemesekli = "n"; } else { odemesekli = ""; } if (odemesekli != "") { try { progressBar1.Visible = true; progressBar1.Value += 15; baglan.Open(); OleDbDataAdapter idbul = new OleDbDataAdapter("Select MAX(ID) AS ID From [satış$]", baglan); DataTable id = new DataTable(); idbul.Fill(id); int ID = Convert.ToInt32(id.Rows[0]["ID"].ToString()); ID++; progressBar1.Value += 15; for (int i = 0; i < dataGridView1.Rows.Count - 1; i++) { ID++; Int64 BarkodNOO = Convert.ToInt64(dataGridView1.Rows[i].Cells[0].Value); int musteriID = Convert.ToInt32(textMusteriID.Text); decimal Fiyati = Convert.ToDecimal(dataGridView1.Rows[i].Cells[2].Value); DateTime zaman = DateTime.Now; string saat = DateTime.Now.ToShortTimeString(); OleDbCommand komut = new OleDbCommand("INSERT INTO [satış$] (ID, BARKOD_NO, MÜŞTERİ_ID, FİYAT, ÖDEME_ŞEKLİ , TARİH) VALUES(@ID, @BarkodNOO, @musteriID, '" + Fiyati + "', @odemesekli, @zaman)", baglan); komut.Parameters.AddWithValue("@ID", ID); komut.Parameters.AddWithValue("@BarkodNOO", BarkodNOO); komut.Parameters.AddWithValue("@musteriID", musteriID); komut.Parameters.AddWithValue("@odemesekli", odemesekli); komut.Parameters.AddWithValue("@zaman", GetDateWithoutMilliseconds(DateTime.Now)); komut.ExecuteNonQuery(); } progressBar1.Value += 60; for (int i = 0; i < dataGridView1.Rows.Count - 1; i++) { Int64 BarkodNOO = Convert.ToInt64(dataGridView1.Rows[i].Cells[0].Value); OleDbDataAdapter da = new OleDbDataAdapter("SELECT ADET FROM [normal$] WHERE BARKOD_NO=" + BarkodNOO + "", baglan); DataTable dtable = new DataTable(); da.Fill(dtable); if (dtable.Rows.Count == 1) { int adet = Convert.ToInt32(dtable.Rows[0]["ADET"].ToString()); adet = adet - 1; OleDbCommand komut3 = new OleDbCommand("UPDATE [normal$] SET ADET =" + adet + " WHERE BARKOD_NO=" + BarkodNOO + "", baglan); komut3.ExecuteNonQuery(); } else if (dtable.Rows.Count == 0) { OleDbDataAdapter daa = new OleDbDataAdapter("SELECT ADET FROM [indirimli$] WHERE BARKOD_NO=" + BarkodNOO + "", baglan); DataTable dttable = new DataTable(); daa.Fill(dttable); int adet = Convert.ToInt32(dttable.Rows[0]["ADET"].ToString()); adet = adet - 1; OleDbCommand komut3 = new OleDbCommand("UPDATE [indirimli$] SET ADET =" + adet + " WHERE BARKOD_NO=" + BarkodNOO + "", baglan); komut3.ExecuteNonQuery(); } } progressBar1.Value += 10; MessageBox.Show("Başarılı"); } catch (Exception hata) { MessageBox.Show("Kayıt edilmedi " + hata.Message); } finally { progressBar1.Visible = false; progressBar1.Value = 0; baglan.Close(); } this.Hide(); yeniSatisform = new satis(); yeniSatisform.FormClosing += yeniSatisform_FormClosing; yeniSatisform.ShowDialog(); } else { MessageBox.Show("ÖDEME ŞEKLİ BOŞ OLAMAZ", "ÖDEME ŞEKLİ"); } } else { MessageBox.Show("Müşteri Girilmedi", "Hata"); } } else//değişim { string odemesekli = ""; string kartturu = ""; if (radioButton1.Checked) { odemesekli = "kk"; kartturu = comboBox1.Text; odemesekli = odemesekli + " " + kartturu; } else if (radioButton2.Checked) { odemesekli = "n"; } else { odemesekli = ""; } if (odemesekli != "") { try { baglan.Open(); OleDbDataAdapter idbul = new OleDbDataAdapter("Select MAX(ID) AS ID From [satış$]", baglan); DataTable id = new DataTable(); idbul.Fill(id); int ID = Convert.ToInt32(id.Rows[0]["ID"].ToString()); ID++; for (int i = 0; i < dataGridView1.Rows.Count - 1; i++) { ID++; Int64 BarkodNOO = Convert.ToInt64(dataGridView1.Rows[i].Cells[0].Value); int musteriID = Convert.ToInt32(textMusteriID.Text); decimal Fiyati = Convert.ToDecimal(dataGridView1.Rows[i].Cells[2].Value); DateTime zaman = DateTime.Now; string saat = DateTime.Now.ToShortTimeString(); OleDbCommand komut = new OleDbCommand("INSERT INTO [satış$] (ID, BARKOD_NO, MÜŞTERİ_ID, FİYAT, ÖDEME_ŞEKLİ , TARİH) VALUES(@ID, @BarkodNOO, @musteriID, '" + Fiyati + "', @odemesekli, @zaman)", baglan); komut.Parameters.AddWithValue("@ID", ID); komut.Parameters.AddWithValue("@BarkodNOO", BarkodNOO); komut.Parameters.AddWithValue("@musteriID", musteriID); komut.Parameters.AddWithValue("@odemesekli", odemesekli); komut.Parameters.AddWithValue("@zaman", GetDateWithoutMilliseconds(DateTime.Now)); komut.ExecuteNonQuery(); } for (int i = 0; i < dataGridView1.Rows.Count - 1; i++) { Int64 BarkodNOO = Convert.ToInt64(dataGridView1.Rows[i].Cells[0].Value); OleDbDataAdapter da = new OleDbDataAdapter("SELECT ADET FROM [normal$] WHERE BARKOD_NO=" + BarkodNOO + "", baglan); DataTable dtable = new DataTable(); da.Fill(dtable); if (dtable.Rows.Count == 1) { int adet = Convert.ToInt32(dtable.Rows[0]["ADET"].ToString()); adet = adet - 1; OleDbCommand komut3 = new OleDbCommand("UPDATE [normal$] SET ADET =" + adet + " WHERE BARKOD_NO=" + BarkodNOO + "", baglan); komut3.ExecuteNonQuery(); } else if (dtable.Rows.Count == 0) { OleDbDataAdapter daa = new OleDbDataAdapter("SELECT ADET FROM [indirimli$] WHERE BARKOD_NO=" + BarkodNOO + "", baglan); DataTable dttable = new DataTable(); daa.Fill(dttable); int adet = Convert.ToInt32(dttable.Rows[0]["ADET"].ToString()); adet = adet - 1; OleDbCommand komut3 = new OleDbCommand("UPDATE [indirimli$] SET ADET =" + adet + " WHERE BARKOD_NO=" + BarkodNOO + "", baglan); komut3.ExecuteNonQuery(); } } //normal işlemler bitiş //eski ürünlere stok ekleme for (int i = 0; i < dataGridView2.Rows.Count; i++) { Int64 barkodnumarasi = Convert.ToInt64(dataGridView2.Rows[i].Cells[2].Value); OleDbCommand komutsil = new OleDbCommand("UPDATE [satış$] SET FİYAT = 0 WHERE BARKOD_NO='" + barkodnumarasi + "'", baglan);//fiyatı silme komutsil.ExecuteNonQuery(); OleDbDataAdapter da = new OleDbDataAdapter("SELECT ADET FROM [normal$] WHERE BARKOD_NO=" + barkodnumarasi + "", baglan); DataTable dtable = new DataTable(); da.Fill(dtable); if (dtable.Rows.Count == 1) { int adet = Convert.ToInt32(dtable.Rows[0]["ADET"].ToString()); adet = adet + 1; OleDbCommand komut3 = new OleDbCommand("UPDATE [normal$] SET ADET =" + adet + " WHERE BARKOD_NO=" + barkodnumarasi + "", baglan); komut3.ExecuteNonQuery(); } else if (dtable.Rows.Count == 0) { OleDbDataAdapter daa = new OleDbDataAdapter("SELECT ADET FROM [indirimli$] WHERE BARKOD_NO=" + barkodnumarasi + "", baglan); DataTable dttable = new DataTable(); daa.Fill(dttable); int adet = Convert.ToInt32(dttable.Rows[0]["ADET"].ToString()); adet = adet + 1; OleDbCommand komut3 = new OleDbCommand("UPDATE [indirimli$] SET ADET =" + adet + " WHERE BARKOD_NO=" + barkodnumarasi + "", baglan); komut3.ExecuteNonQuery(); } } MessageBox.Show("Başarılı"); this.Hide(); yeniSatisform = new satis(); yeniSatisform.FormClosing += yeniSatisform_FormClosing; yeniSatisform.ShowDialog(); } catch (Exception hata) { MessageBox.Show("Kayıt edilmedi" + hata.Message); } finally { baglan.Close(); } } else { MessageBox.Show("ÖDEME ŞEKLİ BOŞ OLAMAZ", "ÖDEME ŞEKLİ"); } } }