public bool EditShopingcharts(Shopingchart oData)
{
methodName = "EditShopingcharts";
traceID = 1;
using (var uow = new UnitOfWork(AppConfig.Current.ContextName))
{
traceID = 2;
var oDBData = uow.Shopingchart.Get(oData.IdPermintaanBarang);
if (oDBData != null)
{
using (var trans = uow.BeginTransaction())
{
try
{
traceID = 3;
oDBData.MapFrom(oData);
uow.Shopingchart.Update(oDBData);
uow.Save();
traceID = 4;
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new AppException(500, methodName, traceID, ex);
}
}
}
}
return(true);
}
public bool RemoveShopingcharts(int id)
{
methodName = "RemoveShopingcharts";
traceID = 1;
using (var uow = new UnitOfWork(AppConfig.Current.ContextName))
{
using (var trans = uow.BeginTransaction())
{
try
{
traceID = 2;
Shopingchart oDBShopingchart = uow.Shopingchart.SingleOrDefault(m => m.IdPermintaanBarang == id);
if (oDBShopingchart != null)
{
traceID = 3;
uow.Shopingchart.Remove(id);
uow.Save();
}
traceID = 5;
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new AppException(500, methodName, traceID, ex);
}
}
}
return(true);
}
public int AddShopingcharts(Shopingchart oData)
{
methodName = "AddShopingcharts";
traceID = 1;
using (var uow = new UnitOfWork(AppConfig.Current.ContextName))
{
using (var trans = uow.BeginTransaction())
{
try
{
traceID = 2;
Shopingchart oNewShopingchart = new Shopingchart();
oNewShopingchart.MapFrom(oData);
oNewShopingchart = uow.Shopingchart.Add(oNewShopingchart);
uow.Save();
traceID = 3;
oData.IdPermintaanBarang = oNewShopingchart.IdPermintaanBarang;
oData.idTransaksi = oNewShopingchart.IdPermintaanBarang;
uow.Save();
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new AppException(500, methodName, traceID, ex);
}
}
}
return(oData.IdPermintaanBarang);
}
private void shoping_selectedchange(object sender, SelectionChangedEventArgs e)
{
this.shopingchartSelected = null;
if (cbRequestNo.SelectedItem != null)
{
this.shopingchartSelected = (Shopingchart)cbRequestNo.SelectedItem;
this.LoadDataSku();
txtNote.Text = this.shopingchartSelected.Keterangan;
txttax1.Text = this.shopingchartSelected.IdPermintaanBarang.ToString();
cbLocation.SelectedValue = this.shopingchartSelected.IdLokasi;
dtQuotation.Text = this.shopingchartSelected.TanggaldiBuat.GetValueOrDefault().ToShortDateString();
cbCurrency.SelectedValue = this.shopingchartSelected.IdMataUang;
srnodokumen.Text = this.shopingchartSelected.NoReferensiDokumen.ToString();
cbDepartment.SelectedValue = this.shopingchartSelected.IdDepartemen;
cbProyek.SelectedValue = this.shopingchartSelected.IdProyek;
chkcomplete.IsChecked = this.shopingchartSelected.CheckboxSelesai.GetValueOrDefault();
dtValidaty.Text = this.shopingchartSelected.TanggalDigunakan.GetValueOrDefault().ToShortDateString();
dtAnnual.Text = this.shopingchartSelected.TanggalBerulang.GetValueOrDefault().ToShortDateString();
srstaff.Text = this.shopingchartSelected.NamaPetugas;
chkannual.IsChecked = this.shopingchartSelected.CheckboxBerulang.GetValueOrDefault();
cbAnnual.SelectedValue = this.shopingchartSelected.IdOpsiAnnual.ToString();
txtAnnualFrequency.Text = this.shopingchartSelected.DurasiBerulang.ToString();
}
}
public bool EditOrderProdukBeli(ListOrderBeli oData, Shopingchart oDatas, produk oDatap)
{
methodName = "EditOrderProdukBeli";
traceID = 1;
using (var uow = new UnitOfWork(AppConfig.Current.ContextName))
{
traceID = 2;
var oDBData = uow.ListOrderBeli.Get(oData.Id);
if (oDBData != null)
{
using (var trans = uow.BeginTransaction())
{
try
{
traceID = 3;
oDBData.MapFrom(oData);
uow.ListOrderBeli.Update(oDBData);
traceID = 4;
OrderProdukBeli oDBListorderbeli = uow.OrderProdukBeli.SingleOrDefault(m => m.IdOrderProdukBeli == oData.IdOrderBeli);
if (oDBListorderbeli != null)
{
traceID = 5;
oDBListorderbeli.MapFrom(oData);
traceID = 6;
uow.OrderProdukBeli.Update(oDBListorderbeli);
}
else
{
traceID = 7;
traceID = 8;
}
traceID = 9;
OrderJasaBeli oDBListorderbeli1 = uow.OrderJasaBeli.SingleOrDefault(m => m.IdOrderJasa == oData.IdOrderBeli);
if (oDBListorderbeli1 != null)
{
traceID = 10;
oDBListorderbeli1.MapFrom(oData);
traceID = 11;
// oDBListorderbeli1.TanggalStartdate = oData.TanggalPengiriman;
uow.OrderJasaBeli.Update(oDBListorderbeli1);
}
else
{
traceID = 12;
traceID = 13;
}
traceID = 4;
produk oDproduk = uow.produk.SingleOrDefault(m => m.IdProduk == oData.IdProduk);
if (oDproduk != null)
{
traceID = 5;
oDproduk.MapFrom(oData);
traceID = 6;
oDproduk.JumlahStok = oDproduk.JumlahStok + oData.Jumlah;
uow.produk.Update(oDproduk);
}
else
{
traceID = 7;
traceID = 8;
}
traceID = 14;
uow.Save();
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new AppException(500, methodName, traceID, ex);
}
}
}
}
return(true);
}
private void Saveshopingchart_Click(object sender, RoutedEventArgs e)
{
if (sremployee.Name == "" || txtemail.Name == "" || txthp.Name == "" || dtIssued.Text == "" || cbCurrency.Text == "" || srnodokumen.Name == "" || txtRequestNo.Text == "" || txtNote.Text == "" || cbLocation.Text == "" || dtRequired.Text == "" || cbAnnual.Text == "" || srstaff.Name == "" || txtAnnualFrequency.Text == "" || dtAnnual.Text == "")
{
MessageBox.Show("please fill in the blank fields", ("Form Validation"), MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
ShopingchartBLL shopingBLL = new ShopingchartBLL();
ShopingchartBLL ShopingBLL = new ShopingchartBLL();
Shopingchart shoping = new Shopingchart();
shoping.IdKodeTransaksi = 14;
shoping.KodeTransaksi = "MR";
if (this.kontakSelected != null)
{
shoping.IdEmployee = this.kontakSelected.Id;
shoping.NamaManager = this.kontakSelected.NamaA;
}
shoping.Email = txtemail.Text;
shoping.Nohp = txthp.Text;
shoping.TanggaldiBuat = DateTime.Parse(dtIssued.Text);
if (this.DataMataUangSelected != null)
{
shoping.IdMataUang = this.DataMataUangSelected.Id;
shoping.MataUang = this.DataMataUangSelected.KodeMataUang;
shoping.KursTukar = this.DataMataUangSelected.KursTukar;
}
if (this.dokumenSelected != null)
{
shoping.IdNoReferensiDokumen = this.dokumenSelected.Id;
shoping.NoReferensiDokumen = this.dokumenSelected.NoReferensiDokumen;
}
shoping.NoPermintaanBarang = txtRequestNo.Text;
if (this.lokasiSelected != null)
{
shoping.IdLokasi = this.lokasiSelected.Id;
shoping.NamaLokasi = this.lokasiSelected.NamaTempatLokasi;
}
shoping.Keterangan = txtNote.Text;
if (this.dataDepartemenSelected != null)
{
shoping.IdDepartemen = this.dataDepartemenSelected.Id;
}
if (this.dataProyekSelected != null)
{
shoping.IdProyek = this.dataProyekSelected.Id;
}
shoping.CheckboxSelesai = chkcomplete.IsChecked;
shoping.TanggalDigunakan = DateTime.Parse(dtRequired.Text);
shoping.CheckboxBerulang = chkannual.IsChecked;
if (this.optionAnnualSelected != null)
{
shoping.IdOpsiAnnual = this.optionAnnualSelected.IdOptionAnnual;
shoping.Annual = this.optionAnnualSelected.Annual;
}
if (this.petugasSelected != null)
{
shoping.IdPetugas = this.petugasSelected.Id;
shoping.NamaPetugas = this.petugasSelected.NamaA;
}
shoping.DurasiBerulang = double.Parse(txtAnnualFrequency.Text);
shoping.TanggalBerulang = DateTime.Parse(dtAnnual.Text);
shoping.Nilai = double.Parse(txttotalbeforetax.Text);
shoping.IdUserId = 1;
shoping.IdPeriodeAkuntansi = 1;
shoping.RealRecordingTime = DateTime.Now;
shoping.Checkaktif = true;
if (ShopingBLL.AddShopingcharts(shoping) > 0)
{
// this.ClearForm();
MessageBox.Show("Shoping Chart successfully added !");
}
else
{
MessageBox.Show("Shoping Chart failed to add !");
}
if (DGSKUShopingChart.Items.Count > 0)
{
foreach (var item in DGSKUShopingChart.Items)
{
if (item is ListOrderBeli)
{
ListOrderBeli oNewData1 = (ListOrderBeli)item;
produk oproduk = new produk();
oNewData1.Tanggal = DateTime.Parse(dtIssued.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 = shoping.IdPermintaanBarang;
oNewData1.Checkboxaktif = false;
if (shopingBLL.EditOrderProdukBeli(oNewData1, shoping, oproduk) == true)
{
}
}
}
}
PurchaseDocument v = new PurchaseDocument();
Switcher.SwitchNewShopingchart(v);
}
private void SaveQuotationrequest_Click(object sender, RoutedEventArgs e)
{
if (srvendor.Name == "" || txtemail.Name == "" || txthp.Name == "" || dtQuotation.Text == "" || cbCurrency.Text == "" || srnodokumen.Name == "" || txtQuotationNo.Text == "" || cbRequestNo.Name == "" || 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;
}
QuotationrequestBLL quotationrequestBLL = new QuotationrequestBLL();
ShopingchartBLL shopingchartBLL = new ShopingchartBLL();
Quotationrequest oNewData1 = new Quotationrequest();
oNewData1.KodeTransaksi = "RQ";
oNewData1.IdKodeTransaksi = 16;
if (this.kontakSelected != null)
{
oNewData1.IdVendor = this.kontakSelected.Id;
oNewData1.NamaVendor = this.kontakSelected.NamaA;
}
oNewData1.Email = txtemail.Text;
oNewData1.Nohp = txthp.Text;
oNewData1.TanggalPermintaanPenawaranHarga = DateTime.Parse(dtQuotation.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.NoPemintaanPenawaranHarga = double.Parse(txtQuotationNo.Text);
if (this.shopingchartSelected != null)
{
oNewData1.IdPermitaanBarang = this.shopingchartSelected.IdPermintaanBarang;
oNewData1.NoPermintaanBarang = this.shopingchartSelected.NoPermintaanBarang;
oNewData1.IdTransaksi = this.shopingchartSelected.IdPermintaanBarang;
}
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.CheckboxHidePrice = chkhide.IsChecked;
oNewData1.CheckboxSelesai = chkcomplete.IsChecked;
oNewData1.CheckboxInclusiveTax = chkinclusive.IsChecked;
oNewData1.CheckboxBerulang = chkannual.IsChecked;
oNewData1.TanggalPenutupan = DateTime.Parse(dtValidaty.Text);
oNewData1.DurasiBerulang = double.Parse(txtAnnualFrequency.Text);
oNewData1.TanggalBerulang = DateTime.Parse(dtAnnual.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.termspembayaranSelected != null)
{
oNewData1.IdTermPembayaran = this.termspembayaranSelected.IdTermPembayaran;
oNewData1.TermPembayaran = this.termspembayaranSelected.NamaSkema;
}
oNewData1.TotalOrderProduk = double.Parse(txttotalprodukbeforetax.Text);
oNewData1.IdTransaksi = int.Parse(txttota.Text);
oNewData1.TotalOrderJasa = double.Parse(txttotaljasabeforetax.Text);
oNewData1.TotalPajakJasa = double.Parse(txtTotaljasaTax.Text);
oNewData1.TotalPajakProduk = double.Parse(txtTotalprodukTax.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 (quotationrequestBLL.AddQuotationrequests(oNewData1) > 0)
{
// this.ClearForm();
MessageBox.Show("Quotation Request successfully added !");
}
else
{
MessageBox.Show("Quotation Request failed to add !");
}
if (cbRequestNo.Items.Count > 0)
{
foreach (var item in cbRequestNo.Items)
{
if (item is Shopingchart)
{
Shopingchart oNewData2 = (Shopingchart)item;
oNewData2.Checkaktif = false;
if (shopingchartBLL.EditShopingcharts(oNewData2) == true)
{
}
}
}
}
if (DGSKUQuota.Items.Count > 0)
{
foreach (var item in DGSKUQuota.Items)
{
if (item is ListOrderBeli)
{
ListOrderBeli oNewData3 = (ListOrderBeli)item;
produk oDatap = new produk();
oNewData3.Tanggal = DateTime.Parse(dtQuotation.Text);
if (this.lokasiSelected != null)
{
oNewData3.IdLokasi = this.lokasiSelected.Id;
oNewData3.NamaLokasi = this.lokasiSelected.NamaTempatLokasi;
}
if (this.dataDepartemenSelected != null)
{
oNewData3.IdDepartemen = this.dataDepartemenSelected.Id;
}
oNewData3.IdTransaksi = oNewData1.IdPermintaanPenawaranHarga;
if (this.dataProyekSelected != null)
{
oNewData3.IdProyek = this.dataProyekSelected.Id;
}
oNewData3.Checkboxaktif = false;
if (quotationrequestBLL.EditOrderProdukBeli(oNewData3, oNewData1, oDatap) == true)
{
}
}
}
}
if (DGSKUQuotaa.Items.Count > 0)
{
foreach (var item in DGSKUQuota.Items)
{
if (item is ListOrderBeli)
{
ListOrderBeli oNewData3 = (ListOrderBeli)item;
if (quotationrequestBLL.EditOrderProdukBeli1(oNewData3) == true)
{
}
}
}
}
PurchaseDocument v = new PurchaseDocument();
Switcher.SwitchNewQuotationRequest(v);
}
