public bool RemovePurchasereturn(int id) { methodName = "RemovePurchasereturn"; traceID = 1; using (var uow = new UnitOfWork(AppConfig.Current.ContextName)) { using (var trans = uow.BeginTransaction()) { try { traceID = 2; Purchasereturn oDBPurchasereturn = uow.PurchaseReturn.SingleOrDefault(m => m.IdReturPembelian == id); if (oDBPurchasereturn != null) { traceID = 3; uow.PurchaseReturn.Remove(id); uow.Save(); } traceID = 5; trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw new AppException(500, methodName, traceID, ex); } } } return(true); }
public bool EditPurchasereturn(Purchasereturn oData) { methodName = "EditPurchasereturn"; traceID = 1; using (var uow = new UnitOfWork(AppConfig.Current.ContextName)) { traceID = 2; var oDBData = uow.PurchaseReturn.Get(oData.IdReturPembelian); if (oDBData != null) { using (var trans = uow.BeginTransaction()) { try { traceID = 3; oDBData.MapFrom(oData); uow.PurchaseReturn.Update(oDBData); uow.Save(); traceID = 4; trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw new AppException(500, methodName, traceID, ex); } } } } return(true); }
public int AddPurchasereturn(Purchasereturn oData) { methodName = "AddPurchasereturn"; traceID = 1; using (var uow = new UnitOfWork(AppConfig.Current.ContextName)) { using (var trans = uow.BeginTransaction()) { try { traceID = 2; Purchasereturn oNewPurchasereturn = new Purchasereturn(); oNewPurchasereturn.MapFrom(oData); oNewPurchasereturn = uow.PurchaseReturn.Add(oNewPurchasereturn); uow.Save(); traceID = 3; oData.IdReturPembelian = oNewPurchasereturn.IdReturPembelian; trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw new AppException(500, methodName, traceID, ex); } } } return(oData.IdReturPembelian); }
private void DGPurchaseReturn_SelectionChanged(object sender, SelectionChangedEventArgs e) { this.PurchasereturnSelected = null; if (DGPurchaseReturn.SelectedItem != null) { this.PurchasereturnSelected = (Purchasereturn)DGPurchaseReturn.SelectedItem; } }
public bool EditOrderCustomBeli(ListOrderBeli oData, Purchasereturn oDatas) { methodName = "EditOrderCustomBeli"; traceID = 1; using (var uow = new UnitOfWork(AppConfig.Current.ContextName)) { traceID = 2; var oDBData = uow.ListOrderBeli.Get(oData.Id); if (oDBData != null) { using (var trans = uow.BeginTransaction()) { try { traceID = 3; oDBData.MapFrom(oData); uow.ListOrderBeli.Update(oDBData); traceID = 4; OrderCustomBeli oDBListorderbeli = uow.OrderCustomBeli.SingleOrDefault(m => m.IdOrderCustom == oData.IdOrderBeli); if (oDBListorderbeli != null) { traceID = 5; oDBListorderbeli.MapFrom(oData); traceID = 6; uow.OrderCustomBeli.Update(oDBListorderbeli); } else { traceID = 7; traceID = 8; } traceID = 9; uow.Save(); trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw new AppException(500, methodName, traceID, ex); } } } } return(true); }
private void Delete_Click(object sender, RoutedEventArgs e) { if (this.PurchasereturnSelected == null) { MessageBox.Show("Purchase Return not selected !"); } else { PurchasereturnBLL purchasereturnBLL = new PurchasereturnBLL(); if (purchasereturnBLL.RemovePurchasereturn(this.PurchasereturnSelected.IdReturPembelian) == true) { MessageBox.Show("Purchase Return successfully deleted"); this.LoadPurchasereturn(); this.PurchasereturnSelected = null; } } }
private void savepurchasereturn_Click(object sender, RoutedEventArgs e) { if (dtReceived.Text == "" || cbCurrency.Text == "" || txtPurchaseReturnNumber.Text == "" || cbReceiveNumber.Text == "" || cbCash.Text == "" || txtNote.Text == "" || cbLocation.Text == "" || dtDelivery.Text == "") { MessageBox.Show("please fill in the blank fields", ("Form Validation"), MessageBoxButton.OK, MessageBoxImage.Error); return; } PurchasereturnBLL returBLL = new PurchasereturnBLL(); Purchasereturn oData = new Purchasereturn(); oData.Email = txtemail.Text; oData.IdKodeTransaksi = 21; oData.KodeTransaksi = "PR"; oData.NoHp = txthp.Text; oData.TanggalReturPembelian = DateTime.Parse(dtReceived.Text); oData.NoReturPembelian = double.Parse(txtPurchaseReturnNumber.Text); oData.Keterangan = txtNote.Text; oData.TanggalPengantaran = DateTime.Parse(dtDelivery.Text); if (this.kontakSelected != null) { oData.IdVendor = this.kontakSelected.Id; oData.NamaVendor = this.kontakSelected.NamaA; } if (this.DataMataUangSelected != null) { oData.IdMataUang = this.DataMataUangSelected.Id; oData.MataUang = this.DataMataUangSelected.KodeMataUang; oData.KursTukar = this.DataMataUangSelected.KursTukar; } if (this.dokumenSelected != null) { oData.IdNoReferensiDokumen = this.dokumenSelected.Id; oData.NoReferensiDokumen = this.dokumenSelected.NoReferensiDokumen; } if (this.receivedgoodSelected != null) { oData.IdReferalPa = this.receivedgoodSelected.IdOrder; oData.NoReferensiTransaksi = this.receivedgoodSelected.NoOrder; } if (this.dropdownBankKasSelected != null) { oData.IdMataUang = this.dropdownBankKasSelected.Id; oData.MataUang = this.dropdownBankKasSelected.DropdownBankkas; } if (this.lokasiSelected != null) { oData.IdLokasi = this.lokasiSelected.Id; oData.NamaLokasi = this.lokasiSelected.NamaTempatLokasi; } if (this.dataDepartemenSelected != null) { oData.IdDepartemen = this.dataDepartemenSelected.Id; } if (this.dataProyekSelected != null) { oData.IdProyek = this.dataProyekSelected.Id; } if (this.petugasSelected != null) { oData.IdPetugas = this.petugasSelected.Id; oData.NamaPetugas = this.petugasSelected.NamaA; } if (this.termspembayaranSelected != null) { oData.IdTermPembayaran = this.termspembayaranSelected.IdTermPembayaran; oData.TermPembayaran = this.termspembayaranSelected.NamaSkema; } if (this.receivedgoodSelected != null) { oData.IdTransaksi = this.receivedgoodSelected.IdTransaksi; } oData.CheckboxInclusiveTax = chkinclusive.IsChecked; oData.CheckboxManual = chkmanual.IsChecked; oData.TotalSebelumPajak = double.Parse(txttotalbeforetax.Text); oData.TotalPajak = double.Parse(txtTotalTax.Text); oData.TotalSetelahPajak = double.Parse(txtAfterTotalTax.Text); oData.TotalKreditAkunStokProduk = double.Parse(txttotalbeforetax.Text); oData.TotalKreditAkunPajakProduk = double.Parse(txtTotalprodukTax.Text); oData.TotalKreditAkunPajakJasa = double.Parse(txtTotaljasaTax.Text); oData.TotalDebitAkunHutangPembelian = double.Parse(txtAfterTotalTax.Text); if (returBLL.AddPurchasereturn(oData) > 0) { // this.ClearForm(); MessageBox.Show("Purchased Return successfully added !"); } else { MessageBox.Show("Purchased Return failed to add !"); } if (DGSKUpurchasereturn.Items.Count > 0) { foreach (var item1 in DGSKUpurchasereturn.Items) { if (item1 is ListOrderBeli) { ListOrderBeli oNewData1 = (ListOrderBeli)item1; oNewData1.Tanggal = DateTime.Parse(dtReceived.Text); if (this.lokasiSelected != null) { oNewData1.IdLokasi = this.lokasiSelected.Id; oNewData1.NamaLokasi = this.lokasiSelected.NamaTempatLokasi; } if (this.dataDepartemenSelected != null) { oNewData1.IdDepartemen = this.dataDepartemenSelected.Id; } if (this.dataProyekSelected != null) { oNewData1.IdProyek = this.dataProyekSelected.Id; } oNewData1.Checkboxaktif = false; if (returBLL.EditOrderCustomBeli(oNewData1, oData) == true) { } } } } PurchaseReturn v = new PurchaseReturn(); Switcher.SwitchNewPurchaseReturn(v); }