public bool RemovePurchasedelivery(int id)
{
methodName = "RemovePurchasedelivery";
traceID = 1;
using (var uow = new UnitOfWork(AppConfig.Current.ContextName))
{
using (var trans = uow.BeginTransaction())
{
try
{
traceID = 2;
Purchasedelivery oDBPurchasedelivery = uow.PurchaseDelivery.SingleOrDefault(m => m.IdPengirimanBarangPembelian == id);
if (oDBPurchasedelivery != null)
{
traceID = 3;
uow.PurchaseDelivery.Remove(id);
uow.Save();
}
traceID = 5;
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new AppException(500, methodName, traceID, ex);
}
}
}
return(true);
}
private void PD_selectedchange(object sender, SelectionChangedEventArgs e)
{
this.purchaseDeliverySelected = null;
if (cbPurchasedelivery.SelectedItem != null)
{
this.purchaseDeliverySelected = (Purchasedelivery)cbPurchasedelivery.SelectedItem;
this.LoadDataSku();
this.LoadPO();
txtNote.Text = this.purchaseDeliverySelected.Keterangan;
cbLocation.SelectedValue = this.purchaseDeliverySelected.IdLokasi;
dtReceived.Text = this.purchaseDeliverySelected.TanggalPengantaran.GetValueOrDefault().ToShortDateString();
cbCurrency.SelectedValue = this.purchaseDeliverySelected.IdMataUang;
srnodokumen.Text = this.purchaseDeliverySelected.NoReferensiDokumen.ToString();
cbPurchaseorder.SelectedValue = this.purchaseDeliverySelected.IdOrderPembelian;
cbDepartment.SelectedValue = this.purchaseDeliverySelected.IdDepartemen;
cbProyek.SelectedValue = this.purchaseDeliverySelected.IdProyek;
txttax1.Text = this.purchaseDeliverySelected.IdTransaksi.GetValueOrDefault().ToString();
chktax.IsChecked = this.purchaseDeliverySelected.CheckboxInclusiveTax.GetValueOrDefault();
dtDelivery.Text = this.purchaseDeliverySelected.TanggalPengirimanBarangPembelian.GetValueOrDefault().ToShortDateString();
dtAnnual.Text = this.purchaseDeliverySelected.TanggalBerulang.GetValueOrDefault().ToShortDateString();
srstaff.Text = this.purchaseDeliverySelected.NamaPetugas;
chkannual.IsChecked = this.purchaseDeliverySelected.CheckboxBerulang.GetValueOrDefault();
cbAnnual.SelectedValue = this.purchaseDeliverySelected.IdOpsiAnnual.ToString();
txtAnnualFrequency.Text = this.purchaseDeliverySelected.DurationBerulang.ToString();
}
}
public bool EditPurchasedelivery(Purchasedelivery oData)
{
methodName = "EditPurchasedelivery";
traceID = 1;
using (var uow = new UnitOfWork(AppConfig.Current.ContextName))
{
traceID = 2;
var oDBData = uow.PurchaseDelivery.Get(oData.IdPengirimanBarangPembelian);
if (oDBData != null)
{
using (var trans = uow.BeginTransaction())
{
try
{
traceID = 3;
oDBData.MapFrom(oData);
uow.PurchaseDelivery.Update(oDBData);
uow.Save();
traceID = 4;
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new AppException(500, methodName, traceID, ex);
}
}
}
}
return(true);
}
public int AddPurchasedelivery(Purchasedelivery oData)
{
methodName = "AddPurchasedelivery";
traceID = 1;
using (var uow = new UnitOfWork(AppConfig.Current.ContextName))
{
using (var trans = uow.BeginTransaction())
{
try
{
traceID = 2;
Purchasedelivery oNewPurchasedelivery = new Purchasedelivery();
oNewPurchasedelivery.IdReferalTransaksi = "26" + "." + oData.IdPengirimanBarangPembelian;
oNewPurchasedelivery.MapFrom(oData);
oNewPurchasedelivery = uow.PurchaseDelivery.Add(oNewPurchasedelivery);
uow.Save();
traceID = 3;
oData.IdReferalTransaksi = "26" + "." + oNewPurchasedelivery.IdPengirimanBarangPembelian;
oData.IdPengirimanBarangPembelian = oNewPurchasedelivery.IdPengirimanBarangPembelian;
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new AppException(500, methodName, traceID, ex);
}
}
}
return(oData.IdPengirimanBarangPembelian);
}
private void DGPurchaseDelivery_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
this.PurchasedeliverySelected = null;
if (DGPurchaseDelivery.SelectedItem != null)
{
this.PurchasedeliverySelected = (Purchasedelivery)DGPurchaseDelivery.SelectedItem;
}
}
private void Delete_Click(object sender, RoutedEventArgs e)
{
if (this.PurchasedeliverySelected == null)
{
MessageBox.Show("PurchaseDelivery not selected !");
}
else
{
PurchasedeliveryBLL purchasedeliveryBLL = new PurchasedeliveryBLL();
if (purchasedeliveryBLL.RemovePurchasedelivery(this.PurchasedeliverySelected.IdPengirimanBarangPembelian) == true)
{
MessageBox.Show("PurchaseDelivery successfully deleted");
this.LoadPurchasedelivery();
this.PurchasedeliverySelected = null;
}
}
}
private void Savereceivedgood_Click(object sender, RoutedEventArgs e)
{
if (dtReceived.Text == "" || cbCurrency.Text == "" || txtReceivedNumber.Text == "" || cbCash.Text == "" || cbLocation.Text == "" || dtDelivery.Text == "" || cbAnnual.Text == "" || txtAnnualFrequency.Text == "" || dtAnnual.Text == "")
{
MessageBox.Show("please fill in the blank fields", ("Form Validation"), MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
ReceivedGoodsBLL goodBLL = new ReceivedGoodsBLL();
Receivedgood receivedgood = new Receivedgood();
PurchasedeliveryBLL purchasedeliveryBLL = new PurchasedeliveryBLL();
receivedgood.IdKodeTransaksi = 8;
receivedgood.KodeTransaksi = "PJ";
receivedgood.IdPeriodeAkutansi = 1;
receivedgood.NoOrder = txtReceivedNumber.Text;
if (this.kontakSelected != null)
{
receivedgood.IdVendor = this.kontakSelected.Id;
receivedgood.NamaVendor = this.kontakSelected.NamaA;
}
receivedgood.Email = txtemail.Text;
receivedgood.NoHp = txthp.Text;
receivedgood.TanggalOrder = DateTime.Parse(dtReceived.Text);
if (this.DataMataUangSelected != null)
{
receivedgood.IdMataUang = this.DataMataUangSelected.Id;
receivedgood.MataUang = this.DataMataUangSelected.KodeMataUang;
receivedgood.KursTukar = this.DataMataUangSelected.KursTukar;
}
if (this.dokumenSelected != null)
{
receivedgood.IdNoReferensiDokumen = this.dokumenSelected.Id;
receivedgood.NoReferensiDokumentNi = this.dokumenSelected.NoReferensiDokumen;
}
receivedgood.NoOrderPembeliaan = double.Parse(txtReceivedNumber.Text);
if (this.purchaseDeliverySelected != null)
{
receivedgood.IdPD = this.purchaseDeliverySelected.IdPengirimanBarangPembelian;
receivedgood.NoPD = this.purchaseDeliverySelected.NoPengirimanBarangPembelian;
}
if (this.purchaseDeliverySelected != null)
{
receivedgood.IdTransaksi = this.purchaseDeliverySelected.IdTransaksi;
}
if (this.purchaseOrderSelected != null)
{
receivedgood.IdOrderPembeliaan = this.purchaseOrderSelected.IdOrderPembelian;
receivedgood.NoOrderPembeliaan = this.purchaseOrderSelected.NoOrderPembelian;
}
if (this.dropdownBankKasSelected != null)
{
receivedgood.IdBankCash = this.dropdownBankKasSelected.Id;
receivedgood.BankCash = this.dropdownBankKasSelected.DropdownBankkas;
}
if (this.lokasiSelected != null)
{
receivedgood.IdLokasi = this.lokasiSelected.Id;
receivedgood.NamaLokasi = this.lokasiSelected.NamaTempatLokasi;
}
receivedgood.Keterangan = txtNote.Text;
if (this.dataDepartemenSelected != null)
{
receivedgood.IdDepartmen = this.dataDepartemenSelected.Id;
}
if (this.dataProyekSelected != null)
{
receivedgood.IdProyek = this.dataProyekSelected.Id;
}
receivedgood.CheckboxInclusiveTax = chktax.IsChecked;
receivedgood.TanggalPengiriman = DateTime.Parse(dtDelivery.Text);
receivedgood.CheckboxBerulang = chkannual.IsChecked;
if (this.optionAnnualSelected != null)
{
receivedgood.IdOptionAnnual = this.optionAnnualSelected.IdOptionAnnual;
receivedgood.Annual = this.optionAnnualSelected.Annual;
}
if (this.petugasSelected != null)
{
receivedgood.IdPetugas = this.petugasSelected.Id;
receivedgood.NamaPetugas = this.petugasSelected.NamaA;
}
receivedgood.CicilanPerbulan = double.Parse(txtAnnualFrequency.Text);
receivedgood.TanggalBerulang = DateTime.Parse(dtAnnual.Text);
receivedgood.TotalSebelumPajak = double.Parse(txttotalbeforetax.Text);
receivedgood.TotalPajak = double.Parse(txtTotalTax.Text);
receivedgood.TotalDebitAkunPajakProduk = double.Parse(txtTotalTax.Text);
receivedgood.TotalDebitAkunPersediaanProduk = double.Parse(txttotalbeforetax.Text);
receivedgood.TotalSetelahPajak = double.Parse(txtAfterTotalTax.Text);
//receivedgood.SaldoTerhutang = double.Parse(txtoutstanding.Text);
receivedgood.RealRecordingTime = DateTime.Now;
receivedgood.Checkboxaktif = true;
if (goodBLL.AddReceivedGoods(receivedgood) > 0)
{
// this.ClearForm();
MessageBox.Show("Received Good successfully added !");
}
else
{
MessageBox.Show("Received Good failed to add !");
}
if (DGSKUReceivedGood.Items.Count > 0)
{
foreach (var item1 in DGSKUReceivedGood.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;
}
if (int.Parse(txttota.Text) == 0)
{
oNewData1.IdTransaksi = receivedgood.IdOrder;
}
if (this.purchaseDeliverySelected != null)
{
oNewData1.IdTransaksi = this.purchaseDeliverySelected.IdTransaksi;
}
oNewData1.Checkboxaktif = false;
if (goodBLL.EditOrderProdukbeli(oNewData1, receivedgood) == true)
{
}
}
}
}
if (cbPurchasedelivery.Items.Count > 0)
{
foreach (var item in cbPurchasedelivery.Items)
{
if (item is Purchasedelivery)
{
Purchasedelivery oNewData2 = (Purchasedelivery)item;
oNewData2.Checkboxaktif = false;
if (purchasedeliveryBLL.EditPurchasedelivery(oNewData2) == true)
{
}
}
}
}
ReceivedGood v = new ReceivedGood();
Switcher.Switchnewreceived(v);
}
private void Savepurchasedelivery_Click(object sender, RoutedEventArgs e)
{
if (dtPurchase.Text == "" || cbCurrency.Text == "" || txtPurchaseDeliveryNo.Text == "" || cbPurchaseorder.Text == "" || cbLocation.Text == "" || dtDelivery.Text == "" || txtAnnualFrequency.Text == "" || dtAnnualdate.Text == "")
{
MessageBox.Show("please fill in the blank fields", ("Form Validation"), MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
PurchasedeliveryBLL purchasedeliveryBLL = new PurchasedeliveryBLL();
Purchasedelivery oNewData1 = new Purchasedelivery();
PurchaseordersBLL purchaseordersBLL = new PurchaseordersBLL();
oNewData1.KodeTransaksi = "PD";
oNewData1.IdKodeTransaksi = 26;
if (this.kontakSelected != null)
{
oNewData1.IdVendor = this.kontakSelected.Id;
oNewData1.NamaVendor = this.kontakSelected.NamaA;
}
oNewData1.Email = txtemail.Text;
oNewData1.NoHp = txthp.Text;
oNewData1.TanggalPengirimanBarangPembelian = DateTime.Parse(dtPurchase.Text);
if (this.DataMataUangSelected != null)
{
oNewData1.IdMataUang = this.DataMataUangSelected.Id;
oNewData1.MataUang = this.DataMataUangSelected.NamaMataUang;
oNewData1.KursTukar = this.DataMataUangSelected.KursTukar;
}
if (this.dokumenSelected != null)
{
oNewData1.IdNoReferensiDokumen = this.dokumenSelected.Id;
oNewData1.NoReferensiDokumen = this.dokumenSelected.NoReferensiDokumen;
}
oNewData1.NoPengirimanBarangPembelian = double.Parse(txtPurchaseDeliveryNo.Text);
if (this.purchaseOrderSelected != null)
{
oNewData1.IdOrderPembelian = this.purchaseOrderSelected.IdOrderPembelian;
oNewData1.NoOrderPembelian = this.purchaseOrderSelected.NoOrderPembelian;
}
oNewData1.Keterangan = txtNote.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.CheckboxInclusiveTax = chkinclusive.IsChecked;
oNewData1.CheckboxBerulang = chkannual.IsChecked;
oNewData1.TanggalPengantaran = DateTime.Parse(dtDelivery.Text);
oNewData1.DurationBerulang = double.Parse(txtAnnualFrequency.Text);
oNewData1.TanggalBerulang = DateTime.Parse(dtAnnualdate.Text);
if (this.optionAnnualSelected != null)
{
oNewData1.IdOpsiAnnual = this.optionAnnualSelected.IdOptionAnnual;
oNewData1.Annual = this.optionAnnualSelected.Annual;
}
if (this.petugasSelected != null)
{
oNewData1.IdPetugas = this.petugasSelected.Id;
oNewData1.NamaPetugas = this.petugasSelected.NamaA;
}
if (this.purchaseOrderSelected != null)
{
oNewData1.IdTransaksi = this.purchaseOrderSelected.IdTransaksi;
}
oNewData1.TotalDebitAkunStokProduk = double.Parse(txttotalbeforetax.Text);
oNewData1.TotalKreditAkunPengirimanBeliProduk = double.Parse(txttotalbeforetax.Text);
oNewData1.TotalSebelumPajak = double.Parse(txttotalbeforetax.Text);
oNewData1.TotalPajak = double.Parse(txtTotalTax.Text);
oNewData1.TotalSetelahPajak = double.Parse(txtAfterTotalTax.Text);
oNewData1.RealRecordingTime = DateTime.Now;
oNewData1.Checkboxaktif = true;
if (purchasedeliveryBLL.AddPurchasedelivery(oNewData1) > 0)
{
// this.ClearForm();
MessageBox.Show("Purchased Delivery successfully added !");
}
else
{
MessageBox.Show("Purchased Delivery failed to add !");
}
if (cbPurchaseorder.Items.Count > 0)
{
foreach (var item in cbPurchaseorder.Items)
{
if (item is PurchaseOrder)
{
PurchaseOrder oNewData2 = (PurchaseOrder)item;
oNewData2.Checkboxaktif = false;
if (purchaseordersBLL.EditPurchaseorders(oNewData2) == true)
{
}
}
}
}
if (DGSKUPurchaseDelivery.Items.Count > 0)
{
foreach (var item in DGSKUPurchaseDelivery.Items)
{
if (item is ListOrderBeli)
{
ListOrderBeli oNewData3 = (ListOrderBeli)item;
oNewData3.Checkboxaktif = false;
if (purchasedeliveryBLL.EditOrderProdukBeli(oNewData3) == true)
{
}
}
}
}
PurchaseDelivery v = new PurchaseDelivery();
Switcher.SwitchNewPurchaseDelivery(v);
}
