protected static FR_L5CM_CSNU_1524 Execute(DbConnection Connection, DbTransaction Transaction, P_L5CM_CSNU_1524 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5CM_CSNU_1524();
StructureBuilderUtil structureBuilderUtil = new StructureBuilderUtil();
TreeNodeUtil treeNodeUtil = new TreeNodeUtil();
structureBuilderUtil.company = cls_Get_Company_Structure_For_Tenant.Invoke(Connection, Transaction, securityTicket).Result;;
structureBuilderUtil.sessionToken = securityTicket.SessionTicket;
structureBuilderUtil.addEmployees = false;
structureBuilderUtil.sessionSettings = cls_Get_Settings_For_Tenant.Invoke(Connection, Transaction, securityTicket).Result;
structureBuilderUtil.startDate = cls_Get_CalculationTimeFramesForTenant.Invoke(Connection, Transaction, securityTicket).Result.Min(x => x.CalculationTimeframe_StartDate).Date;
structureBuilderUtil.endDate = DateTime.Now;
structureBuilderUtil.hidenNodeType = CompanyStructureType.None;
structureBuilderUtil.employees = new L5EM_GEFT_0959[0];
EmployeeUtils employeeUtil = new EmployeeUtils();
structureBuilderUtil.employeeUtil = employeeUtil;
returnValue.Result = new L5CM_CSNU_1524();
List <Node> companyStructure = structureBuilderUtil.organizeData(DateTime.Now);
Node node = treeNodeUtil.findNodeForID(companyStructure[0], Parameter.ParentRefID);
if (node != null && node.Children.Count != 0)
{
if (node.Children[0].data is L5OF_GOFT_1157)
{
var officeQuery = new ORM_CMN_STR_Office.Query();
officeQuery.Tenant_RefID = securityTicket.TenantID;
officeQuery.IsDeleted = false;
officeQuery.Office_ShortName = Parameter.ShortName;
var officeQueryRes = ORM_CMN_STR_Office.Query.Search(Connection, Transaction, officeQuery);
if (officeQueryRes.Count > 0)
{
if (officeQueryRes.Count > 0)
{
returnValue.Result.OfficeID = officeQueryRes[0].CMN_STR_OfficeID;
returnValue.Result.OfficeShortName = officeQueryRes[0].Office_ShortName;
}
}
}
else if (node.Children[0].data is L5WA_GWAFT_1201)
{
var workareaQuery = new ORM_CMN_STR_PPS_WorkArea.Query();
workareaQuery.Tenant_RefID = securityTicket.TenantID;
workareaQuery.IsDeleted = false;
workareaQuery.ShortName = Parameter.ShortName;
if (node.data is L5WA_GWAFT_1201)
{
workareaQuery.Parent_RefID = Parameter.ParentRefID;
}
else
{
workareaQuery.Office_RefID = Parameter.ParentRefID;
}
var workareaQueryRes = ORM_CMN_STR_PPS_WorkArea.Query.Search(Connection, Transaction, workareaQuery);
if (workareaQueryRes.Count > 0)
{
returnValue.Result.WorkAreaID = workareaQueryRes[0].CMN_STR_PPS_WorkAreaID;
returnValue.Result.WorkAreaShortName = workareaQueryRes[0].ShortName;
}
}
else if (node.Children[0].data is L5WP_GWFT_1203)
{
var workplaceQuery = new ORM_CMN_STR_PPS_Workplace.Query();
workplaceQuery.Tenant_RefID = securityTicket.TenantID;
workplaceQuery.IsDeleted = false;
workplaceQuery.ShortName = Parameter.ShortName;
workplaceQuery.WorkArea_RefID = Parameter.ParentRefID;
var workplaceQueryRes = ORM_CMN_STR_PPS_Workplace.Query.Search(Connection, Transaction, workplaceQuery);
if (workplaceQueryRes.Count > 0)
{
if (workplaceQueryRes.Count > 0)
{
returnValue.Result.WorkPlaceID = workplaceQueryRes[0].CMN_STR_PPS_WorkplaceID;
returnValue.Result.WorkPlaceShortName = workplaceQueryRes[0].ShortName;
}
}
}
}
return(returnValue);
#endregion UserCode
}
protected static FR_L5WP_GWFT_1203_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_L5WP_GWFT_1203_Array();
L5WP_GWFT_1203 result = new L5WP_GWFT_1203();
ORM_CMN_STR_PPS_Workplace.Query workplaceQuery = new ORM_CMN_STR_PPS_Workplace.Query();
workplaceQuery.IsDeleted = false;
workplaceQuery.Tenant_RefID = securityTicket.TenantID;
List <ORM_CMN_STR_PPS_Workplace> workplaceResults = ORM_CMN_STR_PPS_Workplace.Query.Search(Connection, Transaction, workplaceQuery);
List <L5WP_GWFT_1203> workplaceResultList = new List <L5WP_GWFT_1203>();
foreach (var workplace in workplaceResults)
{
result = new L5WP_GWFT_1203();
ORM_CMN_STR_PPS_Workplace item = new ORM_CMN_STR_PPS_Workplace();
var resultWorkplace = item.Load(Connection, Transaction, workplace.CMN_STR_PPS_WorkplaceID);
if (resultWorkplace.Status != FR_Status.Success || item.CMN_STR_PPS_WorkplaceID == 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_PPS_WorkplaceID = workplace.CMN_STR_PPS_WorkplaceID;
result.ShortName = item.ShortName;
result.WorkArea_RefID = item.WorkArea_RefID;
result.WorkPlaceDescription = item.Description;
result.WorkPlaceName = item.Name;
result.DisplayColor = item.DisplayColor;
var responsiblePersonsQuery = new ORM_CMN_STR_PPS_Workplace_ResponsiblePerson.Query();
responsiblePersonsQuery.Tenant_RefID = securityTicket.TenantID;
responsiblePersonsQuery.Workplace_RefID = workplace.CMN_STR_PPS_WorkplaceID;
responsiblePersonsQuery.IsDeleted = false;
var responsiblePersonsList = ORM_CMN_STR_PPS_Workplace_ResponsiblePerson.Query.Search(Connection, Transaction, responsiblePersonsQuery);
List <L5WP_GWFT_1203_ResponsiblePerson> responsiblePresonsResultList = new List <L5WP_GWFT_1203_ResponsiblePerson>();
foreach (var responsiblePerson in responsiblePersonsList)
{
L5WP_GWFT_1203_ResponsiblePerson responsiblePersonResult = new L5WP_GWFT_1203_ResponsiblePerson();
responsiblePersonResult.CMN_BPT_EMP_EmployeeID = responsiblePerson.CMN_BPT_EMP_Employee_RefID;
responsiblePersonResult.CMN_STR_PPS_Workplace_ResponsiblePersonID = responsiblePerson.CMN_STR_PPS_Workplace_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;
responsiblePersonResult.CMN_PER_PersonInfoID = person.CMN_PER_PersonInfoID;
responsiblePresonsResultList.Add(responsiblePersonResult);
}
result.ResponsiblePersons = responsiblePresonsResultList.ToArray();
workplaceResultList.Add(result);
}
returnValue.Result = workplaceResultList.ToArray();
//Put your code here
return(returnValue);
#endregion UserCode
}
