public bool RemoveDeliveryOrder(int id) { methodName = "RemoveDeliveryOrder"; traceID = 1; using (var uow = new UnitOfWork(AppConfig.Current.ContextName)) { using (var trans = uow.BeginTransaction()) { try { traceID = 2; Deliveryorders oDBDeliveryOrder = uow.DeliveryOrder.SingleOrDefault(m => m.Id == id); if (oDBDeliveryOrder != null) { traceID = 3; uow.Salesquotation.Remove(id); uow.Save(); } traceID = 5; trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw new AppException(500, methodName, traceID, ex); } } } return(true); }
public bool EditDeliveryOrder(Deliveryorders oData) { methodName = "EditDeliveryOrder"; traceID = 1; using (var uow = new UnitOfWork(AppConfig.Current.ContextName)) { traceID = 2; var oDBData = uow.DeliveryOrder.Get(oData.Id); if (oDBData != null) { using (var trans = uow.BeginTransaction()) { try { traceID = 3; oDBData.MapFrom(oData); uow.DeliveryOrder.Update(oDBData); uow.Save(); traceID = 4; trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw new AppException(500, methodName, traceID, ex); } } } } return(true); }
public int AddDeliveryOrder(Deliveryorders oData) { methodName = "AddDeliveryOrder"; traceID = 1; using (var uow = new UnitOfWork(AppConfig.Current.ContextName)) { using (var trans = uow.BeginTransaction()) { try { traceID = 2; Deliveryorders oNewDeliveryOrder = new Deliveryorders(); oNewDeliveryOrder.MapFrom(oData); oNewDeliveryOrder = uow.DeliveryOrder.Add(oNewDeliveryOrder); uow.Save(); traceID = 3; oData.Id = oNewDeliveryOrder.Id; trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw new AppException(500, methodName, traceID, ex); } } } return(oData.Id); }
private void DGDeliveryOrder_SelectionChanged(object sender, SelectionChangedEventArgs e) { this.DeliveryordersSelected = null; if (DGDeliveryOrder.SelectedItem != null) { this.DeliveryordersSelected = (Deliveryorders)DGDeliveryOrder.SelectedItem; } }
private void Delete_Click(object sender, RoutedEventArgs e) { if (this.DeliveryordersSelected == null) { MessageBox.Show("Delivery Order not selected !"); } else { DeliveryOrdersBLL deliveryOrdersBLL = new DeliveryOrdersBLL(); if (deliveryOrdersBLL.RemoveDeliveryOrder(this.DeliveryordersSelected.Id) == true) { MessageBox.Show("Delivery Order successfully deleted"); this.LoadDeliveryorders(); this.DeliveryordersSelected = null; } } }
private void Save_Click(object sender, RoutedEventArgs e) { if (dtDeliveryorderdate.Text == "" || cbCurrency.Text == "" || txtDeliveryOrderNo.Text == "" || cbSalesorder.Text == "" || cbLocation.Text == "" || dtValiditydate.Text == "" || txtAnnualFrequency.Text == "" || dtAnnualdate.Text == "") { MessageBox.Show("please fill in the blank fields", ("Form Validation"), MessageBoxButton.OK, MessageBoxImage.Error); return; } DeliveryOrdersBLL deliveryBLL = new DeliveryOrdersBLL(); Deliveryorders deliveryorders = new Deliveryorders(); if (this.kontakSelected != null) { deliveryorders.IdPelanggan = this.kontakSelected.Id; deliveryorders.NamePelanggan = this.kontakSelected.NamaA; } deliveryorders.Email = txtemail.Text; deliveryorders.NoHp = txthp.Text; deliveryorders.TanggalDo = DateTime.Parse(dtDeliveryorderdate.Text); if (this.DataMataUangSelected != null) { deliveryorders.IdMaatUang = this.DataMataUangSelected.Id; deliveryorders.MaatUang = this.DataMataUangSelected.NamaMataUang; deliveryorders.KursTukar = this.DataMataUangSelected.KursTukar; } if (this.dokumenSelected != null) { deliveryorders.IdNoReferansiDokumen = this.dokumenSelected.Id; deliveryorders.NoReferansiDokumen = this.dokumenSelected.NoReferensiDokumen; } deliveryorders.NoDo = txtDeliveryOrderNo.Text; if (this.SalesOrderSelected != null) { deliveryorders.IdOrderPenjualan = this.SalesOrderSelected.IdOrderPenjualan; deliveryorders.NomorOrderPenjualan = this.SalesOrderSelected.NoOrderPenjualan; } deliveryorders.Keterangan = txtNote.Text; if (this.lokasiSelected != null) { deliveryorders.IdLokasi = this.lokasiSelected.Id; deliveryorders.NameLokasi = this.lokasiSelected.NamaTempatLokasi; } if (this.dataDepartemenSelected != null) { deliveryorders.IdDepartemen = this.dataDepartemenSelected.Id; } if (this.dataProyekSelected != null) { deliveryorders.IdProyek = this.dataProyekSelected.Id; } deliveryorders.CheckboxInclusivePajak = chkinclusive.IsChecked; deliveryorders.TanggalPengiriman = DateTime.Parse(dtValiditydate.Text); deliveryorders.DurationBerulang = double.Parse(txtAnnualFrequency.Text); deliveryorders.TanggalBerulang = DateTime.Parse(dtAnnualdate.Text); if (this.optionAnnualSelected != null) { deliveryorders.IdOpsiAnnual = this.optionAnnualSelected.IdOptionAnnual; deliveryorders.Annual = this.optionAnnualSelected.Annual; } if (this.petugasSelected != null) { deliveryorders.IdPetugas = this.petugasSelected.Id; deliveryorders.NamePetugas = this.petugasSelected.NamaA; } deliveryorders.CheckboxBerulang = chkannual.IsChecked; deliveryorders.IdKodeTransaksi = 25; deliveryorders.KodeTransaksi = "DO"; deliveryorders.IdReferalTransaksi = 1; deliveryorders.IdPeriodeAkuntansi = 1; deliveryorders.RealRecordingTime = DateTime.Now; deliveryorders.TotalKreditAkunPersediaanProduk = double.Parse(txtTotalbeforeTax.Text); deliveryorders.TotalDebitAkunPengirimanJualProduk = double.Parse(txtTotalbeforeTax.Text); deliveryorders.TotalSebelumPajak = double.Parse(txtTotalbeforeTax.Text); deliveryorders.TotalPajak = double.Parse(txtTotalTax.Text); if (this.SalesOrderSelected != null) { deliveryorders.IdTransaksi = this.SalesOrderSelected.IdTransaksi; } deliveryorders.TotalSetelahPajak = double.Parse(txtAfterTotalTax.Text); if (deliveryBLL.AddDeliveryOrder(deliveryorders) > 0) { // this.ClearForm(); MessageBox.Show("Delivery Order successfully added !"); } else { MessageBox.Show("Delivery Order failed to add !"); } Deliveryorder v = new Deliveryorder(); Switcher.SwitchNewDeliveryorder(v); }