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