public bool RemoveSalesreturns(int id) { methodName = "RemoveSalesreturns"; traceID = 1; using (var uow = new UnitOfWork(AppConfig.Current.ContextName)) { using (var trans = uow.BeginTransaction()) { try { traceID = 2; Salesreturn oDBSalesreturn = uow.SalesReturn.SingleOrDefault(m => m.IdReturPenjualan == id); if (oDBSalesreturn != null) { traceID = 3; uow.SalesReturn.Remove(id); uow.Save(); } traceID = 5; trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw new AppException(500, methodName, traceID, ex); } } } return(true); }
public bool EditSalesreturns(Salesreturn oData) { methodName = "EditSalesreturns"; traceID = 1; using (var uow = new UnitOfWork(AppConfig.Current.ContextName)) { traceID = 2; var oDBData = uow.SalesReturn.Get(oData.IdReturPenjualan); if (oDBData != null) { using (var trans = uow.BeginTransaction()) { try { traceID = 3; oDBData.MapFrom(oData); uow.SalesReturn.Update(oDBData); uow.Save(); traceID = 4; trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw new AppException(500, methodName, traceID, ex); } } } } return(true); }
public int AddSalesreturns(Salesreturn oData) { methodName = "AddSalesreturns"; traceID = 1; using (var uow = new UnitOfWork(AppConfig.Current.ContextName)) { using (var trans = uow.BeginTransaction()) { try { traceID = 2; Salesreturn oNewSalesreturn = new Salesreturn(); oNewSalesreturn.MapFrom(oData); oNewSalesreturn = uow.SalesReturn.Add(oNewSalesreturn); uow.Save(); traceID = 3; oData.IdReturPenjualan = oNewSalesreturn.IdReturPenjualan; trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw new AppException(500, methodName, traceID, ex); } } } return(oData.IdReturPenjualan); }
public bool EditOrderProdukjual(OrderProdukJual oData, Salesreturn oDatas) { methodName = "EditOrderProdukjual"; traceID = 1; using (var uow = new UnitOfWork(AppConfig.Current.ContextName)) { traceID = 2; var oDBData = uow.OrderProdukJual.Get(oData.IdOrderProdukJual); if (oDBData != null) { using (var trans = uow.BeginTransaction()) { try { traceID = 3; oDBData.MapFrom(oData); uow.OrderProdukJual.Update(oDBData); traceID = 6; uow.Save(); trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw new AppException(500, methodName, traceID, ex); } } } } return(true); }
private void DGSalesReturn_SelectionChanged(object sender, SelectionChangedEventArgs e) { this.SalesreturnSelected = null; if (DGSalesReturn.SelectedItem != null) { this.SalesreturnSelected = (Salesreturn)DGSalesReturn.SelectedItem; } }
private void Delete_Click(object sender, RoutedEventArgs e) { if (this.SalesreturnSelected == null) { MessageBox.Show("Sales Return not selected !"); } else { SalesreturnBLL salesreturnBLL = new SalesreturnBLL(); if (salesreturnBLL.RemoveSalesreturns(this.SalesreturnSelected.IdReturPenjualan) == true) { MessageBox.Show("Sales Return successfully deleted"); this.LoadSalesReturn(); this.SalesreturnSelected = null; } } }
private void Savesales_Click(object sender, RoutedEventArgs e) { if (srcustomer.Name == "" || txtemail.Name == "" || txthp.Name == "" || dtSales.Text == "" || cbCurrency.Text == "" || txtsalesreturnno.Text == "" || cbLocation.Text == "" || dtDelivery.Text == "" || srstaff.Name == "" || txtAnnualFrequency.Text == "" || dtAnnual.Text == "") { MessageBox.Show("please fill in the blank fields", ("Form Validation"), MessageBoxButton.OK, MessageBoxImage.Error); return; } SalesreturnBLL returnBLL = new SalesreturnBLL(); SalesreturnBLL ReturnBLL = new SalesreturnBLL(); Salesreturn salesreturn = new Salesreturn(); if (this.kontakSelected != null) { salesreturn.IdPelanggan = this.kontakSelected.Id; salesreturn.NamaPelanggan = this.kontakSelected.NamaA; } salesreturn.Email = txtemail.Text; salesreturn.NoHp = txthp.Text; salesreturn.TanggalReturPenjualan = DateTime.Parse(dtSales.Text); if (this.DataMataUangSelected != null) { salesreturn.IdMataUang = this.DataMataUangSelected.Id; salesreturn.MataUang = this.DataMataUangSelected.NamaMataUang; salesreturn.KursTukar = this.DataMataUangSelected.KursTukar; } if (this.dokumenSelected != null) { salesreturn.IdNoReferensiDokumen = this.dokumenSelected.Id; salesreturn.NoReferensiDokumen = this.dokumenSelected.NoReferensiDokumen; } salesreturn.NoReturPenjualan = txtsalesreturnno.Text; if (this.invoiceSelected != null) { salesreturn.IdReferalTransaksi = this.invoiceSelected.IdOrderPenjualan; salesreturn.NoReferensiTransaksi = this.invoiceSelected.NoOrderPenjualan; } salesreturn.Keterangan = txtNote.Text; if (this.lokasiSelected != null) { salesreturn.IdLokasi = this.lokasiSelected.Id; salesreturn.NamaLokasi = this.lokasiSelected.NamaTempatLokasi; } if (this.dataDepartemenSelected != null) { salesreturn.IdDepartemen = this.dataDepartemenSelected.Id; } if (this.dataProyekSelected != null) { salesreturn.IdProyek = this.dataProyekSelected.Id; } salesreturn.CheckboxInclusiveTax = chkinclusive.IsChecked; salesreturn.TanggalPengantaran = DateTime.Parse(dtDelivery.Text); salesreturn.DurasiBerulang = double.Parse(txtAnnualFrequency.Text); salesreturn.TanggalBerulang = DateTime.Parse(dtAnnual.Text); if (this.optionAnnualSelected != null) { salesreturn.IdOpsiAnnual = this.optionAnnualSelected.IdOptionAnnual; salesreturn.Annual = this.optionAnnualSelected.Annual; } if (this.petugasSelected != null) { salesreturn.IdPetugas = this.petugasSelected.Id; salesreturn.NamaPetugas = this.petugasSelected.NamaA; } if (this.invoiceSelected != null) { salesreturn.IdTransaksi = this.invoiceSelected.IdTransaksi; } salesreturn.Checkboxberulang = chkannual.IsChecked; salesreturn.IdKodeTransaksi = 25; salesreturn.KodeTransaksi = "SR"; salesreturn.IdPeriodeAkuntansi = 1; salesreturn.RealRecongitionTime = DateTime.Now; salesreturn.TotalSebelumPajak = double.Parse(txtTotalbeforeTax.Text); salesreturn.TotalPajak = double.Parse(txtTotalTax.Text); salesreturn.TotalSetelahPajak = double.Parse(txtAfterTotalTax.Text); if (ReturnBLL.AddSalesreturns(salesreturn) > 0) { // this.ClearForm(); MessageBox.Show("Sales Return successfully added !"); } else { MessageBox.Show("Sales Return failed to add !"); } SalesReturn v = new SalesReturn(); Switcher.SwitchNewSalesReturn(v); }