///<summary>
/// Method Invocation of wrapper classes
///<summary>
protected static FR_L5OF_GOFT_1157_Array Invoke(DbConnection Connection, DbTransaction Transaction, string ConnectionString, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
bool cleanupConnection = Connection == null;
bool cleanupTransaction = Transaction == null;
FR_L5OF_GOFT_1157_Array functionReturn = new FR_L5OF_GOFT_1157_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_Offices_For_Tenant", ex);
}
return(functionReturn);
}
protected static FR_L5OF_GOFT_1157_Array Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_L5OF_GOFT_1157_Array();
ORM_CMN_STR_Office.Query officesQuery = new ORM_CMN_STR_Office.Query();
officesQuery.IsDeleted = false;
officesQuery.Tenant_RefID = securityTicket.TenantID;
List <ORM_CMN_STR_Office> officesResult = ORM_CMN_STR_Office.Query.Search(Connection, Transaction, officesQuery);
List <L5OF_GOFT_1157> officesResultList = new List <L5OF_GOFT_1157>();
foreach (var office in officesResult)
{
L5OF_GOFT_1157 result = new L5OF_GOFT_1157();
var item = new ORM_CMN_STR_Office();
var resultOffice = item.Load(Connection, Transaction, office.CMN_STR_OfficeID);
if (resultOffice.Status != FR_Status.Success || item.CMN_STR_OfficeID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(null);
}
result.CMN_CAL_CalendarInstance_RefID = item.CMN_CAL_CalendarInstance_RefID;
result.CMN_STR_OfficeID = item.CMN_STR_OfficeID;
result.Country_RefID = item.Country_RefID;
result.Default_FaxNumber = item.Default_FaxNumber;
result.Default_PhoneNumber = item.Default_PhoneNumber;
result.Office_ShortName = item.Office_ShortName;
result.OfficeDescription = item.Office_Description;
result.OfficeName = item.Office_Name;
result.Region_RefID = item.Region_RefID;
result.BillingAddress_CMN_AddressID = item.Default_BillingAddress_RefID;
var address = new ORM_CMN_Address();
var resultItem = address.Load(Connection, Transaction, item.Default_BillingAddress_RefID);
if (resultItem.Status != FR_Status.Success || address.CMN_AddressID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(null);
}
result.BillingAddress_City_Name = address.City_Name;
result.BillingAddress_City_AdministrativeDistrict = address.City_AdministrativeDistrict;
result.BillingAddress_City_PostalCode = address.City_PostalCode;
result.BillingAddress_City_Region = address.City_Region;
result.BillingAddress_Country_Name = address.Country_Name;
result.BillingAddress_Province_Name = address.Province_Name;
result.BillingAddress_Street_Name = address.Street_Name;
result.BillingAddress_Street_Number = address.Street_Number;
result.BillingAddress_Country_ISOCode = address.Country_ISOCode;
ORM_CMN_STR_Office_2_CostCenter.Query officeToCostcenterQuery = new ORM_CMN_STR_Office_2_CostCenter.Query();
officeToCostcenterQuery.Office_RefID = office.CMN_STR_OfficeID;
officeToCostcenterQuery.Tenant_RefID = securityTicket.TenantID;
officeToCostcenterQuery.IsDeleted = false;
List <ORM_CMN_STR_Office_2_CostCenter> officeToCostcenterList = ORM_CMN_STR_Office_2_CostCenter.Query.Search(Connection, Transaction, officeToCostcenterQuery);
if (officeToCostcenterList.Count != 0)
{
L5OF_GOFT_1157_Costcenter costCenter = new L5OF_GOFT_1157_Costcenter();
ORM_CMN_STR_CostCenter costCenterItem = new ORM_CMN_STR_CostCenter();
costCenterItem.Load(Connection, Transaction, officeToCostcenterList[0].CostCenter_RefID);
if (!costCenterItem.IsDeleted)
{
costCenter.AssignmentID = officeToCostcenterList[0].AssignmentID;
costCenter.CMN_STR_CostCenterID = officeToCostcenterList[0].CostCenter_RefID;
costCenter.CostcenterName = costCenterItem.Name;
costCenter.InternalID = costCenterItem.InternalID;
result.Costcenter = costCenter;
}
}
var responsiblePersonsQuery = new ORM_CMN_STR_Office_ResponsiblePerson.Query();
responsiblePersonsQuery.Tenant_RefID = securityTicket.TenantID;
responsiblePersonsQuery.Office_RefID = item.CMN_STR_OfficeID;
responsiblePersonsQuery.IsDeleted = false;
var responsiblePersonsList = ORM_CMN_STR_Office_ResponsiblePerson.Query.Search(Connection, Transaction, responsiblePersonsQuery);
List <L5OF_GOFT_1157_ResponsiblePersons> responsiblePresonsResultList = new List <L5OF_GOFT_1157_ResponsiblePersons>();
foreach (var responsiblePerson in responsiblePersonsList)
{
L5OF_GOFT_1157_ResponsiblePersons responsiblePersonResult = new L5OF_GOFT_1157_ResponsiblePersons();
responsiblePersonResult.CMN_BPT_EMP_EmployeeID = responsiblePerson.CMN_BPT_EMP_Employee_RefID;
responsiblePersonResult.CMN_STR_Office_ResponsiblePersonID = responsiblePerson.CMN_STR_Office_ResponsiblePersonID;
ORM_CMN_BPT_EMP_Employee employee = new ORM_CMN_BPT_EMP_Employee();
employee.Load(Connection, Transaction, responsiblePerson.CMN_BPT_EMP_Employee_RefID);
ORM_CMN_BPT_BusinessParticipant bParticipant = new ORM_CMN_BPT_BusinessParticipant();
bParticipant.Load(Connection, Transaction, employee.BusinessParticipant_RefID);
ORM_CMN_PER_PersonInfo person = new ORM_CMN_PER_PersonInfo();
person.Load(Connection, Transaction, bParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID);
responsiblePersonResult.CMN_BPT_BusinessParticipantID = bParticipant.CMN_BPT_BusinessParticipantID;
responsiblePersonResult.FirstName = person.FirstName;
responsiblePersonResult.LastName = person.LastName;
responsiblePresonsResultList.Add(responsiblePersonResult);
}
result.Managers = responsiblePresonsResultList.ToArray();
officesResultList.Add(result);
}
returnValue.Result = officesResultList.ToArray();
//Put your code here
return(returnValue);
#endregion UserCode
}
