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