protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3PM_SPMCL_1400 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode //Put your code here CL1_TMS_PRO.ORM_TMS_PRO_ProjectMember item = new CL1_TMS_PRO.ORM_TMS_PRO_ProjectMember(); if (Parameter.ProjectMemberID != Guid.Empty) { item = ORM_TMS_PRO_ProjectMember.Query.Search(Connection, Transaction, new ORM_TMS_PRO_ProjectMember.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, TMS_PRO_ProjectMemberID = Parameter.ProjectMemberID }).SingleOrDefault(); } item.ChargingLevel_RefID = Parameter.ProjectMemberChargingLevel; return(new FR_Guid(item.Save(Connection, Transaction), item.TMS_PRO_ProjectMemberID)); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3PM_CPMT_1704 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 var item = new CL1_TMS_PRO.ORM_TMS_PRO_ProjectMember(); if (Parameter.ProjectMemberID != Guid.Empty) { item = ORM_TMS_PRO_ProjectMember.Query.Search(Connection, Transaction, new ORM_TMS_PRO_ProjectMember.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, TMS_PRO_ProjectMemberID = Parameter.ProjectMemberID }).Single(); } item.ProjectMember_Type_RefID = Parameter.ProjectMemberTypeID; return(new FR_Guid(item.Save(Connection, Transaction), item.TMS_PRO_ProjectMemberID)); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L2PR_SPMfPID_1341 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); //Put your code here foreach (var userID in Parameter.User_IDsToRemoveFromProject) { //ORM_TMS_PRO_ProjectMember projectMember = new ORM_TMS_PRO_ProjectMember(); var projectMembers = ORM_TMS_PRO_ProjectMember.Query.Search(Connection, Transaction, new ORM_TMS_PRO_ProjectMember.Query() { USR_Account_RefID = userID, Project_RefID = Parameter.ProjectID, Tenant_RefID = securityTicket.TenantID, IsDeleted = false }); foreach (var projectMember in projectMembers) { projectMember.IsDeleted = true; projectMember.Save(Connection, Transaction); } } foreach (var userID in Parameter.User_IDsToAddToProject) { ORM_TMS_PRO_ProjectMember projectMember = new ORM_TMS_PRO_ProjectMember(); projectMember = new CL1_TMS_PRO.ORM_TMS_PRO_ProjectMember(); projectMember.TMS_PRO_ProjectMemberID = Guid.NewGuid(); projectMember.USR_Account_RefID = userID; projectMember.Project_RefID = Parameter.ProjectID; projectMember.IsDeleted = false; projectMember.Tenant_RefID = securityTicket.TenantID; projectMember.Save(Connection, Transaction); } return(returnValue); #endregion UserCode }
protected static FR_L6PR_SPM_1040 Execute(DbConnection Connection, DbTransaction Transaction, P_L6PR_SPM_1040 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L6PR_SPM_1040(); //Put your code here var item = new CL1_TMS_PRO.ORM_TMS_PRO_ProjectMember(); L6PR_SPM_1040 addedRemovedProjectMemberInfo = new L6PR_SPM_1040(); List <ORM_TMS_PRO_ProjectMember> removedProjectMembers = new List <ORM_TMS_PRO_ProjectMember>(); List <ORM_TMS_PRO_ProjectMember> newProjectMembers = new List <ORM_TMS_PRO_ProjectMember>(); if (Parameter.Project_IDs_to_Remove_Project_Members.ToList().Count() != 0) { foreach (var project in Parameter.Project_IDs_to_Remove_Project_Members.ToList()) { if (project != Guid.Empty) { item = ORM_TMS_PRO_ProjectMember.Query.Search(Connection, Transaction, new ORM_TMS_PRO_ProjectMember.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, Project_RefID = project, USR_Account_RefID = Parameter.User_ID }).Single(); item.IsDeleted = true; item.Save(Connection, Transaction); removedProjectMembers.Add(item); } } } if (Parameter.Project_IDs_to_Add_Project_Members.ToList().Count() != 0) { foreach (var project in Parameter.Project_IDs_to_Add_Project_Members.ToList()) { if (project != Guid.Empty) { item = new CL1_TMS_PRO.ORM_TMS_PRO_ProjectMember(); item = ORM_TMS_PRO_ProjectMember.Query.Search(Connection, Transaction, new ORM_TMS_PRO_ProjectMember.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, Project_RefID = project, USR_Account_RefID = Parameter.User_ID }).SingleOrDefault(); if (item == null) { item = new CL1_TMS_PRO.ORM_TMS_PRO_ProjectMember(); item.TMS_PRO_ProjectMemberID = Guid.NewGuid(); item.USR_Account_RefID = Parameter.User_ID; item.Project_RefID = project; item.IsDeleted = false; item.Tenant_RefID = securityTicket.TenantID; item.Save(Connection, Transaction); newProjectMembers.Add(item); } } } } addedRemovedProjectMemberInfo.RemovedProjectMembers = removedProjectMembers.ToArray(); addedRemovedProjectMemberInfo.AddedProjectMembers = newProjectMembers.ToArray(); returnValue.Result = addedRemovedProjectMemberInfo; return(returnValue); #endregion UserCode }