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; } }