protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6US_SPMT_1448 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
        {
            #region UserCode
            var returnValue = new FR_Guid();
            //Put your code here

            //If no id, create new element
            if (Parameter.Type_ID == null || Parameter.Type_ID == Guid.Empty)
            {
                ORM_TMP_PRO_ProjectMember_Type newType = new ORM_TMP_PRO_ProjectMember_Type();
                newType.ProjectMemberType_Name = Parameter.Type_name;
                newType.Color        = Parameter.Color;
                newType.Tenant_RefID = securityTicket.TenantID;
                return(new FR_Guid(newType.Save(Connection, Transaction), newType.TMP_PRO_ProjectMember_TypeID));
            }

            //If existing load
            ORM_TMP_PRO_ProjectMember_Type tempType = new ORM_TMP_PRO_ProjectMember_Type();
            var resultStatus = tempType.Load(Connection, Transaction, Parameter.Type_ID);
            if (resultStatus.Status != FR_Status.Success || tempType.TMP_PRO_ProjectMember_TypeID == Guid.Empty)
            {
                var error = new FR_Guid();
                error.ErrorMessage = "No Such ID";
                error.Status       = FR_Status.Error_Internal;
                return(error);
            }

            //If deleted, delete and replace
            if (Parameter.Type_isDeleted)
            {
                tempType.IsDeleted = true;
                resultStatus       = tempType.Save(Connection, Transaction);

                if (resultStatus.Status != FR_Status.Success || tempType.TMP_PRO_ProjectMember_TypeID == Guid.Empty)
                {
                    var error = new FR_Guid();
                    error.ErrorMessage = "No Such ID";
                    error.Status       = FR_Status.Error_Internal;
                    return(error);
                }

                ORM_TMS_PRO_ProjectMember.Query searchQuery = new ORM_TMS_PRO_ProjectMember.Query();
                searchQuery.ProjectMember_Type_RefID = Parameter.Type_ID;

                ORM_TMS_PRO_ProjectMember.Query updateQuery = new ORM_TMS_PRO_ProjectMember.Query();
                updateQuery.ProjectMember_Type_RefID = Parameter.Type_ReplacementTypeID;

                ORM_TMS_PRO_ProjectMember.Query.Update(Connection, Transaction, searchQuery, updateQuery);

                return(new FR_Guid());
            }
            //Update name
            tempType.ProjectMemberType_Name = Parameter.Type_name;
            tempType.Color = Parameter.Color;
            return(new FR_Guid(tempType.Save(Connection, Transaction), tempType.TMP_PRO_ProjectMember_TypeID));

            #endregion UserCode
        }
Esempio n. 2
0
        protected static FR_L6PR_GPMwSIfPN_1832_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L6PR_GPMwSIfPN_1832 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
        {
            #region UserCode
            var returnValue = new FR_L6PR_GPMwSIfPN_1832_Array();
            //Put your code here
            List <L6PR_GPMwSIfPN_1832> tempResult = new List <L6PR_GPMwSIfPN_1832>();

            ORM_TMS_PRO_Project_Notes projectNote = new ORM_TMS_PRO_Project_Notes();
            projectNote.Load(Connection, Transaction, Parameter.ProjectNote_ID);

            #region ProjectMembers
            ORM_TMS_PRO_ProjectMember.Query membersQuery = new ORM_TMS_PRO_ProjectMember.Query();
            membersQuery.Project_RefID = projectNote.Project_RefID;
            membersQuery.IsDeleted     = false;

            List <ORM_TMS_PRO_ProjectMember> currentProject_Members = ORM_TMS_PRO_ProjectMember.Query.Search(Connection, Transaction, membersQuery);
            P_L3US_GUBIfUA_1057 userAccountInfoParameter            = new P_L3US_GUBIfUA_1057();
            if (currentProject_Members.Count > 0)
            {
                foreach (var currentMember in currentProject_Members)
                {
                    L6PR_GPMwSIfPN_1832 tempResultItem = new L6PR_GPMwSIfPN_1832();
                    tempResultItem.ProjectMember_AccountID = currentMember.USR_Account_RefID;
                    tempResultItem.ProjectMember_ID        = currentMember.TMS_PRO_ProjectMemberID;
                    userAccountInfoParameter.UserAccountID = currentMember.USR_Account_RefID;
                    var userAccountInfoResult = cls_Get_UserBasicInfo_for_UserAccountID.Invoke(Connection, Transaction, userAccountInfoParameter, securityTicket).Result;
                    tempResultItem.ProjectMember_FirstName = userAccountInfoResult.FirstName;
                    tempResultItem.ProjectMember_LastName  = userAccountInfoResult.LastName;
                    tempResultItem.ProjectMember_ProfileImage_ServerLocation = userAccountInfoResult.File_ServerLocation;
                    tempResult.Add(tempResultItem);
                }
            }

            #endregion

            #region Is member note collaborator
            ORM_TMS_PRO_Project_Note_Collaborators.Query noteCollaboratorsQuery = new ORM_TMS_PRO_Project_Note_Collaborators.Query();
            noteCollaboratorsQuery.IsDeleted         = false;
            noteCollaboratorsQuery.ProjectNote_RefID = Parameter.ProjectNote_ID;
            foreach (var currentMember in tempResult)
            {
                noteCollaboratorsQuery.Account_RefID           = currentMember.ProjectMember_AccountID;
                currentMember.ProjectMember_IsNoteCollaborator = ORM_TMS_PRO_Project_Note_Collaborators.Query.Exists(Connection, Transaction, noteCollaboratorsQuery);
            }
            #endregion

            returnValue.Result = tempResult.ToArray();

            return(returnValue);

            #endregion UserCode
        }
Esempio n. 3
0
        protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6DT_UDTSHwAD_1637 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
        {
            #region UserCode
            var returnValue = new FR_Guid();
            //Put your code here

            #region DocumentUpdated

            var documentUpdatedParam = new P_L2DT_GDTSfGPM_1121();
            documentUpdatedParam.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EDeveloperTaskHistory.DocumentUpdated);

            var documentUpdatedID = cls_Get_DeveloperTaskStatus_for_GlobalPropertyMatchingID.Invoke(Connection, Transaction, documentUpdatedParam, securityTicket).Result;

            #endregion

            var dtask = new ORM_TMS_PRO_DeveloperTask();
            dtask.Load(Connection, Transaction, Parameter.DeveloperTaskID);

            ORM_TMS_PRO_ProjectMember.Query assinment_Query = new ORM_TMS_PRO_ProjectMember.Query();
            assinment_Query.USR_Account_RefID = securityTicket.AccountID;
            assinment_Query.Project_RefID     = dtask.Project_RefID;
            assinment_Query.IsDeleted         = false;

            List <ORM_TMS_PRO_ProjectMember> assinment = ORM_TMS_PRO_ProjectMember.Query.Search(Connection, Transaction, assinment_Query);

            ORM_TMS_PRO_DeveloperTask_StatusHistory statusHistory = new ORM_TMS_PRO_DeveloperTask_StatusHistory();

            statusHistory.TMS_PRO_DeveloperTask_StatusHistoryID = Guid.NewGuid();
            statusHistory.DeveloperTask_RefID             = dtask.TMS_PRO_DeveloperTaskID;
            statusHistory.DeveloperTask_Status_RefID      = documentUpdatedID.TMS_PRO_DeveloperTask_StatusID;
            statusHistory.TriggeredBy_ProjectMember_RefID = assinment.First().TMS_PRO_ProjectMemberID;
            statusHistory.Tenant_RefID       = securityTicket.TenantID;
            statusHistory.Creation_Timestamp = DateTime.Now;
            if (Parameter.FileType == "Document")
            {
                statusHistory.Comment = (String)HttpContext.GetGlobalResourceObject("Global", "File_Add") + Parameter.FileName;
            }
            else if (Parameter.FileType == "Revision")
            {
                statusHistory.Comment = (String)HttpContext.GetGlobalResourceObject("Global", "File_Add") + Parameter.FileName;
            }
            else
            {
                statusHistory.Comment = (String)HttpContext.GetGlobalResourceObject("Global", "Folder_Add") + Parameter.FileName;
            }

            statusHistory.Save(Connection, Transaction);

            return(returnValue);

            #endregion UserCode
        }
        protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6DT_RDT_1057 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
        {
            #region UserCode
            var returnValue = new FR_Guid();

            //Put your code here
            #region Get RecommendedBy ProjecMemberID
            ORM_TMS_PRO_ProjectMember RecommendedBy = null;
            if (Parameter.DeveloperTask_List != null && Parameter.DeveloperTask_List.Count() != 0)
            {
                ORM_TMS_PRO_DeveloperTask firstTask = new ORM_TMS_PRO_DeveloperTask();
                firstTask.Load(Connection, Transaction, Parameter.DeveloperTask_List.First());

                ORM_TMS_PRO_ProjectMember.Query mem_query = new ORM_TMS_PRO_ProjectMember.Query();
                mem_query.Project_RefID     = firstTask.Project_RefID;
                mem_query.USR_Account_RefID = securityTicket.AccountID;

                RecommendedBy = ORM_TMS_PRO_ProjectMember.Query.Search(Connection, Transaction, mem_query).FirstOrDefault();
            }

            foreach (var currentTask in Parameter.DeveloperTask_List)
            {
                #region Remove Previous Recommendations

                ORM_TMS_PRO_DeveloperTask_Recommendation.Query rec_query = new ORM_TMS_PRO_DeveloperTask_Recommendation.Query();
                rec_query.DeveloperTask_RefID = currentTask;
                ORM_TMS_PRO_DeveloperTask_Recommendation.Query.SoftDelete(Connection, Transaction, rec_query);

                foreach (var currentMember in Parameter.ProjectMember_List)
                {
                    ORM_TMS_PRO_DeveloperTask_Recommendation rec_item = new ORM_TMS_PRO_DeveloperTask_Recommendation();
                    rec_item.DeveloperTask_RefID = currentTask;
                    rec_item.RecommendedBy_ProjectMember_RefID = RecommendedBy.TMS_PRO_ProjectMemberID;
                    rec_item.RecommendedTo_ProjectMember_RefID = currentMember;
                    rec_item.Description  = "";
                    rec_item.Tenant_RefID = securityTicket.TenantID;
                    rec_item.Save(Connection, Transaction);
                }
                #endregion
            }
            #endregion

            return(returnValue);

            #endregion UserCode
        }
Esempio n. 5
0
        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
        }
Esempio n. 6
0
        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
        }