public bool MergePayments(Company company, PaymentsGrid dgCreditorTranOpenGrid, CreditorPaymentFormat credPaymFormat, SQLCache bankAccountCache)
{
string creditorAcc = string.Empty;
string creditorOCRPaymentId = string.Empty;
string creditorBIC = string.Empty;
string mergePaymIdString = string.Empty;
if (credPaymFormat._PaymentGrouping == PaymentGroupingType.Invoice)
{
return(false);
}
var credCache = company.GetCache(typeof(Uniconta.DataModel.Creditor));
PaymentISO20022Validate paymentISO20022Validate = new PaymentISO20022Validate();
BankSpecificSettings bankSpecific = BankSpecificSettings.BankSpecTypeInstance(credPaymFormat);
try
{
var grid = dgCreditorTranOpenGrid.GetVisibleRows() as IEnumerable <CreditorTransPayment>;
foreach (var rec in grid)
{
if (rec._PaymentFormat != credPaymFormat._Format || rec._OnHold || rec._Paid)
{
rec.MergePaymId = Uniconta.ClientTools.Localization.lookup("Excluded");
continue;
}
//Validate payments >>
paymentISO20022Validate.CompanyBank(credPaymFormat);
var validateRes = paymentISO20022Validate.ValidateISO20022(company, rec, bankAccountCache);
if (validateRes.HasErrors)
{
foreach (CheckError error in validateRes.CheckErrors)
{
rec.ErrorInfo += rec.ErrorInfo == null?error.ToString() : Environment.NewLine + rec.ErrorInfo;
}
rec.MergePaymId = Uniconta.ClientTools.Localization.lookup("Excluded");
continue;
}
else
{
rec.ErrorInfo = BaseDocument.VALIDATE_OK;
}
//Validate payments <<
var creditor = (Uniconta.DataModel.Creditor)credCache.Get(rec.Account);
string creditorNumber = creditor._Account;
string paymGrpVal = string.Empty;
switch (credPaymFormat._PaymentGrouping)
{
case PaymentGroupingType.Date:
paymGrpVal = rec._PaymentDate.ToString("yyyyMMdd");
break;
case PaymentGroupingType.Week:
paymGrpVal = CultureInfo.CurrentCulture.Calendar.GetWeekOfYear(rec._PaymentDate, CalendarWeekRule.FirstFullWeek, DayOfWeek.Monday).ToString();
break;
case PaymentGroupingType.All:
break;
}
var mergePaymId = StringBuilderReuse.Create();
switch (rec._PaymentMethod)
{
case PaymentTypes.VendorBankAccount:
creditorAcc = bankSpecific.CreditorBBAN(rec._PaymentId, creditor._PaymentId, rec._SWIFT);
creditorOCRPaymentId = bankSpecific.CreditorRefNumber(rec._PaymentId);
creditorBIC = bankSpecific.CreditorBIC(rec._SWIFT);
if (creditorOCRPaymentId != string.Empty && creditorBIC != string.Empty)
{
mergePaymId.Append(creditorNumber).Append('-').Append(creditorAcc).Append('-').Append(creditorOCRPaymentId).Append('-').Append(creditorBIC).Append('-').Append(rec.CurrencyLocalStr).Append('-').Append(paymGrpVal);
}
else if (creditorOCRPaymentId != string.Empty)
{
mergePaymId.Append(creditorNumber).Append('-').Append(creditorAcc).Append('-').Append(creditorOCRPaymentId).Append('-').Append(rec.CurrencyLocalStr).Append('-').Append(paymGrpVal);
}
else if (creditorBIC != string.Empty)
{
mergePaymId.Append(creditorNumber).Append('-').Append(creditorAcc).Append('-').Append(creditorBIC).Append('-').Append(rec.CurrencyLocalStr).Append('-').Append(paymGrpVal);
}
else
{
mergePaymId.Append(creditorNumber).Append('-').Append(creditorAcc).Append('-').Append(rec.CurrencyLocalStr).Append('-').Append(paymGrpVal);
}
break;
case PaymentTypes.IBAN:
creditorAcc = bankSpecific.CreditorIBAN(rec._PaymentId, creditor._PaymentId, company._CountryId, creditor._Country);
creditorBIC = bankSpecific.CreditorBIC(rec._SWIFT);
creditorOCRPaymentId = bankSpecific.CreditorRefNumberIBAN(rec._PaymentId, company._CountryId, creditor._Country);
mergePaymId.Append(creditorNumber).Append('-').Append(creditorAcc).Append('-').Append(creditorBIC).Append('-').Append(rec.CurrencyLocalStr).Append('-').Append(paymGrpVal);
break;
case PaymentTypes.PaymentMethod3: //FIK71
var tuple71 = bankSpecific.CreditorFIK71(rec._PaymentId);
creditorOCRPaymentId = tuple71.Item1;
creditorOCRPaymentId = BaseDocument.FIK71 + "/" + creditorOCRPaymentId;
creditorAcc = tuple71.Item2;
mergePaymId.Append(creditorNumber).Append('-').Append(creditorOCRPaymentId).Append('-').Append(creditorAcc).Append('-').Append(rec.CurrencyLocalStr).Append('-').Append(paymGrpVal);
break;
case PaymentTypes.PaymentMethod5: //FIK75
var tuple75 = bankSpecific.CreditorFIK75(rec._PaymentId);
creditorOCRPaymentId = tuple75.Item1;
creditorOCRPaymentId = BaseDocument.FIK75 + "/" + creditorOCRPaymentId;
creditorAcc = tuple75.Item2;
mergePaymId.Append(creditorNumber).Append('-').Append(creditorOCRPaymentId).Append('-').Append(creditorAcc).Append('-').Append(rec.CurrencyLocalStr).Append('-').Append(paymGrpVal);
break;
case PaymentTypes.PaymentMethod4: //FIK73
creditorOCRPaymentId = BaseDocument.FIK73 + "/";
creditorAcc = bankSpecific.CreditorFIK73(rec._PaymentId);
mergePaymId.Append(creditorNumber).Append('-').Append(creditorOCRPaymentId).Append('-').Append(creditorAcc).Append('-').Append(rec.CurrencyLocalStr).Append('-').Append(paymGrpVal);
break;
case PaymentTypes.PaymentMethod6: //FIK04
var tuple04 = bankSpecific.CreditorFIK04(rec._PaymentId);
creditorOCRPaymentId = tuple04.Item1;
creditorOCRPaymentId = BaseDocument.FIK04 + "/" + creditorOCRPaymentId;
creditorAcc = tuple04.Item2;
mergePaymId.Append(creditorNumber).Append('-').Append(creditorOCRPaymentId).Append('-').Append(creditorAcc).Append('-').Append(rec.CurrencyLocalStr).Append('-').Append(paymGrpVal);
break;
}
if (mergePaymId.Length > 0 && mergePaymId[mergePaymId.Length - 1] == '-')
{
mergePaymId.Length--;
}
rec.MergePaymId = mergePaymId.ToStringAndRelease();
}
var noDuplicates = grid.Where(x => x.MergePaymId != Uniconta.ClientTools.Localization.lookup("Excluded")).GroupBy(s => s.MergePaymId).Where(grp => grp.Count() == 1).SelectMany(x => x);
foreach (var rec in noDuplicates)
{
if (rec.PaymentAmount <= 0)
{
rec.MergePaymId = Uniconta.ClientTools.Localization.lookup("Excluded");
rec.ErrorInfo = string.Concat(Uniconta.ClientTools.Localization.lookup("PaymentAmount"), "< 0");
}
else
{
rec.MergePaymId = MERGEID_SINGLEPAYMENT;
}
}
return(true);
}
catch (Exception ex)
{
UnicontaMessageBox.Show(ex, Uniconta.ClientTools.Localization.lookup("Exception"), System.Windows.MessageBoxButton.OK);
return(false);
}
}
public void StatusReport(PaymentsGrid dgCreditorTranOpenGrid, string xmlFileName, CrudAPI capi)
{
try
{
if (!this.IsValidStatusReportFormat(xmlFileName))
{
UnicontaMessageBox.Show(string.Format("Payment Status Report doesn't have a valid format"), Uniconta.ClientTools.Localization.lookup("Error"));
}
else
{
//Clear SystemInfo field>>
var grid = dgCreditorTranOpenGrid.GetVisibleRows() as IEnumerable <CreditorTransPayment>;
foreach (var rec in grid)
{
rec.ErrorInfo = null;
}
//Clear SystemInfo field<<
var changedlst = new List <CrudAPI.UpdatePair>();
using (var xmlReader = new StreamReader(xmlFileName))
{
XmlDocument xmldoc = new XmlDocument();
xmldoc.Load(xmlReader);
var paymStatusList = this.ReadStatusReport(xmldoc);
IEnumerable <UnicontaClient.Pages.CreditorTransPayment> queryPaymentTrans = null;
foreach (var paymStatusRec in paymStatusList)
{
if (dgCreditorTranOpenGrid.ItemsSource != null)
{
var Trans = dgCreditorTranOpenGrid.GetVisibleRows() as IEnumerable <CreditorTransPayment>;
queryPaymentTrans = Trans.Where(paymentTrans =>
{
var endToEndID = Regex.Replace(paymStatusRec.TransEndToEndId ?? "0", "[^0-9]", "");
return(paymentTrans != null && (paymentTrans.PaymentEndToEndId.ToString() == endToEndID));
});
foreach (var rec in queryPaymentTrans)
{
string statusDescription = paymStatusRec.TransStatusCodeAdd == string.Empty ? paymStatusRec.TransStatusDescription : paymStatusRec.TransStatusCodeAdd;
rec.ErrorInfo = string.Format("{0}\n{1}", paymStatusRec.TransStatusDescriptionShort, statusDescription);
if (paymStatusRec.TransStatus == PAYMSTATUSID_ACSC)//The payment has been executed
{
var org = new CreditorTransPayment();
StreamingManager.Copy(rec, org);
rec._Paid = true;
rec.NotifyPropertyChanged("Paid");
changedlst.Add(new CrudAPI.UpdatePair()
{
loaded = org, modified = rec
});
}
}
}
}
if (changedlst != null)
{
capi.Update(changedlst);
}
}
}
}
catch (Exception ex)
{
UnicontaMessageBox.Show(ex, Uniconta.ClientTools.Localization.lookup("Exception"), System.Windows.MessageBoxButton.OK);
return;
}
}