protected static FR_L5EM_GENFT_1344_Array Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5EM_GENFT_1344_Array();
List <L5EM_GENFT_1344> employeeResultList = new List <L5EM_GENFT_1344>();
ORM_CMN_BPT_EMP_Employee.Query employeeQuery = new ORM_CMN_BPT_EMP_Employee.Query();
employeeQuery.IsDeleted = false;
employeeQuery.Tenant_RefID = securityTicket.TenantID;
List <ORM_CMN_BPT_EMP_Employee> employeeList = ORM_CMN_BPT_EMP_Employee.Query.Search(Connection, Transaction, employeeQuery);
foreach (var employeeItem in employeeList)
{
L5EM_GENFT_1344 result = new L5EM_GENFT_1344();
ORM_CMN_BPT_EMP_Employee employee = new ORM_CMN_BPT_EMP_Employee();
employee.Load(Connection, Transaction, employeeItem.CMN_BPT_EMP_EmployeeID);
result.CMN_BPT_EMP_EmployeeID = employeeItem.CMN_BPT_EMP_EmployeeID;
ORM_CMN_BPT_BusinessParticipant businessParticipant = new ORM_CMN_BPT_BusinessParticipant();
businessParticipant.Load(Connection, Transaction, employee.BusinessParticipant_RefID);
ORM_CMN_PER_PersonInfo personInfo = new ORM_CMN_PER_PersonInfo();
personInfo.Load(Connection, Transaction, businessParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID);
result.FirstName = personInfo.FirstName;
result.LastName = personInfo.LastName;
employeeResultList.Add(result);
//Employee workplace history
ORM_CMN_BPT_EMP_Employee_WorkplaceAssignment.Query employeeWorkplaceAssignmentsQuery = new ORM_CMN_BPT_EMP_Employee_WorkplaceAssignment.Query();
employeeWorkplaceAssignmentsQuery.CMN_BPT_EMP_Employee_RefID = employee.CMN_BPT_EMP_EmployeeID;
employeeWorkplaceAssignmentsQuery.Tenant_RefID = securityTicket.TenantID;
employeeWorkplaceAssignmentsQuery.IsDeleted = false;
List <ORM_CMN_BPT_EMP_Employee_WorkplaceAssignment> employeeWorkplaceAssignemntsList = ORM_CMN_BPT_EMP_Employee_WorkplaceAssignment.Query.Search(Connection, Transaction, employeeWorkplaceAssignmentsQuery);
List <L5EM_GENFT_1344_EmployeeWorkplaceHistory> employeeWorkplaceAssignments = new List <L5EM_GENFT_1344_EmployeeWorkplaceHistory>();
foreach (var workplaceAssignemns in employeeWorkplaceAssignemntsList)
{
L5EM_GENFT_1344_EmployeeWorkplaceHistory item = new L5EM_GENFT_1344_EmployeeWorkplaceHistory();
item.BoundTo_Workplace_RefID = workplaceAssignemns.BoundTo_Workplace_RefID;
item.CMN_BPT_EMP_Employee_PlanGroup_RefID = workplaceAssignemns.CMN_BPT_EMP_Employee_PlanGroup_RefID;
item.CMN_BPT_EMP_Employee_WorkplaceAssignmentID = workplaceAssignemns.CMN_BPT_EMP_Employee_WorkplaceAssignment;
item.Default_BreakTime_Template_RefID = workplaceAssignemns.Default_BreakTime_Template_RefID;
item.IsBreakTimeCalculated_Actual = workplaceAssignemns.IsBreakTimeCalculated_Actual;
item.IsBreakTimeCalculated_Planning = workplaceAssignemns.IsBreakTimeCalculated_Planning;
item.SequenceNumber = workplaceAssignemns.SequenceNumber;
item.WorkplaceAssignment_StartDate = workplaceAssignemns.WorkplaceAssignment_StartDate;
employeeWorkplaceAssignments.Add(item);
}
result.EmployeeWorkplaceHistory = employeeWorkplaceAssignments.ToArray();
}
returnValue.Result = employeeResultList.ToArray();
//Put your code here
return(returnValue);
#endregion UserCode
}
protected static FR_Base Execute(DbConnection Connection, DbTransaction Transaction, P_L6MRMS_SEtR_1606 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Base();
List <ORM_MRS_RUN_MeasurementRun_AccountDownloadCode> downloadCodes = ORM_MRS_RUN_MeasurementRun_AccountDownloadCode.Query.Search(Connection, Transaction, new ORM_MRS_RUN_MeasurementRun_AccountDownloadCode.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
MeasurementRun_RefID = Parameter.ReadingSessionId
});
foreach (var downloadCode in downloadCodes)
{
ORM_CMN_BPT_BusinessParticipant businessParticipant = new ORM_CMN_BPT_BusinessParticipant();
var bpLoad = businessParticipant.Load(Connection, Transaction, downloadCode.Account_RefID);
if (bpLoad.Status != FR_Status.Success)
{
continue;
}
ORM_CMN_BPT_BusinessParticipant_AccessCode bpAccountCode = ORM_CMN_BPT_BusinessParticipant_AccessCode.Query.Search(Connection, Transaction, new ORM_CMN_BPT_BusinessParticipant_AccessCode.Query()
{
Tenant_RefID = securityTicket.TenantID,
BusinessParticipant_RefID = businessParticipant.CMN_BPT_BusinessParticipantID
}).SingleOrDefault();
if (bpAccountCode == null)
{
continue;
}
ORM_CMN_PER_PersonInfo personInfo = new ORM_CMN_PER_PersonInfo();
var piLoad = personInfo.Load(Connection, Transaction, businessParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID);
if (piLoad.Status != FR_Status.Success)
{
continue;
}
//sending email
string subject = Parameter.EmailSubjectTemplate;
string body = String.Format
(
Parameter.EmailBodyTemplate,
personInfo.FirstName,
personInfo.LastName,
downloadCode.DownloadCode,
bpAccountCode.Code
);
EmailUtils.SendMail(personInfo.PrimaryEmail, subject, body);
}
return(returnValue);
#endregion UserCode
}
protected static FR_Base Execute(DbConnection Connection, DbTransaction Transaction, P_L3US_SUAI_1642 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Base();
returnValue.Status = FR_Status.Error_Internal;
//Put your code here
//EDIT
if (Parameter.AccountID != null && Parameter.AccountID != Guid.Empty)
{
var item = new ORM_USR_Account();
if (item.Load(Connection, Transaction, Parameter.AccountID) == null)
{
returnValue.Status = FR_Status.Error_Internal;
return(returnValue);
}
ORM_CMN_PER_PersonInfo_2_Account.Query searchConnection = new CL1_CMN_PER.ORM_CMN_PER_PersonInfo_2_Account.Query();
searchConnection.IsDeleted = false;
searchConnection.Tenant_RefID = securityTicket.TenantID;
searchConnection.USR_Account_RefID = Parameter.AccountID;
ORM_CMN_PER_PersonInfo_2_Account personInfo2Account = ORM_CMN_PER_PersonInfo_2_Account.Query.Search(Connection, Transaction, searchConnection).FirstOrDefault();
if (personInfo2Account != null)
{
ORM_CMN_PER_PersonInfo PersonInfo = new ORM_CMN_PER_PersonInfo();
PersonInfo.Load(Connection, Transaction, personInfo2Account.CMN_PER_PersonInfo_RefID);
if (PersonInfo != null)
{
PersonInfo.FirstName = Parameter.FirstName;
PersonInfo.LastName = Parameter.LastName;
PersonInfo.Save(Connection, Transaction);
returnValue.Status = FR_Status.Success;
return(returnValue);
}
}
}
return(returnValue);
#endregion UserCode
}
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
}
protected static FR_L5DD_GRGFRP_1403_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L5DD_GRGFRP_1403 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_L5DD_GRGFRP_1403_Array();
var retVal = new List <L5DD_GRGFRP_1403>();
L5DD_GRGFRP_1403 revisionGroupItem;
//Put your code here
#region Realestate
ORM_RES_RealestateProperty realestateProperty = new ORM_RES_RealestateProperty();
if (Parameter.RealestatePropertyID != Guid.Empty)
{
var realestatePropertyResult = realestateProperty.Load(Connection, Transaction, Parameter.RealestatePropertyID);
if (realestatePropertyResult.Status != FR_Status.Success || realestateProperty.RES_RealestatePropertyID == Guid.Empty)
{
return(null);
}
}
#endregion
#region Address
ORM_CMN_Address address = new ORM_CMN_Address();
ORM_CMN_LOC_Location location = new ORM_CMN_LOC_Location();
var locationResult = location.Load(Connection, Transaction, realestateProperty.RealestateProperty_Location_RefID);
if (locationResult.Status == FR_Status.Success && location.CMN_LOC_LocationID != Guid.Empty)
{
var addressResult = address.Load(Connection, Transaction, location.Address_RefID);
if (locationResult.Status != FR_Status.Success || location.CMN_LOC_LocationID == Guid.Empty)
{
address = null;
}
}
#endregion
#region Revision groups for realestrate
ORM_RES_DUD_RevisionGroup.Query revisionGroupQuery = new ORM_RES_DUD_RevisionGroup.Query();
revisionGroupQuery.Tenant_RefID = securityTicket.TenantID;
revisionGroupQuery.IsDeleted = false;
revisionGroupQuery.RealestateProperty_RefID = realestateProperty.RES_RealestatePropertyID;
List <ORM_RES_DUD_RevisionGroup> revisionGroupList = ORM_RES_DUD_RevisionGroup.Query.Search(Connection, Transaction, revisionGroupQuery);
#endregion
#region Buildings for realestate
ORM_RES_BLD_Building_RevisionHeader.Query revisionHeaderQuery = new ORM_RES_BLD_Building_RevisionHeader.Query();
revisionHeaderQuery.Tenant_RefID = securityTicket.TenantID;
revisionHeaderQuery.IsDeleted = false;
revisionHeaderQuery.RealestateProperty_RefID = realestateProperty.RES_RealestatePropertyID;
ORM_RES_BLD_Building_RevisionHeader revisionHeader = ORM_RES_BLD_Building_RevisionHeader.Query.Search(Connection, Transaction, revisionHeaderQuery).FirstOrDefault();
List <ORM_RES_BLD_Building> buildings = new List <ORM_RES_BLD_Building>();
List <ORM_RES_DUD_Revision> revisions = new List <ORM_RES_DUD_Revision>();
List <ORM_RES_BLD_Building_2_BuildingType> buildingTypes = new List <ORM_RES_BLD_Building_2_BuildingType>();
List <ORM_RES_BLD_Building_2_GarbageContainerType> buildingGarbageContainerType = new List <ORM_RES_BLD_Building_2_GarbageContainerType>();
if (revisionHeader != null)
{
ORM_RES_BLD_Building.Query buildingQuery = new ORM_RES_BLD_Building.Query();
buildingQuery.Tenant_RefID = securityTicket.TenantID;
buildingQuery.IsDeleted = false;
buildingQuery.BuildingRevisionHeader_RefID = revisionHeader.RES_BLD_Building_RevisionHeaderID;
buildings = ORM_RES_BLD_Building.Query.Search(Connection, Transaction, buildingQuery);
if (buildings == null)
{
buildings = new List <ORM_RES_BLD_Building>();
}
#region revisions and building types for every building
foreach (var buildingItem in buildings)
{
ORM_RES_DUD_Revision.Query revisionQuery = new ORM_RES_DUD_Revision.Query();
revisionQuery.Tenant_RefID = securityTicket.TenantID;
revisionQuery.IsDeleted = false;
revisionQuery.RES_BLD_Building_RefID = buildingItem.RES_BLD_BuildingID;
revisions.AddRange(ORM_RES_DUD_Revision.Query.Search(Connection, Transaction, revisionQuery));
ORM_RES_BLD_Building_2_BuildingType.Query buildingTypeQuery = new ORM_RES_BLD_Building_2_BuildingType.Query();
buildingTypeQuery.Tenant_RefID = securityTicket.TenantID;
buildingTypeQuery.IsDeleted = false;
buildingTypeQuery.RES_BLD_Building_RefID = buildingItem.RES_BLD_BuildingID;
buildingTypes.AddRange(ORM_RES_BLD_Building_2_BuildingType.Query.Search(Connection, Transaction, buildingTypeQuery));
ORM_RES_BLD_Building_2_GarbageContainerType.Query buildingGarbageContainerTypeQuery = new ORM_RES_BLD_Building_2_GarbageContainerType.Query();
buildingGarbageContainerTypeQuery.Tenant_RefID = securityTicket.TenantID;
buildingGarbageContainerTypeQuery.IsDeleted = false;
buildingGarbageContainerTypeQuery.RES_BLD_Building_RefID = buildingItem.RES_BLD_BuildingID;
buildingGarbageContainerType.AddRange(ORM_RES_BLD_Building_2_GarbageContainerType.Query.Search(Connection, Transaction, buildingGarbageContainerTypeQuery));
}
#endregion
}
#endregion
#region Revision groups
List <L5DD_GRGFRP_1403_Buildings> buildingsResult;
L5DD_GRGFRP_1403_Buildings buildingResult;
foreach (var revisionGroup in revisionGroupList)
{
revisionGroupItem = new L5DD_GRGFRP_1403();
revisionGroupItem.RES_DUD_Revision_GroupID = revisionGroup.RES_DUD_Revision_GroupID;
revisionGroupItem.RevisionGroup_Name = revisionGroup.RevisionGroup_Name;
revisionGroupItem.RevisionGroup_SubmittedBy_Account_RefID = revisionGroup.RevisionGroup_SubmittedBy_Account_RefID;
revisionGroupItem.Creation_Timestamp = revisionGroup.Creation_Timestamp;
revisionGroupItem.Tenant_RefID = revisionGroup.Tenant_RefID;
revisionGroupItem.IsDeleted = revisionGroup.IsDeleted;
revisionGroupItem.RealestateProperty_RefID = revisionGroup.RealestateProperty_RefID;
revisionGroupItem.RevisionGroup_Comment = revisionGroup.RevisionGroup_Comment;
#region Person info
ORM_CMN_PER_PersonInfo personInfo = new ORM_CMN_PER_PersonInfo();
ORM_CMN_PER_PersonInfo_2_Account.Query personInfoAccountQuery = new ORM_CMN_PER_PersonInfo_2_Account.Query();
personInfoAccountQuery.Tenant_RefID = securityTicket.TenantID;
personInfoAccountQuery.IsDeleted = false;
personInfoAccountQuery.USR_Account_RefID = revisionGroup.RevisionGroup_SubmittedBy_Account_RefID;
ORM_CMN_PER_PersonInfo_2_Account account = ORM_CMN_PER_PersonInfo_2_Account.Query.Search(Connection, Transaction, personInfoAccountQuery).FirstOrDefault();
if (account != null)
{
var personInfoResult = personInfo.Load(Connection, Transaction, account.CMN_PER_PersonInfo_RefID);
if (personInfoResult.Status == FR_Status.Success && personInfo.CMN_PER_PersonInfoID != Guid.Empty)
{
revisionGroupItem.FirstName = personInfo.FirstName;
revisionGroupItem.LastName = personInfo.LastName;
}
}
#endregion
#region set address info
if (address != null)
{
revisionGroupItem.Country_Name = address.Country_Name;
revisionGroupItem.City_Region = address.City_Region;
revisionGroupItem.City_PostalCode = address.City_PostalCode;
revisionGroupItem.City_Name = address.City_Name;
revisionGroupItem.Street_Name = address.Street_Name;
revisionGroupItem.Street_Number = address.Street_Number;
}
#endregion
#region set building info
buildingsResult = new List <L5DD_GRGFRP_1403_Buildings>();
// get revisions for revision group
var revisionsForRetVal = revisions.Where(i => i.RevisionGroup_RefID == revisionGroup.RES_DUD_Revision_GroupID).ToList();
ORM_RES_DUD_Revision revisionForBuildingID;
// get buildings for list of revision
List <ORM_RES_BLD_Building> buildingForRetVal = new List <ORM_RES_BLD_Building>();
buildingForRetVal.AddRange(buildings.Where(i => revisionsForRetVal.Any(j => j.RES_BLD_Building_RefID == i.RES_BLD_BuildingID)).ToList());
foreach (var buildingForRetValItem in buildingForRetVal)
{
revisionForBuildingID = revisionsForRetVal.FirstOrDefault(i => i.RES_BLD_Building_RefID == buildingForRetValItem.RES_BLD_BuildingID);
buildingResult = new L5DD_GRGFRP_1403_Buildings();
buildingResult.Building_Name = buildingForRetValItem.Building_Name;
buildingResult.RES_BLD_BuildingID = buildingForRetValItem.RES_BLD_BuildingID;
buildingResult.RES_DUD_RevisionID = revisionForBuildingID.RES_DUD_RevisionID;
buildingResult.QuestionnaireVersion_RefID = revisionForBuildingID.QuestionnaireVersion_RefID;
buildingResult.RES_BLD_Building_Type_RefID = buildingTypes.FirstOrDefault(i => i.RES_BLD_Building_RefID == buildingForRetValItem.RES_BLD_BuildingID).RES_BLD_Building_Type_RefID;
buildingResult.RES_BLD_GarbageContainerType_RefID = buildingGarbageContainerType.FirstOrDefault(i => i.RES_BLD_Building_RefID == buildingForRetValItem.RES_BLD_BuildingID).RES_BLD_GarbageContainerType_RefID;
buildingsResult.Add(buildingResult);
}
#endregion
revisionGroupItem.Buildings = buildingsResult.ToArray();
retVal.Add(revisionGroupItem);
}
#endregion
returnValue.Result = retVal.ToArray();
return(returnValue);
#endregion UserCode
}
protected static FR_L5EM_GEFT_0959_Array Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5EM_GEFT_0959_Array();
List <L5EM_GEFT_0959> employeeResultList = new List <L5EM_GEFT_0959>();
ORM_CMN_BPT_EMP_Employee.Query employeeQuery = new ORM_CMN_BPT_EMP_Employee.Query();
employeeQuery.IsDeleted = false;
employeeQuery.Tenant_RefID = securityTicket.TenantID;
List <ORM_CMN_BPT_EMP_Employee> employeeList = ORM_CMN_BPT_EMP_Employee.Query.Search(Connection, Transaction, employeeQuery);
foreach (var employeeItem in employeeList)
{
L5EM_GEFT_0959 result = new L5EM_GEFT_0959();
ORM_CMN_BPT_EMP_Employee employee = new ORM_CMN_BPT_EMP_Employee();
employee.Load(Connection, Transaction, employeeItem.CMN_BPT_EMP_EmployeeID);
result.CMN_BPT_EMP_EmployeeID = employee.CMN_BPT_EMP_EmployeeID;
result.Staff_Number = employee.Staff_Number;
result.StandardFunction = employee.StandardFunction;
ORM_USR_Account.Query accountQuery = new ORM_USR_Account.Query();
accountQuery.BusinessParticipant_RefID = employee.BusinessParticipant_RefID;
accountQuery.Tenant_RefID = securityTicket.TenantID;
accountQuery.IsDeleted = false;
ORM_USR_Account account = ORM_USR_Account.Query.Search(Connection, Transaction, accountQuery).FirstOrDefault();
if (account != null)
{
result.USR_AccountID = account.USR_AccountID;
}
ORM_CMN_BPT_BusinessParticipant businessParticipant = new ORM_CMN_BPT_BusinessParticipant();
businessParticipant.Load(Connection, Transaction, employee.BusinessParticipant_RefID);
result.CMN_BPT_BusinessParticipantID = businessParticipant.CMN_BPT_BusinessParticipantID;
result.DisplayName = businessParticipant.DisplayName;
ORM_CMN_PER_PersonInfo personInfo = new ORM_CMN_PER_PersonInfo();
personInfo.Load(Connection, Transaction, businessParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID);
result.CMN_PER_PersonInfoID = personInfo.CMN_PER_PersonInfoID;
result.FirstName = personInfo.FirstName;
result.LastName = personInfo.LastName;
result.PrimaryEmail = personInfo.PrimaryEmail;
result.Title = personInfo.Title;
result.ProfileImage_Document_RefID = personInfo.ProfileImage_Document_RefID;
result.BirthDate = personInfo.BirthDate;
ORM_CMN_BPT_EMP_EmploymentRelationship.Query workingContractQuery = new ORM_CMN_BPT_EMP_EmploymentRelationship.Query();
workingContractQuery.Employee_RefID = employee.CMN_BPT_EMP_EmployeeID;
workingContractQuery.IsDeleted = false;
workingContractQuery.Tenant_RefID = securityTicket.TenantID;
ORM_CMN_BPT_EMP_EmploymentRelationship employmentRelationship = ORM_CMN_BPT_EMP_EmploymentRelationship.Query.Search(Connection, Transaction, workingContractQuery).FirstOrDefault();
result.CMN_BPT_EMP_EmploymentRelationshipID = employmentRelationship.CMN_BPT_EMP_EmploymentRelationshipID;
result.Work_StartDate = employmentRelationship.Work_StartDate;
result.Work_EndDate = employmentRelationship.Work_EndDate;
//Address
if (personInfo.Address_RefID != Guid.Empty)
{
ORM_CMN_Address address = new ORM_CMN_Address();
address.Load(Connection, Transaction, personInfo.Address_RefID);
result.CMN_AddressID = address.CMN_AddressID;
result.Street_Name = address.Street_Name;
result.Street_Number = address.Street_Number;
result.City_AdministrativeDistrict = address.City_AdministrativeDistrict;
result.City_Region = address.City_Region;
result.City_Name = address.City_Name;
result.City_PostalCode = address.City_PostalCode;
result.Province_Name = address.Province_Name;
result.Country_Name = address.Country_Name;
result.Country_ISOCode = address.Country_ISOCode;
}
//Contacts
ORM_CMN_PER_CommunicationContact.Query comunicationContactQuery = new ORM_CMN_PER_CommunicationContact.Query();
comunicationContactQuery.PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID;
comunicationContactQuery.Tenant_RefID = securityTicket.TenantID;
comunicationContactQuery.IsDeleted = false;
List <ORM_CMN_PER_CommunicationContact> comunicationContacts = ORM_CMN_PER_CommunicationContact.Query.Search(Connection, Transaction, comunicationContactQuery);
List <L5EM_GEFT_0959_Contacts> resultComunicationContacts = new List <L5EM_GEFT_0959_Contacts>();
foreach (var comunicationContact in comunicationContacts)
{
ORM_CMN_PER_CommunicationContact_Type contactType = new ORM_CMN_PER_CommunicationContact_Type();
contactType.Load(Connection, Transaction, comunicationContact.CMN_PER_CommunicationContactID);
L5EM_GEFT_0959_Contacts resultComunicationContact = new L5EM_GEFT_0959_Contacts();
resultComunicationContact.CMN_PER_CommunicationContact_TypeID = contactType.CMN_PER_CommunicationContact_TypeID;
resultComunicationContact.CMN_PER_CommunicationContactID = comunicationContact.CMN_PER_CommunicationContactID;
resultComunicationContact.Content = comunicationContact.Content;
resultComunicationContact.Type = contactType.Type;
resultComunicationContacts.Add(resultComunicationContact);
}
result.Contacts = resultComunicationContacts.ToArray();
//Employee workplace history
ORM_CMN_BPT_EMP_Employee_WorkplaceAssignment.Query employeeWorkplaceAssignmentsQuery = new ORM_CMN_BPT_EMP_Employee_WorkplaceAssignment.Query();
employeeWorkplaceAssignmentsQuery.CMN_BPT_EMP_Employee_RefID = employee.CMN_BPT_EMP_EmployeeID;
employeeWorkplaceAssignmentsQuery.Tenant_RefID = securityTicket.TenantID;
employeeWorkplaceAssignmentsQuery.IsDeleted = false;
List <ORM_CMN_BPT_EMP_Employee_WorkplaceAssignment> employeeWorkplaceAssignemntsList = ORM_CMN_BPT_EMP_Employee_WorkplaceAssignment.Query.Search(Connection, Transaction, employeeWorkplaceAssignmentsQuery);
List <L5EM_GEFT_0959_EmployeeWorkplaceHistory> employeeWorkplaceAssignments = new List <L5EM_GEFT_0959_EmployeeWorkplaceHistory>();
foreach (var workplaceAssignemns in employeeWorkplaceAssignemntsList)
{
L5EM_GEFT_0959_EmployeeWorkplaceHistory item = new L5EM_GEFT_0959_EmployeeWorkplaceHistory();
item.BoundTo_Workplace_RefID = workplaceAssignemns.BoundTo_Workplace_RefID;
item.CMN_BPT_EMP_Employee_PlanGroup_RefID = workplaceAssignemns.CMN_BPT_EMP_Employee_PlanGroup_RefID;
item.CMN_BPT_EMP_Employee_WorkplaceAssignmentID = workplaceAssignemns.CMN_BPT_EMP_Employee_WorkplaceAssignment;
item.Default_BreakTime_Template_RefID = workplaceAssignemns.Default_BreakTime_Template_RefID;
item.IsBreakTimeCalculated_Actual = workplaceAssignemns.IsBreakTimeCalculated_Actual;
item.IsBreakTimeCalculated_Planning = workplaceAssignemns.IsBreakTimeCalculated_Planning;
item.SequenceNumber = workplaceAssignemns.SequenceNumber;
item.WorkplaceAssignment_StartDate = workplaceAssignemns.WorkplaceAssignment_StartDate;
employeeWorkplaceAssignments.Add(item);
}
result.EmployeeWorkplaceHistory = employeeWorkplaceAssignments.ToArray();
//Contracts
ORM_CMN_BPT_EMP_EmploymentRelationship_2_WorkingContract.Query contractTermQuery = new ORM_CMN_BPT_EMP_EmploymentRelationship_2_WorkingContract.Query();
contractTermQuery.EmploymentRelationship_RefID = employmentRelationship.CMN_BPT_EMP_EmploymentRelationshipID;
contractTermQuery.IsDeleted = false;
contractTermQuery.Tenant_RefID = securityTicket.TenantID;
List <ORM_CMN_BPT_EMP_EmploymentRelationship_2_WorkingContract> contracts = ORM_CMN_BPT_EMP_EmploymentRelationship_2_WorkingContract.Query.Search(Connection, Transaction, contractTermQuery);
List <L5EM_GEFT_0959_WorkingContracts> resultContracts = new List <L5EM_GEFT_0959_WorkingContracts>();
foreach (var contractToRelationship in contracts)
{
L5EM_GEFT_0959_WorkingContracts resultContract = new L5EM_GEFT_0959_WorkingContracts();
ORM_CMN_BPT_EMP_WorkingContract workingContract = new ORM_CMN_BPT_EMP_WorkingContract();
workingContract.Load(Connection, Transaction, contractToRelationship.WorkingContract_RefID);
if (!workingContract.IsDeleted)
{
resultContract.CMN_BPT_EMP_WorkingContractID = workingContract.CMN_BPT_EMP_WorkingContractID;
resultContract.EmploymentRelationshipToWorkingContractAssignmentID = contractToRelationship.AssignmentID;
resultContract.IsWorkingContract_Active = contractToRelationship.IsContract_Active;
resultContract.Contract_StartDate = workingContract.Contract_StartDate;
resultContract.Contract_EndDate = workingContract.Contract_EndDate;
resultContract.IsContractEndDateDefined = workingContract.IsContractEndDateDefined;
resultContract.IsWorkTimeCalculated_InDays = workingContract.IsWorkTimeCalculated_InDays;
resultContract.IsWorkTimeCalculated_InHours = workingContract.IsWorkTimeCalculated_InHours;
resultContract.R_WorkTime_DaysPerWeek = workingContract.R_WorkTime_DaysPerWeek;
resultContract.R_WorkTime_HoursPerWeek = workingContract.R_WorkTime_HoursPerWeek;
//Office hours
ORM_CMN_BPT_EMP_WorkingContract_2_WorkingDay.Query workingContractTermToWorkingDayQuery = new ORM_CMN_BPT_EMP_WorkingContract_2_WorkingDay.Query();
workingContractTermToWorkingDayQuery.CMN_BPT_EMP_WorkingContract_RefID = workingContract.CMN_BPT_EMP_WorkingContractID;
workingContractTermToWorkingDayQuery.Tenant_RefID = securityTicket.TenantID;
workingContractTermToWorkingDayQuery.IsDeleted = false;
List <ORM_CMN_BPT_EMP_WorkingContract_2_WorkingDay> workingDayAssigments = ORM_CMN_BPT_EMP_WorkingContract_2_WorkingDay.Query.Search(Connection, Transaction, workingContractTermToWorkingDayQuery);
List <L5EM_GEFT_0959_WeeklyOfficeHours> resultWeeklyOfficeHours = new List <L5EM_GEFT_0959_WeeklyOfficeHours>();
foreach (var workingDayAssigment in workingDayAssigments)
{
ORM_CMN_CAL_WeeklyOfficeHours_Interval interval = new ORM_CMN_CAL_WeeklyOfficeHours_Interval();
interval.Load(Connection, Transaction, workingDayAssigment.CMN_CAL_WeeklyOfficeHours_Interval_RefID);
L5EM_GEFT_0959_WeeklyOfficeHours resultOfficeHour = new L5EM_GEFT_0959_WeeklyOfficeHours();
resultOfficeHour.CMN_CAL_WeeklyOfficeHours_IntervalID = interval.CMN_CAL_WeeklyOfficeHours_IntervalID;
resultOfficeHour.IsFriday = interval.IsFriday;
resultOfficeHour.IsMonday = interval.IsMonday;
resultOfficeHour.IsSaturday = interval.IsSaturday;
resultOfficeHour.IsSunday = interval.IsSunday;
resultOfficeHour.IsThursday = interval.IsThursday;
resultOfficeHour.IsTuesday = interval.IsTuesday;
resultOfficeHour.IsWednesday = interval.IsWednesday;
resultOfficeHour.IsWholeDay = interval.IsWholeDay;
resultOfficeHour.TimeFrom_InMinutes = interval.TimeFrom_InMinutes;
resultOfficeHour.TimeTo_InMinutes = interval.TimeTo_InMinutes;
resultWeeklyOfficeHours.Add(resultOfficeHour);
}
resultContract.WeeklyOfficeHours = resultWeeklyOfficeHours.ToArray();
//Allowed absence reasons
ORM_CMN_BPT_EMP_WorkingContract_AllowedAbsenceReason.Query AllowedAbsenceReasonQuery = new ORM_CMN_BPT_EMP_WorkingContract_AllowedAbsenceReason.Query();
AllowedAbsenceReasonQuery.WorkingContract_RefID = resultContract.CMN_BPT_EMP_WorkingContractID;
AllowedAbsenceReasonQuery.Tenant_RefID = securityTicket.TenantID;
AllowedAbsenceReasonQuery.IsDeleted = false;
List <ORM_CMN_BPT_EMP_WorkingContract_AllowedAbsenceReason> allowedAbsenceReasons = ORM_CMN_BPT_EMP_WorkingContract_AllowedAbsenceReason.Query.Search(Connection, Transaction, AllowedAbsenceReasonQuery);
List <L5EM_GEFT_0959_WorkingContractToLeaveRequest> resultAllowedAbsenceReasons = new List <L5EM_GEFT_0959_WorkingContractToLeaveRequest>();
foreach (var allowedAbsenceReason in allowedAbsenceReasons)
{
ORM_CMN_BPT_STA_AbsenceReason absenceReason = new ORM_CMN_BPT_STA_AbsenceReason();
absenceReason.Load(Connection, Transaction, allowedAbsenceReason.STA_AbsenceReason_RefID);
L5EM_GEFT_0959_WorkingContractToLeaveRequest resultReasonresultReason = new L5EM_GEFT_0959_WorkingContractToLeaveRequest();
resultReasonresultReason.CMN_BPT_EMP_Employee_WorkingContract_AllowedAbsenceReasonID = allowedAbsenceReason.CMN_BPT_EMP_WorkingContract_AllowedAbsenceReasonID;
resultReasonresultReason.STA_AbsenceReason_RefID = absenceReason.CMN_BPT_STA_AbsenceReasonID;
resultReasonresultReason.IsAbsenceCalculated_InDays = allowedAbsenceReason.IsAbsenceCalculated_InDays;
resultReasonresultReason.IsAbsenceCalculated_InHours = allowedAbsenceReason.IsAbsenceCalculated_InHours;
resultReasonresultReason.ContractAllowedAbsence_per_Month = allowedAbsenceReason.ContractAllowedAbsence_per_Month;
resultAllowedAbsenceReasons.Add(resultReasonresultReason);
}
resultContract.WorkingContractToLeaveRequest = resultAllowedAbsenceReasons.ToArray();
resultContracts.Add(resultContract);
}
}
result.WorkingContracts = resultContracts.ToArray();
employeeResultList.Add(result);
}
returnValue.Result = employeeResultList.ToArray();
//Put your code here
return(returnValue);
#endregion UserCode
}
protected static FR_L5WA_GWAFWA_0907 Execute(DbConnection Connection, DbTransaction Transaction, P_L5WA_GWAFWA_0907 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5WA_GWAFWA_0907();
returnValue.Result = new L5WA_GWAFWA_0907();
L5WA_GWAFT_1201 result = new L5WA_GWAFT_1201();
ORM_CMN_STR_PPS_WorkArea item = new ORM_CMN_STR_PPS_WorkArea();
if (Parameter.WorkAreaID != Guid.Empty)
{
var resultWorkplace = item.Load(Connection, Transaction, Parameter.WorkAreaID);
if (resultWorkplace.Status != FR_Status.Success || item.CMN_STR_PPS_WorkAreaID == 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_BPT_STA_SettingProfile_RefID = item.CMN_BPT_STA_SettingProfile_RefID;
result.Office_RefID = item.Office_RefID;
result.Parent_RefID = item.Parent_RefID;
result.WorkAreaName = item.Name;
result.WorkAreaDescription = item.Description;
result.ShortName = item.ShortName;
result.CMN_STR_PPS_WorkAreaID = item.CMN_STR_PPS_WorkAreaID;
result.Default_StartWorkingHour = item.Default_StartWorkingHour;
ORM_CMN_STR_PPS_WorkArea_2_CostCenter.Query workareaToCostcenterQuery = new ORM_CMN_STR_PPS_WorkArea_2_CostCenter.Query();
workareaToCostcenterQuery.WorkArea_RefID = Parameter.WorkAreaID;
workareaToCostcenterQuery.Tenant_RefID = securityTicket.TenantID;
workareaToCostcenterQuery.IsDeleted = false;
List <ORM_CMN_STR_PPS_WorkArea_2_CostCenter> workareaToCostcenterList = ORM_CMN_STR_PPS_WorkArea_2_CostCenter.Query.Search(Connection, Transaction, workareaToCostcenterQuery);
if (workareaToCostcenterList.Count != 0)
{
L5WA_GWAFT_1201_Costcenter costCenter = new L5WA_GWAFT_1201_Costcenter();
ORM_CMN_STR_CostCenter costCenterItem = new ORM_CMN_STR_CostCenter();
costCenterItem.Load(Connection, Transaction, workareaToCostcenterList[0].CostCenter_RefID);
if (!costCenterItem.IsDeleted)
{
costCenter.AssignmentID = workareaToCostcenterList[0].AssignmentID;
costCenter.CMN_STR_CostCenterID = workareaToCostcenterList[0].CostCenter_RefID;
costCenter.CostcenterName = costCenterItem.Name;
costCenter.InternalID = costCenterItem.InternalID;
result.Costcenter = costCenter;
}
}
var responsiblePersonsQuery = new ORM_CMN_STR_PPS_WorkArea_ResponsiblePerson.Query();
responsiblePersonsQuery.Tenant_RefID = securityTicket.TenantID;
responsiblePersonsQuery.WorkArea_RefID = item.CMN_STR_PPS_WorkAreaID;
responsiblePersonsQuery.IsDeleted = false;
var responsiblePersonsList = ORM_CMN_STR_PPS_WorkArea_ResponsiblePerson.Query.Search(Connection, Transaction, responsiblePersonsQuery);
List <L5WA_GWAFT_1201_ResponsiblePersons> responsiblePresonsResultList = new List <L5WA_GWAFT_1201_ResponsiblePersons>();
foreach (var responsiblePerson in responsiblePersonsList)
{
L5WA_GWAFT_1201_ResponsiblePersons responsiblePersonResult = new L5WA_GWAFT_1201_ResponsiblePersons();
responsiblePersonResult.CMN_BPT_EMP_EmployeeID = responsiblePerson.CMN_BPT_EMP_Employee_RefID;
responsiblePersonResult.CMN_STR_PPS_WorkArea_ResponsiblePersonID = responsiblePerson.CMN_STR_PPS_WorkArea_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;
responsiblePersonResult.WorkArea_RefID = item.CMN_STR_PPS_WorkAreaID;
responsiblePresonsResultList.Add(responsiblePersonResult);
}
result.ResponsiblePersons = responsiblePresonsResultList.ToArray();
returnValue.Result.workarea = result;
//Put your code here
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5US_SSU_1847 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
var userAccount = new ORM_USR_Account();
var result = userAccount.Load(Connection, Transaction, Parameter.USR_AccountID);
if (result.Status == FR_Status.Success)
{
//Get business participant via userAccount
var businessParticipant = new ORM_CMN_BPT_BusinessParticipant();
businessParticipant.Load(Connection, Transaction, userAccount.BusinessParticipant_RefID);
//Load person
var personInfo = new ORM_CMN_PER_PersonInfo();
personInfo.Load(Connection, Transaction, businessParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID);
//Load communication contacts for person
P_L2CN_GCCfPI_1222 contactsParam = new P_L2CN_GCCfPI_1222();
contactsParam.PersonInfoID = personInfo.CMN_PER_PersonInfoID;
var contactsForPersonInfo = cls_Get_ComunicationContacts_for_PersonInfoID.Invoke(Connection, Transaction, contactsParam, securityTicket).Result.ToList();
if (!Parameter.IsInitialSave)
{
if (Parameter.IsDeleted)
{
#region Delete
var queryApplicationSubscription = new ORM_CMN_Account_ApplicationSubscription.Query();
queryApplicationSubscription.Application_RefID = Parameter.ApplicationID;
queryApplicationSubscription.Account_RefID = userAccount.USR_AccountID;
queryApplicationSubscription.Tenant_RefID = securityTicket.TenantID;
var foundApplicationSubscription = ORM_CMN_Account_ApplicationSubscription.Query.SoftDelete(Connection, Transaction, queryApplicationSubscription);
return(new FR_Guid(FR_Base.Status_OK, userAccount.USR_AccountID));
#endregion
}
#region Edit
personInfo.FirstName = Parameter.FirstName_ContactPerson;
personInfo.LastName = Parameter.LastName_ContactPerson;
personInfo.Save(Connection, Transaction);
var employeeTemp = ORM_CMN_BPT_EMP_Employee.Query.Search(Connection, Transaction, new ORM_CMN_BPT_EMP_Employee.Query()
{
BusinessParticipant_RefID = businessParticipant.CMN_BPT_BusinessParticipantID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).SingleOrDefault();
if (employeeTemp == null)
{
var newEmployee = new ORM_CMN_BPT_EMP_Employee();
newEmployee.CMN_BPT_EMP_EmployeeID = Guid.NewGuid();
newEmployee.BusinessParticipant_RefID = businessParticipant.CMN_BPT_BusinessParticipantID;
newEmployee.StandardFunction = "APOAdminEmployee";
newEmployee.Tenant_RefID = securityTicket.TenantID;
newEmployee.Save(Connection, Transaction);
}
var address = new ORM_CMN_Address();
address.Load(Connection, Transaction, personInfo.Address_RefID);
address.Street_Name = Parameter.Street_Name;
address.Street_Number = Parameter.Street_Number;
address.City_Name = Parameter.Town;
address.City_PostalCode = Parameter.ZIP;
address.Save(Connection, Transaction);
try
{
//telephone
var telephone = contactsForPersonInfo.Where(i => i.Type == EnumUtils.GetEnumDescription(EComunactionContactType.Phone))
.First().Contacts;
if (telephone.Count() == 1)
{
var contactID = telephone[0].CMN_PER_CommunicationContactID;
var contactTelephone = new ORM_CMN_PER_CommunicationContact();
contactTelephone.Load(Connection, Transaction, contactID);
contactTelephone.Content = Parameter.Contact_Telephone;
contactTelephone.Save(Connection, Transaction);
}
}
catch
{
//Log this
}
#region CommentedUsefull-PreviousWayOfContactEmailHandling
//try
//{
// //email
// var email = contactsForPersonInfo.Where(i => i.Type == EnumUtils.GetEnumDescription(EComunactionContactType.Email))
// .First().Contacts;
// if (email.Count() == 1)
// {
// var contactID = email[0].CMN_PER_CommunicationContactID;
// var contactEmail = new ORM_CMN_PER_CommunicationContact();
// contactEmail.Load(Connection, Transaction, contactID);
// contactEmail.Content = Parameter.Contact_Email;
// contactEmail.Save(Connection, Transaction);
// }
//}
//catch
//{
// //Log this
//}
#endregion
#endregion
}
#region SaveGroup
var userAccountToGroup = ORM_USR_Account_2_Group.Query.Search(Connection, Transaction, new ORM_USR_Account_2_Group.Query()
{
USR_Account_RefID = userAccount.USR_AccountID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).SingleOrDefault();
if (userAccountToGroup == null)
{
var newGroup = new ORM_USR_Account_2_Group();
newGroup.AssignmentID = Guid.NewGuid();
newGroup.USR_Account_RefID = userAccount.USR_AccountID;
newGroup.USR_Group_RefID = Parameter.USR_GroupID;
newGroup.Creation_Timestamp = DateTime.Now;
newGroup.Tenant_RefID = securityTicket.TenantID;
newGroup.Save(Connection, Transaction);
}
else
{
userAccountToGroup.USR_Group_RefID = Parameter.USR_GroupID;
userAccountToGroup.Save(Connection, Transaction);
}
#endregion
#region SaveEmployee
var employee = ORM_CMN_BPT_EMP_Employee.Query.Search(Connection, Transaction, new ORM_CMN_BPT_EMP_Employee.Query()
{
BusinessParticipant_RefID = businessParticipant.CMN_BPT_BusinessParticipantID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).SingleOrDefault();
if (employee == null)
{
var newEmployee = new ORM_CMN_BPT_EMP_Employee();
newEmployee.CMN_BPT_EMP_EmployeeID = Guid.NewGuid();
newEmployee.BusinessParticipant_RefID = businessParticipant.CMN_BPT_BusinessParticipantID;
newEmployee.StandardFunction = "APOAdminEmployee";
newEmployee.Tenant_RefID = securityTicket.TenantID;
newEmployee.Save(Connection, Transaction);
}
#endregion
#region CreateOrUpdateContactEmail
var emailTypeProperty = EnumUtils.GetEnumDescription(EComunactionContactType.Email);
var contactEmailTypeQuery = new ORM_CMN_PER_CommunicationContact_Type.Query();
contactEmailTypeQuery.Type = emailTypeProperty;
contactEmailTypeQuery.Tenant_RefID = securityTicket.TenantID;
var contactEmailType = ORM_CMN_PER_CommunicationContact_Type.Query.Search(Connection, Transaction, contactEmailTypeQuery).FirstOrDefault();
//Search for default contact email and create it if don't exist
var defaultContactEmailQuery = new ORM_CMN_PER_CommunicationContact.Query();
defaultContactEmailQuery.PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID;
defaultContactEmailQuery.Contact_Type = contactEmailType.CMN_PER_CommunicationContact_TypeID;
defaultContactEmailQuery.Tenant_RefID = securityTicket.TenantID;
var defaultContactEmail = ORM_CMN_PER_CommunicationContact.Query.Search(Connection, Transaction, defaultContactEmailQuery).FirstOrDefault();
if (defaultContactEmail == null)
{
defaultContactEmail = new ORM_CMN_PER_CommunicationContact();
defaultContactEmail.PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID;
defaultContactEmail.Contact_Type = contactEmailType.CMN_PER_CommunicationContact_TypeID;
defaultContactEmail.IsDefaultForContactType = true;
defaultContactEmail.Tenant_RefID = securityTicket.TenantID;
}
defaultContactEmail.Content = Parameter.Contact_Email;
defaultContactEmail.IsDefaultForContactType = true;
defaultContactEmail.Save(Connection, Transaction);
#endregion
}
else
{
FR_Guid error = new FR_Guid();
error.ErrorMessage = "No Such ID.";
error.Status = FR_Status.Error_Internal;
return(error);
}
return(new FR_Guid(FR_Base.Status_OK, userAccount.USR_AccountID));
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6DR_DDBID_1653 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
P_L6DR_DDBID_1653 param = new P_L6DR_DDBID_1653();
param.CMN_BPT_BusinessParticipantID = Parameter.CMN_BPT_BusinessParticipantID;
var drivers = cls_Retrieve_Driver_Info_and_VerCode.Invoke(Connection, Transaction, securityTicket).Result;
var driver = drivers.FirstOrDefault(x => x.CMN_BPT_BusinessParticipantID == param.CMN_BPT_BusinessParticipantID);
if (driver != null)
{
ORM_CMN_PER_PersonInfo person = new ORM_CMN_PER_PersonInfo();
if (driver.CMN_PER_PersonInfoID != Guid.Empty)
{
var result = person.Load(Connection, Transaction, driver.CMN_PER_PersonInfoID);
if (result.Status != FR_Status.Success || person.CMN_PER_PersonInfoID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
person.IsDeleted = true;
person.Save(Connection, Transaction);
}
ORM_CMN_BPT_BusinessParticipant bParticipant = new ORM_CMN_BPT_BusinessParticipant();
if (driver.CMN_BPT_BusinessParticipantID != Guid.Empty)
{
var result = bParticipant.Load(Connection, Transaction, driver.CMN_BPT_BusinessParticipantID);
if (result.Status != FR_Status.Success || bParticipant.CMN_BPT_BusinessParticipantID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
bParticipant.IsDeleted = true;
bParticipant.Save(Connection, Transaction);
}
if (driver.Contacts != null)
{
foreach (var parContact in driver.Contacts)
{
ORM_CMN_PER_CommunicationContact contact = new ORM_CMN_PER_CommunicationContact();
if (parContact.CMN_PER_CommunicationContact_TypeID != Guid.Empty)
{
var result = contact.Load(Connection, Transaction, parContact.CMN_PER_CommunicationContact_TypeID);
if (result.Status != FR_Status.Success || contact.CMN_PER_CommunicationContactID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
contact.IsDeleted = true;
contact.Save(Connection, Transaction);
}
}
}
ORM_CMN_Address adress = new ORM_CMN_Address();
if (driver.CMN_AddressID != Guid.Empty)
{
var result = adress.Load(Connection, Transaction, driver.CMN_AddressID);
if (result.Status != FR_Status.Success || adress.CMN_AddressID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
adress.IsDeleted = true;
adress.Save(Connection, Transaction);
}
ORM_CMN_BPT_Supplier supplier = new ORM_CMN_BPT_Supplier();
if (driver.CMN_BPT_SupplierID != Guid.Empty)
{
var result = supplier.Load(Connection, Transaction, driver.CMN_BPT_SupplierID);
if (result.Status != FR_Status.Success || supplier.CMN_BPT_SupplierID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
supplier.IsDeleted = true;
supplier.Save(Connection, Transaction);
}
ORM_CMN_BPT_BusinessParticipant asossBParticipant = new ORM_CMN_BPT_BusinessParticipant();
if (driver.AssociatedBusinessParticipant_RefID != Guid.Empty)
{
var result = asossBParticipant.Load(Connection, Transaction, driver.AssociatedBusinessParticipant_RefID);
if (result.Status != FR_Status.Success || asossBParticipant.CMN_BPT_BusinessParticipantID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
asossBParticipant.IsDeleted = true;
asossBParticipant.Save(Connection, Transaction);
}
ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant BusinessParticipant_AssociatedBusinessParticipant = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant();
if (driver.AssociatedBusinessParticipant_RefID != Guid.Empty)
{
var result = BusinessParticipant_AssociatedBusinessParticipant.Load(Connection, Transaction, driver.CMN_BPT_BusinessParticipant_AssociatedBusinessParticipantID);
if (result.Status != FR_Status.Success || BusinessParticipant_AssociatedBusinessParticipant.CMN_BPT_BusinessParticipant_AssociatedBusinessParticipantID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
BusinessParticipant_AssociatedBusinessParticipant.IsDeleted = true;
BusinessParticipant_AssociatedBusinessParticipant.Save(Connection, Transaction);
}
ORM_USR_Account account = new ORM_USR_Account();
if (driver.USR_AccountID != Guid.Empty)
{
var result = account.Load(Connection, Transaction, driver.USR_AccountID);
if (result.Status != FR_Status.Success || account.USR_AccountID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
account.IsDeleted = true;
account.Save(Connection, Transaction);
}
ORM_USR_Device_AccountCode_StatusHistory Device_AccountCode_StatusHistory = new ORM_USR_Device_AccountCode_StatusHistory();
if (driver.USR_Device_AccountCode_UsageHistoryID != Guid.Empty)
{
var result = Device_AccountCode_StatusHistory.Load(Connection, Transaction, driver.USR_Device_AccountCode_UsageHistoryID);
if (result.Status != FR_Status.Success || Device_AccountCode_StatusHistory.USR_Device_AccountCode_StatusHistoryID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
Device_AccountCode_StatusHistory.IsDeleted = true;
Device_AccountCode_StatusHistory.Save(Connection, Transaction);
}
ORM_USR_Device_AccountCode accountCode = new ORM_USR_Device_AccountCode();
if (driver.USR_Device_AccountCodeID != Guid.Empty)
{
var result = accountCode.Load(Connection, Transaction, driver.USR_Device_AccountCodeID);
if (result.Status != FR_Status.Success || accountCode.USR_Device_AccountCodeID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
accountCode.IsDeleted = true;
accountCode.Save(Connection, Transaction);
}
var Device_AccountCode_UsageHistoryQuery = new ORM_USR_Device_AccountCode_UsageHistory.Query();
Device_AccountCode_UsageHistoryQuery.Device_AccountCode_RefID = accountCode.USR_Device_AccountCodeID;
Device_AccountCode_UsageHistoryQuery.IsDeleted = false;
Device_AccountCode_UsageHistoryQuery.Tenant_RefID = securityTicket.TenantID;
var historyArray = ORM_USR_Device_AccountCode_UsageHistory.Query.Search(Connection, Transaction, Device_AccountCode_UsageHistoryQuery);
if (historyArray != null && historyArray.Count > 0)
{
foreach (var historyItem in historyArray)
{
historyItem.IsDeleted = true;
historyItem.Save(Connection, Transaction);
}
}
}
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6DR_SD_1537 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
if (Parameter.CMN_BPT_BusinessParticipantID == Guid.Empty)
{
#region Create Mode
#region BusinessParticipant
ORM_CMN_BPT_BusinessParticipant bParticipant = new ORM_CMN_BPT_BusinessParticipant();
bParticipant.CMN_BPT_BusinessParticipantID = Guid.NewGuid();
bParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID = Guid.NewGuid();
bParticipant.IsNaturalPerson = true;
bParticipant.Tenant_RefID = securityTicket.TenantID;
bParticipant.Creation_Timestamp = DateTime.Now;
bParticipant.Save(Connection, Transaction);
#endregion
#region Account
ORM_USR_Account account = new ORM_USR_Account();
account.Username = Parameter.FirstName + "_" + Parameter.LastName;
account.AccountType = 3;
account.BusinessParticipant_RefID = bParticipant.CMN_BPT_BusinessParticipantID;
account.Tenant_RefID = securityTicket.TenantID;
account.Creation_Timestamp = DateTime.Now;
account.Save(Connection, Transaction);
P_L2DC_GUDCfT_1505 codeParam = new P_L2DC_GUDCfT_1505();
codeParam.codeLength = 8;
var checkCodeValue = cls_GetUniqueDeviceCodeForTenant.Invoke(Connection, Transaction, codeParam, securityTicket).Result;
ORM_USR_Device_AccountCode accountCode = new ORM_USR_Device_AccountCode();
accountCode.Account_RefID = account.USR_AccountID;
accountCode.AccountCode_Value = checkCodeValue.CodeValue;
accountCode.AccountCode_ValidFrom = DateTime.Now;
accountCode.AccountCode_CurrentStatus_RefID = Guid.NewGuid();
accountCode.IsAccountCode_Expirable = false;
accountCode.Tenant_RefID = securityTicket.TenantID;
accountCode.Creation_Timestamp = DateTime.Now;
accountCode.Save(Connection, Transaction);
ORM_USR_Device_AccountCode_StatusHistory Device_AccountCode_StatusHistory = new ORM_USR_Device_AccountCode_StatusHistory();
Device_AccountCode_StatusHistory.USR_Device_AccountCode_StatusHistoryID = accountCode.AccountCode_CurrentStatus_RefID;
Device_AccountCode_StatusHistory.IsAccountCode_Active = true;
Device_AccountCode_StatusHistory.Device_AccountCode_RefID = accountCode.USR_Device_AccountCodeID;
Device_AccountCode_StatusHistory.Tenant_RefID = securityTicket.TenantID;
Device_AccountCode_StatusHistory.Creation_Timestamp = DateTime.Now;
Device_AccountCode_StatusHistory.Save(Connection, Transaction);
ORM_USR_Device_AccountCode_UsageHistory USR_Device_AccountCode_UsageHistory = new ORM_USR_Device_AccountCode_UsageHistory();
USR_Device_AccountCode_UsageHistory.USR_Device_AccountCode_UsageHistoryID = Guid.NewGuid();
USR_Device_AccountCode_UsageHistory.Tenant_RefID = securityTicket.TenantID;
USR_Device_AccountCode_UsageHistory.Device_AccountCode_RefID = accountCode.USR_Device_AccountCodeID;
USR_Device_AccountCode_UsageHistory.Creation_Timestamp = DateTime.Now;
USR_Device_AccountCode_UsageHistory.Save(Connection, Transaction);
#endregion
#region PersonInfo and Adresses
ORM_CMN_PER_PersonInfo personInfo = new ORM_CMN_PER_PersonInfo();
personInfo.CMN_PER_PersonInfoID = bParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID;
personInfo.Salutation_General = Parameter.Salutation_General;
personInfo.FirstName = Parameter.FirstName;
personInfo.LastName = Parameter.LastName;
personInfo.PrimaryEmail = Parameter.PrimaryMail;
personInfo.Address_RefID = Guid.NewGuid();
personInfo.Tenant_RefID = securityTicket.TenantID;
personInfo.Save(Connection, Transaction);
ORM_CMN_PER_PersonInfo_2_Address personAdress = new ORM_CMN_PER_PersonInfo_2_Address();
personAdress.AssignmentID = Guid.NewGuid();
personAdress.CMN_PER_PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID;
personAdress.CMN_Address_RefID = personInfo.Address_RefID;
personAdress.IsPrimary = true;
personAdress.Tenant_RefID = securityTicket.TenantID;
personAdress.Save(Connection, Transaction);
ORM_CMN_Address adress = new ORM_CMN_Address();
adress.CMN_AddressID = personInfo.Address_RefID;
adress.City_Name = Parameter.City_Name;
adress.Province_Name = Parameter.Province_Name;
adress.Street_Name = Parameter.Street_Name;
adress.Street_Number = Parameter.Street_Number;
adress.City_PostalCode = Parameter.City_PostalCode;
adress.Tenant_RefID = securityTicket.TenantID;
adress.Save(Connection, Transaction);
#endregion
#region Contacts
foreach (var parContact in Parameter.Contacts)
{
ORM_CMN_PER_CommunicationContact contact = new ORM_CMN_PER_CommunicationContact();
contact.Content = parContact.Content;
contact.Contact_Type = parContact.CMN_PER_CommunicationContact_TypeID;
contact.Tenant_RefID = securityTicket.TenantID;
contact.PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID;
contact.Save(Connection, Transaction);
}
#endregion
#region Driver To Employer
ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant bpt_asBP = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant();
bpt_asBP.CMN_BPT_BusinessParticipant_AssociatedBusinessParticipantID = Guid.NewGuid();
bpt_asBP.BusinessParticipant_RefID = bParticipant.CMN_BPT_BusinessParticipantID;
bpt_asBP.AssociatedParticipant_FunctionName = "Driver";
bpt_asBP.Tenant_RefID = securityTicket.TenantID;
bpt_asBP.AssociatedBusinessParticipant_RefID = Parameter.CMN_BPT_BusinessParticipantID_Of_Employer;
bpt_asBP.Save(Connection, Transaction);
#endregion
#endregion
}
else
{
ORM_CMN_BPT_BusinessParticipant bParticipant = new ORM_CMN_BPT_BusinessParticipant();
bParticipant.Load(Connection, Transaction, Parameter.CMN_BPT_BusinessParticipantID);
var personInfo = new ORM_CMN_PER_PersonInfo();
personInfo.Load(Connection, Transaction, bParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID);
personInfo.Salutation_General = Parameter.Salutation_General;
personInfo.FirstName = Parameter.FirstName;
personInfo.LastName = Parameter.LastName;
personInfo.PrimaryEmail = Parameter.PrimaryMail;
personInfo.Save(Connection, Transaction);
ORM_CMN_Address adress = new ORM_CMN_Address();
adress.Load(Connection, Transaction, personInfo.Address_RefID);
adress.City_Name = Parameter.City_Name;
adress.Province_Name = Parameter.Province_Name;
adress.Street_Name = Parameter.Street_Name;
adress.Street_Number = Parameter.Street_Number;
adress.Save(Connection, Transaction);
foreach (var parContact in Parameter.Contacts)
{
var query = new ORM_CMN_PER_CommunicationContact.Query();
query.Contact_Type = parContact.CMN_PER_CommunicationContact_TypeID;
query.IsDeleted = false;
query.PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID;
var contact = ORM_CMN_PER_CommunicationContact.Query.Search(Connection, Transaction, query).First();
contact.Content = parContact.Content;
contact.Contact_Type = parContact.CMN_PER_CommunicationContact_TypeID;
contact.Save(Connection, Transaction);
}
var associationQuery = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query();
associationQuery.BusinessParticipant_RefID = Parameter.CMN_BPT_BusinessParticipantID;
associationQuery.IsDeleted = false;
var bpt_asBP = ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query.Search(Connection, Transaction, associationQuery).First();
bpt_asBP.AssociatedBusinessParticipant_RefID = Parameter.CMN_BPT_BusinessParticipantID_Of_Employer;
bpt_asBP.Save(Connection, Transaction);
}
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5EM_SE_1657 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
ORM_CMN_Address address = new ORM_CMN_Address();
if (Parameter.CMN_AddressID != Guid.Empty)
{
var result = address.Load(Connection, Transaction, Parameter.CMN_AddressID);
if (result.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(error);
}
}
address.City_Name = Parameter.City_Name;
address.Street_Name = Parameter.Street_Name;
address.Street_Number = Parameter.Street_Number;
address.Country_Name = Parameter.Country_Name;
address.Province_Name = Parameter.Province_Name;
address.Tenant_RefID = securityTicket.TenantID;
address.City_PostalCode = Parameter.City_PostalCode;
address.Save(Connection, Transaction);
CSV2Core.DlTrace.Trace("success address");
ORM_CMN_PER_PersonInfo person = new ORM_CMN_PER_PersonInfo();
if (Parameter.CMN_PER_PersonInfoID != Guid.Empty)
{
var result = person.Load(Connection, Transaction, Parameter.CMN_PER_PersonInfoID);
if (result.Status != FR_Status.Success || person.CMN_PER_PersonInfoID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
//person.AccountImage_URL = Parameter.ProfileImage_Document_RefID;
person.FirstName = Parameter.FirstName;
person.LastName = Parameter.LastName;
person.PrimaryEmail = Parameter.PrimaryEmail;
person.Tenant_RefID = securityTicket.TenantID;
person.Title = Parameter.Title;
person.Address_RefID = address.CMN_AddressID;
person.ProfileImage_Document_RefID = Parameter.ImageID;
person.BirthDate = Parameter.BirthDate;
person.NumberOfChildren = Parameter.TaxInfoParameter != null ? Parameter.TaxInfoParameter.NumberOfChildren : 0;
person.Save(Connection, Transaction);
CSV2Core.DlTrace.Trace("success persopm");
var contactQuery = new ORM_CMN_PER_CommunicationContact.Query();
contactQuery.Tenant_RefID = securityTicket.TenantID;
contactQuery.PersonInfo_RefID = person.CMN_PER_PersonInfoID;
contactQuery.IsDeleted = false;
var deleteContacts = ORM_CMN_PER_CommunicationContact.Query.SoftDelete(Connection, Transaction, contactQuery);
foreach (var parContact in Parameter.Contacts)
{
ORM_CMN_PER_CommunicationContact contact = new ORM_CMN_PER_CommunicationContact();
if (parContact.CMN_PER_CommunicationContactID != Guid.Empty)
{
var result = contact.Load(Connection, Transaction, parContact.CMN_PER_CommunicationContactID);
if (result.Status != FR_Status.Success || contact.CMN_PER_CommunicationContactID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
contact.Content = parContact.Content;
contact.Contact_Type = parContact.CMN_PER_CommunicationContact_TypeID;
contact.Tenant_RefID = securityTicket.TenantID;
contact.PersonInfo_RefID = person.CMN_PER_PersonInfoID;
contact.Save(Connection, Transaction);
CSV2Core.DlTrace.Trace("success contact");
}
ORM_CMN_BPT_BusinessParticipant bParticipant = new ORM_CMN_BPT_BusinessParticipant();
if (Parameter.CMN_BPT_BusinessParticipantID != Guid.Empty)
{
var result = bParticipant.Load(Connection, Transaction, Parameter.CMN_BPT_BusinessParticipantID);
if (result.Status != FR_Status.Success || bParticipant.CMN_BPT_BusinessParticipantID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
bParticipant.DisplayName = Parameter.DisplayName;
bParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID = person.CMN_PER_PersonInfoID;
bParticipant.IsNaturalPerson = true;
bParticipant.Tenant_RefID = securityTicket.TenantID;
bParticipant.Save(Connection, Transaction);
ORM_CMN_BPT_EMP_Employee employee = new ORM_CMN_BPT_EMP_Employee();
CSV2Core.DlTrace.Trace("success bpart");
if (Parameter.CMN_BPT_EMP_EmployeeID != Guid.Empty)
{
var result = employee.Load(Connection, Transaction, Parameter.CMN_BPT_EMP_EmployeeID);
if (result.Status != FR_Status.Success || employee.CMN_BPT_EMP_EmployeeID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
employee.BusinessParticipant_RefID = bParticipant.CMN_BPT_BusinessParticipantID;
employee.Staff_Number = Parameter.Staff_Number;
employee.StandardFunction = Parameter.StandardFunction;
employee.Tenant_RefID = securityTicket.TenantID;
employee.Save(Connection, Transaction);
CSV2Core.DlTrace.Trace("success employee");
ORM_CMN_BPT_EMP_EmploymentRelationship employmentRelationship = new ORM_CMN_BPT_EMP_EmploymentRelationship();
if (Parameter.CMN_BPT_EMP_Employee_EmploymentRelationshipID != Guid.Empty)
{
var result = employmentRelationship.Load(Connection, Transaction, Parameter.CMN_BPT_EMP_Employee_EmploymentRelationshipID);
if (result.Status != FR_Status.Success || employmentRelationship.CMN_BPT_EMP_EmploymentRelationshipID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
employmentRelationship.Work_StartDate = Parameter.Work_StartDate;
bool resignationDateChanged = false;
if (employmentRelationship.Work_EndDate != Parameter.Work_EndDate)
{
resignationDateChanged = true;
}
employmentRelationship.Work_EndDate = Parameter.Work_EndDate;
employmentRelationship.Tenant_RefID = securityTicket.TenantID;
employmentRelationship.Employee_RefID = employee.CMN_BPT_EMP_EmployeeID;
employmentRelationship.Save(Connection, Transaction);
CSV2Core.DlTrace.Trace("success employmentRelationship");
if (Parameter.Work_EndDate.Ticks != 0)
{
ORM_CMN_BPT_EMP_EmploymentRelationship_2_WorkingContract.Query empRelationShipToWorkingContractQuery = new ORM_CMN_BPT_EMP_EmploymentRelationship_2_WorkingContract.Query();
empRelationShipToWorkingContractQuery.EmploymentRelationship_RefID = employmentRelationship.CMN_BPT_EMP_EmploymentRelationshipID;
empRelationShipToWorkingContractQuery.Tenant_RefID = securityTicket.TenantID;
empRelationShipToWorkingContractQuery.IsDeleted = false;
List <ORM_CMN_BPT_EMP_EmploymentRelationship_2_WorkingContract> workingContractAssignments = ORM_CMN_BPT_EMP_EmploymentRelationship_2_WorkingContract.Query.Search(Connection, Transaction, empRelationShipToWorkingContractQuery);
foreach (var workingContractAssignment in workingContractAssignments)
{
ORM_CMN_BPT_EMP_WorkingContract workingContract = new ORM_CMN_BPT_EMP_WorkingContract();
if (workingContractAssignment.WorkingContract_RefID != Guid.Empty)
{
var result = workingContract.Load(Connection, Transaction, workingContractAssignment.WorkingContract_RefID);
if (result.Status != FR_Status.Success || workingContract.CMN_BPT_EMP_WorkingContractID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
if (workingContract.Contract_EndDate.Ticks == 0 || workingContract.Contract_EndDate.Ticks > Parameter.Work_EndDate.Ticks)
{
workingContract.Contract_EndDate = Parameter.Work_EndDate;
workingContract.IsContractEndDateDefined = true;
workingContract.Save(Connection, Transaction);
}
}
}
var activeTimeFrame = cls_Get_Active_CalculationTimeFrame.Invoke(Connection, Transaction, securityTicket).Result;
var timeframes = cls_Get_CalculationTimeFramesForTenant.Invoke(Connection, Transaction, securityTicket).Result.ToList();
var resultFrames = timeframes.Where(i => i.CalculationTimeframe_StartDate.Year == employmentRelationship.Work_StartDate.Year).ToList();
if (resultFrames.Count == 0)
{
var newFrame = new ORM_CMN_CAL_CalculationTimeframe();
int currentYear = Parameter.Work_StartDate.Year;
while (currentYear < activeTimeFrame.CalculationTimeframe_StartDate.Year)
{
if (!timeframes.Any(i => i.CalculationTimeframe_StartDate.Year == currentYear))
{
newFrame.CalculationTimeframe_StartDate = new DateTime(currentYear, 1, 1);
newFrame.CalculationTimeframe_EstimatedEndDate = new DateTime(currentYear, 12, 31);
newFrame.Tenant_RefID = securityTicket.TenantID;
newFrame.Save(Connection, Transaction);
newFrame = new ORM_CMN_CAL_CalculationTimeframe();
}
currentYear++;
ORM_CMN_BPT_EMP_EmploymentRelationship_Timeframe relationshipFrame = new ORM_CMN_BPT_EMP_EmploymentRelationship_Timeframe();
relationshipFrame.CalculationTimeframe_RefID = newFrame.CMN_CAL_CalculationTimeframeID;
relationshipFrame.EmploymentRelationship_RefID = employmentRelationship.CMN_BPT_EMP_EmploymentRelationshipID;
relationshipFrame.Tenant_RefID = securityTicket.TenantID;
relationshipFrame.Save(Connection, Transaction);
}
}
else
{
timeframes = timeframes.Where(i => i.CalculationTimeframe_StartDate.Year < activeTimeFrame.CalculationTimeframe_StartDate.Year && i.CalculationTimeframe_StartDate.Year >= employmentRelationship.Work_StartDate.Year).ToList();
foreach (var timeframe in timeframes)
{
ORM_CMN_BPT_EMP_EmploymentRelationship_Timeframe.Query relationshipFrameQuery = new ORM_CMN_BPT_EMP_EmploymentRelationship_Timeframe.Query();
relationshipFrameQuery.CalculationTimeframe_RefID = timeframe.CMN_CAL_CalculationTimeframeID;
relationshipFrameQuery.EmploymentRelationship_RefID = employmentRelationship.CMN_BPT_EMP_EmploymentRelationshipID;
relationshipFrameQuery.Tenant_RefID = securityTicket.TenantID;
List <ORM_CMN_BPT_EMP_EmploymentRelationship_Timeframe> oldContractFrames = ORM_CMN_BPT_EMP_EmploymentRelationship_Timeframe.Query.Search(Connection, Transaction, relationshipFrameQuery);
if (oldContractFrames.Count == 0)
{
ORM_CMN_BPT_EMP_EmploymentRelationship_Timeframe relationshipFrame = new ORM_CMN_BPT_EMP_EmploymentRelationship_Timeframe();
relationshipFrame.CalculationTimeframe_RefID = timeframe.CMN_CAL_CalculationTimeframeID;
relationshipFrame.EmploymentRelationship_RefID = employmentRelationship.CMN_BPT_EMP_EmploymentRelationshipID;
relationshipFrame.Tenant_RefID = securityTicket.TenantID;
relationshipFrame.Save(Connection, Transaction);
}
}
}
P_L5EM_GAERCTFFE_1405 timeFrameParam = new P_L5EM_GAERCTFFE_1405();
timeFrameParam.EmployeeID = employee.CMN_BPT_EMP_EmployeeID;
L5EM_GAERCTFFE_1405 employeeTimeFrame = cls_Get_Active_EmployeeRelationshipTimeFrame_For_EmployeeID.Invoke(Connection, Transaction, timeFrameParam, securityTicket).Result;
if (employeeTimeFrame == null)
{
ORM_CMN_BPT_EMP_EmploymentRelationship_Timeframe timeFrame = new ORM_CMN_BPT_EMP_EmploymentRelationship_Timeframe();
timeFrame.CalculationTimeframe_RefID = activeTimeFrame.CMN_CAL_CalculationTimeframeID;
timeFrame.EmploymentRelationship_RefID = employmentRelationship.CMN_BPT_EMP_EmploymentRelationshipID;
timeFrame.Tenant_RefID = securityTicket.TenantID;
timeFrame.Save(Connection, Transaction);
CSV2Core.DlTrace.Trace("success timeFrame");
}
//save employee professions
P_L5EM_SEP_1447 saveProfessionsPar = new P_L5EM_SEP_1447();
saveProfessionsPar.Employee_RefID = employee.CMN_BPT_EMP_EmployeeID;
saveProfessionsPar.FunctionHistories = Parameter.FunctionHistories;
cls_Save_EmployeeFunctionHistory.Invoke(Connection, Transaction, saveProfessionsPar, securityTicket);
CSV2Core.DlTrace.Trace("success employee function history");
//save workplace histories
P_L5EM_SWPH_1625 saveWorkplaceHistoryPar = new P_L5EM_SWPH_1625();
saveWorkplaceHistoryPar.Employee_RefID = employee.CMN_BPT_EMP_EmployeeID;
saveWorkplaceHistoryPar.WorkplaceHistories = Parameter.WorkplaceHistories;
cls_Save_WorkplaceHistories.Invoke(Connection, Transaction, saveWorkplaceHistoryPar, securityTicket);
CSV2Core.DlTrace.Trace("success workplaceHistories");
P_L5EM_SUED_1648 saveDocuments = new P_L5EM_SUED_1648();
saveDocuments.Employee_RefID = employee.CMN_BPT_EMP_EmployeeID;
saveDocuments.Documents = Parameter.Documents;
cls_Save_Uploaded_Employee_Document.Invoke(Connection, Transaction, saveDocuments, securityTicket);
CSV2Core.DlTrace.Trace("success documents");
P_L5EM_SEQS_0959 saveSkillsPar = new P_L5EM_SEQS_0959();
saveSkillsPar.Employee_RefID = employee.CMN_BPT_EMP_EmployeeID;
saveSkillsPar.Skills = Parameter.Skills;
cls_Save_Employee_QualificationSkills.Invoke(Connection, Transaction, saveSkillsPar, securityTicket);
CSV2Core.DlTrace.Trace("success skills");
CSV2Core.DlTrace.Trace("AccountID :" + Parameter.USR_AccountID);
if (Parameter.USR_AccountID != null && Parameter.USR_AccountID != Guid.Empty)
{
CSV2Core.DlTrace.Trace("success param");
ORM_USR_Account account = new ORM_USR_Account();
if (Parameter.USR_AccountID != Guid.Empty)
{
var result = account.Load(Connection, Transaction, Parameter.USR_AccountID);
if (account.USR_AccountID == Guid.Empty)
{
account.USR_AccountID = Guid.NewGuid();
account.AccountType = 2;
}
account.Username = Parameter.username;
account.DefaultLanguage_RefID = Parameter.LanguageID;
account.BusinessParticipant_RefID = bParticipant.CMN_BPT_BusinessParticipantID;
account.Tenant_RefID = securityTicket.TenantID;
account.Save(Connection, Transaction);
var personToAccountQuery = new ORM_CMN_PER_PersonInfo_2_Account.Query();
personToAccountQuery.Tenant_RefID = securityTicket.TenantID;
personToAccountQuery.USR_Account_RefID = account.USR_AccountID;
personToAccountQuery.IsDeleted = false;
var personToAccounts = ORM_CMN_PER_PersonInfo_2_Account.Query.Search(Connection, Transaction, personToAccountQuery);
if (personToAccounts.Count != 0)
{
ORM_CMN_PER_PersonInfo_2_Account personToAccount = personToAccounts[0];
personToAccount.CMN_PER_PersonInfo_RefID = person.CMN_PER_PersonInfoID;
personToAccount.USR_Account_RefID = account.USR_AccountID;
personToAccount.Tenant_RefID = securityTicket.TenantID;
personToAccount.Save(Connection, Transaction);
}
else
{
ORM_CMN_PER_PersonInfo_2_Account personToAccount = new ORM_CMN_PER_PersonInfo_2_Account();
personToAccount.CMN_PER_PersonInfo_RefID = person.CMN_PER_PersonInfoID;
personToAccount.USR_Account_RefID = account.USR_AccountID;
personToAccount.Tenant_RefID = securityTicket.TenantID;
personToAccount.Save(Connection, Transaction);
}
}
if (Parameter.Rights != null)
{
foreach (var rightsParam in Parameter.Rights)
{
if (rightsParam.RightAssinmentID == Guid.Empty && rightsParam.RightID != Guid.Empty)
{
var right2account = new ORM_USR_Account_2_FunctionLevelRight();
right2account.Account_RefID = Parameter.USR_AccountID;
right2account.FunctionLevelRight_RefID = rightsParam.RightID;
right2account.Tenant_RefID = securityTicket.TenantID;
right2account.Save(Connection, Transaction);
CSV2Core.DlTrace.Trace("success save right: " + right2account.FunctionLevelRight_RefID);
}
if (rightsParam.RightAssinmentID != Guid.Empty && rightsParam.RightID == Guid.Empty)
{
var right2account = new ORM_USR_Account_2_FunctionLevelRight();
if (rightsParam.RightAssinmentID != Guid.Empty)
{
var result = right2account.Load(Connection, Transaction, rightsParam.RightAssinmentID);
if (result.Status != FR_Status.Success || right2account.AssignmentID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
right2account.IsDeleted = true;
right2account.Save(Connection, Transaction);
CSV2Core.DlTrace.Trace("success save right2Acc: " + right2account.FunctionLevelRight_RefID);
}
}
}
}
CSV2Core.DlTrace.Trace("emp id wtf " + Parameter.CMN_BPT_EMP_EmployeeID);
if (Parameter.CMN_BPT_EMP_EmployeeID == Guid.Empty || resignationDateChanged)
{
var enterpriseService = InfrastructureFactory.CreateEnterpriseService();
KeyPerformanceIndicator action = new KeyPerformanceIndicator();
action.PerformedByAccountID = securityTicket.AccountID;
action.PerformedByApplicationID = Parameter.ApplicationID;
action.PerformedOn = DateTime.Now;
action.PerformedByTenantID = securityTicket.TenantID;
action.KeyPerformanceIndicatorID = Guid.Parse("4dda967a-5399-4929-afae-7af64699895b");
action.Value = cls_Get_Employees_For_Tenant.Invoke(Connection, Transaction, securityTicket).Result.Where(i => i.Work_EndDate.Ticks == 0 || i.Work_EndDate.Ticks > DateTime.Now.Ticks).ToArray().Length;
var result = enterpriseService.SendMessage(action.ToPayload(), KeyPerformanceIndicator.MESSAGE_TYPE, Parameter.ApplicationID, EMessageRecipient.CUSTOMER_MANAGEMENT_PLATFORM);
// ServerLog.Instance.Info("Enterprise message sending " + (result.Code == 200 ? "successful" : "failed"));
CSV2Core.DlTrace.Trace("success send kpi");
}
Parameter.TaxInfoParameter.EmployeeID = employee.CMN_BPT_EMP_EmployeeID;
Parameter.TaxInfoParameter.CMN_BPT_BusinessParticipantID = bParticipant.CMN_BPT_BusinessParticipantID;
cls_Save_Employee_TaxInformation.Invoke(Connection, Transaction, Parameter.TaxInfoParameter, securityTicket);
cls_Save_Employee_BankAccount.Invoke(Connection, Transaction, Parameter.BankAccountParameter, securityTicket);
Parameter.SocialSecurity.CMN_PER_PersonInfoID = person.CMN_PER_PersonInfoID;
Parameter.SocialSecurity.CMN_BPT_EMP_EmployeeID = employee.CMN_BPT_EMP_EmployeeID;
Parameter.SocialSecurity.CMN_BPT_BusinessParticipantID = bParticipant.CMN_BPT_BusinessParticipantID;
cls_Save_Employee_SocialSecurity.Invoke(Connection, Transaction, Parameter.SocialSecurity, securityTicket);
returnValue.Result = employee.CMN_BPT_EMP_EmployeeID;
return(returnValue);
#endregion UserCode
}
protected static FR_L5WP_GWPFWPID_1132 Execute(DbConnection Connection, DbTransaction Transaction, P_L5WP_GWPFWPID_1132 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5WP_GWPFWPID_1132();
returnValue.Result = new L5WP_GWPFWPID_1132();
L5WP_GWFT_1203 result = new L5WP_GWFT_1203();
ORM_CMN_STR_PPS_Workplace item = new ORM_CMN_STR_PPS_Workplace();
if (Parameter.workplaceID != Guid.Empty)
{
var resultWorkplace = item.Load(Connection, Transaction, Parameter.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 = item.CMN_STR_PPS_WorkplaceID;
result.ShortName = item.ShortName;
result.WorkArea_RefID = item.WorkArea_RefID;
result.WorkPlaceDescription = item.Description;
result.WorkPlaceName = item.Name;
var responsiblePersonsQuery = new ORM_CMN_STR_PPS_Workplace_ResponsiblePerson.Query();
responsiblePersonsQuery.Tenant_RefID = securityTicket.TenantID;
responsiblePersonsQuery.Workplace_RefID = item.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();
returnValue.Result.workplace = result;
//Put your code here
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6PA_SBBVP_1223 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
ORM_HEC_Patient patient = new ORM_HEC_Patient();
if (Parameter.HEC_PatientID != Guid.Empty)
{
var result = patient.Load(Connection, Transaction, Parameter.HEC_PatientID);
if (result.Status != FR_Status.Success || patient.HEC_PatientID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
patient.IsPatientParticipationPolicyValidated = Parameter.HasFulfilledParticipationPolicyRequirements;
patient.PatientComment = Parameter.Comment;
patient.Tenant_RefID = securityTicket.TenantID;
ORM_CMN_BPT_BusinessParticipant bParticipant = new ORM_CMN_BPT_BusinessParticipant();
if (patient.CMN_BPT_BusinessParticipant_RefID != Guid.Empty)
{
var result = bParticipant.Load(Connection, Transaction, patient.CMN_BPT_BusinessParticipant_RefID);
if (result.Status != FR_Status.Success || bParticipant.CMN_BPT_BusinessParticipantID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
bParticipant.IsNaturalPerson = true;
bParticipant.Tenant_RefID = securityTicket.TenantID;
ORM_CMN_PER_PersonInfo person = new ORM_CMN_PER_PersonInfo();
if (bParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID != Guid.Empty)
{
var result = person.Load(Connection, Transaction, bParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID);
if (result.Status != FR_Status.Success || person.CMN_PER_PersonInfoID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
person.FirstName = Parameter.FirstName;
person.LastName = Parameter.LastName;
person.PrimaryEmail = Parameter.Mail;
person.Tenant_RefID = securityTicket.TenantID;
person.Salutation_General = Parameter.Salutation;
person.Save(Connection, Transaction);
bParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID = person.CMN_PER_PersonInfoID;
bParticipant.Save(Connection, Transaction);
patient.CMN_BPT_BusinessParticipant_RefID = bParticipant.CMN_BPT_BusinessParticipantID;
patient.Save(Connection, Transaction);
ORM_CMN_PER_CommunicationContact.Query contactQuery = new ORM_CMN_PER_CommunicationContact.Query();
contactQuery.IsDeleted = false;
contactQuery.Tenant_RefID = securityTicket.TenantID;
contactQuery.PersonInfo_RefID = person.CMN_PER_PersonInfoID;
var contactQueryRes = ORM_CMN_PER_CommunicationContact.Query.Search(Connection, Transaction, contactQuery);
ORM_CMN_PER_CommunicationContact contactPhone = contactQueryRes.FirstOrDefault(c => c.Contact_Type == STLD_ContactTypes.Phone);
ORM_CMN_PER_CommunicationContact contactFax = contactQueryRes.FirstOrDefault(c => c.Contact_Type == STLD_ContactTypes.Fax);
if (contactPhone == null)
{
contactPhone = new ORM_CMN_PER_CommunicationContact();
contactPhone.Contact_Type = STLD_ContactTypes.Phone;
contactPhone.Tenant_RefID = securityTicket.TenantID;
contactPhone.PersonInfo_RefID = person.CMN_PER_PersonInfoID;
}
contactPhone.Content = Parameter.Phone;
contactPhone.Save(Connection, Transaction);
if (contactFax == null)
{
contactFax = new ORM_CMN_PER_CommunicationContact();
contactFax.Content = Parameter.Fax;
contactFax.Contact_Type = STLD_ContactTypes.Fax;
contactFax.Tenant_RefID = securityTicket.TenantID;
contactFax.PersonInfo_RefID = person.CMN_PER_PersonInfoID;
contactFax.Save(Connection, Transaction);
}
contactFax.Content = Parameter.Fax;
contactFax.Save(Connection, Transaction);
ORM_HEC_Patient_HealthInsurance.Query Patient_HealthInsuranceQuery = new ORM_HEC_Patient_HealthInsurance.Query();
Patient_HealthInsuranceQuery.Tenant_RefID = securityTicket.TenantID;
Patient_HealthInsuranceQuery.IsDeleted = false;
Patient_HealthInsuranceQuery.Patient_RefID = patient.HEC_PatientID;
ORM_HEC_Patient_HealthInsurance Patient_HealthInsurance;
var Patient_HealthInsuranceQueryRes = ORM_HEC_Patient_HealthInsurance.Query.Search(Connection, Transaction, Patient_HealthInsuranceQuery);
if (Patient_HealthInsuranceQueryRes.Count == 1)
{
Patient_HealthInsurance = Patient_HealthInsuranceQueryRes[0];
}
else
{
Patient_HealthInsurance = new ORM_HEC_Patient_HealthInsurance();
Patient_HealthInsurance.Patient_RefID = patient.HEC_PatientID;
Patient_HealthInsurance.Tenant_RefID = securityTicket.TenantID;
Patient_HealthInsurance.IsPrimary = true;
}
Patient_HealthInsurance.HealthInsurance_Number = Parameter.HealthcareNumber;
Patient_HealthInsurance.Save(Connection, Transaction);
ORM_HEC_STU_Study_ParticipatingPatient.Query Study_ParticipatingPatientsQuery = new ORM_HEC_STU_Study_ParticipatingPatient.Query();
Study_ParticipatingPatientsQuery.Tenant_RefID = securityTicket.TenantID;
Study_ParticipatingPatientsQuery.IsDeleted = false;
Study_ParticipatingPatientsQuery.Patient_RefID = patient.HEC_PatientID;
ORM_HEC_STU_Study_ParticipatingPatient Study_ParticipatingPatients;
var Study_ParticipatingPatientsQueryRes = ORM_HEC_STU_Study_ParticipatingPatient.Query.Search(Connection, Transaction, Study_ParticipatingPatientsQuery);
if (Study_ParticipatingPatientsQueryRes.Count == 1)
{
Study_ParticipatingPatients = Study_ParticipatingPatientsQueryRes[0];
}
else
{
Study_ParticipatingPatients = new ORM_HEC_STU_Study_ParticipatingPatient();
Study_ParticipatingPatients.Patient_RefID = patient.HEC_PatientID;
Study_ParticipatingPatients.Tenant_RefID = securityTicket.TenantID;
}
Study_ParticipatingPatients.HasFulfilledParticipationPolicyRequirements = Parameter.HasFulfilledParticipationPolicyRequirements;
Study_ParticipatingPatients.Save(Connection, Transaction);
returnValue.Result = patient.HEC_PatientID;
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6PA_SMSP_1548 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
ORM_HEC_Patient patient = new ORM_HEC_Patient();
if (Parameter.HEC_PatientID != Guid.Empty)
{
var result = patient.Load(Connection, Transaction, Parameter.HEC_PatientID);
if (result.Status != FR_Status.Success || patient.HEC_PatientID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
patient.IsPatientParticipationPolicyValidated = Parameter.HasFulfilledParticipationPolicyRequirements;
patient.PatientComment = Parameter.Comment;
patient.Tenant_RefID = securityTicket.TenantID;
ORM_CMN_BPT_BusinessParticipant bParticipant = new ORM_CMN_BPT_BusinessParticipant();
if (patient.CMN_BPT_BusinessParticipant_RefID != Guid.Empty)
{
var result = bParticipant.Load(Connection, Transaction, patient.CMN_BPT_BusinessParticipant_RefID);
if (result.Status != FR_Status.Success || bParticipant.CMN_BPT_BusinessParticipantID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
bParticipant.IsNaturalPerson = true;
bParticipant.Tenant_RefID = securityTicket.TenantID;
ORM_CMN_PER_PersonInfo person = new ORM_CMN_PER_PersonInfo();
if (bParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID != Guid.Empty)
{
var result = person.Load(Connection, Transaction, bParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID);
if (result.Status != FR_Status.Success || person.CMN_PER_PersonInfoID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
person.FirstName = Parameter.FirstName;
person.LastName = Parameter.LastName;
person.PrimaryEmail = Parameter.Mail;
person.Tenant_RefID = securityTicket.TenantID;
person.Salutation_General = Parameter.Salutation;
person.Save(Connection, Transaction);
bParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID = person.CMN_PER_PersonInfoID;
bParticipant.Save(Connection, Transaction);
patient.CMN_BPT_BusinessParticipant_RefID = bParticipant.CMN_BPT_BusinessParticipantID;
patient.Save(Connection, Transaction);
ORM_CMN_PER_CommunicationContact.Query contactQuery = new ORM_CMN_PER_CommunicationContact.Query();
contactQuery.IsDeleted = false;
contactQuery.Tenant_RefID = securityTicket.TenantID;
contactQuery.PersonInfo_RefID = person.CMN_PER_PersonInfoID;
var contactQueryRes = ORM_CMN_PER_CommunicationContact.Query.Search(Connection, Transaction, contactQuery);
ORM_CMN_PER_CommunicationContact contactPhone = contactQueryRes.FirstOrDefault(c => c.Contact_Type == STLD_ContactTypes.Phone);
ORM_CMN_PER_CommunicationContact contactFax = contactQueryRes.FirstOrDefault(c => c.Contact_Type == STLD_ContactTypes.Fax);
if (contactPhone == null)
{
contactPhone = new ORM_CMN_PER_CommunicationContact();
contactPhone.Contact_Type = STLD_ContactTypes.Phone;
contactPhone.Tenant_RefID = securityTicket.TenantID;
contactPhone.PersonInfo_RefID = person.CMN_PER_PersonInfoID;
}
contactPhone.Content = Parameter.Phone;
contactPhone.Save(Connection, Transaction);
if (contactFax == null)
{
contactFax = new ORM_CMN_PER_CommunicationContact();
contactFax.Content = Parameter.Fax;
contactFax.Contact_Type = STLD_ContactTypes.Fax;
contactFax.Tenant_RefID = securityTicket.TenantID;
contactFax.PersonInfo_RefID = person.CMN_PER_PersonInfoID;
contactFax.Save(Connection, Transaction);
}
contactFax.Content = Parameter.Fax;
contactFax.Save(Connection, Transaction);
ORM_HEC_Patient_HealthInsurance.Query Patient_HealthInsuranceQuery = new ORM_HEC_Patient_HealthInsurance.Query();
Patient_HealthInsuranceQuery.Tenant_RefID = securityTicket.TenantID;
Patient_HealthInsuranceQuery.IsDeleted = false;
Patient_HealthInsuranceQuery.Patient_RefID = patient.HEC_PatientID;
ORM_HEC_Patient_HealthInsurance Patient_HealthInsurance;
var Patient_HealthInsuranceQueryRes = ORM_HEC_Patient_HealthInsurance.Query.Search(Connection, Transaction, Patient_HealthInsuranceQuery);
if (Patient_HealthInsuranceQueryRes.Count == 1)
{
Patient_HealthInsurance = Patient_HealthInsuranceQueryRes[0];
}
else
{
Patient_HealthInsurance = new ORM_HEC_Patient_HealthInsurance();
Patient_HealthInsurance.Patient_RefID = patient.HEC_PatientID;
Patient_HealthInsurance.Tenant_RefID = securityTicket.TenantID;
Patient_HealthInsurance.IsPrimary = true;
}
Patient_HealthInsurance.HealthInsurance_Number = Parameter.HealthcareNumber;
Patient_HealthInsurance.Save(Connection, Transaction);
ORM_HEC_STU_Study_ParticipatingPatient.Query Study_ParticipatingPatientsQuery = new ORM_HEC_STU_Study_ParticipatingPatient.Query();
Study_ParticipatingPatientsQuery.Tenant_RefID = securityTicket.TenantID;
Study_ParticipatingPatientsQuery.IsDeleted = false;
Study_ParticipatingPatientsQuery.Patient_RefID = patient.HEC_PatientID;
ORM_HEC_STU_Study_ParticipatingPatient Study_ParticipatingPatients;
var Study_ParticipatingPatientsQueryRes = ORM_HEC_STU_Study_ParticipatingPatient.Query.Search(Connection, Transaction, Study_ParticipatingPatientsQuery);
if (Study_ParticipatingPatientsQueryRes.Count == 1)
{
Study_ParticipatingPatients = Study_ParticipatingPatientsQueryRes[0];
}
else
{
Study_ParticipatingPatients = new ORM_HEC_STU_Study_ParticipatingPatient();
Study_ParticipatingPatients.Patient_RefID = patient.HEC_PatientID;
Study_ParticipatingPatients.Tenant_RefID = securityTicket.TenantID;
}
Study_ParticipatingPatients.HasFulfilledParticipationPolicyRequirements = Parameter.HasFulfilledParticipationPolicyRequirements;
Study_ParticipatingPatients.Save(Connection, Transaction);
ORM_USR_Account account;
ORM_USR_Account.Query ORM_USR_AccountQuery = new ORM_USR_Account.Query();
ORM_USR_AccountQuery.IsDeleted = false;
ORM_USR_AccountQuery.Tenant_RefID = securityTicket.TenantID;
ORM_USR_AccountQuery.BusinessParticipant_RefID = bParticipant.CMN_BPT_BusinessParticipantID;
var accountRes = ORM_USR_Account.Query.Search(Connection, Transaction, ORM_USR_AccountQuery);
if (accountRes.Count == 1)
{
account = accountRes[0];
}
else
{
account = new ORM_USR_Account();
account.Tenant_RefID = securityTicket.TenantID;
account.BusinessParticipant_RefID = bParticipant.CMN_BPT_BusinessParticipantID;
account.AccountType = 3;
account.Save(Connection, Transaction);
}
ORM_USR_Device_AccountCode.Query ORM_USR_Device_AccountCodeQuery = new ORM_USR_Device_AccountCode.Query();
ORM_USR_Device_AccountCodeQuery.IsDeleted = false;
ORM_USR_Device_AccountCodeQuery.Tenant_RefID = securityTicket.TenantID;
ORM_USR_Device_AccountCodeQuery.Account_RefID = account.USR_AccountID;
var accountCodeRes = ORM_USR_Device_AccountCode.Query.Search(Connection, Transaction, ORM_USR_Device_AccountCodeQuery);
if (accountCodeRes.Count == 0)
{
P_L2DC_GUDCfT_1505 codeParam = new P_L2DC_GUDCfT_1505();
codeParam.codeLength = 8;
var checkCodeValue = cls_GetUniqueDeviceCodeForTenant.Invoke(Connection, Transaction, codeParam, securityTicket).Result;
ORM_USR_Device_AccountCode_StatusHistory AccountCode_StatusHistory = new ORM_USR_Device_AccountCode_StatusHistory();
AccountCode_StatusHistory.Tenant_RefID = securityTicket.TenantID;
AccountCode_StatusHistory.IsAccountCode_Active = true;
AccountCode_StatusHistory.Save(Connection, Transaction);
ORM_USR_Device_AccountCode devoceAccpimtCpde = new ORM_USR_Device_AccountCode();
devoceAccpimtCpde.Account_RefID = account.USR_AccountID;
devoceAccpimtCpde.Tenant_RefID = securityTicket.TenantID;
devoceAccpimtCpde.AccountCode_Value = checkCodeValue.CodeValue;
devoceAccpimtCpde.IsAccountCode_Expirable = false;
devoceAccpimtCpde.AccountCode_CurrentStatus_RefID = AccountCode_StatusHistory.USR_Device_AccountCode_StatusHistoryID;
devoceAccpimtCpde.Save(Connection, Transaction);
AccountCode_StatusHistory.Device_AccountCode_RefID = devoceAccpimtCpde.USR_Device_AccountCodeID;
AccountCode_StatusHistory.Save(Connection, Transaction);
}
returnValue.Result = patient.HEC_PatientID;
return(returnValue);
#endregion UserCode
}
protected static FR_L6WS_GSCDfSCID_1458 Execute(DbConnection Connection, DbTransaction Transaction, P_L6WS_GSCDfSCID_1458 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L6WS_GSCDfSCID_1458();
//Put your code here
if (Parameter.ShoppingCartID == Guid.Empty)
{
return(null);
}
returnValue.Result = new L6WS_GSCDfSCID_1458();
#region ShoppingCart
returnValue.Result.ShoppingCart = cls_Get_ShoppingCart_for_ShoppingCartID.Invoke(Connection, Transaction, new P_L6WS_GSCfSCID_1448()
{
ShoppingCartID = Parameter.ShoppingCartID
}, securityTicket).Result;
if (returnValue.Result.ShoppingCart == null)
{
return(null);
}
#endregion
#region ShoppingCart_Notes
returnValue.Result.ShoppingCart_Notes = cls_Get_ShoppingCart_Notes_for_ShoppingCartID.Invoke(Connection, Transaction, new P_L5AWSAR_GSCNfSC_1454()
{
ShoppingCartID = Parameter.ShoppingCartID
}, securityTicket).Result.OrderBy(i => i.UpdatedOn).ToArray();
#endregion
#region Articles
ORM_ORD_PRC_ShoppingCart_Product.Query shoppingCartProductsQuery = new ORM_ORD_PRC_ShoppingCart_Product.Query();
shoppingCartProductsQuery.ORD_PRC_ShoppingCart_RefID = returnValue.Result.ShoppingCart.ORD_PRC_ShoppingCartID;
shoppingCartProductsQuery.IsDeleted = false;
shoppingCartProductsQuery.IsCanceled = false;
shoppingCartProductsQuery.Tenant_RefID = securityTicket.TenantID;
List <ORM_ORD_PRC_ShoppingCart_Product> productList = ORM_ORD_PRC_ShoppingCart_Product.Query.Search(Connection, Transaction, shoppingCartProductsQuery);
List <Guid> articleIds = new List <Guid>();
if (productList != null && productList.Count > 0)
{
articleIds.AddRange(productList.Select(i => i.CMN_PRO_Product_RefID));
}
List <L3AR_GAfAL_0942> articleInfos = new List <L3AR_GAfAL_0942>();
if (articleIds.Count > 0)
{
articleInfos = cls_Get_Articles_for_ArticleList.Invoke(Connection, Transaction,
new P_L3AR_GAfAL_0942()
{
ProductID_List = articleIds.ToArray()
}, securityTicket).Result.ToList();
}
List <L6WS_GSCDfSCID_1458_Product> products = new List <L6WS_GSCDfSCID_1458_Product>();
L6WS_GSCDfSCID_1458_Product product;
L3AR_GAfAL_0942 articleInfo;
double taxRate = 0;
#region ORM and Querie objects
ORM_CMN_PRO_Product orm_product;
ORM_CMN_SLS_Price.Query priceQuery;
ORM_CMN_PRO_Product_SalesTaxAssignmnet.Query taxAssignmentQuery;
ORM_ACC_TAX_Tax orm_tax;
#endregion
foreach (var productItem in productList)
{
#region check procurement order date and number
if (returnValue.Result.OrderDate == null || returnValue.Result.OrderDate.Ticks == 0)
{
ORM_ORD_PRC_ShoppingCart_2_ProcurementOrderPosition.Query shoppingCartOrderPositionQuery = new ORM_ORD_PRC_ShoppingCart_2_ProcurementOrderPosition.Query();
shoppingCartOrderPositionQuery.IsDeleted = false;
shoppingCartOrderPositionQuery.Tenant_RefID = securityTicket.TenantID;
shoppingCartOrderPositionQuery.ORD_PRC_ShoppingCart_Product_RefID = productItem.ORD_PRC_ShoppingCart_ProductID;
List <ORM_ORD_PRC_ShoppingCart_2_ProcurementOrderPosition> shoppingCartOrderPositionList = ORM_ORD_PRC_ShoppingCart_2_ProcurementOrderPosition.Query.Search(Connection, Transaction, shoppingCartOrderPositionQuery);
foreach (var shoppingCartOrderPosition in shoppingCartOrderPositionList)
{
ORM_ORD_PRC_ProcurementOrder_Position procurementOrder_Position = new ORM_ORD_PRC_ProcurementOrder_Position();
var procurementOrder_PositionResult = procurementOrder_Position.Load(Connection, Transaction, shoppingCartOrderPosition.ORD_PRC_ProcurementOrder_Position_RefID);
if (procurementOrder_PositionResult.Status != FR_Status.Success || procurementOrder_Position.ORD_PRC_ProcurementOrder_PositionID == Guid.Empty)
{
continue;
}
ORM_ORD_PRC_ProcurementOrder_Header procurementOrder_Header = new ORM_ORD_PRC_ProcurementOrder_Header();
var procurementOrder_HeaderResult = procurementOrder_Header.Load(Connection, Transaction, procurementOrder_Position.ProcurementOrder_Header_RefID);
if (procurementOrder_HeaderResult.Status != FR_Status.Success || procurementOrder_Header.ORD_PRC_ProcurementOrder_HeaderID == Guid.Empty)
{
continue;
}
returnValue.Result.OrderDate = procurementOrder_Header.ProcurementOrder_Date;
returnValue.Result.OrderNumber = procurementOrder_Header.ProcurementOrder_Number;
break;
}
}
#endregion
#region get product
orm_product = new ORM_CMN_PRO_Product();
var productResult = orm_product.Load(Connection, Transaction, productItem.CMN_PRO_Product_RefID);
if (productResult.Status != FR_Status.Success || orm_product.CMN_PRO_ProductID == Guid.Empty)
{
continue;
}
#endregion
#region get price
ORM_CMN_PRO_SubscribedCatalog.Query catalogQuery = new ORM_CMN_PRO_SubscribedCatalog.Query();
catalogQuery.Tenant_RefID = securityTicket.TenantID;
catalogQuery.IsDeleted = false;
List <ORM_CMN_PRO_SubscribedCatalog> catalogList = ORM_CMN_PRO_SubscribedCatalog.Query.Search(Connection, Transaction, catalogQuery);
priceQuery = new ORM_CMN_SLS_Price.Query();
priceQuery.CMN_PRO_Product_RefID = orm_product.CMN_PRO_ProductID;
priceQuery.Tenant_RefID = securityTicket.TenantID;
priceQuery.IsDeleted = false;
List <ORM_CMN_SLS_Price> prices = ORM_CMN_SLS_Price.Query.Search(Connection, Transaction, priceQuery);
ORM_CMN_SLS_Price price = prices.Where(i => catalogList.Select(j => j.SubscribedCatalog_PricelistRelease_RefID).Contains(i.PricelistRelease_RefID)).FirstOrDefault();
#endregion
#region get taxes
taxRate = 0;
taxAssignmentQuery = new ORM_CMN_PRO_Product_SalesTaxAssignmnet.Query();
taxAssignmentQuery.Product_RefID = orm_product.CMN_PRO_ProductID;
taxAssignmentQuery.Tenant_RefID = securityTicket.TenantID;
taxAssignmentQuery.IsDeleted = false;
List <ORM_CMN_PRO_Product_SalesTaxAssignmnet> taxAssignmentList = ORM_CMN_PRO_Product_SalesTaxAssignmnet.Query.Search(Connection, Transaction, taxAssignmentQuery);
foreach (var taxAssignment in taxAssignmentList)
{
orm_tax = new ORM_ACC_TAX_Tax();
var taxResult = orm_tax.Load(Connection, Transaction, taxAssignment.ApplicableSalesTax_RefID);
if (taxResult.Status == FR_Status.Success && orm_tax.ACC_TAX_TaxeID != Guid.Empty)
{
taxRate += orm_tax.TaxRate;
}
}
#endregion
#region set product item
product = new L6WS_GSCDfSCID_1458_Product();
product.CMN_PRO_Product_RefID = orm_product.CMN_PRO_ProductID;
product.PriceAmount = price == null ? 0 : (price.PriceAmount == null ? 0 : Double.Parse(price.PriceAmount.ToString()));
product.TaxRate = taxRate;
product.Quantity = productItem.Quantity.ToString();
product.IsProductCanceled = productItem.IsCanceled;
if (!String.IsNullOrEmpty(productItem.Comment))
{
string[] comments = productItem.Comment.Split('@');
if (comments.Length == 2)
{
product.ProductComment = comments[1];
}
}
product.IsProductReplacementAllowed = productItem.IsProductReplacementAllowed;
articleInfo = articleInfos.FirstOrDefault(i => i.CMN_PRO_ProductID == orm_product.CMN_PRO_ProductID);
if (articleInfo != null)
{
product.Product_Name = articleInfo.Product_Name;
product.Product_Number = articleInfo.Product_Number;
product.UnitAmount = articleInfo.UnitAmount.ToString();
product.UnitIsoCode = articleInfo.UnitIsoCode;
product.DossageFormName = articleInfo.DossageFormName;
}
#endregion
products.Add(product);
}
returnValue.Result.Products = products.ToArray();
#endregion
#region Person info
// current user
ORM_CMN_PER_PersonInfo_2_Account.Query accountQuery = new ORM_CMN_PER_PersonInfo_2_Account.Query();
accountQuery.USR_Account_RefID = securityTicket.AccountID;
accountQuery.Tenant_RefID = securityTicket.TenantID;
accountQuery.IsDeleted = false;
ORM_CMN_PER_PersonInfo_2_Account account = ORM_CMN_PER_PersonInfo_2_Account.Query.Search(Connection, Transaction, accountQuery).FirstOrDefault();
if (account != null)
{
ORM_CMN_PER_PersonInfo personInfo = new ORM_CMN_PER_PersonInfo();
var personInfoResult = personInfo.Load(Connection, Transaction, account.CMN_PER_PersonInfo_RefID);
if (personInfoResult.Status == FR_Status.Success && personInfo.CMN_PER_PersonInfoID != Guid.Empty)
{
returnValue.Result.CurrentUser = personInfo.FirstName + " " + personInfo.LastName;
}
}
#region Approved by user
ORM_ORD_PRC_ShoppingCart_Status.Query stusesQuery = new ORM_ORD_PRC_ShoppingCart_Status.Query();
stusesQuery.Tenant_RefID = securityTicket.TenantID;
stusesQuery.IsDeleted = false;
List <ORM_ORD_PRC_ShoppingCart_Status> statuses = ORM_ORD_PRC_ShoppingCart_Status.Query.Search(Connection, Transaction, stusesQuery);
ORM_ORD_PRC_ShoppingCart_Status approvedStatus = statuses.FirstOrDefault(i => i.GlobalPropertyMatchingID.Contains("approved"));
if (approvedStatus != null)
{
ORM_ORD_PRC_ShoppingCartStatus_History.Query statusHistoryQuery = new ORM_ORD_PRC_ShoppingCartStatus_History.Query();
statusHistoryQuery.Tenant_RefID = securityTicket.TenantID;
statusHistoryQuery.IsDeleted = false;
statusHistoryQuery.ORD_PRC_ShoppingCart_RefID = returnValue.Result.ShoppingCart.ORD_PRC_ShoppingCartID;
statusHistoryQuery.ORD_PRC_ShoppingCart_Status_RefID = approvedStatus.ORD_PRC_ShoppingCart_StatusID;
ORM_ORD_PRC_ShoppingCartStatus_History statusHistory = ORM_ORD_PRC_ShoppingCartStatus_History.Query.Search(Connection, Transaction, statusHistoryQuery).FirstOrDefault();
if (statusHistory != null)
{
accountQuery = new ORM_CMN_PER_PersonInfo_2_Account.Query();
accountQuery.USR_Account_RefID = statusHistory.PerformedBy_Account_RefID;
accountQuery.Tenant_RefID = securityTicket.TenantID;
accountQuery.IsDeleted = false;
account = ORM_CMN_PER_PersonInfo_2_Account.Query.Search(Connection, Transaction, accountQuery).FirstOrDefault();
if (account != null)
{
ORM_CMN_PER_PersonInfo personInfo = new ORM_CMN_PER_PersonInfo();
var personInfoResult = personInfo.Load(Connection, Transaction, account.CMN_PER_PersonInfo_RefID);
if (personInfoResult.Status == FR_Status.Success && personInfo.CMN_PER_PersonInfoID != Guid.Empty)
{
returnValue.Result.ApprovedByUser = personInfo.FirstName + " " + personInfo.LastName;
returnValue.Result.DateOfApproval = statusHistory.Creation_Timestamp;
}
}
}
}
#endregion
#endregion
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5EM_SFE_1524 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
ORM_CMN_Address address = new ORM_CMN_Address();
if (Parameter.CMN_AddressID != Guid.Empty)
{
var result = address.Load(Connection, Transaction, Parameter.CMN_AddressID);
if (result.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(error);
}
}
address.City_Name = Parameter.City_Name;
address.Street_Name = Parameter.Street_Name;
address.Street_Number = Parameter.Street_Number;
address.Country_Name = Parameter.Country_Name;
address.Province_Name = Parameter.Province_Name;
address.Tenant_RefID = Parameter.TenantID;
address.Save(Connection, Transaction);
ORM_CMN_PER_PersonInfo person = new ORM_CMN_PER_PersonInfo();
if (Parameter.CMN_PER_PersonInfoID != Guid.Empty)
{
var result = person.Load(Connection, Transaction, Parameter.CMN_PER_PersonInfoID);
if (result.Status != FR_Status.Success || person.CMN_PER_PersonInfoID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
//person.AccountImage_URL = Parameter.ProfileImage_Document_RefID;
person.FirstName = Parameter.FirstName;
person.LastName = Parameter.LastName;
person.PrimaryEmail = Parameter.PrimaryEmail;
person.Tenant_RefID = Parameter.TenantID;
person.Title = Parameter.Title;
person.Address_RefID = address.CMN_AddressID;
person.BirthDate = Parameter.BirthDate;
person.Save(Connection, Transaction);
ORM_CMN_BPT_BusinessParticipant bParticipant = new ORM_CMN_BPT_BusinessParticipant();
if (Parameter.CMN_BPT_BusinessParticipantID != Guid.Empty)
{
var result = bParticipant.Load(Connection, Transaction, Parameter.CMN_BPT_BusinessParticipantID);
if (result.Status != FR_Status.Success || bParticipant.CMN_BPT_BusinessParticipantID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
bParticipant.DisplayName = Parameter.DisplayName;
bParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID = person.CMN_PER_PersonInfoID;
bParticipant.IsNaturalPerson = true;
bParticipant.Tenant_RefID = Parameter.TenantID;
bParticipant.Save(Connection, Transaction);
ORM_CMN_BPT_EMP_Employee employee = new ORM_CMN_BPT_EMP_Employee();
CSV2Core.DlTrace.Trace("Parameter.CMN_BPT_EMP_EmployeeID " + Parameter.CMN_BPT_EMP_EmployeeID);
if (Parameter.CMN_BPT_EMP_EmployeeID != Guid.Empty)
{
var result = employee.Load(Connection, Transaction, Parameter.CMN_BPT_EMP_EmployeeID);
if (result.Status != FR_Status.Success || employee.CMN_BPT_EMP_EmployeeID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
employee.BusinessParticipant_RefID = bParticipant.CMN_BPT_BusinessParticipantID;
employee.Staff_Number = Parameter.Staff_Number;
employee.StandardFunction = Parameter.StandardFunction;
employee.Tenant_RefID = Parameter.TenantID;
employee.Save(Connection, Transaction);
CSV2Core.DlTrace.Trace("after save Parameter.CMN_BPT_EMP_EmployeeID " + Parameter.CMN_BPT_EMP_EmployeeID);
CSV2Core.DlTrace.Trace("employee.Status_IsAlreadySaved " + employee.Status_IsAlreadySaved);
ORM_CMN_BPT_EMP_EmploymentRelationship employeeRelationship = new ORM_CMN_BPT_EMP_EmploymentRelationship();
if (Parameter.CMN_BPT_EMP_Employee_WorkingContractID != Guid.Empty)
{
var result = employeeRelationship.Load(Connection, Transaction, Parameter.CMN_BPT_EMP_Employee_WorkingContractID);
if (result.Status != FR_Status.Success || employeeRelationship.CMN_BPT_EMP_EmploymentRelationshipID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
employeeRelationship.Work_StartDate = Parameter.Work_StartDate;
employeeRelationship.Work_EndDate = Parameter.Work_EndDate;
employeeRelationship.Tenant_RefID = Parameter.TenantID;
employeeRelationship.Employee_RefID = employee.CMN_BPT_EMP_EmployeeID;
employeeRelationship.Save(Connection, Transaction);
if (Parameter.USR_AccountID != null && Parameter.USR_AccountID != Guid.Empty)
{
ORM_USR_Account account = new ORM_USR_Account();
account.Load(Connection, Transaction, Parameter.USR_AccountID);
account.USR_AccountID = Parameter.USR_AccountID;
account.Username = Parameter.username;
account.DefaultLanguage_RefID = Parameter.LanguageID;
account.BusinessParticipant_RefID = bParticipant.CMN_BPT_BusinessParticipantID;
account.Tenant_RefID = Parameter.TenantID;
account.Save(Connection, Transaction);
var personToAccountQuery = new ORM_CMN_PER_PersonInfo_2_Account.Query();
personToAccountQuery.Tenant_RefID = securityTicket.TenantID;
personToAccountQuery.USR_Account_RefID = account.USR_AccountID;
personToAccountQuery.IsDeleted = false;
var personToAccounts = ORM_CMN_PER_PersonInfo_2_Account.Query.Search(Connection, Transaction, personToAccountQuery);
if (personToAccounts.Count != 0)
{
ORM_CMN_PER_PersonInfo_2_Account personToAccount = personToAccounts[0];
personToAccount.CMN_PER_PersonInfo_RefID = person.CMN_PER_PersonInfoID;
personToAccount.USR_Account_RefID = account.USR_AccountID;
personToAccount.Tenant_RefID = securityTicket.TenantID;
personToAccount.Save(Connection, Transaction);
}
else
{
ORM_CMN_PER_PersonInfo_2_Account personToAccount = new ORM_CMN_PER_PersonInfo_2_Account();
personToAccount.CMN_PER_PersonInfo_RefID = person.CMN_PER_PersonInfoID;
personToAccount.USR_Account_RefID = account.USR_AccountID;
personToAccount.Tenant_RefID = securityTicket.TenantID;
personToAccount.Save(Connection, Transaction);
}
if (Parameter.Rights != null)
{
foreach (var rightParam in Parameter.Rights)
{
var right = new ORM_USR_Account_FunctionLevelRight();
if (rightParam.RightID != Guid.Empty)
{
var result = right.Load(Connection, Transaction, rightParam.RightID);
if (result.Status != FR_Status.Success || right.USR_Account_FunctionLevelRightID == Guid.Empty)
{
right.USR_Account_FunctionLevelRightID = rightParam.RightID;
right.Tenant_RefID = Parameter.TenantID;
right.RightName = rightParam.RightName;
right.FunctionLevelRights_Group_RefID = Guid.Empty;
right.Save(Connection, Transaction);
}
}
var right2account = new ORM_USR_Account_2_FunctionLevelRight();
right2account.Account_RefID = account.USR_AccountID;
right2account.FunctionLevelRight_RefID = rightParam.RightID;
right2account.Tenant_RefID = Parameter.TenantID;
right2account.Save(Connection, Transaction);
}
}
}
returnValue.Result = employee.CMN_BPT_EMP_EmployeeID;
return(returnValue);
#endregion UserCode
}
protected static FR_L6LR_GLR_ID_1339 Execute(DbConnection Connection, DbTransaction Transaction, P_L6LR_GLR_ID_1339 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L6LR_GLR_ID_1339();
returnValue.Result = new L6LR_GLR_ID_1339();
//Covers
ORM_CMN_BPT_EMP_Employee_LeaveRequest.Query leaveRequestQuery = new ORM_CMN_BPT_EMP_Employee_LeaveRequest.Query();
leaveRequestQuery.CMN_BPT_EMP_Employee_LeaveRequestID = Parameter.LeaveID;
leaveRequestQuery.Tenant_RefID = securityTicket.TenantID;
leaveRequestQuery.IsDeleted = false;
ORM_CMN_BPT_EMP_Employee_LeaveRequest leaveRequest = ORM_CMN_BPT_EMP_Employee_LeaveRequest.Query.Search(Connection, Transaction, leaveRequestQuery).FirstOrDefault();
ORM_CMN_BPT_EMP_Employee employee = new ORM_CMN_BPT_EMP_Employee();
employee.Load(Connection, Transaction, leaveRequest.RequestedFor_Employee_RefID);
L5LR_GLRFSP_1532 result = new L5LR_GLRFSP_1532();
result.ForEmployeeID = employee.CMN_BPT_EMP_EmployeeID;
result.ForEmployee_BusinessParticipant_RefID = employee.BusinessParticipant_RefID;
result.ForEmployee_Staff_Number = employee.Staff_Number;
result.ForEmployee_StandardFunction = employee.StandardFunction;
result.LeaveRequestCreationSource = leaveRequest.LeaveRequestCreationSource;
ORM_CMN_BPT_BusinessParticipant bpart = new ORM_CMN_BPT_BusinessParticipant();
bpart.Load(Connection, Transaction, employee.BusinessParticipant_RefID);
ORM_CMN_PER_PersonInfo per = new ORM_CMN_PER_PersonInfo();
per.Load(Connection, Transaction, bpart.IfNaturalPerson_CMN_PER_PersonInfo_RefID);
result.FirstName = per.FirstName;
result.LastName = per.LastName;
result.CMN_CAL_Event_RefID = leaveRequest.CMN_CAL_Event_RefID;
result.CMN_CAL_Event_Approval_RefID = leaveRequest.CMN_CAL_Event_Approval_RefID;
//result.AbsenceReason_Type_RefID = leaveRequest.CMN_BPT_STA_AbsenceReason_RefID;
result.Comment = leaveRequest.Comment;
result.RequestedBy_Employee_RefID = leaveRequest.RequestedBy_Employee_RefID;
result.CMN_BPT_EMP_Employee_LeaveRequestID = leaveRequest.CMN_BPT_EMP_Employee_LeaveRequestID;
ORM_CMN_BPT_EMP_Employee_LeaveRequest_EmployeeCover.Query covers = new ORM_CMN_BPT_EMP_Employee_LeaveRequest_EmployeeCover.Query();
covers.CMN_BPT_EMP_Employee_LeaveRequests = leaveRequest.CMN_BPT_EMP_Employee_LeaveRequestID;
covers.Tenant_RefID = securityTicket.TenantID;
covers.IsDeleted = false;
List <ORM_CMN_BPT_EMP_Employee_LeaveRequest_EmployeeCover> employeeCovers = ORM_CMN_BPT_EMP_Employee_LeaveRequest_EmployeeCover.Query.Search(Connection, Transaction, covers);
result.Cover = new L5LR_GLRFSP_1532_Cover();
if (employeeCovers.Count != 0)
{
ORM_CMN_BPT_EMP_Employee_LeaveRequest_EmployeeCover employeeCover = employeeCovers[0];
result.Cover.CMN_BPT_EMP_EmployeeID = employeeCover.EmployeeCover_RefID;
result.Cover.CMN_BPT_EMP_Employee_LeaveRequest_EmployeeCoverID = employeeCover.CMN_BPT_EMP_Employee_LeaveRequest_EmployeeCoverID;
result.Cover.SequenceNumber = employeeCover.SequenceNumber;
}
ORM_CMN_BPT_STA_AbsenceReason absenceReason = new ORM_CMN_BPT_STA_AbsenceReason();
absenceReason.Load(Connection, Transaction, leaveRequest.CMN_BPT_STA_AbsenceReason_RefID);
result.CMN_BPT_STA_AbsenceReason_RefID = absenceReason.CMN_BPT_STA_AbsenceReasonID;
result.ShortName = absenceReason.ShortName;
result.ReasonName = absenceReason.Name;
result.ReasonDesc = absenceReason.Description;
result.AbsenceReason_Type_RefID = absenceReason.AbsenceReason_Type_RefID;
result.ColorCode = absenceReason.ColorCode;
result.Parent_RefID = absenceReason.Parent_RefID;
result.IsAuthorizationRequired = absenceReason.IsAuthorizationRequired;
result.IsIncludedInCapacityCalculation = absenceReason.IsIncludedInCapacityCalculation;
result.IsAllowedAbsence = absenceReason.IsAllowedAbsence;
result.IsDeactivated = absenceReason.IsDeactivated;
result.IsCarryOverEnabled = absenceReason.IsCarryOverEnabled;
result.IsCaryOverLimited = absenceReason.IsCaryOverLimited;
result.IfCarryOverLimited_MaximumAmount_Hrs = absenceReason.IfCarryOverLimited_MaximumAmount_Hrs;
ORM_CMN_CAL_Event Event = new ORM_CMN_CAL_Event();
Event.Load(Connection, Transaction, leaveRequest.CMN_CAL_Event_RefID);
result.CalendarInstance_RefID = Event.CalendarInstance_RefID;
result.StartTime = Event.StartTime;
result.EndTime = Event.EndTime;
result.R_EventDuration_sec = Event.R_EventDuration_sec;
ORM_CMN_CAL_Event_Approval eventApproval = new ORM_CMN_CAL_Event_Approval();
eventApproval.Load(Connection, Transaction, leaveRequest.CMN_CAL_Event_Approval_RefID);
result.Action = new L5LR_GLRFSP_1532_Action();
result.IsApproved = eventApproval.IsApproved;
result.IsApprovalProcessOpened = eventApproval.IsApprovalProcessOpened;
result.IsApprovalProcessDenied = eventApproval.IsApprovalProcessDenied;
ORM_CMN_CAL_Event_Approval_Action.Query approvalQuery = new ORM_CMN_CAL_Event_Approval_Action.Query();
approvalQuery.EventApproval_RefID = eventApproval.CMN_CAL_Event_ApprovalID;
approvalQuery.Tenant_RefID = securityTicket.TenantID;
approvalQuery.IsDeleted = false;
List <ORM_CMN_CAL_Event_Approval_Action> apporvalActions = ORM_CMN_CAL_Event_Approval_Action.Query.Search(Connection, Transaction, approvalQuery);
if (apporvalActions.Count != 0)
{
ORM_CMN_CAL_Event_Approval_Action approvalAction = apporvalActions[0];
result.Action.ActionTriggeredBy_Account_RefID = approvalAction.ActionTriggeredBy_Account_RefID;
result.Action.CMN_CAL_Event_Approval_ActionID = approvalAction.CMN_CAL_Event_Approval_ActionID;
result.Action.IsApproval = approvalAction.IsApproval;
result.Action.IsRevocation = approvalAction.IsRevocation;
result.Action.IsDenial = approvalAction.IsDenial;
result.Action.Approval_Action_Commnet = approvalAction.Comment;
}
returnValue.Result.Leave = result;
//Put your code here
return(returnValue);
#endregion UserCode
}