public bool RemoveSalesreturns(int id)
{
methodName = "RemoveSalesreturns";
traceID = 1;
using (var uow = new UnitOfWork(AppConfig.Current.ContextName))
{
using (var trans = uow.BeginTransaction())
{
try
{
traceID = 2;
Salesreturn oDBSalesreturn = uow.SalesReturn.SingleOrDefault(m => m.IdReturPenjualan == id);
if (oDBSalesreturn != null)
{
traceID = 3;
uow.SalesReturn.Remove(id);
uow.Save();
}
traceID = 5;
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new AppException(500, methodName, traceID, ex);
}
}
}
return(true);
}
public bool EditSalesreturns(Salesreturn oData)
{
methodName = "EditSalesreturns";
traceID = 1;
using (var uow = new UnitOfWork(AppConfig.Current.ContextName))
{
traceID = 2;
var oDBData = uow.SalesReturn.Get(oData.IdReturPenjualan);
if (oDBData != null)
{
using (var trans = uow.BeginTransaction())
{
try
{
traceID = 3;
oDBData.MapFrom(oData);
uow.SalesReturn.Update(oDBData);
uow.Save();
traceID = 4;
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new AppException(500, methodName, traceID, ex);
}
}
}
}
return(true);
}
public int AddSalesreturns(Salesreturn oData)
{
methodName = "AddSalesreturns";
traceID = 1;
using (var uow = new UnitOfWork(AppConfig.Current.ContextName))
{
using (var trans = uow.BeginTransaction())
{
try
{
traceID = 2;
Salesreturn oNewSalesreturn = new Salesreturn();
oNewSalesreturn.MapFrom(oData);
oNewSalesreturn = uow.SalesReturn.Add(oNewSalesreturn);
uow.Save();
traceID = 3;
oData.IdReturPenjualan = oNewSalesreturn.IdReturPenjualan;
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new AppException(500, methodName, traceID, ex);
}
}
}
return(oData.IdReturPenjualan);
}
public bool EditOrderProdukjual(OrderProdukJual oData, Salesreturn oDatas)
{
methodName = "EditOrderProdukjual";
traceID = 1;
using (var uow = new UnitOfWork(AppConfig.Current.ContextName))
{
traceID = 2;
var oDBData = uow.OrderProdukJual.Get(oData.IdOrderProdukJual);
if (oDBData != null)
{
using (var trans = uow.BeginTransaction())
{
try
{
traceID = 3;
oDBData.MapFrom(oData);
uow.OrderProdukJual.Update(oDBData);
traceID = 6;
uow.Save();
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new AppException(500, methodName, traceID, ex);
}
}
}
}
return(true);
}
private void DGSalesReturn_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
this.SalesreturnSelected = null;
if (DGSalesReturn.SelectedItem != null)
{
this.SalesreturnSelected = (Salesreturn)DGSalesReturn.SelectedItem;
}
}
private void Delete_Click(object sender, RoutedEventArgs e)
{
if (this.SalesreturnSelected == null)
{
MessageBox.Show("Sales Return not selected !");
}
else
{
SalesreturnBLL salesreturnBLL = new SalesreturnBLL();
if (salesreturnBLL.RemoveSalesreturns(this.SalesreturnSelected.IdReturPenjualan) == true)
{
MessageBox.Show("Sales Return successfully deleted");
this.LoadSalesReturn();
this.SalesreturnSelected = null;
}
}
}
private void Savesales_Click(object sender, RoutedEventArgs e)
{
if (srcustomer.Name == "" || txtemail.Name == "" || txthp.Name == "" || dtSales.Text == "" || cbCurrency.Text == "" || txtsalesreturnno.Text == "" || cbLocation.Text == "" || dtDelivery.Text == "" || srstaff.Name == "" || txtAnnualFrequency.Text == "" || dtAnnual.Text == "")
{
MessageBox.Show("please fill in the blank fields", ("Form Validation"), MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
SalesreturnBLL returnBLL = new SalesreturnBLL();
SalesreturnBLL ReturnBLL = new SalesreturnBLL();
Salesreturn salesreturn = new Salesreturn();
if (this.kontakSelected != null)
{
salesreturn.IdPelanggan = this.kontakSelected.Id;
salesreturn.NamaPelanggan = this.kontakSelected.NamaA;
}
salesreturn.Email = txtemail.Text;
salesreturn.NoHp = txthp.Text;
salesreturn.TanggalReturPenjualan = DateTime.Parse(dtSales.Text);
if (this.DataMataUangSelected != null)
{
salesreturn.IdMataUang = this.DataMataUangSelected.Id;
salesreturn.MataUang = this.DataMataUangSelected.NamaMataUang;
salesreturn.KursTukar = this.DataMataUangSelected.KursTukar;
}
if (this.dokumenSelected != null)
{
salesreturn.IdNoReferensiDokumen = this.dokumenSelected.Id;
salesreturn.NoReferensiDokumen = this.dokumenSelected.NoReferensiDokumen;
}
salesreturn.NoReturPenjualan = txtsalesreturnno.Text;
if (this.invoiceSelected != null)
{
salesreturn.IdReferalTransaksi = this.invoiceSelected.IdOrderPenjualan;
salesreturn.NoReferensiTransaksi = this.invoiceSelected.NoOrderPenjualan;
}
salesreturn.Keterangan = txtNote.Text;
if (this.lokasiSelected != null)
{
salesreturn.IdLokasi = this.lokasiSelected.Id;
salesreturn.NamaLokasi = this.lokasiSelected.NamaTempatLokasi;
}
if (this.dataDepartemenSelected != null)
{
salesreturn.IdDepartemen = this.dataDepartemenSelected.Id;
}
if (this.dataProyekSelected != null)
{
salesreturn.IdProyek = this.dataProyekSelected.Id;
}
salesreturn.CheckboxInclusiveTax = chkinclusive.IsChecked;
salesreturn.TanggalPengantaran = DateTime.Parse(dtDelivery.Text);
salesreturn.DurasiBerulang = double.Parse(txtAnnualFrequency.Text);
salesreturn.TanggalBerulang = DateTime.Parse(dtAnnual.Text);
if (this.optionAnnualSelected != null)
{
salesreturn.IdOpsiAnnual = this.optionAnnualSelected.IdOptionAnnual;
salesreturn.Annual = this.optionAnnualSelected.Annual;
}
if (this.petugasSelected != null)
{
salesreturn.IdPetugas = this.petugasSelected.Id;
salesreturn.NamaPetugas = this.petugasSelected.NamaA;
}
if (this.invoiceSelected != null)
{
salesreturn.IdTransaksi = this.invoiceSelected.IdTransaksi;
}
salesreturn.Checkboxberulang = chkannual.IsChecked;
salesreturn.IdKodeTransaksi = 25;
salesreturn.KodeTransaksi = "SR";
salesreturn.IdPeriodeAkuntansi = 1;
salesreturn.RealRecongitionTime = DateTime.Now;
salesreturn.TotalSebelumPajak = double.Parse(txtTotalbeforeTax.Text);
salesreturn.TotalPajak = double.Parse(txtTotalTax.Text);
salesreturn.TotalSetelahPajak = double.Parse(txtAfterTotalTax.Text);
if (ReturnBLL.AddSalesreturns(salesreturn) > 0)
{
// this.ClearForm();
MessageBox.Show("Sales Return successfully added !");
}
else
{
MessageBox.Show("Sales Return failed to add !");
}
SalesReturn v = new SalesReturn();
Switcher.SwitchNewSalesReturn(v);
}
