public bool EditSalesquotation(Salesquotation oData)
{
methodName = "EditSalesquotation";
traceID = 1;
using (var uow = new UnitOfWork(AppConfig.Current.ContextName))
{
traceID = 2;
var oDBData = uow.Salesquotation.Get(oData.Id);
if (oDBData != null)
{
using (var trans = uow.BeginTransaction())
{
try
{
traceID = 3;
oDBData.MapFrom(oData);
uow.Salesquotation.Update(oDBData);
uow.Save();
traceID = 4;
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new AppException(500, methodName, traceID, ex);
}
}
}
}
return(true);
}
public bool RemoveSalesquotation(int id)
{
methodName = "RemoveSalesquotation";
traceID = 1;
using (var uow = new UnitOfWork(AppConfig.Current.ContextName))
{
using (var trans = uow.BeginTransaction())
{
try
{
traceID = 2;
Salesquotation oDBSalesquotation = uow.Salesquotation.SingleOrDefault(m => m.Id == id);
if (oDBSalesquotation != 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);
}
private void Salesquotation_selectedchange(object sender, SelectionChangedEventArgs e)
{
this.salesquotationSelected = null;
if (cbSalesquota.SelectedItem != null)
{
this.salesquotationSelected = (Salesquotation)cbSalesquota.SelectedItem;
this.LoadDataSku();
this.LoadDataQuota();
}
}
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 int AddSalesquotation(Salesquotation oData)
{
methodName = "AddSalesquotation";
traceID = 1;
using (var uow = new UnitOfWork(AppConfig.Current.ContextName))
{
using (var trans = uow.BeginTransaction())
{
try
{
traceID = 2;
Salesquotation oNewSalesquotation = new Salesquotation();
oNewSalesquotation.MapFrom(oData);
oNewSalesquotation = uow.Salesquotation.Add(oNewSalesquotation);
uow.Save();
/* if (oNewSalesquotation.Id > 0)
* {
* traceID = 3;
* oData.Id = oNewSalesquotation.Id;
* SalesOrder oNewsalesorder = new SalesOrder();
* oNewsalesorder.MapFrom(oData);
*
* traceID = 4;
* oNewsalesorder.IdTransaksi = oData.Id;
* uow.SalesOrder.Add(oNewsalesorder);
* }
*
* if (oNewSalesquotation.Id > 0)
* {
* traceID = 3;
* oData.Id = oNewSalesquotation.Id;
* Deliveryorders oNeworder = new Deliveryorders();
* oNeworder.MapFrom(oData);
*
* traceID = 4;
* oNeworder.IdTransaksi = oData.Id;
* uow.DeliveryOrder.Add(oNeworder);
* }
*
* if (oNewSalesquotation.Id > 0)
* {
* traceID = 3;
* oData.Id = oNewSalesquotation.Id;
* invoice oNewinvoice = new invoice();
* oNewinvoice.MapFrom(oData);
*
* traceID = 4;
* oNewinvoice.IdTransaksi = oData.Id;
* uow.Invoice.Add(oNewinvoice);
* }
*
* if (oNewSalesquotation.Id > 0)
* {
* traceID = 3;
* oData.Id = oNewSalesquotation.Id;
* Salesreturn oNewgood = new Salesreturn();
* oNewgood.MapFrom(oData);
*
* traceID = 4;
* oNewgood.IdTransaksi = oData.Id;
* uow.SalesReturn.Add(oNewgood);
* }*/
traceID = 3;
oData.Id = oNewSalesquotation.Id;
oData.IdTransaksi = oNewSalesquotation.Id;
uow.Save();
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new AppException(500, methodName, traceID, ex);
}
}
}
return(oData.Id);
}
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);
}
