private bool isInputValid()
{
if (itxt_InvoiceNo.isEmpty())
{
return(itxt_InvoiceNo.isValueError("Invalid Invoice No"));
}
else if (VendorInvoice.isInvoiceNoExist(_vendorInvoice.ID, itxt_InvoiceNo.ValueText))
{
return(itxt_InvoiceNo.isValueError("Invoice No already exists"));
}
if (_fakturPajak != null) //edit assigned FP
{
if (itxt_FakturPajak_No.isEmpty())
{
return(itxt_FakturPajak_No.isValueError("Please provide No"));
}
else if (FakturPajak.isNoExist(_fakturPajak.Id, itxt_FakturPajak_No.ValueText))
{
return(itxt_FakturPajak_No.isValueError("FP No already exists"));
}
}
else if (!itxt_FakturPajak_No.isEmpty()) //add new FP
{
if (FakturPajak.isNoExist(null, itxt_FakturPajak_No.ValueText))
{
return(itxt_FakturPajak_No.isValueError("FP No already exists"));
}
}
return(true);
}
private void GridFakturPajaks_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (Util.isColumnMatch(sender, e, col_gridFakturPajaks_removeKontrabons_Id))
{
FakturPajak.update_Kontrabons_Id((Guid)Util.getSelectedRowValue(sender, col_gridFakturPajaks_Id), null);
updateRowInfo();
}
}
public VendorInvoices_Edit_Form(Guid id)
{
InitializeComponent();
_vendorInvoice = new VendorInvoice(id);
if (_vendorInvoice.FakturPajaks_Id != null)
{
_fakturPajak = new FakturPajak(_vendorInvoice.FakturPajaks_Id);
}
btnRemoveFakturPajakFromVendorInvoice.Enabled = (_vendorInvoice.FakturPajaks_Id != null);
}
/*******************************************************************************************************/
#region METHODS
private void populateGridFakturPajaks(bool repopulateGridKontrabon)
{
DataTable data = FakturPajak.get_by_Kontrabons_Id((Guid)_lastSelectedKontrabons_Id);
Util.setGridviewDataSource(gridFakturPajaks, data);
tpFakturPajaks.Text = string.Format("{0}: {1:N2}", TABTITLE_FakturPajaks, Util.compute(data, "SUM", FakturPajak.COL_TotalAmount, ""));
if (repopulateGridKontrabon)
{
populateGridViewDataSource(true);
}
}
protected override void add()
{
Guid?Customers_Id = null;
Guid?Vendors_Id = null;
if (rbVendor.Checked)
{
Vendors_Id = (Guid?)iddl_Vendors.SelectedValue;
}
else
{
Customers_Id = (Guid?)iddl_Customers.SelectedValue;
}
FakturPajak.add((DateTime)idtp_Timestamp.ValueAsStartDateFilter, Customers_Id, Vendors_Id, itxt_No.ValueText, in_DPP.ValueDecimal, in_PPN.ValueDecimal, itxt_Notes.ValueText);
}
protected override void populateInputFields()
{
FakturPajak obj = new FakturPajak(selectedRowID());
idtp_Timestamp.Value = obj.Timestamp;
itxt_No.ValueText = obj.No;
in_DPP.Value = obj.DPP;
in_PPN.Value = obj.PPN;
itxt_Notes.ValueText = obj.Notes;
iddl_Customers.SelectedValue = obj.Customers_Id;
iddl_Vendors.SelectedValue = obj.Vendors_Id;
rbVendor.Checked = (obj.Vendors_Id != null);
setRadioButtonEnability(rbVendor);
}
private void BtnAddFakturPajaks_Click(object sender, EventArgs e)
{
if (_lastSelectedKontrabons_Id == null)
{
Util.displayMessageBoxError("Double click kontrabon");
}
else
{
SharedForms.MasterData_v1_FakturPajaks_Form form = new SharedForms.MasterData_v1_FakturPajaks_Form(FormModes.Browse, (Guid)Util.getSelectedRowValue(dgv, col_dgv_Customers_Id));
Util.displayForm(null, form);
if (form.DialogResult == DialogResult.OK)
{
FakturPajak.update_Kontrabons_Id(form.BrowsedItemSelectionId, _lastSelectedKontrabons_Id);
updateRowInfo();
}
}
}
private void BtnRemoveFakturPajakFromVendorInvoice_Click(object sender, EventArgs e)
{
if (Util.displayMessageBoxYesNo("Remove FP connection to this Invoice? FP is NOT deleted"))
{
VendorInvoice.update_FakturPajaks_Id(_vendorInvoice.ID, null);
_vendorInvoice = new VendorInvoice(_vendorInvoice.ID);
if (_vendorInvoice.FakturPajaks_Id == null)
{
_fakturPajak = null;
}
else
{
_fakturPajak = new FakturPajak(_vendorInvoice.FakturPajaks_Id);
}
btnRemoveFakturPajakFromVendorInvoice.Enabled = (_vendorInvoice.FakturPajaks_Id != null);
populateFakturPajak();
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
if (isInputValid())
{
VendorInvoice.update(_vendorInvoice.ID, (DateTime)idtp_Timestamp.ValueAsStartDateFilter, itxt_InvoiceNo.ValueText, in_Amount.ValueDecimal, in_TOP.ValueInt, itxt_Notes.ValueText);
if (_fakturPajak != null) //edit assigned FP
{
FakturPajak.update(_fakturPajak.Id, (DateTime)idtp_Timestamp.ValueAsStartDateFilter, null, _vendorInvoice.Vendors_Id, itxt_FakturPajak_No.ValueText, in_FakturPajak_DPP.ValueDecimal, in_FakturPajak_PPN.ValueDecimal, itxt_FakturPajak_Notes.ValueText);
}
else if (!itxt_FakturPajak_No.isEmpty()) //add new FP
{
Guid FakturPajaks_Id = FakturPajak.add((DateTime)idtp_Timestamp.ValueAsStartDateFilter, null, _vendorInvoice.Vendors_Id, itxt_FakturPajak_No.ValueText, in_FakturPajak_DPP.ValueDecimal, in_FakturPajak_PPN.ValueDecimal, itxt_FakturPajak_Notes.ValueText);
VendorInvoice.update_FakturPajaks_Id(_vendorInvoice.ID, FakturPajaks_Id);
}
this.Close();
}
}
protected override Boolean isInputFieldsValid()
{
if (itxt_No.isEmpty())
{
return(itxt_No.isValueError("Please provide No"));
}
else if (rbCustomer.Checked && !iddl_Customers.hasSelectedValue())
{
return(iddl_Customers.SelectedValueError("Please select Customer"));
}
else if (rbVendor.Checked && !iddl_Vendors.hasSelectedValue())
{
return(iddl_Vendors.SelectedValueError("Please select Vendor"));
}
else if ((Mode != FormModes.Update && FakturPajak.isNoExist(null, itxt_No.ValueText)) ||
(Mode == FormModes.Update && FakturPajak.isNoExist(selectedRowID(), itxt_No.ValueText)))
{
return(itxt_No.isValueError("No is already in the list"));
}
return(true);
}
private void SetViewBagFooter(FakturPajak fakturPajak)
{
ExchangeRate _USDRate = reportFakturPajak.FindRateUSD(DateTime.Today.Date);
//decimal totalpenjualan = CalculateTotalPenjualan(fakturPajak, _USDRate);
//decimal totalkonsesi = TotalKonsesi(totalpenjualan, fakturPajak);
//decimal totalbagihasil = totalkonsesi * fakturPajak.Tarif;
//decimal totalpajakbagihasil = Math.Round(totalbagihasil * fakturPajak.Pajak, 2);
//decimal totaltagihan = totalpajakbagihasil + totalbagihasil;
if (fakturPajak.CcyCode.ToUpper() == USD)
{
decimal totaltagihanIDR = Math.Round(fakturPajak.PajakBagiHasil,2) * _USDRate.Rate;
ViewBag.TotalTagihanIDR = "Rp " + totaltagihanIDR.ToString("N0");
ViewBag.Rate = _USDRate.Rate;
}
ViewBag.TotalKonsesi = fakturPajak.CcyCode.ToUpper() == USD ? USD + " " + fakturPajak.Konsesi.ToString("N2") : fakturPajak.Konsesi.ToString("N0");
ViewBag.TotalPenjualan = fakturPajak.CcyCode.ToUpper() == USD ? USD + " " + fakturPajak.Penjualan.ToString("N2") : fakturPajak.Penjualan.ToString("N0");
ViewBag.TotalBagiHasil = fakturPajak.CcyCode.ToUpper() == USD ? USD + " " + fakturPajak.BagiHasil.ToString("N2") : fakturPajak.BagiHasil.ToString("N0");
ViewBag.TotalPajakBagiHasil = fakturPajak.CcyCode.ToUpper() == USD ? USD + " " + fakturPajak.PajakBagiHasil.ToString("N2") : fakturPajak.PajakBagiHasil.ToString("N0");
ViewBag.TotalTagihan = fakturPajak.CcyCode.ToUpper() == USD ? USD + " " + fakturPajak.Tagihan.ToString("N2") : "Rp " + fakturPajak.Tagihan.ToString("N0");
//if(fakturPajak.CcyCode.ToUpper() == USD)
//{
// ViewBag.Rate = _USDRate.Rate;
// ViewBag.TotalTagihan = IDR + " " + (totaltagihan * _USDRate.Rate).ToString("N");
// ViewBag.Say = SetCcyTerbilang(totaltagihan, fakturPajak.CcyCode);
//}
//else
//{
// ViewBag.Rate = 1;
// ViewBag.TotalTagihan = IDR + " " + (totalbagihasil).ToString("N");
// ViewBag.Say = SetCcyTerbilang(totaltagihan, fakturPajak.CcyCode);
//}
}
private decimal CalculateTotalPenjualan(FakturPajak fakturPajak, ExchangeRate usdRate)
{
if (usdRate == null)
throw new ApplicationException("Rate USD tanggal " + DateTime.Today.Date.ToString("dd / MM /yyyy") + " tidak ditemukan.");
if (fakturPajak.CcyCode.ToUpper() == USD)
return (fakturPajak.TotalPenjualan / usdRate.Rate) + fakturPajak.TotalPenjualanInUSD;
return fakturPajak.TotalPenjualan + (fakturPajak.TotalPenjualanInUSD * usdRate.Rate);
}
public decimal TotalKonsesi(decimal totalPenjualan, FakturPajak fakturPajak)
{
if (fakturPajak.Penjualan < fakturPajak.Target)
{
return fakturPajak.Target;
}
return totalPenjualan;
}
protected override void updateCheckbox1Column(Guid id, Boolean newValue)
{
FakturPajak.updateCompleted(id, newValue);
setButtonsVisibility(!newValue);
}
protected override DataView loadGridviewDataSource()
{
return(FakturPajak.get(itxt_No.ValueText, (Guid?)iddl_Customers.SelectedValue, (Guid?)iddl_Vendors.SelectedValue,
idtp_MonthFilter.getFirstDayOfSelectedMonth(), idtp_MonthFilter.getLastDayOfSelectedMonth(), chkShowCompleted.Checked).DefaultView);
}
