///<summary>
/// Method Invocation of wrapper classes
///<summary>
protected static FR_L5BL_GCfTID_1006_Array Invoke(DbConnection Connection, DbTransaction Transaction, string ConnectionString, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
bool cleanupConnection = Connection == null;
bool cleanupTransaction = Transaction == null;
FR_L5BL_GCfTID_1006_Array functionReturn = new FR_L5BL_GCfTID_1006_Array();
try
{
if (cleanupConnection == true)
{
Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString);
Connection.Open();
}
if (cleanupTransaction == true)
{
Transaction = Connection.BeginTransaction();
}
functionReturn = Execute(Connection, Transaction, securityTicket);
#region Cleanup Connection/Transaction
//Commit the transaction
if (cleanupTransaction == true)
{
Transaction.Commit();
}
//Close the connection
if (cleanupConnection == true)
{
Connection.Close();
}
#endregion
}
catch (Exception ex)
{
try
{
if (cleanupTransaction == true && Transaction != null)
{
Transaction.Rollback();
}
}
catch { }
try
{
if (cleanupConnection == true && Connection != null)
{
Connection.Close();
}
}
catch { }
throw new Exception("Exception occured in method cls_Get_Customers_for_TenantID", ex);
}
return(functionReturn);
}
protected static FR_L5BL_GCfTID_1006_Array Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5BL_GCfTID_1006_Array();
var resList = new List <L5BL_GCfTID_1006>();
var persons = cls_Get_PersonCustomers_for_TenantID.Invoke(Connection, Transaction, securityTicket).Result;
var companies = cls_Get_CompanyCustomers_for_TenantID.Invoke(Connection, Transaction, securityTicket).Result;
if (persons != null)
{
foreach (var p in persons)
{
var item = new L5BL_GCfTID_1006();
item.CMN_BPT_BusinessParticipantID = p.CMN_BPT_BusinessParticipantID;
item.CMN_BPT_CTM_CustomerID = p.CMN_BPT_CTM_CustomerID;
item.FirstName = p.FirstName;
item.LastName = p.LastName;
item.DisplayName = p.DisplayName;
item.LegalGuardian = p.LegalGuardian;
item.BirthDate = p.BirthDate;
item.IsPerson = true;
item.IfPerson_CMN_PER_PersonInfoID = p.CMN_PER_PersonInfoID;
item.PaymentTypeID = p.ACC_PAY_Type_RefID;
item.InternalCustomerNumber = p.InternalCustomerNumber;
resList.Add(item);
}
}
if (companies != null)
{
foreach (var c in companies)
{
var item = new L5BL_GCfTID_1006();
item.CMN_BPT_BusinessParticipantID = c.CMN_BPT_BusinessParticipantID;
item.CMN_BPT_CTM_CustomerID = c.CMN_BPT_CTM_CustomerID;
item.FirmName = c.CompanyName_Line1;
item.IsCompany = true;
item.DisplayName = c.DisplayName;
item.LegalGuardian = c.LegalGuardian;
item.IfCompany_CMN_COM_CompanyInfoID = c.CMN_COM_CompanyInfoID;
item.PaymentTypeID = c.ACC_PAY_Type_RefID;
item.InternalCustomerNumber = c.InternalCustomerNumber;
resList.Add(item);
}
}
returnValue.Result = resList.OrderBy(l => l.LastName).ToArray();
return(returnValue);
#endregion UserCode
}
