protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3DT_SPDfDTID_1425 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
ORM_TMS_PRO_DeveloperTask devTask = ORM_TMS_PRO_DeveloperTask.Query.Search(Connection, Transaction, new ORM_TMS_PRO_DeveloperTask.Query()
{
TMS_PRO_DeveloperTaskID = Parameter.DeveloperTaskID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
ORM_TMS_PRO_ProjectMember projMember = ORM_TMS_PRO_ProjectMember.Query.Search(Connection, Transaction, new ORM_TMS_PRO_ProjectMember.Query()
{
USR_Account_RefID = securityTicket.AccountID,
Project_RefID = devTask.Project_RefID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
ORM_TMS_PRO_Project project = ORM_TMS_PRO_Project.Query.Search(Connection, Transaction, new ORM_TMS_PRO_Project.Query()
{
TMS_PRO_ProjectID = devTask.Project_RefID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
if (Parameter.Delete)
{
ORM_TMS_PRO_Peers_Development subscription2Delete = ORM_TMS_PRO_Peers_Development.Query.Search(Connection, Transaction, new ORM_TMS_PRO_Peers_Development.Query()
{
DeveloperTask_RefID = Parameter.DeveloperTaskID,
ProjectMember_RefID = projMember.TMS_PRO_ProjectMemberID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
subscription2Delete.IsDeleted = true;
subscription2Delete.Save(Connection, Transaction);
}
else
{
ORM_TMS_PRO_Peers_Development newSubscription = new ORM_TMS_PRO_Peers_Development();
newSubscription.Tenant_RefID = securityTicket.TenantID;
newSubscription.ProjectMember_RefID = projMember.TMS_PRO_ProjectMemberID;
newSubscription.DeveloperTask_RefID = Parameter.DeveloperTaskID;
newSubscription.Save(Connection, Transaction);
}
return(returnValue);
#endregion UserCode
}
protected static FR_L6DT_GDTIfT_1444_Array Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L6DT_GDTIfT_1444_Array();
//Put your code here
List <L6DT_GDTIfT_1444> DeveloperTasksInfo = new List <L6DT_GDTIfT_1444>();
var devTasksAndFeaturesForTenant = cls_Get_DeveloperTask_with_Features_for_Tenant.Invoke(Connection, Transaction, securityTicket).Result.ToList();
var nonArchivedNonDeletedParents = cls_Get_Features_for_Tenant.Invoke(Connection, Transaction, securityTicket).Result.ToList();
foreach (var item in devTasksAndFeaturesForTenant)
{
L6DT_GDTIfT_1444 DeveloperTaskInfo = new L6DT_GDTIfT_1444();
DeveloperTaskInfo.Identifier = item.IdentificationNumber;
DeveloperTaskInfo.DeveloperTaskDescription = item.Description;
DeveloperTaskInfo.DeveloperTaskName = item.Name;
DeveloperTaskInfo.DeveloperTaskID = item.TMS_PRO_DeveloperTaskID;
DeveloperTaskInfo.EstimatedTime = item.DeveloperTime_RequiredEstimation_min;
DeveloperTaskInfo.Points = item.Developer_Points;
DeveloperTaskInfo.DeadLine = item.Completion_Deadline.Date.ToString("d");
DeveloperTaskInfo.ProjectID = item.Project_RefID;
DeveloperTaskInfo.ProjectMemberID = item.TMS_PRO_ProjectMemberID;
//checking for subscriptions for current user
ORM_TMS_PRO_Peers_Development subscription = ORM_TMS_PRO_Peers_Development.Query.Search(Connection, Transaction, new ORM_TMS_PRO_Peers_Development.Query()
{
DeveloperTask_RefID = item.TMS_PRO_DeveloperTaskID,
Tenant_RefID = securityTicket.TenantID,
ProjectMember_RefID = item.TMS_PRO_ProjectMemberID,
IsDeleted = false
}).SingleOrDefault();
if (subscription != null)
{
DeveloperTaskInfo.IsSubscribed = true;
}
//**********************************
var parents = nonArchivedNonDeletedParents.Where(f => f.TMS_PRO_FeatureID == item.TMS_PRO_FeatureID).SingleOrDefault();
if (parents != null)
{
DeveloperTaskInfo.Path = parents.BTPath;
}
else
{
DeveloperTaskInfo.Path = "-";
}
DeveloperTaskInfo.DeveloperInfo = new L6DT_GDTIfT_1444DeveloperInfo();
List <L6DT_GDTIfT_1444TagInfo> TagsInfo = new List <L6DT_GDTIfT_1444TagInfo>();
P_L3PM_GAIfPMID_1345 ProjectMemberInfoParameter = new P_L3PM_GAIfPMID_1345();
ProjectMemberInfoParameter.ProjectMemberID = item.GrabbedByMember_RefID;
var projectMemberInfo = cls_Get_Account_Information_for_ProjectMemberID.Invoke(Connection, Transaction, ProjectMemberInfoParameter, securityTicket).Result.ToList().SingleOrDefault();
if (projectMemberInfo != null)
{
DeveloperTaskInfo.DeveloperInfo.ProjectMemberID = projectMemberInfo.TMS_PRO_ProjectMemberID;
DeveloperTaskInfo.DeveloperInfo.FirstAndLastName = projectMemberInfo.FirstName + " " + projectMemberInfo.LastName;
DeveloperTaskInfo.DeveloperInfo.ProjectMemberID = item.GrabbedByMember_RefID;
P_L3DT_GTfDT_1738 developerTaskTagsParameter = new P_L3DT_GTfDT_1738();
developerTaskTagsParameter.DTaskID = item.TMS_PRO_DeveloperTaskID;
var tagsForDeveloperTask = cls_Get_Tags_for_DeveloperTask.Invoke(Connection, Transaction, developerTaskTagsParameter, securityTicket).Result.ToList();
List <L6DT_GDTIfT_1444TagInfo> Tags4DeveloperTask = new List <L6DT_GDTIfT_1444TagInfo>();
foreach (var tag in tagsForDeveloperTask)
{
L6DT_GDTIfT_1444TagInfo tagInfo = new L6DT_GDTIfT_1444TagInfo();
tagInfo.TagID = tag.TMS_PRO_TagID;
tagInfo.TagValue = tag.TagValue;
tagInfo.AssignmentID = tag.AssignmentID;
Tags4DeveloperTask.Add(tagInfo);
}
DeveloperTaskInfo.TagsInfo = Tags4DeveloperTask.ToArray();
DeveloperTasksInfo.Add(DeveloperTaskInfo);
}
}
returnValue.Result = DeveloperTasksInfo.ToArray();
return(returnValue);
#endregion UserCode
}
