//:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
/// <summary>
/// Generate Fast Report Business Objects for ProcessReportFinanceDocumentPayment
/// </summary>
public static ResultFRBODocumentFinancePayment GetFRBOFinancePayment(Guid pDocumentFinancePaymentOid)
{
ResultFRBODocumentFinancePayment result = new ResultFRBODocumentFinancePayment();
try
{
FIN_DocumentFinancePayment documentFinancePayment = (FIN_DocumentFinancePayment)FrameworkUtils.GetXPGuidObject(GlobalFramework.SessionXpo, typeof(FIN_DocumentFinancePayment), pDocumentFinancePaymentOid);
string sqlFilter = string.Format("fpaOid = '{0}'", pDocumentFinancePaymentOid.ToString());
//Prepare and Declare FRBOGenericCollections
FRBOGenericCollection <FRBODocumentFinancePaymentView> gcDocumentFinancePayment = new FRBOGenericCollection <FRBODocumentFinancePaymentView>(sqlFilter);
FRBOGenericCollection <FRBODocumentFinancePaymentDocumentView> gcDocumentFinancePaymentDocument;
//Decrypt Values
gcDocumentFinancePayment.List[0].EntityName = XPGuidObject.DecryptIfNeeded(gcDocumentFinancePayment.List[0].EntityName).ToString();
gcDocumentFinancePayment.List[0].EntityAddress = XPGuidObject.DecryptIfNeeded(gcDocumentFinancePayment.List[0].EntityAddress).ToString();
gcDocumentFinancePayment.List[0].EntityZipCode = XPGuidObject.DecryptIfNeeded(gcDocumentFinancePayment.List[0].EntityZipCode).ToString();
gcDocumentFinancePayment.List[0].EntityCity = XPGuidObject.DecryptIfNeeded(gcDocumentFinancePayment.List[0].EntityCity).ToString();
gcDocumentFinancePayment.List[0].EntityFiscalNumber = XPGuidObject.DecryptIfNeeded(gcDocumentFinancePayment.List[0].EntityFiscalNumber).ToString();
//If FinalConsumer - Clean Output Data
if (gcDocumentFinancePayment.List[0].EntityFiscalNumber == SettingsApp.FinanceFinalConsumerFiscalNumber)
{
gcDocumentFinancePayment.List[0].EntityName = string.Empty;
gcDocumentFinancePayment.List[0].EntityAddress = string.Empty;
gcDocumentFinancePayment.List[0].EntityZipCode = string.Empty;
gcDocumentFinancePayment.List[0].EntityCity = string.Empty;
gcDocumentFinancePayment.List[0].EntityFiscalNumber = SettingsApp.FinanceFinalConsumerFiscalNumberDisplay;
}
//Render Child Bussiness Objects
foreach (FRBODocumentFinancePaymentView documentFinanceMasterPayment in gcDocumentFinancePayment)
{
//Get FinanceDetail
gcDocumentFinancePaymentDocument = new FRBOGenericCollection <FRBODocumentFinancePaymentDocumentView>(string.Format("fpaOid = '{0}'", documentFinanceMasterPayment.Oid), "ftpCode, fmaDocumentNumber");
documentFinanceMasterPayment.DocumentFinancePaymentDocument = gcDocumentFinancePaymentDocument.List;
}
result.DocumentFinancePayment = gcDocumentFinancePayment;
}
catch (Exception ex)
{
_log.Error(ex.Message, ex);
}
return(result);
}
/// <summary>
/// Generate Fast Report Business Objects for ProcessReportFinanceDocument
/// </summary>
public static ResultFRBODocumentFinanceMaster GetFRBOFinanceDocument(Guid pDocumentFinanceMasterOid)
{
ResultFRBODocumentFinanceMaster result = new ResultFRBODocumentFinanceMaster();
try
{
fin_documentfinancemaster documentFinanceMaster = (fin_documentfinancemaster)FrameworkUtils.GetXPGuidObject(GlobalFramework.SessionXpo, typeof(fin_documentfinancemaster), pDocumentFinanceMasterOid);
bool retificationDocuments = (
documentFinanceMaster.DocumentType.Oid == SettingsApp.XpoOidDocumentFinanceTypeCreditNote
);
/* IN009173 */
bool isTransportDocument = (
documentFinanceMaster.DocumentType.Oid == SettingsApp.XpoOidDocumentFinanceTypeTransportationGuide ||
documentFinanceMaster.DocumentType.Oid == SettingsApp.XpoOidDocumentFinanceTypeDeliveryNote
);
string sqlFilter = string.Format("fmOid = '{0}'", documentFinanceMaster.Oid.ToString());
//Prepare and Declare FRBOGenericCollections : Limit 1, One Record (Document Master), else we get All Details to (View)
FRBOGenericCollection <FRBODocumentFinanceMasterView> gcDocumentFinanceMaster = new FRBOGenericCollection <FRBODocumentFinanceMasterView>(sqlFilter, 1);
FRBOGenericCollection <FRBODocumentFinanceDetail> gcDocumentFinanceDetail;
FRBOGenericCollection <FRBODocumentFinanceMasterTotalView> gcDocumentFinanceMasterTotal;
/* IN005986 - code refactoring */
FRBODocumentFinanceMasterView documentFinanceMasterView = gcDocumentFinanceMaster.List[0];
/* IN009075 - for decrypt phase */
bool customerDataHasBeenCleaned = false;
//Override Default Values
//If Simplified Invoice - Remove Customer Details (If System Country Equal to PT)
if (SettingsApp.ConfigurationSystemCountry.Oid.Equals(SettingsApp.XpoOidConfigurationCountryPortugal) ||
SettingsApp.ConfigurationSystemCountry.Oid.Equals(SettingsApp.XpoOidConfigurationCountryMozambique) || /* IN005986 */
SettingsApp.ConfigurationSystemCountry.Oid.Equals(SettingsApp.XpoOidConfigurationCountryAngola)) /* IN009230 - Angola is now added to this rule */
{
/* IN009230 - now, only when Final Customer we have data cleaned */
//if (SettingsApp.XpoOidDocumentFinanceTypeSimplifiedInvoice.Equals(new Guid(documentFinanceMasterView.DocumentType))
// || FrameworkUtils.GetFinalConsumerEntity().Oid.ToString() == documentFinanceMasterView.EntityOid) //Added
if (FrameworkUtils.GetFinalConsumerEntity().Oid.ToString() == documentFinanceMasterView.EntityOid) //Added
{
documentFinanceMasterView.EntityName = string.Empty;
documentFinanceMasterView.EntityAddress = string.Empty;
documentFinanceMasterView.EntityZipCode = string.Empty;
documentFinanceMasterView.EntityCity = string.Empty;
documentFinanceMasterView.EntityCountry = string.Empty;
documentFinanceMasterView.EntityLocality = string.Empty;
/* IN009230 */
documentFinanceMasterView.EntityFiscalNumber = SettingsApp.FinanceFinalConsumerFiscalNumberDisplay;
customerDataHasBeenCleaned = true;
}
/* IN009230 - "If" content removed from here to the just before block of code */
//Detect if is FinalConsumer with FiscalNumber 999999990 and Hide it
//erp_customer customer = (erp_customer)GlobalFramework.SessionXpo.GetObjectByKey(typeof(erp_customer), SettingsApp.XpoOidDocumentFinanceMasterFinalConsumerEntity);
//if (documentFinanceMasterView.EntityFiscalNumber == customer.FiscalNumber)
//{
// documentFinanceMasterView.EntityFiscalNumber = SettingsApp.FinanceFinalConsumerFiscalNumberDisplay;
//}
}
//IN009347 Documentos PT - Alteração do Layout dos dados do Cliente #Lindote 2020
/* IN009075 - decrypt phase */
if (!customerDataHasBeenCleaned)
{
documentFinanceMasterView.EntityName = GlobalFramework.PluginSoftwareVendor.Decrypt(documentFinanceMasterView.EntityName);
documentFinanceMasterView.EntityAddress = GlobalFramework.PluginSoftwareVendor.Decrypt(documentFinanceMasterView.EntityAddress);
documentFinanceMasterView.EntityZipCode = GlobalFramework.PluginSoftwareVendor.Decrypt(documentFinanceMasterView.EntityZipCode);
documentFinanceMasterView.EntityCity = GlobalFramework.PluginSoftwareVendor.Decrypt(documentFinanceMasterView.EntityCity);
documentFinanceMasterView.EntityLocality = GlobalFramework.PluginSoftwareVendor.Decrypt(documentFinanceMasterView.EntityLocality);
// documentFinanceMasterView.EntityCountry = GlobalFramework.PluginSoftwareVendor.Decrypt(documentFinanceMasterView.EntityCountry);
// EntityLocality???
/* IN009230 */
documentFinanceMasterView.EntityFiscalNumber = GlobalFramework.PluginSoftwareVendor.Decrypt(documentFinanceMasterView.EntityFiscalNumber);
}
/* IN009173 - add Parent document number to Notes field */
if (isTransportDocument && documentFinanceMaster.DocumentParent != null)
{
string notes = string.Format("{0}: {1}", resources.CustomResources.GetCustomResources(GlobalFramework.Settings["customCultureResourceDefinition"], "global_source_document"), documentFinanceMaster.DocumentParent.DocumentNumber);
if (!string.IsNullOrEmpty(documentFinanceMasterView.Notes))
{
notes += " | ";
}
notes += documentFinanceMasterView.Notes;
documentFinanceMasterView.Notes = notes;
}
/* Add ATDocCodeID to Notes field */
if (!string.IsNullOrEmpty(documentFinanceMasterView.ATDocCodeID))
{
string notes = string.Format("{0}: {1}", resources.CustomResources.GetCustomResources(GlobalFramework.Settings["customCultureResourceDefinition"], "global_at_atdoccodeid"), documentFinanceMasterView.ATDocCodeID);
if (!string.IsNullOrEmpty(documentFinanceMasterView.Notes))
{
notes += " | " /*Environment.NewLine*/;
}
notes += documentFinanceMasterView.Notes;
documentFinanceMasterView.Notes = notes;
}
//Detect if is Retification Document (ND/NC) and add SourceDocument to Show on Notes
if (retificationDocuments)
{
//TK016319 - Certificação Angola - Alterações para teste da AGT
//Notas de Credito
string notes = string.Format("{0}: {1}", resources.CustomResources.GetCustomResources(GlobalFramework.Settings["customCultureResourceDefinition"], "global_source_document"), documentFinanceMaster.DocumentParent.DocumentNumber);
if (SettingsApp.XpoOidConfigurationCountryAngola.Equals(SettingsApp.ConfigurationSystemCountry.Oid))
{
notes = string.Format("{0}: {1}", resources.CustomResources.GetCustomResources(GlobalFramework.Settings["customCultureResourceDefinition"], "global_source_document_NC_ND"), documentFinanceMaster.DocumentParent.DocumentNumber);
}
/* IN009252 - "Reason" added to "fin_documentfinancemaster.Notes" */
if (!string.IsNullOrEmpty(documentFinanceMasterView.Notes))
{
notes += Environment.NewLine; /* " | " */
}
notes += String.Format("{0}: {1}", resources.CustomResources.GetCustomResources(GlobalFramework.Settings["customCultureResourceDefinition"], "global_reason"), documentFinanceMasterView.Notes);
documentFinanceMasterView.Notes = notes;
}
//Render Child Bussiness Objects
foreach (FRBODocumentFinanceMasterView documentMaster in gcDocumentFinanceMaster)
{
//Get FinanceDetail
gcDocumentFinanceDetail = new FRBOGenericCollection <FRBODocumentFinanceDetail>(string.Format("DocumentMaster = '{0}'", documentMaster.Oid), "Ord");
documentMaster.DocumentFinanceDetail = gcDocumentFinanceDetail.List;
//Get FinanceMasterTotals
gcDocumentFinanceMasterTotal = new FRBOGenericCollection <FRBODocumentFinanceMasterTotalView>(string.Format("fmtDocumentMaster = '{0}'", documentMaster.Oid), "Value");
documentMaster.DocumentFinanceMasterTotal = gcDocumentFinanceMasterTotal.List;
}
result.DocumentFinanceMaster = gcDocumentFinanceMaster;
}
catch (Exception ex)
{
_log.Error(ex.Message, ex);
}
return(result);
}
public ResultFRBODocumentFinancePayment(FRBOGenericCollection <FRBODocumentFinancePaymentView> pFRBODocumentFinancePayment)
{
_documentFinancePayment = pFRBODocumentFinancePayment;
}
public ResultFRBODocumentFinanceMaster(FRBOGenericCollection <FRBODocumentFinanceMasterView> pFRBODocumentFinanceMaster)
{
_documentFinanceMaster = pFRBODocumentFinanceMaster;
}
/// <summary>
/// Generate Fast Report Business Objects for ProcessReportFinanceDocument
/// </summary>
public static ResultFRBODocumentFinanceMaster GetFRBOFinanceDocument(Guid pDocumentFinanceMasterOid)
{
ResultFRBODocumentFinanceMaster result = new ResultFRBODocumentFinanceMaster();
try
{
FIN_DocumentFinanceMaster documentFinanceMaster = (FIN_DocumentFinanceMaster)FrameworkUtils.GetXPGuidObject(GlobalFramework.SessionXpo, typeof(FIN_DocumentFinanceMaster), pDocumentFinanceMasterOid);
bool retificationDocuments = (
documentFinanceMaster.DocumentType.Oid == SettingsApp.XpoOidDocumentFinanceTypeCreditNote
);
string sqlFilter = string.Format("fmOid = '{0}'", documentFinanceMaster.Oid.ToString());
//Prepare and Declare FRBOGenericCollections : Limit 1, One Record (Document Master), else we get All Details to (View)
FRBOGenericCollection <FRBODocumentFinanceMasterView> gcDocumentFinanceMaster = new FRBOGenericCollection <FRBODocumentFinanceMasterView>(sqlFilter, 1);
FRBOGenericCollection <FRBODocumentFinanceDetail> gcDocumentFinanceDetail;
FRBOGenericCollection <FRBODocumentFinanceMasterTotalView> gcDocumentFinanceMasterTotal;
//Override Default Values
//If Simplified Invoice - Remove Customer Details (If System Country Equal to PT)
if (
(
SettingsApp.XpoOidConfigurationCountryPortugal == SettingsApp.ConfigurationSystemCountry.Oid &&
new Guid(gcDocumentFinanceMaster.List[0].DocumentType) == SettingsApp.XpoOidDocumentFinanceTypeSimplifiedInvoice
)
//Added
|| FrameworkUtils.GetFinalConsumerEntity().Oid.ToString() == gcDocumentFinanceMaster.List[0].EntityOid
//Removed This Way we only clean Entity data if is a SimplifiedInvoice, to protect Hidden Entitys with FinanceFinalConsumerFiscalNumber
//|| (
// gcDocumentFinanceMaster.List[0].EntityFiscalNumber == SettingsApp.FinanceFinalConsumerFiscalNumber
//)
)
{
gcDocumentFinanceMaster.List[0].EntityName = string.Empty;
gcDocumentFinanceMaster.List[0].EntityAddress = string.Empty;
gcDocumentFinanceMaster.List[0].EntityZipCode = string.Empty;
gcDocumentFinanceMaster.List[0].EntityCity = string.Empty;
gcDocumentFinanceMaster.List[0].EntityCountry = string.Empty;
}
//Detect if is FinalConsumer with FiscalNumber 999999990 and Hide it
ERP_Customer customer = (ERP_Customer)GlobalFramework.SessionXpo.GetObjectByKey(typeof(ERP_Customer), SettingsApp.XpoOidDocumentFinanceMasterFinalConsumerEntity);
if (gcDocumentFinanceMaster.List[0].EntityFiscalNumber == customer.FiscalNumber)
{
gcDocumentFinanceMaster.List[0].EntityFiscalNumber = SettingsApp.FinanceFinalConsumerFiscalNumberDisplay;
}
//Detect if is Retification Document (ND/NC) and add SourceDocument to Show on Notes
if (!string.IsNullOrEmpty(gcDocumentFinanceMaster.List[0].ATDocCodeID))
{
string notes = string.Format("{0} : {1}", Resx.global_at_atdoccodeid, gcDocumentFinanceMaster.List[0].ATDocCodeID);
if (!string.IsNullOrEmpty(gcDocumentFinanceMaster.List[0].Notes))
{
notes += " | " /*Environment.NewLine*/;
}
notes += gcDocumentFinanceMaster.List[0].Notes;
gcDocumentFinanceMaster.List[0].Notes = notes;
}
//Detect if is Retification Document (ND/NC) and add SourceDocument to Show on Notes
if (retificationDocuments)
{
string notes = string.Format("{0} : {1}", Resx.global_source_document, documentFinanceMaster.DocumentParent.DocumentNumber);
if (!string.IsNullOrEmpty(gcDocumentFinanceMaster.List[0].Notes))
{
notes += " | " /*Environment.NewLine*/;
}
notes += gcDocumentFinanceMaster.List[0].Notes;
gcDocumentFinanceMaster.List[0].Notes = notes;
}
//Render Child Bussiness Objects
foreach (FRBODocumentFinanceMasterView documentMaster in gcDocumentFinanceMaster)
{
//Get FinanceDetail
gcDocumentFinanceDetail = new FRBOGenericCollection <FRBODocumentFinanceDetail>(string.Format("DocumentMaster = '{0}'", documentMaster.Oid), "Ord");
documentMaster.DocumentFinanceDetail = gcDocumentFinanceDetail.List;
//Get FinanceMasterTotals
gcDocumentFinanceMasterTotal = new FRBOGenericCollection <FRBODocumentFinanceMasterTotalView>(string.Format("fmtDocumentMaster = '{0}'", documentMaster.Oid), "Value");
documentMaster.DocumentFinanceMasterTotal = gcDocumentFinanceMasterTotal.List;
}
result.DocumentFinanceMaster = gcDocumentFinanceMaster;
}
catch (Exception ex)
{
_log.Error(ex.Message, ex);
}
return(result);
}