public void UpdateTotalRemittanceAmount(Guid txID, long remittanceId)
{
FnRemittanceDataset fnRemittanceDS = (FnRemittanceDataset)TransactionService.GetDS(txID);
if (fnRemittanceDS != null)
{
double totalRemittanceAmount = 0;
double totalRemittanceMainAmount = 0;
FnRemittanceDataset.FnRemittanceItemRow[] items = (FnRemittanceDataset.FnRemittanceItemRow[])fnRemittanceDS.FnRemittanceItem.Select();
FnRemittanceDataset.FnRemittanceRow fnremittanceRow = fnRemittanceDS.FnRemittance.FindByRemittanceID(remittanceId);
if (items.Length > 0)
{
totalRemittanceAmount = items.Sum(x => x.AmountTHB);
if ((!fnremittanceRow.IsIsRepOfficeNull() && fnremittanceRow.IsRepOffice))
{
totalRemittanceMainAmount = items.Sum(x => x.MainCurrencyAmount);
}
}
fnremittanceRow.BeginEdit();
fnremittanceRow.TotalAmount = (double)Math.Round((decimal)totalRemittanceAmount, 2, MidpointRounding.AwayFromZero);
fnremittanceRow.MainCurrencyAmount = (double)Math.Round((decimal)totalRemittanceMainAmount, 2, MidpointRounding.AwayFromZero);
//fnremittanceRow.IsRepOffice = isRepOffice;
fnremittanceRow.EndEdit();
}
}
public void UpdateRemittanceDocumentTransaction(Guid txtID, FnRemittance fnRemittance, bool IsHeaderAndFooter)
{
this.ValidateRemittance(fnRemittance, IsHeaderAndFooter); // function to validateion of remittance.
Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors();
FnRemittanceDataset fnRemittanceDS = (FnRemittanceDataset)TransactionService.GetDS(txtID);
#region FnRemittanceDocument
FnRemittanceDataset.FnRemittanceRow fnremittanceRow = fnRemittanceDS.FnRemittance.FindByRemittanceID(fnRemittance.RemittanceID);
if (!IsHeaderAndFooter && fnremittanceRow.TotalAmount == 0)
{
errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("CannotSaveRemittance_TotalRemittanceAmountMustMoreThanZero"));
}
if (!errors.IsEmpty)
{
throw new ServiceValidationException(errors);
}
fnremittanceRow.BeginEdit();
if (fnRemittance.Document != null)
{
fnremittanceRow.DocumentID = fnRemittance.Document.DocumentID;
}
if (fnRemittance.TADocumentID > 0)
{
fnremittanceRow.TADocumentID = fnRemittance.TADocumentID;
}
if (fnRemittance.PB != null)
{
fnremittanceRow.PBID = fnRemittance.PB.Pbid;
}
if (fnRemittance.MainCurrencyID != null)
{
fnremittanceRow.MainCurrencyID = fnRemittance.MainCurrencyID;
}
//fnremittanceRow.TotalAmount = (double)Math.Round((decimal)fnRemittance.TotalAmount, 2, MidpointRounding.AwayFromZero);
fnremittanceRow.isFullClearing = fnRemittance.IsFullClearing;
fnremittanceRow.IsRepOffice = Convert.ToBoolean(fnRemittance.IsRepOffice);
fnremittanceRow.Active = fnRemittance.Active;
fnremittanceRow.CreBy = UserAccount.UserID;
fnremittanceRow.CreDate = DateTime.Now;
fnremittanceRow.UpdBy = UserAccount.UserID;
fnremittanceRow.UpdDate = DateTime.Now;;
fnremittanceRow.UpdPgm = UserAccount.CurrentProgramCode;
fnremittanceRow.EndEdit();
#endregion
}