private static List <ORM_TMS_PRO_DeveloperTask> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction) { CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection(); List <ORM_TMS_PRO_DeveloperTask> items; try { managedConnection.set(connectionString, connection, transaction); var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(managedConnection.getConnection(), managedConnection.getTransaction()); DbCommand command = managedConnection.manage(query.CreateSelectQuery(TableName)); query.SetParameters(command); items = new List <ORM_TMS_PRO_DeveloperTask>(); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); reader.SetOrdinals(new string[] { "TMS_PRO_DeveloperTaskID", "IdentificationNumber", "DOC_Structure_Header_RefID", "CreatedBy_ProjectMember_RefID", "Priority_RefID", "Project_RefID", "DeveloperTask_Type_RefID", "IsTaskEstimable", "DeveloperTime_RequiredEstimation_min", "DeveloperTime_CurrentInvestment_min", "GrabbedByMember_RefID", "Completion_Deadline", "Completion_Timestamp", "PercentageComplete", "Name", "Description", "Developer_Points", "IsComplete", "IsIncompleteInformation", "IsArchived", "IsBeingPrepared", "Creation_Timestamp", "IsDeleted", "Tenant_RefID" }); while (reader.Read()) { ORM_TMS_PRO_DeveloperTask item = new ORM_TMS_PRO_DeveloperTask(); //0:Parameter TMS_PRO_DeveloperTaskID of type Guid item.TMS_PRO_DeveloperTaskID = reader.GetGuid(0); //1:Parameter IdentificationNumber of type String item.IdentificationNumber = reader.GetString(1); //2:Parameter DOC_Structure_Header_RefID of type Guid item.DOC_Structure_Header_RefID = reader.GetGuid(2); //3:Parameter CreatedBy_ProjectMember_RefID of type Guid item.CreatedBy_ProjectMember_RefID = reader.GetGuid(3); //4:Parameter Priority_RefID of type Guid item.Priority_RefID = reader.GetGuid(4); //5:Parameter Project_RefID of type Guid item.Project_RefID = reader.GetGuid(5); //6:Parameter DeveloperTask_Type_RefID of type Guid item.DeveloperTask_Type_RefID = reader.GetGuid(6); //7:Parameter IsTaskEstimable of type Boolean item.IsTaskEstimable = reader.GetBoolean(7); //8:Parameter DeveloperTime_RequiredEstimation_min of type Double item.DeveloperTime_RequiredEstimation_min = reader.GetDouble(8); //9:Parameter DeveloperTime_CurrentInvestment_min of type Double item.DeveloperTime_CurrentInvestment_min = reader.GetDouble(9); //10:Parameter GrabbedByMember_RefID of type Guid item.GrabbedByMember_RefID = reader.GetGuid(10); //11:Parameter Completion_Deadline of type DateTime item.Completion_Deadline = reader.GetDate(11); //12:Parameter Completion_Timestamp of type DateTime item.Completion_Timestamp = reader.GetDate(12); //13:Parameter PercentageComplete of type String item.PercentageComplete = reader.GetString(13); //14:Parameter Name of type String item.Name = reader.GetString(14); //15:Parameter Description of type String item.Description = reader.GetString(15); //16:Parameter Developer_Points of type int item.Developer_Points = reader.GetInteger(16); //17:Parameter IsComplete of type Boolean item.IsComplete = reader.GetBoolean(17); //18:Parameter IsIncompleteInformation of type Boolean item.IsIncompleteInformation = reader.GetBoolean(18); //19:Parameter IsArchived of type Boolean item.IsArchived = reader.GetBoolean(19); //20:Parameter IsBeingPrepared of type Boolean item.IsBeingPrepared = reader.GetBoolean(20); //21:Parameter Creation_Timestamp of type DateTime item.Creation_Timestamp = reader.GetDate(21); //22:Parameter IsDeleted of type Boolean item.IsDeleted = reader.GetBoolean(22); //23:Parameter Tenant_RefID of type Guid item.Tenant_RefID = reader.GetGuid(23); item.Status_IsAlreadySaved = true; item.Status_IsDirty = false; items.Add(item); } reader.Close(); loader.Load(); managedConnection.commit(); } catch (Exception ex) { managedConnection.rollback(); throw; } return(items); }
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 }