private void button2_Click(object sender, EventArgs e)
{
if (dataGridViewDetail.Rows.Count <= 0)
{
MessageBox.Show("Belum ada barang yang di retur", "Warning!", MessageBoxButtons.OK);
}
else
{
string tampID = "";
if (status == "FRJ")
{
try
{
tampID = listBoxID.Text;
db_Retur_Pembelian frpem = new db_Retur_Pembelian()
{
No_Retur_Pembelian = labelID.Text,
No_Retur_Penjualan = tampID,
No_Faktur_Pemesanan = "",
Tanggal = dateTimePicker3.Text,
};
db.AddTodb_Retur_Pembelian(frpem);
db.SaveChanges();
for (int i = 0; i < dataGridViewDetail.RowCount; i++)
{
string ih = "";
string ah = "";
int h = 0;
string eh = "";
try
{
ih = dataGridViewDetail.Rows[i].Cells[0].Value.ToString();
ah = dataGridViewDetail.Rows[i].Cells[1].Value.ToString();
h = int.Parse(dataGridViewDetail.Rows[i].Cells[2].Value.ToString());
eh = dataGridViewDetail.Rows[i].Cells[3].Value.ToString();
}
catch (Exception) { }
db_Detail_Retur_Pembelian dd = new db_Detail_Retur_Pembelian()
{
No_Retur_Pembelian = labelID.Text,
ID_Barang = ih,
Jumlah = h,
Deskripsi = eh,
Nama_Barang = ah,
};
db.AddTodb_Detail_Retur_Pembelian(dd);
db.SaveChanges();
//var t = (from a in db.db_Detail_Retur_Penjualan where a.No_Retur_Penjualan == tampID && a.ID_Barang ==ih select a).First();
//t.Jumlah = t.Jumlah - h;
//db.SaveChanges();
}
}
catch (Exception) { }
}
else if (status == "FPE")
{
try
{
tampID = listBoxID.Text;
db_Retur_Pembelian frpem = new db_Retur_Pembelian()
{
No_Retur_Pembelian = labelID.Text,
No_Retur_Penjualan = "",
No_Faktur_Pemesanan = tampID,
Tanggal = dateTimePicker3.Text,
};
db.AddTodb_Retur_Pembelian(frpem);
db.SaveChanges();
for (int i = 0; i < dataGridViewDetail.RowCount; i++)
{
string ih = "";
string ah = "";
int h = 0;
string eh = "";
try
{
ih = dataGridViewDetail.Rows[i].Cells[0].Value.ToString();
ah = dataGridViewDetail.Rows[i].Cells[1].Value.ToString();
h = int.Parse(dataGridViewDetail.Rows[i].Cells[2].Value.ToString());
eh = dataGridViewDetail.Rows[i].Cells[3].Value.ToString();
}
catch (Exception) { }
db_Detail_Retur_Pembelian dt = new db_Detail_Retur_Pembelian()
{
No_Retur_Pembelian = labelID.Text,
ID_Barang = ih,
Jumlah = h,
Deskripsi = eh,
Nama_Barang = ah,
};
db.AddTodb_Detail_Retur_Pembelian(dt);
db.SaveChanges();
//try
//{
// var t = (from a in db.db_Detail_Faktur_Pemesanan where a.No_Faktur_Pemesanan == tampID && a.ID_Barang == ih select a).First();
// t.Jumlah = t.Jumlah - h;
//}
//catch (Exception) { }
}
}catch (Exception) { }
}
MessageBox.Show("Add Retur berhasil", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
button2.Enabled = false;
button1.Enabled = false;
button4.Enabled = false;
}
}
