private void button5_Click(object sender, EventArgs e)
{
if (dataGridView1.Rows.Count <= 0)
{
MessageBox.Show("Tidak ada data untuk di simpan", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
db_Form_Penjualan_Grosir fpg = new db_Form_Penjualan_Grosir()
{
No_Form_Penjualan_Grosir = textBox6.Text,
ID_Karyawan = textBox1.Text,
ID_Pelanggan = textBox12.Text,
Tanggal = dateTimePicker1.Text,
};
db.AddTodb_Form_Penjualan_Grosir(fpg);
db.SaveChanges();
for (int i = 0; i < dataGridView1.RowCount; i++)
{
string ih = "";
string ah = "";
int h = 0, l = 0;
try
{
ih = dataGridView1.Rows[i].Cells[2].Value.ToString();
h = int.Parse(dataGridView1.Rows[i].Cells[4].Value.ToString());
l = int.Parse(dataGridView1.Rows[i].Cells[5].Value.ToString());
ah = dataGridView1.Rows[i].Cells[3].Value.ToString();
}
catch (Exception) { }
db_Detail_Form_Penjualan_Grosir dt = new db_Detail_Form_Penjualan_Grosir()
{
No_Form_Penjualan_Grosir = textBox6.Text,
ID_Barang = ih,
Harga = h,
Jumlah = l,
Nama_Barang = ah
};
db.AddTodb_Detail_Form_Penjualan_Grosir(dt);
db.SaveChanges();
try
{
var up = (from a in db.db_Barang where a.ID_Barang == ih select a).FirstOrDefault();
if (up.Stock != null)
{
up.Stock = up.Stock - l;
db.SaveChanges();
if (up.Stock <= 200)
{
MessageBox.Show("Stock " + dataGridView1.Rows[i].Cells[3].Value.ToString() + " mulai menipis, harap segera buat Faktur Pemesanan! ", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception) { }
}
var te = (from a in db.db_Pelanggan where a.ID_Pelanggan == textBox12.Text select a).First();
if (te.Count < 3)
{
te.Count += 1;
}
db.SaveChanges();
if (total >= 1000000)
{
te.Count = 3;
}
db.SaveChanges();
MessageBox.Show("Transaksi berhasil", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
button4.Enabled = false;
button5.Enabled = false;
button6.Enabled = false;
id = textBox6.Text;
idkaryawan = textBox1.Text;
}
}
