protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6DT_ADT_1443 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
#region InPreparationStatus
var inPrepParam = new P_L2PR_GPSfGP_1339();
inPrepParam.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EProjectStatus.InPreparation);
var inPreparationStatus = cls_Get_ProjectStatuses_for_GlobalPropertyID.Invoke(Connection, Transaction, inPrepParam, securityTicket).Result;
#endregion
#region InPreparationFeatureStatus
var inPrepFeatureParam = new P_L2FE_GFSfGPM_1405();
inPrepFeatureParam.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EFeatureStatus.InPreparation);
var inPreparationFeatureStatus = cls_Get_FeatureStatus_for_GlobalPropertyMatchigID.Invoke(Connection, Transaction, inPrepFeatureParam, securityTicket).Result;
#endregion
#region inPreparationBTStatus
var inPreparationBTStatusParam = new P_L2BT_GBTfGPM_1409();
inPreparationBTStatusParam.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EBusinessTaskStatus.InPreparation);
var inPreparationBTStatus = cls_Get_BusinessTask_for_GlobalPropertyMatchingID.Invoke(Connection, Transaction, inPreparationBTStatusParam, securityTicket).Result;
#endregion
//find old active
P_L3DT_GADTfAU_1505 param1 = new P_L3DT_GADTfAU_1505();
param1.IsBeingPrepared_Only = false;
var result1 = cls_Get_ActiveDeveloperTask_for_ActiveUser.Invoke(Connection, Transaction, param1, securityTicket).Result.FirstOrDefault();
//if active task doesn't exist
if (result1 == null)
{
result1 = new L3DT_GADTfAU_1505();
}
//deactivate old and activate new
P_L6DT_CADT_1453 param2 = new P_L6DT_CADT_1453();
param2.AssignmentID_newActive = Parameter.AssignmentID_newActive;
param2.AssignmentID_oldActive = result1.DeveloperTask_InvolvementID;
returnValue = cls_Change_Active_DeveloperTask.Invoke(Connection, Transaction, param2, securityTicket);
return(returnValue);
#endregion UserCode
}
protected static FR_L6US_GDMDMDfAU_1802 Execute(DbConnection Connection, DbTransaction Transaction, P_L6US_GDMDMDfAU_1802 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_L6US_GDMDMDfAU_1802();
//Put your code here
returnValue.Result = new L6US_GDMDMDfAU_1802();
#region ActiveTask
P_L3DT_GADTfAU_1505 Parameter_ActiveTask = new P_L3DT_GADTfAU_1505();
Parameter_ActiveTask.IsBeingPrepared_Only = Parameter.IsBeingPrepared_Only;
returnValue.Result.ActiveTask = cls_Get_ActiveDeveloperTask_for_ActiveUser.Invoke(Connection, Transaction, Parameter_ActiveTask, securityTicket).Result.FirstOrDefault();
#endregion
#region ProjectIDs
P_L3PR_GPIDLfAUaRPL_1344 Paramater_Project = new P_L3PR_GPIDLfAUaRPL_1344();
Paramater_Project.IsArchived = Parameter.IsArchived;
Paramater_Project.RightPackIDList = Parameter.RightPackIDList;
List <L3PR_GPIDLfAUaRPL_1344> AvailableProjects = cls_Get_ProjectIDList_for_ActiveUser_and_RightPackageList.Invoke(Connection, Transaction, Paramater_Project, securityTicket).Result.ToList();
#endregion
if (AvailableProjects != null && AvailableProjects.Count > 0)
{
#region AssignedTasks
P_L3DT_GADTLfAUaPL_1559 Parameter_AssignedTasks = new P_L3DT_GADTLfAUaPL_1559();
Parameter_AssignedTasks.IsBeingPrepared_Only = Parameter.IsBeingPrepared_Only;
Parameter_AssignedTasks.ProjectID_List = AvailableProjects.Select(p => p.Project_ID).ToArray();
Parameter_AssignedTasks.FeatureStatusExcluded = Parameter.FeatureStatusDifferentFromThis;
Parameter_AssignedTasks.BusinessTaskStatusExcluded = Parameter.BusinessTaskStatusDifferentFromThis;
Parameter_AssignedTasks.ProjectStatusExcluded = Parameter.ProjectStatusDifferenFromThis;
returnValue.Result.AssignedTasks = cls_Get_AssignedDeveloperTaskList_for_ActiveUser_and_ProjectList.Invoke(Connection, Transaction, Parameter_AssignedTasks, securityTicket).Result;
#endregion
#region CompletedTasks
P_L3DT_GCDTfAUaPL_1610 Parameter_CompletedTasks = new P_L3DT_GCDTfAUaPL_1610();
Parameter_CompletedTasks.ProjectID_List = AvailableProjects.Select(p => p.Project_ID).ToArray();
returnValue.Result.CompletedTasks = cls_Get_CompletedDeveloperTasks_for_ActiveUser_and_ProjectList.Invoke(Connection, Transaction, Parameter_CompletedTasks, securityTicket).Result;
#endregion
#region MentionedTasks
P_L3DT_GDTIDwAUiM_1712 Parameter_MentionTasks = new P_L3DT_GDTIDwAUiM_1712();
Parameter_MentionTasks.BusinessTaskStatusExcluded = Parameter.BusinessTaskStatusDifferentFromThis;
Parameter_MentionTasks.FeatureStatusExcluded = Parameter.FeatureStatusDifferentFromThis;
Parameter_MentionTasks.ProjectStatusExcluded = Parameter.ProjectStatusDifferenFromThis;
returnValue.Result.MentionTasks = cls_Get_DeveloperTaskIDs_where_ActiveUser_is_Mentioned.Invoke(Connection, Transaction, Parameter_MentionTasks, securityTicket).Result;
#endregion
#region FreeTasks
P_L3DT_GFDTLfAUIDaPL_1643 Parameter_FreeTasks = new P_L3DT_GFDTLfAUIDaPL_1643();
Parameter_FreeTasks.IsBeingPrepared_Only = Parameter.IsBeingPrepared_Only;
Parameter_FreeTasks.ProjectID_List = AvailableProjects.Select(p => p.Project_ID).ToArray();
Parameter_FreeTasks.BusinessTaskStatusExcluded = Parameter.BusinessTaskStatusDifferentFromThis;
Parameter_FreeTasks.FeatureStatusExcluded = Parameter.FeatureStatusDifferentFromThis;
Parameter_FreeTasks.ProjectStatusExcluded = Parameter.ProjectStatusDifferenFromThis;
returnValue.Result.FreeTasks = cls_Get_FreeDeveloperTasksList_for_ActiveUser_and_ProjectList.Invoke(Connection, Transaction, Parameter_FreeTasks, securityTicket).Result;
#endregion
#region RecommendedTasks
P_L3DT_GRDTLfAU_1408 Parameter_RecommendedTasks = new P_L3DT_GRDTLfAU_1408();
Parameter_RecommendedTasks.BusinessTaskStatusExcluded = Parameter.BusinessTaskStatusDifferentFromThis;
Parameter_RecommendedTasks.FeatureStatusExcluded = Parameter.FeatureStatusDifferentFromThis;
Parameter_RecommendedTasks.ProjectStatusExcluded = Parameter.ProjectStatusDifferenFromThis;
Parameter_RecommendedTasks.IsBeingPrepared_Only = Parameter.IsBeingPrepared_Only;
Parameter_RecommendedTasks.ProjectID_List = AvailableProjects.Select(p => p.Project_ID).ToArray();
returnValue.Result.RecomendedTasks = cls_Get_RecommendedDeveloperTaskList_for_ActiveUser.Invoke(Connection, Transaction, Parameter_RecommendedTasks, securityTicket).Result;
#endregion
}
//Notes
ORM_TMS_PRO_Project_Notes.Query notesQuery = new ORM_TMS_PRO_Project_Notes.Query();
notesQuery.IsDeleted = false;
notesQuery.Tenant_RefID = securityTicket.TenantID;
var notes = ORM_TMS_PRO_Project_Notes.Query.Search(Connection, Transaction, notesQuery).Count;
returnValue.Result.NotesCount = notes;
return(returnValue);
#endregion UserCode
}
protected static FR_L6US_GDMDMDfAU_1802 Execute(DbConnection Connection, DbTransaction Transaction, P_L6US_GDMDMDfAU_1802 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L6US_GDMDMDfAU_1802();
//Put your code here
returnValue.Result = new L6US_GDMDMDfAU_1802();
#region ActiveTask
P_L3DT_GADTfAU_1505 Parameter_ActiveTask = new P_L3DT_GADTfAU_1505();
Parameter_ActiveTask.IsBeingPrepared_Only = Parameter.IsBeingPrepared_Only;
Parameter_ActiveTask.FeatureStatusExcluded = Parameter.FeatureStatusDifferentFromThis;
Parameter_ActiveTask.BusinessTaskStatusExcluded = Parameter.BusinessTaskStatusDifferentFromThis;
Parameter_ActiveTask.ProjectStatusExcluded = Parameter.ProjectStatusDifferenFromThis;
returnValue.Result.ActiveTask = cls_Get_ActiveDeveloperTask_for_ActiveUser.Invoke(Connection, Transaction, Parameter_ActiveTask, securityTicket).Result;
#endregion
#region ProjectIDs
P_L3PR_GPIDLfAUaRPL_1344 Paramater_Project = new P_L3PR_GPIDLfAUaRPL_1344();
Paramater_Project.IsArchived = Parameter.IsArchived;
Paramater_Project.RightPackIDList = Parameter.RightPackIDList;
List <L3PR_GPIDLfAUaRPL_1344> AvailableProjects = cls_Get_ProjectIDList_for_ActiveUser_and_RightPackageList.Invoke(Connection, Transaction, Paramater_Project, securityTicket).Result.ToList();
#endregion
if (AvailableProjects != null && AvailableProjects.Count > 0)
{
#region AssignedTasks
P_L3DT_GADTLfAUaPL_1559 Parameter_AssignedTasks = new P_L3DT_GADTLfAUaPL_1559();
Parameter_AssignedTasks.IsBeingPrepared_Only = Parameter.IsBeingPrepared_Only;
Parameter_AssignedTasks.ProjectID_List = AvailableProjects.Select(p => p.Project_ID).ToArray();
Parameter_AssignedTasks.FeatureStatusExcluded = Parameter.FeatureStatusDifferentFromThis;
Parameter_AssignedTasks.BusinessTaskStatusExcluded = Parameter.BusinessTaskStatusDifferentFromThis;
Parameter_AssignedTasks.ProjectStatusExcluded = Parameter.ProjectStatusDifferenFromThis;
returnValue.Result.AssignedTasks = cls_Get_AssignedDeveloperTaskList_for_ActiveUser_and_ProjectList.Invoke(Connection, Transaction, Parameter_AssignedTasks, securityTicket).Result;
#endregion
#region CompletedTasks
P_L3DT_GCDTfAUaPL_1610 Parameter_CompletedTasks = new P_L3DT_GCDTfAUaPL_1610();
Parameter_CompletedTasks.ProjectID_List = AvailableProjects.Select(p => p.Project_ID).ToArray();
returnValue.Result.CompletedTasks = cls_Get_CompletedDeveloperTasks_for_ActiveUser_and_ProjectList.Invoke(Connection, Transaction, Parameter_CompletedTasks, securityTicket).Result;
#endregion
#region MentionedTasks
P_L3DT_GDTIDwAUiM_1712 Parameter_MentionTasks = new P_L3DT_GDTIDwAUiM_1712();
Parameter_MentionTasks.BusinessTaskStatusExcluded = Parameter.BusinessTaskStatusDifferentFromThis;
Parameter_MentionTasks.FeatureStatusExcluded = Parameter.FeatureStatusDifferentFromThis;
Parameter_MentionTasks.ProjectStatusExcluded = Parameter.ProjectStatusDifferenFromThis;
returnValue.Result.MentionTasks = cls_Get_DeveloperTaskIDs_where_ActiveUser_is_Mentioned.Invoke(Connection, Transaction, Parameter_MentionTasks, securityTicket).Result;
#endregion
#region FreeTasks
P_L3DT_GFDTLfAUIDaPL_1643 Parameter_FreeTasks = new P_L3DT_GFDTLfAUIDaPL_1643();
Parameter_FreeTasks.IsBeingPrepared_Only = Parameter.IsBeingPrepared_Only;
Parameter_FreeTasks.ProjectID_List = AvailableProjects.Select(p => p.Project_ID).ToArray();
Parameter_FreeTasks.BusinessTaskStatusExcluded = Parameter.BusinessTaskStatusDifferentFromThis;
Parameter_FreeTasks.FeatureStatusExcluded = Parameter.FeatureStatusDifferentFromThis;
Parameter_FreeTasks.ProjectStatusExcluded = Parameter.ProjectStatusDifferenFromThis;
returnValue.Result.FreeTasks = cls_Get_FreeDeveloperTasksList_for_ActiveUser_and_ProjectList.Invoke(Connection, Transaction, Parameter_FreeTasks, securityTicket).Result;
#endregion
#region RecommendedTasks
P_L3DT_GRDTLfAU_1408 Parameter_RecommendedTasks = new P_L3DT_GRDTLfAU_1408();
Parameter_RecommendedTasks.BusinessTaskStatusExcluded = Parameter.BusinessTaskStatusDifferentFromThis;
Parameter_RecommendedTasks.FeatureStatusExcluded = Parameter.FeatureStatusDifferentFromThis;
Parameter_RecommendedTasks.ProjectStatusExcluded = Parameter.ProjectStatusDifferenFromThis;
Parameter_RecommendedTasks.IsBeingPrepared_Only = Parameter.IsBeingPrepared_Only;
Parameter_RecommendedTasks.ProjectID_List = AvailableProjects.Select(p => p.Project_ID).ToArray();
returnValue.Result.RecomendedTasks = cls_Get_RecommendedDeveloperTaskList_for_ActiveUser.Invoke(Connection, Transaction, Parameter_RecommendedTasks, securityTicket).Result;
#endregion
}
//Updated independently
//#region InvestedTime
//returnValue.Result.CurrentDayWorkTime = cls_Get_Invested_Working_Time_for_Today.Invoke(Connection, Transaction, securityTicket).Result.ToArray();
//#endregion
return(returnValue);
#endregion UserCode
}
