/// <summary>
/// Format the letter for the donor with all the gifts
///
/// Can also used for a single receipt.
/// </summary>
/// <returns>One or more html documents, each in its own body tag, for printing with the HTML printer</returns>
private static string FormatLetter(Int64 ADonorKey,
string ADonorName,
DataTable ADonations,
string ABaseCurrency,
string AHTMLTemplate,
string ALedgerCountryCode,
TDBTransaction ATransaction)
{
// get details of the donor, and best address
PLocationTable Location;
PPartnerLocationTable PartnerLocation;
string CountryName;
string EmailAddress;
if (!TAddressTools.GetBestAddress(ADonorKey, out Location, out PartnerLocation, out CountryName, out EmailAddress, ATransaction))
{
return("");
}
bool TaxDeductiblePercentageEnabled = Convert.ToBoolean(
TSystemDefaults.GetSystemDefault(SharedConstants.SYSDEFAULT_TAXDEDUCTIBLEPERCENTAGE, "FALSE"));
string msg = AHTMLTemplate;
if (ADonorName.Contains(","))
{
msg = msg.Replace("#TITLE", Calculations.FormatShortName(ADonorName, eShortNameFormat.eOnlyTitle));
}
else
{
// organisations have no title
msg = msg.Replace("#TITLE", "");
}
msg = msg.Replace("#NAME", Calculations.FormatShortName(ADonorName, eShortNameFormat.eReverseWithoutTitle));
msg = msg.Replace("#STREETNAME", GetStringOrEmpty(Location[0].StreetName));
msg = msg.Replace("#LOCATION", GetStringOrEmpty(Location[0].Locality));
msg = msg.Replace("#ADDRESS3", GetStringOrEmpty(Location[0].Address3));
msg = msg.Replace("#BUILDING1", GetStringOrEmpty(Location[0].Building1));
msg = msg.Replace("#BUILDING2", GetStringOrEmpty(Location[0].Building2));
msg = msg.Replace("#CITY", GetStringOrEmpty(Location[0].City));
msg = msg.Replace("#POSTALCODE", GetStringOrEmpty(Location[0].PostalCode));
msg = msg.Replace("#DATE", DateTime.Now.ToString("d. MMMM yyyy"));
// according to German Post, there is no country code in front of the post code
// if country code is same for the address of the recipient and this office, then COUNTRYNAME is cleared
if (GetStringOrEmpty(Location[0].CountryCode) != ALedgerCountryCode)
{
msg = msg.Replace("#COUNTRYNAME", CountryName);
}
else
{
msg = msg.Replace("#COUNTRYNAME", "");
}
// recognise detail lines automatically
string RowTemplate;
msg = TPrinterHtml.GetTableRow(msg, "#AMOUNT", out RowTemplate);
string OrigRowTemplate = RowTemplate;
string rowTexts = "";
decimal sum = 0;
decimal sumTaxDeduct = 0;
decimal sumNonDeduct = 0;
decimal prevAmount = 0.0M;
decimal prevAmountTaxDeduct = 0.0M;
decimal prevAmountNonDeduct = 0.0M;
string prevCurrency = String.Empty;
string prevCommentOne = String.Empty;
string prevAccountDesc = String.Empty;
string prevCostCentreDesc = String.Empty;
string prevgifttype = string.Empty;
DateTime prevDateEntered = DateTime.MaxValue;
foreach (DataRow rowGifts in ADonations.Rows)
{
DateTime dateEntered = Convert.ToDateTime(rowGifts["DateEntered"]);
decimal amount = Convert.ToDecimal(rowGifts["TransactionAmount"]);
decimal taxDeductibleAmount = 0;
decimal nonDeductibleAmount = 0;
string currency = rowGifts["Currency"].ToString();
string commentOne = rowGifts["CommentOne"].ToString();
string accountDesc = rowGifts["AccountDesc"].ToString();
string costcentreDesc = rowGifts["CostCentreDesc"].ToString();
string gifttype = rowGifts["GiftType"].ToString();
RowTemplate = OrigRowTemplate;
sum += Convert.ToDecimal(rowGifts["AmountInBaseCurrency"]);
if (TaxDeductiblePercentageEnabled)
{
taxDeductibleAmount = Convert.ToDecimal(rowGifts["TaxDeductibleAmount"]);
nonDeductibleAmount = Convert.ToDecimal(rowGifts["NonDeductibleAmount"]);
sumTaxDeduct += Convert.ToDecimal(rowGifts["TaxDeductibleAmountBase"]);
sumNonDeduct += Convert.ToDecimal(rowGifts["NonDeductibleAmountBase"]);
}
// can we sum up donations on the same date, or do we need to print each detail with the account description?
if (RowTemplate.Contains("#COMMENTONE") || RowTemplate.Contains("#ACCOUNTDESC") || RowTemplate.Contains("#COSTCENTREDESC"))
{
if (gifttype == MFinanceConstants.GIFT_TYPE_GIFT_IN_KIND)
{
RowTemplate = TPrinterHtml.RemoveDivWithClass(RowTemplate, MFinanceConstants.GIFT_TYPE_GIFT);
}
else if (gifttype == MFinanceConstants.GIFT_TYPE_GIFT)
{
RowTemplate = TPrinterHtml.RemoveDivWithClass(RowTemplate, MFinanceConstants.GIFT_TYPE_GIFT_IN_KIND);
}
rowTexts += RowTemplate.
Replace("#DONATIONDATE", dateEntered.ToString("dd.MM.yyyy")).
Replace("#AMOUNTCURRENCY", currency).
Replace("#AMOUNT", StringHelper.FormatUsingCurrencyCode(amount, currency)).
Replace("#TAXDEDUCTAMOUNT", StringHelper.FormatUsingCurrencyCode(taxDeductibleAmount, currency)).
Replace("#TAXNONDEDUCTAMOUNT", StringHelper.FormatUsingCurrencyCode(nonDeductibleAmount, currency)).
Replace("#COMMENTONE", commentOne).
Replace("#ACCOUNTDESC", accountDesc).
Replace("#COSTCENTREDESC", costcentreDesc);
}
else
{
if ((dateEntered != prevDateEntered) && (prevDateEntered != DateTime.MaxValue))
{
if (prevgifttype == MFinanceConstants.GIFT_TYPE_GIFT_IN_KIND)
{
RowTemplate = TPrinterHtml.RemoveDivWithClass(RowTemplate, MFinanceConstants.GIFT_TYPE_GIFT);
}
else if (prevgifttype == MFinanceConstants.GIFT_TYPE_GIFT)
{
RowTemplate = TPrinterHtml.RemoveDivWithClass(RowTemplate, MFinanceConstants.GIFT_TYPE_GIFT_IN_KIND);
}
rowTexts += RowTemplate.
Replace("#DONATIONDATE", prevDateEntered.ToString("dd.MM.yyyy")).
Replace("#AMOUNTCURRENCY", prevCurrency).
Replace("#AMOUNT", StringHelper.FormatUsingCurrencyCode(prevAmount, prevCurrency)).
Replace("#TAXDEDUCTAMOUNT", StringHelper.FormatUsingCurrencyCode(prevAmountTaxDeduct, prevCurrency)).
Replace("#TAXNONDEDUCTAMOUNT", StringHelper.FormatUsingCurrencyCode(prevAmountNonDeduct, prevCurrency)).
Replace("#COMMENTONE", prevCommentOne).
Replace("#ACCOUNTDESC", prevAccountDesc).
Replace("#COSTCENTREDESC", prevCostCentreDesc);
prevAmount = amount;
if (TaxDeductiblePercentageEnabled)
{
prevAmountTaxDeduct = taxDeductibleAmount;
prevAmountNonDeduct = nonDeductibleAmount;
}
}
else
{
prevAmount += amount;
if (TaxDeductiblePercentageEnabled)
{
prevAmountTaxDeduct += taxDeductibleAmount;
prevAmountNonDeduct += nonDeductibleAmount;
}
}
prevCurrency = currency;
prevDateEntered = dateEntered;
prevCommentOne = commentOne;
prevAccountDesc = accountDesc;
prevCostCentreDesc = costcentreDesc;
prevgifttype = gifttype;
}
}
if (prevDateEntered != DateTime.MaxValue)
{
RowTemplate = OrigRowTemplate;
if (prevgifttype == MFinanceConstants.GIFT_TYPE_GIFT_IN_KIND)
{
RowTemplate = TPrinterHtml.RemoveDivWithClass(RowTemplate, MFinanceConstants.GIFT_TYPE_GIFT);
}
else if (prevgifttype == MFinanceConstants.GIFT_TYPE_GIFT)
{
RowTemplate = TPrinterHtml.RemoveDivWithClass(RowTemplate, MFinanceConstants.GIFT_TYPE_GIFT_IN_KIND);
}
rowTexts += RowTemplate.
Replace("#DONATIONDATE", prevDateEntered.ToString("dd.MM.yyyy")).
Replace("#AMOUNTCURRENCY", prevCurrency).
Replace("#AMOUNT", StringHelper.FormatUsingCurrencyCode(prevAmount, prevCurrency)).
Replace("#TAXDEDUCTAMOUNT", StringHelper.FormatUsingCurrencyCode(prevAmountTaxDeduct, prevCurrency)).
Replace("#TAXNONDEDUCTAMOUNT", StringHelper.FormatUsingCurrencyCode(prevAmountNonDeduct, prevCurrency)).
Replace("#COMMENTONE", prevCommentOne).
Replace("#ACCOUNTDESC", prevAccountDesc).
Replace("#COSTCENTREDESC", prevCostCentreDesc);
prevAmount = 0.0M;
if (TaxDeductiblePercentageEnabled)
{
prevAmountTaxDeduct = 0.0M;
prevAmountNonDeduct = 0.0M;
}
}
msg = msg.Replace("#OVERALLAMOUNTCURRENCY", ABaseCurrency).
Replace("#OVERALLAMOUNT", StringHelper.FormatUsingCurrencyCode(sum, ABaseCurrency)).
Replace("#OVERALLTAXDEDUCTAMOUNT", StringHelper.FormatUsingCurrencyCode(sumTaxDeduct, ABaseCurrency)).
Replace("#OVERALLTAXNONDEDUCTAMOUNT", StringHelper.FormatUsingCurrencyCode(sumNonDeduct, ABaseCurrency));
if ((ADonations.Rows.Count == 1) && msg.Contains("#DONATIONDATE"))
{
// this is a receipt for just one gift
msg = msg.Replace("#DONATIONDATE", Convert.ToDateTime(ADonations.Rows[0]["DateEntered"]).ToString("dd.MM.yyyy"));
}
// TODO allow other currencies. use a_currency table, and base currency
msg = msg.Replace("#TOTALAMOUNTINWORDS", NumberToWords.AmountToWords(sum, "Euro", "Cent")).
Replace("#TOTALTAXDEDUCTAMOUNTINWORDS", NumberToWords.AmountToWords(sumTaxDeduct, "Euro", "Cent")).
Replace("#TOTALTAXNONDEDUCTAMOUNTINWORDS", NumberToWords.AmountToWords(sumNonDeduct, "Euro", "Cent"));
return(msg.Replace("#ROWTEMPLATE", rowTexts));
}
