protected static FR_L3FE_GFDfFID_1338 Execute(DbConnection Connection, DbTransaction Transaction, P_L3FE_GFDfFID_1338 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L3FE_GFDfFID_1338(); returnValue.Result = new L3FE_GFDfFID_1338(); ORM_TMS_PRO_Feature.Query searchQuery = new ORM_TMS_PRO_Feature.Query(); searchQuery.IsArchived = false; searchQuery.IsDeleted = false; searchQuery.TMS_PRO_FeatureID = Parameter.FeatureID; ORM_TMS_PRO_Feature SelectedFeature = ORM_TMS_PRO_Feature.Query.Search(Connection, Transaction, searchQuery).FirstOrDefault(); if (SelectedFeature != null) { returnValue.Result.TMS_PRO_FeatureID = SelectedFeature.TMS_PRO_FeatureID; returnValue.Result.IdentificationNumber = SelectedFeature.IdentificationNumber; returnValue.Result.Name = SelectedFeature.Name; returnValue.Result.Description = SelectedFeature.Description; returnValue.Result.Deadline = SelectedFeature.Feature_Deadline; returnValue.Result.Project_RefID = SelectedFeature.Project_RefID; returnValue.Result.Tags = GetTagsForFeature(Connection, Transaction, securityTicket, SelectedFeature.TMS_PRO_FeatureID); returnValue.Result.Feature_DeveloperTasks = GetDeveloperTasksForFeature(Connection, Transaction, securityTicket, SelectedFeature.TMS_PRO_FeatureID); } //Put your code here return(returnValue); #endregion UserCode }
protected static FR_Base Execute(DbConnection Connection,DbTransaction Transaction,P_L2FE_AFfFID_1136 Parameter,CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null){ #region UserCode var returnValue = new FR_Base(); //Put your code here if (Parameter.FeatureID.ToList().Count != 0 && Parameter.FeatureID != null) { foreach (var FeatureID in Parameter.FeatureID) { ORM_TMS_PRO_Feature.Query searchQuery = new ORM_TMS_PRO_Feature.Query(); searchQuery.TMS_PRO_FeatureID = Guid.Parse(FeatureID); ORM_TMS_PRO_Feature.Query updateQuery = new ORM_TMS_PRO_Feature.Query(); updateQuery.IsArchived = true; ORM_TMS_PRO_Feature.Query.Update(Connection, Transaction, searchQuery, updateQuery); } returnValue.Status = FR_Status.Success; return returnValue; } else { returnValue.Status = FR_Status.Error_Internal; return returnValue; } #endregion UserCode }
protected static FR_L6US_GMMDMDfAU_1401 Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_L6US_GMMDMDfAU_1401(); //Put your code here returnValue.Result = new L6US_GMMDMDfAU_1401(); ORM_TMS_PRO_Project.Query projectQuery = new ORM_TMS_PRO_Project.Query(); projectQuery.IsArchived = false; projectQuery.IsDeleted = false; int ProjectsCount = ORM_TMS_PRO_Project.Query.Search(Connection, Transaction, projectQuery).Count; if (ProjectsCount != null) { returnValue.Result.Projects_Count = ProjectsCount; } // NO DATABASE TABLE returnValue.Result.Boards_Count = 11; ORM_TMS_PRO_Feature.Query featureQuery = new ORM_TMS_PRO_Feature.Query(); featureQuery.IsArchived = false; featureQuery.IsDeleted = false; int FeaturesCount = ORM_TMS_PRO_Feature.Query.Search(Connection, Transaction, featureQuery).Count; if (FeaturesCount != null) { returnValue.Result.Features_Count = FeaturesCount; } ORM_TMS_PRO_Feature_2_DeveloperTask.Query developer_tasks_Query = new ORM_TMS_PRO_Feature_2_DeveloperTask.Query(); developer_tasks_Query.IsDeleted = false; int DeveloperTasksCount = ORM_TMS_PRO_Feature_2_DeveloperTask.Query.Search(Connection, Transaction, developer_tasks_Query).Count; if (DeveloperTasksCount != null) { returnValue.Result.DeveloperTasks_Count = DeveloperTasksCount; } returnValue.Result.TimeReportedToday = 606; return(returnValue); #endregion UserCode }
protected static FR_L3FE_GNFI_1213 Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_L3FE_GNFI_1213(); returnValue.Result = new L3FE_GNFI_1213(); ORM_TMS_PRO_Feature.Query query = new ORM_TMS_PRO_Feature.Query(); query.Tenant_RefID = securityTicket.TenantID; var count = ORM_TMS_PRO_Feature.Query.Search(Connection, Transaction, query).Count() + 1; String identifier = "000000" + count.ToString(); identifier = identifier.Substring(identifier.Length - 6); returnValue.Result.Identifier = identifier; return(returnValue); #endregion UserCode }
protected static FR_Base Execute(DbConnection Connection, DbTransaction Transaction, P_L2FE_SF_1202 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_Base(); //Put your code here var item = new ORM_TMS_PRO_Feature(); if (Parameter.FeatureID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.FeatureID); if (result.Status != FR_Status.Success || item.TMS_PRO_FeatureID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } #region Single Delete if (Parameter.IsDeleted == true && Parameter.ActionType.Equals("DeleteSingle")) { ORM_TMS_PRO_Feature.Query searchQuery = new ORM_TMS_PRO_Feature.Query(); searchQuery.TMS_PRO_FeatureID = Parameter.FeatureID; ORM_TMS_PRO_Feature.Query.SoftDelete(Connection, Transaction, searchQuery); item.IsDeleted = true; item.Save(Connection, Transaction); DeleteTags(Connection, Transaction, Parameter.FeatureID, securityTicket); FR_Base retVal = new FR_Base(); retVal.Status = FR_Status.Success; return(retVal); } #endregion #region Multiple Delete if (Parameter.IsDeleted == true && Parameter.ActionType.Equals("DeleteMultiple")) { foreach (var featureID in Parameter.FeaturesToDelete) { ORM_TMS_PRO_Feature.Query searchQuery = new ORM_TMS_PRO_Feature.Query(); searchQuery.TMS_PRO_FeatureID = Guid.Parse(featureID); ORM_TMS_PRO_Feature.Query.SoftDelete(Connection, Transaction, searchQuery); DeleteTags(Connection, Transaction, Guid.Parse(featureID), securityTicket); } FR_Base retVal = new FR_Base(); retVal.Status = FR_Status.Success; return(retVal); } #endregion #region Add New Feature if (Parameter.IsDeleted == false && Parameter.ActionType.Equals("NewFeature")) { FR_Base retVal = new FR_Base(); ORM_TMS_PRO_Feature NewFeature = new ORM_TMS_PRO_Feature(); NewFeature.TMS_PRO_FeatureID = Guid.NewGuid(); NewFeature.IdentificationNumber = cls_Get_NewFeatureIdentifier.Invoke(Connection, Transaction, securityTicket).Result.Identifier; NewFeature.Name = Parameter.Name; NewFeature.Description = Parameter.Description; NewFeature.IsDeleted = false; NewFeature.IsArchived = false; NewFeature.Feature_Deadline = Parameter.Feature_Deadline; NewFeature.Type_RefID = Guid.Empty; NewFeature.Status_RefID = Guid.Empty; NewFeature.Component_RefID = Guid.Empty; NewFeature.DOC_Structure_Header_RefID = Guid.Empty; NewFeature.Parent_RefID = Parameter.Parent_RefID; NewFeature.Project_RefID = Parameter.Project_RefID; NewFeature.Tenant_RefID = securityTicket.TenantID; NewFeature.CreatedByAccount_RefID = securityTicket.AccountID; if (SaveTagsForFeature(Connection, Transaction, NewFeature.TMS_PRO_FeatureID, Parameter.Tags, securityTicket).Status == FR_Status.Error_Internal) { retVal.Status = FR_Status.Error_Internal; return(retVal); } NewFeature.Save(Connection, Transaction); retVal.Status = FR_Status.Success; return(retVal); } #endregion #region Edit Feature if (Parameter.IsDeleted == false && Parameter.ActionType.Equals("EditFeature")) { ORM_TMS_PRO_Feature.Query featureSearchQuery = new ORM_TMS_PRO_Feature.Query(); featureSearchQuery.TMS_PRO_FeatureID = Parameter.FeatureID; ORM_TMS_PRO_Feature FeatureItem = ORM_TMS_PRO_Feature.Query.Search(Connection, Transaction, featureSearchQuery).FirstOrDefault(); FeatureItem.Name = Parameter.Name; FeatureItem.Description = Parameter.Description; FeatureItem.Project_RefID = Parameter.Project_RefID; FeatureItem.Parent_RefID = Parameter.Parent_RefID; FeatureItem.Feature_Deadline = Parameter.Feature_Deadline; SaveTagsFor_EditedFeature(Connection, Transaction, Parameter.FeatureID, Parameter.Tags, securityTicket); FeatureItem.Save(Connection, Transaction); FR_Base retVal = new FR_Base(); retVal.Status = FR_Status.Success; return(retVal); } #endregion return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3DT_SDT_0949 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 Boolean multipleEdit; String oldName = ""; String oldDescription = ""; Guid oldPriority_RefID = Guid.Empty; Guid oldDeveloperTask_Type_RefID = Guid.Empty; double oldEstimatedReqTime = -1; DateTime oldCompletion_Deadline = new DateTime(); Boolean oldIsBeingPrepared = false; Guid Project_RefID = Guid.Empty; if (Parameter.Parent_RefID != Guid.Empty) { ORM_TMS_PRO_Feature.Query query = new ORM_TMS_PRO_Feature.Query(); query.TMS_PRO_FeatureID = Parameter.Parent_RefID; var items = ORM_TMS_PRO_Feature.Query.Search(Connection, Transaction, query); Project_RefID = items.FirstOrDefault().Project_RefID; } foreach (var TMS_PRO_DeveloperTaskID in Parameter.TMS_PRO_DeveloperTaskIDList) { var item = new CL1_TMS_PRO.ORM_TMS_PRO_DeveloperTask(); var result = item.Load(Connection, Transaction, TMS_PRO_DeveloperTaskID); P_L3DT_GPfDT_1659 parameterPeers = new P_L3DT_GPfDT_1659(); parameterPeers.DTaskID = item.TMS_PRO_DeveloperTaskID; List <L3DT_GPfDT_1659> dtaskPeers = cls_Get_Peers_for_DTaskID.Invoke(Connection, Transaction, parameterPeers, securityTicket).Result.ToList(); if (Parameter.IsDeleted == true) { #region Delete ORM_CMN_BPT_InvestedWorkTime var involment_query = new ORM_TMS_PRO_DeveloperTask_Involvement.Query(); involment_query.DeveloperTask_RefID = item.TMS_PRO_DeveloperTaskID; involment_query.IsDeleted = false; var involments = ORM_TMS_PRO_DeveloperTask_Involvement.Query.Search(Connection, Transaction, involment_query); foreach (var involment in involments) { var dtinv_query = new ORM_TMS_PRO_DeveloperTask_Involvements_InvestedWorkTime.Query(); dtinv_query.TMS_PRO_DeveloperTask_Involvement_RefID = involment.TMS_PRO_DeveloperTask_InvolvementID; dtinv_query.IsDeleted = false; var dtinv = ORM_TMS_PRO_DeveloperTask_Involvements_InvestedWorkTime.Query.Search(Connection, Transaction, dtinv_query); foreach (var dt in dtinv) { dt.IsDeleted = true; dt.Save(Connection, Transaction); var inv_query = new ORM_CMN_BPT_InvestedWorkTime.Query(); inv_query.CMN_BPT_InvestedWorkTimeID = dt.CMN_BPT_InvestedWorkTime_RefID; inv_query.IsDeleted = false; ORM_CMN_BPT_InvestedWorkTime.Query.SoftDelete(Connection, Transaction, inv_query); } } #endregion #region DeleteAssignments ORM_TMS_PRO_Peers_Development.Query instance1 = new ORM_TMS_PRO_Peers_Development.Query(); instance1.DeveloperTask_RefID = TMS_PRO_DeveloperTaskID; ORM_TMS_PRO_Peers_Development.Query.SoftDelete(Connection, Transaction, instance1); ORM_TMS_PRO_Feature_2_DeveloperTask.Query instance2 = new ORM_TMS_PRO_Feature_2_DeveloperTask.Query(); instance2.DeveloperTask_RefID = TMS_PRO_DeveloperTaskID; ORM_TMS_PRO_Feature_2_DeveloperTask.Query.SoftDelete(Connection, Transaction, instance2); ORM_TMS_PRO_DeveloperTask_Involvement.Query instance3 = new ORM_TMS_PRO_DeveloperTask_Involvement.Query(); instance3.DeveloperTask_RefID = TMS_PRO_DeveloperTaskID; ORM_TMS_PRO_DeveloperTask_Involvement.Query.SoftDelete(Connection, Transaction, instance3); ORM_TMS_PRO_DeveloperTask_StatusHistory.Query instance4 = new ORM_TMS_PRO_DeveloperTask_StatusHistory.Query(); instance4.DeveloperTask_RefID = TMS_PRO_DeveloperTaskID; ORM_TMS_PRO_DeveloperTask_StatusHistory.Query.SoftDelete(Connection, Transaction, instance4); ORM_TMS_PRO_DeveloperTask_Recommendation.Query instance5 = new ORM_TMS_PRO_DeveloperTask_Recommendation.Query(); instance5.DeveloperTask_RefID = TMS_PRO_DeveloperTaskID; ORM_TMS_PRO_DeveloperTask_Recommendation.Query.SoftDelete(Connection, Transaction, instance5); ORM_CMN_PRO_Product_Release_2_DeveloperTask.Query instance6 = new ORM_CMN_PRO_Product_Release_2_DeveloperTask.Query(); instance6.TMS_PRO_DeveloperTask_RefID = TMS_PRO_DeveloperTaskID; ORM_CMN_PRO_Product_Release_2_DeveloperTask.Query.SoftDelete(Connection, Transaction, instance6); ORM_TMS_QuickTask.Query instance7 = new ORM_TMS_QuickTask.Query(); instance7.AssignedTo_DeveloperTask_RefID = TMS_PRO_DeveloperTaskID; var quicktasks = ORM_TMS_QuickTask.Query.Search(Connection, Transaction, instance7); foreach (var quicktask in quicktasks) { var param = new P_L3QT_SQT_0905(); param.TMS_QuickTaskID = quicktask.TMS_QuickTaskID; param.IsDeleted = true; cls_Save_TMS_QuickTask.Invoke(Connection, Transaction, param, securityTicket); } #endregion #region projectInfo var project = new ORM_TMS_PRO_Project(); project.Load(Connection, Transaction, item.Project_RefID); ORM_TMS_PRO_Project_Status ProjectStatus = new ORM_TMS_PRO_Project_Status(); ProjectStatus.Load(Connection, Transaction, project.Status_RefID); Guid language = Parameter.LanguageID; String statusLabel = ProjectStatus.Label.GetContent(language); String projectName = project.Name.GetContent(language); #endregion item.IsDeleted = true; item.Save(Connection, Transaction); } if (Parameter.IsArchived == true) { item.IsArchived = true; item.Save(Connection, Transaction); continue; } #region ORM_TMS_PRO_Feature_2_DeveloperTask if (Parameter.Parent_RefID != Guid.Empty) { ORM_TMS_PRO_Feature_2_DeveloperTask.Query assignquery = new ORM_TMS_PRO_Feature_2_DeveloperTask.Query(); assignquery.DeveloperTask_RefID = item.TMS_PRO_DeveloperTaskID; List <ORM_TMS_PRO_Feature_2_DeveloperTask> assignments = ORM_TMS_PRO_Feature_2_DeveloperTask.Query.Search(Connection, Transaction, assignquery); foreach (var assignment in assignments) { assignment.Feature_RefID = Parameter.Parent_RefID; assignment.Save(Connection, Transaction); } } #endregion if (Project_RefID != Guid.Empty) { item.Project_RefID = Project_RefID; } if (Parameter.TMS_PRO_DeveloperTaskIDList.Length == 1) { multipleEdit = false; oldName = item.Name; oldDescription = item.Description; item.Name = Parameter.TaskName; item.Description = Parameter.Description; item.Priority_RefID = Parameter.Priority_RefID; item.DeveloperTask_Type_RefID = Parameter.DeveloperTask_Type_RefID; item.DeveloperTime_RequiredEstimation_min = Parameter.DeveloperTime_RequiredEstimation_min; item.Completion_Deadline = Parameter.Completion_Deadline; item.IsBeingPrepared = Parameter.IsBeingPrepared; item.IsTaskEstimable = Parameter.IsTaskEstimable; #region ORM_CMN_PRO_Product_Release_2_DeveloperTask if (Parameter.ReleaseID != Guid.Empty) { var revisionAssignment = new ORM_CMN_PRO_Product_Release_2_DeveloperTask(); revisionAssignment.AssignmentID = Guid.NewGuid(); revisionAssignment.CMN_PRO_Product_Release_RefID = Parameter.ReleaseID; revisionAssignment.TMS_PRO_DeveloperTask_RefID = item.TMS_PRO_DeveloperTaskID; revisionAssignment.Creation_Timestamp = DateTime.Now; revisionAssignment.Tenant_RefID = securityTicket.TenantID; revisionAssignment.Save(Connection, Transaction); } else { var query = new ORM_CMN_PRO_Product_Release_2_DeveloperTask.Query(); query.TMS_PRO_DeveloperTask_RefID = item.TMS_PRO_DeveloperTaskID; ORM_CMN_PRO_Product_Release_2_DeveloperTask.Query.SoftDelete(Connection, Transaction, query); } #endregion } else { multipleEdit = true; if (Parameter.Priority_RefID != Guid.Empty) { item.Priority_RefID = Parameter.Priority_RefID; } if (Parameter.DeveloperTask_Type_RefID != Guid.Empty) { item.DeveloperTask_Type_RefID = Parameter.DeveloperTask_Type_RefID; } if (Parameter.DeveloperTime_RequiredEstimation_min != 0) { item.DeveloperTime_RequiredEstimation_min = Parameter.DeveloperTime_RequiredEstimation_min; } if (Parameter.Completion_Deadline != new DateTime()) { item.Completion_Deadline = Parameter.Completion_Deadline; } if (Parameter.IsBeingPreparedIgnore == false) { item.IsBeingPrepared = Parameter.IsBeingPrepared; } if (Parameter.ReleaseIDIgnore == false) { #region ORM_CMN_PRO_Product_Release_2_DeveloperTask if (Parameter.ReleaseID != Guid.Empty) { var revisionAssignment = new ORM_CMN_PRO_Product_Release_2_DeveloperTask(); revisionAssignment.AssignmentID = Guid.NewGuid(); revisionAssignment.CMN_PRO_Product_Release_RefID = Parameter.ReleaseID; revisionAssignment.TMS_PRO_DeveloperTask_RefID = item.TMS_PRO_DeveloperTaskID; revisionAssignment.Creation_Timestamp = DateTime.Now; revisionAssignment.Tenant_RefID = securityTicket.TenantID; revisionAssignment.Save(Connection, Transaction); } else { var query = new ORM_CMN_PRO_Product_Release_2_DeveloperTask.Query(); query.TMS_PRO_DeveloperTask_RefID = item.TMS_PRO_DeveloperTaskID; ORM_CMN_PRO_Product_Release_2_DeveloperTask.Query.SoftDelete(Connection, Transaction, query); } #endregion } } item.Save(Connection, Transaction); } return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3SPFT_SPN_1100 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); var item = new ORM_TMS_PRO_Project(); if (Parameter.TMS_PRO_ProjectID != Guid.Empty) { item.Load(Connection, Transaction, Parameter.TMS_PRO_ProjectID); } if (Parameter.IsDeleted == true) { ORM_TMS_PRO_Project.Query query = new ORM_TMS_PRO_Project.Query(); query.TMS_PRO_ProjectID = item.TMS_PRO_ProjectID; item.IsDeleted = true; ORM_TMS_PRO_Project.Query.SoftDelete(Connection, Transaction, query); #region Delete ORM_TMS_PRO_BusinessTask ORM_TMS_PRO_BusinessTask.Query ORM_TMS_PRO_BusinessTaskquery = new ORM_TMS_PRO_BusinessTask.Query(); ORM_TMS_PRO_BusinessTaskquery.Project_RefID = Parameter.TMS_PRO_ProjectID; ORM_TMS_PRO_BusinessTaskquery.IsArchived = false; ORM_TMS_PRO_BusinessTaskquery.IsDeleted = false; ORM_TMS_PRO_BusinessTask.Query.SoftDelete(Connection, Transaction, ORM_TMS_PRO_BusinessTaskquery); #endregion #region Delete ORM_TMS_PRO_BusinessTaskPackage ORM_TMS_PRO_BusinessTaskPackage.Query ORM_TMS_PRO_BusinessTaskPackagequery = new ORM_TMS_PRO_BusinessTaskPackage.Query(); ORM_TMS_PRO_BusinessTaskPackagequery.Project_RefID = Parameter.TMS_PRO_ProjectID; ORM_TMS_PRO_BusinessTaskPackagequery.IsDeleted = false; ORM_TMS_PRO_BusinessTaskPackage.Query.SoftDelete(Connection, Transaction, ORM_TMS_PRO_BusinessTaskPackagequery); #endregion #region Delete ORM_TMS_PRO_ProjectMember var ORM_TMS_PRO_ProjectMemberquery = new ORM_TMS_PRO_ProjectMember.Query(); ORM_TMS_PRO_ProjectMemberquery.IsDeleted = true; ORM_TMS_PRO_ProjectMemberquery.Project_RefID = Parameter.TMS_PRO_ProjectID; ORM_TMS_PRO_ProjectMember.Query.SoftDelete(Connection, Transaction, ORM_TMS_PRO_ProjectMemberquery); #endregion #region Delete ORM_TMS_PRO_BussinessTask_2_Feature var ORM_TMS_PRO_BussinessTask_2_Featurequery = new ORM_TMS_PRO_BusinessTask_2_Feature.Query(); ORM_TMS_PRO_BussinessTask_2_Featurequery.Feature_RefID = Parameter.TMS_PRO_ProjectID; ORM_TMS_PRO_BussinessTask_2_Featurequery.IsDeleted = true; ORM_TMS_PRO_BusinessTask_2_Feature.Query.SoftDelete(Connection, Transaction, ORM_TMS_PRO_BussinessTask_2_Featurequery); #endregion #region Delete ORM_TMS_PRO_Features var ORM_TMS_PRO_Featuresquery = new ORM_TMS_PRO_Feature.Query(); ORM_TMS_PRO_Featuresquery.TMS_PRO_FeatureID = Parameter.TMS_PRO_ProjectID; ORM_TMS_PRO_Featuresquery.IsDeleted = true; ORM_TMS_PRO_Feature.Query.SoftDelete(Connection, Transaction, ORM_TMS_PRO_Featuresquery); #endregion #region Delete ORM_TMS_DeveloperTasks var ORM_TMS_Developertaskquery = new ORM_TMS_PRO_DeveloperTask.Query(); ORM_TMS_Developertaskquery.TMS_PRO_DeveloperTaskID = Parameter.TMS_PRO_ProjectID; ORM_TMS_Developertaskquery.IsDeleted = true; ORM_TMS_PRO_DeveloperTask.Query.SoftDelete(Connection, Transaction, ORM_TMS_Developertaskquery); #endregion return(returnValue); } if (Parameter.IsArchived == true) { #region archive Project //ORM_TMS_PRO_Project.Query searchQueryProject = new ORM_TMS_PRO_Project.Query(); //searchQueryProject.TMS_PRO_ProjectID = item.TMS_PRO_ProjectID; //searchQueryProject.IsArchived = false; //ORM_TMS_PRO_Project.Query updateQueryProject = new ORM_TMS_PRO_Project.Query(); //updateQueryProject.TMS_PRO_ProjectID = item.TMS_PRO_ProjectID; //updateQueryProject.IsArchived = true; //ORM_TMS_PRO_Project.Query.Update(Connection, Transaction, searchQueryProject, updateQueryProject); var project = ORM_TMS_PRO_Project.Query.Search(Connection, Transaction, new ORM_TMS_PRO_Project.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, TMS_PRO_ProjectID = Parameter.TMS_PRO_ProjectID }).Single(); project.IsArchived = true; project.Save(Connection, Transaction); #endregion #region archive ORM_TMS_PRO_BusinessTask //ORM_TMS_PRO_BusinessTask.Query searchQueryBusinessTask = new ORM_TMS_PRO_BusinessTask.Query(); //searchQueryBusinessTask.Project_RefID= item.TMS_PRO_ProjectID; //searchQueryBusinessTask.IsArchived = false; //ORM_TMS_PRO_BusinessTask.Query updateQueryBusinessTask = new ORM_TMS_PRO_BusinessTask.Query(); //updateQueryBusinessTask.Project_RefID = item.TMS_PRO_ProjectID; //updateQueryBusinessTask.IsArchived = true; //ORM_TMS_PRO_BusinessTask.Query.Update(Connection, Transaction, searchQueryBusinessTask, updateQueryBusinessTask); var businesstaskList = ORM_TMS_PRO_BusinessTask.Query.Search(Connection, Transaction, new ORM_TMS_PRO_BusinessTask.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, Project_RefID = Parameter.TMS_PRO_ProjectID }); foreach (var businesstaskitem in businesstaskList) { businesstaskitem.IsArchived = true; businesstaskitem.Save(Connection, Transaction); } #endregion #region archive ORM_TMS_PRO_Features //ORM_TMS_PRO_Feature.Query searchQueryFeature = new ORM_TMS_PRO_Feature.Query(); //searchQueryFeature.Project_RefID = item.TMS_PRO_ProjectID; //searchQueryFeature.IsArchived = false; //ORM_TMS_PRO_Feature.Query updateQueryFeature = new ORM_TMS_PRO_Feature.Query(); //updateQueryFeature.Project_RefID = item.TMS_PRO_ProjectID; //updateQueryFeature.IsArchived = true; //ORM_TMS_PRO_Feature.Query.Update(Connection, Transaction, searchQueryFeature, updateQueryFeature); var featureList = ORM_TMS_PRO_Feature.Query.Search(Connection, Transaction, new ORM_TMS_PRO_Feature.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, Project_RefID = Parameter.TMS_PRO_ProjectID }); foreach (var feature in featureList) { feature.IsArchived = true; feature.Save(Connection, Transaction); } #endregion #region archive ORM_TMS_DeveloperTasks var devTaskList = ORM_TMS_PRO_DeveloperTask.Query.Search(Connection, Transaction, new ORM_TMS_PRO_DeveloperTask.Query() { Tenant_RefID = securityTicket.TenantID, Project_RefID = item.TMS_PRO_ProjectID, IsDeleted = false }); foreach (var devTask in devTaskList) { devTask.IsArchived = true; devTask.Save(Connection, Transaction); } //ORM_TMS_PRO_DeveloperTask.Query searchQueryDeveloperTask = new ORM_TMS_PRO_DeveloperTask.Query(); //searchQueryDeveloperTask.Project_RefID = item.TMS_PRO_ProjectID; //searchQueryDeveloperTask.IsArchived = false; //ORM_TMS_PRO_DeveloperTask.Query updateQueryDeveloperTask = new ORM_TMS_PRO_DeveloperTask.Query(); //updateQueryDeveloperTask.Project_RefID = item.TMS_PRO_ProjectID; //updateQueryDeveloperTask.IsArchived = true; //ORM_TMS_PRO_DeveloperTask.Query.Update(Connection, Transaction, searchQueryDeveloperTask, updateQueryDeveloperTask); #endregion } if (Parameter.TMS_PRO_ProjectID == Guid.Empty) { item.TMS_PRO_ProjectID = Guid.NewGuid(); #region Define Documents var structureHeader = new ORM_DOC_Structure_Header(); structureHeader.DOC_Structure_HeaderID = Guid.NewGuid(); structureHeader.Label = Parameter.Name_DictID.Contents.FirstOrDefault().Content; structureHeader.Tenant_RefID = securityTicket.TenantID; var structureStatusSave = structureHeader.Save(Connection, Transaction); item.DOC_Structure_Header_RefID = structureHeader.DOC_Structure_HeaderID; #endregion #region ORM_TMS_PRO_ProjectMember #region ProjectMemberID String gpmProjectMember = EnumUtils.GetEnumDescription(ERightsPackage.ProjectMember); var parameter = new P_L2RP_GRPfGPM_1150(); parameter.GlobalPropertyMatchingID = gpmProjectMember; var projectMemberID = cls_Get_RightPackage_for_GlobalPropertyMatchingID.Invoke(Connection, Transaction, parameter, securityTicket).Result; #endregion #region ProjectManagerID String gpmProjectManager = EnumUtils.GetEnumDescription(ERightsPackage.ProjectManager); parameter = new P_L2RP_GRPfGPM_1150(); parameter.GlobalPropertyMatchingID = gpmProjectManager; var projectManagerID = cls_Get_RightPackage_for_GlobalPropertyMatchingID.Invoke(Connection, Transaction, parameter, securityTicket).Result; #endregion var projectMember = new ORM_TMS_PRO_ProjectMember(); projectMember.Project_RefID = item.TMS_PRO_ProjectID; projectMember.USR_Account_RefID = securityTicket.AccountID; projectMember.IsDeleted = false; projectMember.Tenant_RefID = securityTicket.TenantID; projectMember.IsOwner = true; projectMember.Save(Connection, Transaction); ORM_TMS_PRO_Members_2_RightPackage assignment_member = new ORM_TMS_PRO_Members_2_RightPackage(); assignment_member.ACC_RightsPackage_RefID = projectMemberID.TMS_PRO_ACC_RightsPackageID; assignment_member.ProjectMember_RefID = projectMember.TMS_PRO_ProjectMemberID; assignment_member.IsDeleted = false; assignment_member.Tenant_RefID = securityTicket.TenantID; assignment_member.Save(Connection, Transaction); ORM_TMS_PRO_Members_2_RightPackage assignment_manager = new ORM_TMS_PRO_Members_2_RightPackage(); assignment_manager.ACC_RightsPackage_RefID = projectManagerID.TMS_PRO_ACC_RightsPackageID; assignment_manager.ProjectMember_RefID = projectMember.TMS_PRO_ProjectMemberID; assignment_manager.IsDeleted = false; assignment_manager.Tenant_RefID = securityTicket.TenantID; assignment_manager.Save(Connection, Transaction); #endregion item.Tenant_RefID = securityTicket.TenantID; } if (Parameter.Name_DictID != null) { item.Name = Parameter.Name_DictID; } if (Parameter.Description_DictID != null) { item.Description = Parameter.Description_DictID; } if (Parameter.Status_RefID != null) { item.Status_RefID = Parameter.Status_RefID; } if (Parameter.Color != null) { item.Color = Parameter.Color; } return(new FR_Guid(item.Save(Connection, Transaction), item.TMS_PRO_ProjectID)); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3DPFT_DPN_1100 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); var item = new CL1_TMS_PRO.ORM_TMS_PRO_Project(); if (Parameter.TMS_PRO_ProjectID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.TMS_PRO_ProjectID); if (result.Status != FR_Status.Success || item.TMS_PRO_ProjectID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No such ID"; error.Status = FR_Status.Error_Internal; return(error); } } returnValue = new FR_Guid(item.Save(Connection, Transaction), item.TMS_PRO_ProjectID); ORM_TMS_PRO_Project.Query query = new ORM_TMS_PRO_Project.Query(); query.TMS_PRO_ProjectID = item.TMS_PRO_ProjectID; item.IsDeleted = true; ORM_TMS_PRO_Project.Query.SoftDelete(Connection, Transaction, query); #region Delete ORM_TMS_PRO_BusinessTask ORM_TMS_PRO_BusinessTask.Query ORM_TMS_PRO_BusinessTaskquery = new ORM_TMS_PRO_BusinessTask.Query(); ORM_TMS_PRO_BusinessTaskquery.Project_RefID = Parameter.TMS_PRO_ProjectID; ORM_TMS_PRO_BusinessTaskquery.IsArchived = false; ORM_TMS_PRO_BusinessTaskquery.IsDeleted = false; ORM_TMS_PRO_BusinessTask.Query.SoftDelete(Connection, Transaction, ORM_TMS_PRO_BusinessTaskquery); #endregion #region Delete ORM_TMS_PRO_BusinessTaskPackage ORM_TMS_PRO_BusinessTaskPackage.Query ORM_TMS_PRO_BusinessTaskPackagequery = new ORM_TMS_PRO_BusinessTaskPackage.Query(); ORM_TMS_PRO_BusinessTaskPackagequery.Project_RefID = Parameter.TMS_PRO_ProjectID; ORM_TMS_PRO_BusinessTaskPackagequery.IsDeleted = false; ORM_TMS_PRO_BusinessTaskPackage.Query.SoftDelete(Connection, Transaction, ORM_TMS_PRO_BusinessTaskPackagequery); #endregion #region Delete ORM_TMS_PRO_ProjectMember var ORM_TMS_PRO_ProjectMemberquery = new ORM_TMS_PRO_ProjectMember.Query(); ORM_TMS_PRO_ProjectMemberquery.IsDeleted = true; ORM_TMS_PRO_ProjectMemberquery.Project_RefID = Parameter.TMS_PRO_ProjectID; ORM_TMS_PRO_ProjectMember.Query.SoftDelete(Connection, Transaction, ORM_TMS_PRO_ProjectMemberquery); #endregion #region Delete ORM_TMS_PRO_BussinessTask_2_Feature var ORM_TMS_PRO_BussinessTask_2_Featurequery = new ORM_TMS_PRO_BusinessTask_2_Feature.Query(); ORM_TMS_PRO_BussinessTask_2_Featurequery.Feature_RefID = Parameter.TMS_PRO_ProjectID; ORM_TMS_PRO_BussinessTask_2_Featurequery.IsDeleted = true; ORM_TMS_PRO_BusinessTask_2_Feature.Query.SoftDelete(Connection, Transaction, ORM_TMS_PRO_BussinessTask_2_Featurequery); #endregion #region Delete ORM_TMS_PRO_Features var ORM_TMS_PRO_Featuresquery = new ORM_TMS_PRO_Feature.Query(); ORM_TMS_PRO_Featuresquery.TMS_PRO_FeatureID = Parameter.TMS_PRO_ProjectID; ORM_TMS_PRO_Featuresquery.IsDeleted = true; ORM_TMS_PRO_Feature.Query.SoftDelete(Connection, Transaction, ORM_TMS_PRO_Featuresquery); #endregion #region Delete ORM_TMS_DeveloperTasks var ORM_TMS_Developertaskquery = new ORM_TMS_PRO_DeveloperTask.Query(); ORM_TMS_Developertaskquery.TMS_PRO_DeveloperTaskID = Parameter.TMS_PRO_ProjectID; ORM_TMS_Developertaskquery.IsDeleted = true; ORM_TMS_PRO_DeveloperTask.Query.SoftDelete(Connection, Transaction, ORM_TMS_Developertaskquery); #endregion return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3FE_SF_0927 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 String oldName = ""; String oldDescription = ""; #region Get_Project Guid Project_RefID = Guid.Empty; if (Parameter.Parent_RefID != Guid.Empty) { ORM_TMS_PRO_BusinessTask.Query query = new ORM_TMS_PRO_BusinessTask.Query(); query.TMS_PRO_BusinessTaskID = Parameter.Parent_RefID; var items = ORM_TMS_PRO_BusinessTask.Query.Search(Connection, Transaction, query); Project_RefID = items.FirstOrDefault().Project_RefID; } #endregion foreach (var TMS_PRO_FeatureID in Parameter.TMS_PRO_FeatureIDList) { var item = new ORM_TMS_PRO_Feature(); var result = item.Load(Connection, Transaction, TMS_PRO_FeatureID); oldName = ""; oldDescription = ""; P_L3FE_GPfF_1445 peersParameter = new P_L3FE_GPfF_1445(); peersParameter.FeatureID = item.TMS_PRO_FeatureID; List <L3FE_GPfF_1445> featurePeers = cls_Get_Peers_for_Feature.Invoke(Connection, Transaction, peersParameter, securityTicket).Result.ToList(); if (Parameter.IsDeleted == true) { #region DeleteAssignments ORM_TMS_PRO_Feature.Query instance1 = new ORM_TMS_PRO_Feature.Query(); instance1.TMS_PRO_FeatureID = TMS_PRO_FeatureID; ORM_TMS_PRO_Feature.Query.SoftDelete(Connection, Transaction, instance1); ORM_TMS_PRO_BusinessTask_2_Feature.Query instance2 = new ORM_TMS_PRO_BusinessTask_2_Feature.Query(); instance2.Feature_RefID = TMS_PRO_FeatureID; ORM_TMS_PRO_BusinessTask_2_Feature.Query.SoftDelete(Connection, Transaction, instance2); ORM_TMS_PRO_Peers_Feature.Query instance3 = new ORM_TMS_PRO_Peers_Feature.Query(); instance3.Feature_RefID = TMS_PRO_FeatureID; instance3.IsDeleted = false; ORM_TMS_PRO_Peers_Feature.Query.SoftDelete(Connection, Transaction, instance3); ORM_TMS_PRO_Feature_2_DeveloperTask.Query instance4 = new ORM_TMS_PRO_Feature_2_DeveloperTask.Query(); instance4.Feature_RefID = TMS_PRO_FeatureID; List <ORM_TMS_PRO_Feature_2_DeveloperTask> assignmentResult = ORM_TMS_PRO_Feature_2_DeveloperTask.Query.Search(Connection, Transaction, instance4); var DTasks = assignmentResult.Select(i => i.DeveloperTask_RefID).ToArray(); ORM_TMS_QuickTask.Query instance7 = new ORM_TMS_QuickTask.Query(); instance7.AssignedTo_Feature_RefID = TMS_PRO_FeatureID; var quicktasks = ORM_TMS_QuickTask.Query.Search(Connection, Transaction, instance7); foreach (var quicktask in quicktasks) { var param = new P_L3QT_SQT_0905(); param.TMS_QuickTaskID = quicktask.TMS_QuickTaskID; param.IsDeleted = true; cls_Save_TMS_QuickTask.Invoke(Connection, Transaction, param, securityTicket); } P_L3DT_SDT_0949 DTParam = new P_L3DT_SDT_0949(); DTParam.TMS_PRO_DeveloperTaskIDList = DTasks; DTParam.IsDeleted = true; DTParam.SendEmail = false; cls_Save_TMS_PRO_DeveloperTask.Invoke(Connection, Transaction, DTParam, securityTicket); #endregion continue; } if (Parameter.IsArchived == true) { ORM_TMS_PRO_Feature_2_DeveloperTask.Query instance3 = new ORM_TMS_PRO_Feature_2_DeveloperTask.Query(); instance3.Feature_RefID = TMS_PRO_FeatureID; List <ORM_TMS_PRO_Feature_2_DeveloperTask> assignmentResult = ORM_TMS_PRO_Feature_2_DeveloperTask.Query.Search(Connection, Transaction, instance3); var DTasks = assignmentResult.Select(i => i.DeveloperTask_RefID).ToArray(); P_L3DT_SDT_0949 DTParam = new P_L3DT_SDT_0949(); DTParam.TMS_PRO_DeveloperTaskIDList = DTasks; DTParam.IsArchived = true; DTParam.SendEmail = false; cls_Save_TMS_PRO_DeveloperTask.Invoke(Connection, Transaction, DTParam, securityTicket); item.IsArchived = true; item.Save(Connection, Transaction); continue; } #region ORM_BusinessTask_2_Feature ORM_TMS_PRO_BusinessTask_2_Feature.Query assignquery = new ORM_TMS_PRO_BusinessTask_2_Feature.Query(); assignquery.Feature_RefID = item.TMS_PRO_FeatureID; List <ORM_TMS_PRO_BusinessTask_2_Feature> assignments = ORM_TMS_PRO_BusinessTask_2_Feature.Query.Search(Connection, Transaction, assignquery); foreach (var assignment in assignments) { assignment.BusinessTask_RefID = Parameter.Parent_RefID; assignment.Save(Connection, Transaction); } #endregion item.Project_RefID = Project_RefID; if (Parameter.TMS_PRO_FeatureIDList.Length == 1) { if (Parameter.FeatureName != null && item.Name.GetContent(Parameter.LanguageID) != Parameter.FeatureName.GetContent(Parameter.LanguageID)) { oldName = item.Name.GetContent(Parameter.LanguageID); item.Name = Parameter.FeatureName; } if (Parameter.Description != null && item.Description.GetContent(Parameter.LanguageID) != Parameter.Description.GetContent(Parameter.LanguageID)) { oldDescription = item.Description.GetContent(Parameter.LanguageID); item.Description = Parameter.Description; } } #region mailSendout #endregion if (Parameter.Parent_RefID != Guid.Empty) { item.Parent_RefID = Parameter.Parent_RefID; } if (Parameter.Type_RefID != Guid.Empty) { item.Type_RefID = Parameter.Type_RefID; } if (Parameter.Status_RefID != Guid.Empty) { item.Status_RefID = Parameter.Status_RefID; } if (Parameter.Feature_Deadline != new DateTime()) { item.Feature_Deadline = Parameter.Feature_Deadline; } item.Save(Connection, Transaction); } return(returnValue); #endregion UserCode }