public int AddOrderProdukjual(OrderProdukJual oData)
{
methodName = "AddOrderProdukjual";
traceID = 1;
using (var uow = new UnitOfWork(AppConfig.Current.ContextName))
{
using (var trans = uow.BeginTransaction())
{
try
{
traceID = 2;
OrderProdukJual oNewOrderProdukJual = new OrderProdukJual();
oNewOrderProdukJual.MapFrom(oData);
oNewOrderProdukJual = uow.OrderProdukJual.Add(oNewOrderProdukJual);
uow.Save();
if (oNewOrderProdukJual.IdOrderProdukJual > 0)
{
traceID = 3;
oData.IdOrderProdukJual = oNewOrderProdukJual.IdOrderProdukJual;
ListOrderJual oNewListOrderJual = new ListOrderJual();
oNewListOrderJual.MapFrom(oData);
traceID = 4;
oNewListOrderJual.IdOrderJual = oData.IdOrderProdukJual;
oNewListOrderJual.Jumlah = oData.JumlahProduk;
oNewListOrderJual.Diskon = oData.DiskonProduk;
oNewListOrderJual.TotalPajak = oData.TotalPajakProduk;
oNewListOrderJual.TotalPajakProduk = oData.TotalPajakProduk;
oNewListOrderJual.TotalOrderProduk = oData.TotalOrderProduk;
oNewListOrderJual.HargaJual = oData.HargaJual;
oNewListOrderJual.TotalOrder = oData.TotalOrderProduk;
uow.ListOrderJual.Add(oNewListOrderJual);
}
traceID = 5;
uow.Save();
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new AppException(500, methodName, traceID, ex);
}
}
}
return(oData.IdOrderProdukJual);
}
public bool EditOrderProdukjual(ListOrderJual oData, Salesquotation oDatas)
{
methodName = "EditOrderProdukjual";
traceID = 1;
using (var uow = new UnitOfWork(AppConfig.Current.ContextName))
{
traceID = 2;
var oDBData = uow.ListOrderJual.Get(oData.Id);
if (oDBData != null)
{
using (var trans = uow.BeginTransaction())
{
try
{
traceID = 3;
oDBData.MapFrom(oData);
uow.ListOrderJual.Update(oDBData);
traceID = 4;
OrderProdukJual oDBListorderjual = uow.OrderProdukJual.SingleOrDefault(m => m.IdOrderProdukJual == oData.IdOrderJual);
if (oDBListorderjual != null)
{
traceID = 5;
oDBListorderjual.MapFrom(oData);
traceID = 6;
uow.OrderProdukJual.Update(oDBListorderjual);
}
else
{
traceID = 7;
traceID = 8;
}
traceID = 9;
OrderJasaJual oDBListorderjual1 = uow.OrderJasaJual.SingleOrDefault(m => m.IdOrderJasa == oData.IdOrderJual);
if (oDBListorderjual1 != null)
{
traceID = 10;
oDBListorderjual1.MapFrom(oData);
traceID = 11;
uow.OrderJasaJual.Update(oDBListorderjual1);
}
else
{
traceID = 12;
traceID = 13;
}
traceID = 14;
uow.Save();
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new AppException(500, methodName, traceID, ex);
}
}
}
}
return(true);
}
public bool EditOrderProdukJual(ListOrderJual oData, invoice oDatas)
{
methodName = "EditOrderProdukJual";
traceID = 1;
using (var uow = new UnitOfWork(AppConfig.Current.ContextName))
{
traceID = 2;
var oDBData = uow.ListOrderJual.Get(oData.Id);
if (oDBData != null)
{
using (var trans = uow.BeginTransaction())
{
try
{
traceID = 3;
oDBData.MapFrom(oData);
uow.ListOrderJual.Update(oDBData);
traceID = 4;
OrderProdukJual oDBListorderjual = uow.OrderProdukJual.SingleOrDefault(m => m.IdOrderProdukJual == oData.IdOrderJual);
if (oDBListorderjual != null)
{
traceID = 5;
oDBListorderjual.MapFrom(oData);
traceID = 6;
uow.OrderProdukJual.Update(oDBListorderjual);
}
else
{
traceID = 7;
OrderProdukJual oNewListorderjual = new OrderProdukJual();
oNewListorderjual.MapFrom(oData);
traceID = 8;
uow.OrderProdukJual.Add(oNewListorderjual);
}
traceID = 9;
OrderJasaJual oDBListorderjual1 = uow.OrderJasaJual.SingleOrDefault(m => m.IdOrderJasa == oData.IdOrderJual);
if (oDBListorderjual1 != null)
{
traceID = 10;
oDBListorderjual1.MapFrom(oData);
traceID = 11;
oDBListorderjual1.TanggalStartdate = oData.TanggalPengiriman;
uow.OrderJasaJual.Update(oDBListorderjual1);
}
else
{
traceID = 12;
traceID = 13;
}
traceID = 14;
OrderCustomJual oDBListorderjual2 = uow.OrderCustomJual.SingleOrDefault(m => m.IdOrderCustom == oData.IdOrderJual);
if (oDBListorderjual2 != null)
{
traceID = 15;
oDBListorderjual2.MapFrom(oData);
traceID = 16;
uow.OrderCustomJual.Update(oDBListorderjual2);
}
else
{
traceID = 17;
traceID = 18;
}
traceID = 19;
uow.Save();
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new AppException(500, methodName, traceID, ex);
}
}
}
}
return(true);
}
private void Savesales_Click(object sender, RoutedEventArgs e)
{
if (srcustomer.Name == "" || txtemail.Name == "" || txthp.Name == "" || dtSales.Text == "" || cbCurrency.Text == "" || srnodokumen.Name == "" || txtSalesQuotationNo.Text == "" || cbLocation.Text == "" || dtValidaty.Text == "" || cbAnnual.Text == "" || srstaff.Name == "" || txtAnnualFrequency.Text == "" || dtAnnual.Text == "")
{
MessageBox.Show("please fill in the blank fields", ("Form Validation"), MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
SalesquotationBLL quotaBLL = new SalesquotationBLL();
SalesquotationBLL QuotaBLL = new SalesquotationBLL();
Salesquotation salesquotation = new Salesquotation();
if (this.kontakSelected != null)
{
salesquotation.IdKontak = this.kontakSelected.Id;
salesquotation.NamaPelanggan = this.kontakSelected.NamaA;
}
salesquotation.Email = txtemail.Text;
salesquotation.NoHp = txthp.Text;
salesquotation.TanggalPenawaranHarga = DateTime.Parse(dtSales.Text);
if (this.DataMataUangSelected != null)
{
salesquotation.IdMataUang = this.DataMataUangSelected.Id;
salesquotation.MataUang = this.DataMataUangSelected.NamaMataUang;
salesquotation.KursTukar = this.DataMataUangSelected.KursTukar;
}
if (this.dokumenSelected != null)
{
salesquotation.IdNoReferensiDokumen = this.dokumenSelected.Id;
salesquotation.NoReferensiDokumen = this.dokumenSelected.NoReferensiDokumen;
}
salesquotation.NoPenawaranHarga = txtSalesQuotationNo.Text;
salesquotation.Keterangan = txtNote.Text;
if (this.lokasiSelected != null)
{
salesquotation.IdLokasi = this.lokasiSelected.Id;
salesquotation.NamaLokasi = this.lokasiSelected.NamaTempatLokasi;
}
if (this.dataDepartemenSelected != null)
{
salesquotation.IdDepartemen = this.dataDepartemenSelected.Id;
}
if (this.dataProyekSelected != null)
{
salesquotation.IdProyek = this.dataProyekSelected.Id;
}
salesquotation.CheckboxInclusiveTax = chkinclusive.IsChecked;
salesquotation.CheckboxSelesai = chkcomplete.IsChecked;
salesquotation.TanggalPenutupan = DateTime.Parse(dtValidaty.Text);
if (this.petugasSelected != null)
{
salesquotation.IdPetugas = this.petugasSelected.Id;
salesquotation.NamaPetugas = this.petugasSelected.NamaA;
}
if (this.termspembayaranSelected != null)
{
salesquotation.IdTermPembayaran = this.termspembayaranSelected.IdTermPembayaran;
salesquotation.TermPembayaran = this.termspembayaranSelected.NamaSkema;
}
salesquotation.CheckboxBerulang = chkannual.IsChecked;
salesquotation.DurasiBerulang = double.Parse(txtAnnualFrequency.Text);
salesquotation.TanggalBerulang = DateTime.Parse(dtAnnual.Text);
if (this.optionAnnualSelected != null)
{
salesquotation.IdOpsiAnnual = this.optionAnnualSelected.IdOptionAnnual;
salesquotation.Annual = this.optionAnnualSelected.Annual;
}
salesquotation.IdKodeTransaksi = 15;
salesquotation.KodeTransaksi = "SQ";
salesquotation.IdPeriodeAkutansi = 1;
salesquotation.RealRecordingTime = DateTime.Now;
salesquotation.TotalOrderProduk = double.Parse(txttotalprodukbeforetax.Text);
salesquotation.TotalOrderJasa = double.Parse(txttotaljasabeforetax.Text);
salesquotation.TotalPajakProduk = double.Parse(txtTotalprodukTax.Text);
salesquotation.TotalPajakJasa = double.Parse(txtTotaljasaTax.Text);
salesquotation.TotalSebelumPajak = double.Parse(txttotalbeforetax.Text);
salesquotation.TotalPajak = double.Parse(txtTotalTax.Text);
salesquotation.TotalSetelahPajak = double.Parse(txtAfterTotalTax.Text);
if (QuotaBLL.AddSalesquotation(salesquotation) > 0)
{
// this.ClearForm();
MessageBox.Show("Sales Quotation successfully added !");
}
else
{
MessageBox.Show("Sales Quotation failed to add !");
}
if (DGSKU.Items.Count > 0)
{
foreach (var item in DGSKU.Items)
{
if (item is ListOrderJual)
{
ListOrderJual oNewData1 = (ListOrderJual)item;
oNewData1.IdReferalTransaksi = 1;
oNewData1.Tanggal = DateTime.Parse(dtSales.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.IdTransaksi = salesquotation.Id;
oNewData1.TanggalPengiriman = DateTime.Parse(dtValidaty.Text);
oNewData1.Checkbokaktif = false;
if (quotaBLL.EditOrderProdukjual(oNewData1, salesquotation) == true)
{
}
}
}
}
Sales v = new Sales();
Switcher.Switch2(v);
}
private void Saveinvoice_Click(object sender, RoutedEventArgs e)
{
if (dtInvoicedate.Text == "" || cbCurrency.Text == "" || txtInvoiceNumber.Text == "" || cbLocation.Text == "" ||
dtDeliverydate.Text == "" || cbAnnual.Text == "" || txtAnnualFrequency.Text == "" || dtAnnualdate.Text == "")
{
MessageBox.Show("please fill in the blank fields", ("Form Validation"), MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
InvoicesBLL invoiceBLL = new InvoicesBLL();
InvoicesBLL InvoiceBLL = new InvoicesBLL();
invoice invoice = new invoice();
if (this.kontakSelected != null)
{
invoice.IdPelanggan = this.kontakSelected.Id;
invoice.NamaPelanggan = this.kontakSelected.NamaA;
}
invoice.Email = txtemail.Text;
invoice.NoHp = txthp.Text;
invoice.TanggalInvoice = DateTime.Parse(dtInvoicedate.Text);
if (this.DataMataUangSelected != null)
{
invoice.IdMataUang = this.DataMataUangSelected.Id;
invoice.MataUang = this.DataMataUangSelected.NamaMataUang;
invoice.KursTukar = this.DataMataUangSelected.KursTukar;
}
if (this.dokumenSelected != null)
{
invoice.IdNoReferensiDokumen = this.dokumenSelected.Id;
invoice.NoReferensiDokumen = this.dokumenSelected.NoReferensiDokumen;
}
invoice.NoInvoice = txtInvoiceNumber.Text;
invoice.Keterangan = txtNote.Text;
if (this.lokasiSelected != null)
{
invoice.IdLokasi = this.lokasiSelected.Id;
invoice.NamaLokasi = this.lokasiSelected.NamaTempatLokasi;
}
if (this.dataDepartemenSelected != null)
{
invoice.IdDepartemen = this.dataDepartemenSelected.Id;
}
if (this.dataProyekSelected != null)
{
invoice.IdProyek = this.dataProyekSelected.Id;
}
invoice.CheckboxInclusiveTax = chkinclusive.IsChecked;
invoice.TanggalPengiriman = DateTime.Parse(dtDeliverydate.Text);
if (this.petugasSelected != null)
{
invoice.IdPetugas = this.petugasSelected.Id;
invoice.NamaPetugas = this.petugasSelected.NamaA;
}
if (this.termspembayaranSelected != null)
{
invoice.IdTermPembayaran = this.termspembayaranSelected.IdTermPembayaran;
invoice.TermPembayaran = this.termspembayaranSelected.NamaSkema;
}
invoice.CheckboxBerulang = chkannual.IsChecked;
invoice.DurasiBerulang = double.Parse(txtAnnualFrequency.Text);
invoice.TanggalBerulang = DateTime.Parse(dtAnnualdate.Text);
if (this.optionAnnualSelected != null)
{
invoice.IdOpsiAnnual = this.optionAnnualSelected.IdOptionAnnual;
invoice.Annual = this.optionAnnualSelected.Annual;
}
if (this.DeliveryOrderSelected != null)
{
invoice.IdTransaksi = this.DeliveryOrderSelected.IdTransaksi;
}
invoice.IdKodeTransaksi = 15;
invoice.KodeTransaksi = "SQ";
invoice.IdPeriodeAkuntansi = 1;
invoice.RealRecordingTime = DateTime.Now;
invoice.TotalDebitAkunPiutangPenjualan = invoice.TotalSebelumPajak;
invoice.TotalSebelumPajak = double.Parse(txtTotalbeforeTax.Text);
invoice.TotalPajak = double.Parse(txtTotalTax.Text);
invoice.TotalSetelahPajak = double.Parse(txtAfterTotalTax.Text);
if (InvoiceBLL.AddInvoices(invoice) > 0)
{
// this.ClearForm();
MessageBox.Show("Invoice successfully added !");
}
else
{
MessageBox.Show("Invoice failed to add !");
}
if (DGSKUInvoice.Items.Count > 0)
{
foreach (var item in DGSKUInvoice.Items)
{
if (item is ListOrderJual)
{
ListOrderJual oNewData1 = (ListOrderJual)item;
oNewData1.IdReferalTransaksi = 1;
oNewData1.Tanggal = DateTime.Parse(dtInvoicedate.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.TanggalPengiriman = DateTime.Parse(dtDeliverydate.Text);
oNewData1.Checkbokaktif = false;
if (invoiceBLL.EditOrderProdukJual(oNewData1, invoice) == true)
{
}
}
}
}
Invoice v = new Invoice();
Switcher.SwitchNewInvoice(v);
}
