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_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 }
protected static FR_L6PR_GPMwRIfDTaR_1317_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L6PR_GPMwRIfDTaR_1317 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L6PR_GPMwRIfDTaR_1317_Array(); //Put your code here List <L6PR_GPMwRIfDTaR_1317> tempResult = new List <L6PR_GPMwRIfDTaR_1317>(); ORM_TMS_PRO_DeveloperTask developerTask = new ORM_TMS_PRO_DeveloperTask(); developerTask.Load(Connection, Transaction, Parameter.DeveloperTask_ID); P_L3PM_GPMfPaRP_1459 ParameterMembers = new P_L3PM_GPMfPaRP_1459(); ParameterMembers.ProjectID = developerTask.Project_RefID; ParameterMembers.RightPackageID = Parameter.Right_ID; var tempMembers = cls_Get_ProjectMemebers_for_ProjectID_and_RightPackageID.Invoke(Connection, Transaction, ParameterMembers, securityTicket).Result; if (tempMembers != null) { ORM_TMS_PRO_DeveloperTask_Recommendation.Query recommendationsQuery = new ORM_TMS_PRO_DeveloperTask_Recommendation.Query(); recommendationsQuery.DeveloperTask_RefID = Parameter.DeveloperTask_ID; recommendationsQuery.IsDeleted = false; foreach (var member in tempMembers) { L6PR_GPMwRIfDTaR_1317 tempResultItem = new L6PR_GPMwRIfDTaR_1317(); tempResultItem.ProjectMember_FirstName = member.ProjectMember_FirstName; tempResultItem.ProjectMember_ID = member.ProjectMember_ID; tempResultItem.ProjectMember_AccountID = member.ProjectMember_AccountID; tempResultItem.ProjectMember_LastName = member.ProjectMember_LastName; tempResultItem.ProjectMember_ProfilePic_ServerLocation = member.ProjectMember_ProfilePic_ServerLocation; recommendationsQuery.RecommendedTo_ProjectMember_RefID = member.ProjectMember_ID; tempResultItem.ProjectMember_IsRecommended = ORM_TMS_PRO_DeveloperTask_Recommendation.Query.Exists(Connection, Transaction, recommendationsQuery); tempResult.Add(tempResultItem); } } returnValue.Result = tempResult.ToArray(); return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3DT_FDT_1646 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); //Put your code here #region Finished Status ID var Parameter_StatusFinished = new P_L2DT_GDTSfGPM_1121(); Parameter_StatusFinished.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EDeveloperTaskHistory.Finished); var StatusFinished = cls_Get_DeveloperTaskStatus_for_GlobalPropertyMatchingID.Invoke(Connection, Transaction, Parameter_StatusFinished, securityTicket).Result; var Parameter_StatusStarted = new P_L2DT_GDTSfGPM_1121(); Parameter_StatusStarted.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EDeveloperTaskHistory.Started); var StatusStarted = cls_Get_DeveloperTaskStatus_for_GlobalPropertyMatchingID.Invoke(Connection, Transaction, Parameter_StatusStarted, securityTicket).Result; #endregion #region Developer Task involvement ORM_TMS_PRO_DeveloperTask_Involvement DeveloperTask_Involvemnet = new ORM_TMS_PRO_DeveloperTask_Involvement(); DeveloperTask_Involvemnet.Load(Connection, Transaction, Parameter.DeveloperTask_InvolvementID); DeveloperTask_Involvemnet.IsActive = false; DeveloperTask_Involvemnet.IsArchived = true; DeveloperTask_Involvemnet.R_InvestedWorkingTime_min += Parameter.DeveloperTask_InvestedTime; DeveloperTask_Involvemnet.Save(Connection, Transaction); #endregion #region Developer Task //ORM_TMS_PRO_DeveloperTask_Involvement.Query InvolvementQuery = new ORM_TMS_PRO_DeveloperTask_Involvement.Query(); //InvolvementQuery.DeveloperTask_RefID = DeveloperTask_Involvemnet.DeveloperTask_RefID; //var InvestedTime = ORM_TMS_PRO_DeveloperTask_Involvement.Query.Search(Connection, Transaction, InvolvementQuery).Sum(i => i.R_InvestedWorkingTime_min); ORM_TMS_PRO_DeveloperTask DeveloperTask = new ORM_TMS_PRO_DeveloperTask(); DeveloperTask.Load(Connection, Transaction, DeveloperTask_Involvemnet.DeveloperTask_RefID); DeveloperTask.DeveloperTime_CurrentInvestment_min += Parameter.DeveloperTask_InvestedTime; DeveloperTask.Completion_Timestamp = DateTime.Now; DeveloperTask.PercentageComplete = "100"; DeveloperTask.IsComplete = true; DeveloperTask.Save(Connection, Transaction); //Retrieve start task timestamp ORM_TMS_PRO_DeveloperTask_StatusHistory.Query DeveloperTask_History_Query = new ORM_TMS_PRO_DeveloperTask_StatusHistory.Query(); DeveloperTask_History_Query.DeveloperTask_Status_RefID = StatusStarted.TMS_PRO_DeveloperTask_StatusID; DeveloperTask_History_Query.DeveloperTask_RefID = DeveloperTask.TMS_PRO_DeveloperTaskID; DeveloperTask_History_Query.TriggeredBy_ProjectMember_RefID = DeveloperTask_Involvemnet.ProjectMember_RefID; List <ORM_TMS_PRO_DeveloperTask_StatusHistory> statusHistoryResult = ORM_TMS_PRO_DeveloperTask_StatusHistory.Query.Search(Connection, Transaction, DeveloperTask_History_Query); //Status History ORM_TMS_PRO_DeveloperTask_StatusHistory DeveloperTask_StatusHistory = new ORM_TMS_PRO_DeveloperTask_StatusHistory(); DeveloperTask_StatusHistory.DeveloperTask_RefID = DeveloperTask.TMS_PRO_DeveloperTaskID; DeveloperTask_StatusHistory.DeveloperTask_Status_RefID = StatusFinished.TMS_PRO_DeveloperTask_StatusID; DeveloperTask_StatusHistory.TriggeredBy_ProjectMember_RefID = DeveloperTask_Involvemnet.ProjectMember_RefID; DeveloperTask_StatusHistory.Comment = Parameter.DeveloperTask_Comment != ""? "Comment: " + Parameter.DeveloperTask_Comment + "</br>" + "Invested time : " + DeveloperTask_Involvemnet.R_InvestedWorkingTime_min + " minutes": "Invested time: " + DeveloperTask_Involvemnet.R_InvestedWorkingTime_min + " minutes"; DeveloperTask_StatusHistory.Tenant_RefID = securityTicket.TenantID; DeveloperTask_StatusHistory.Save(Connection, Transaction); #endregion #region Charging Level ORM_TMP_PRO_ProjectMember_Type_AvailableChargingLevel DefaultChargingLevel = null; ORM_TMS_PRO_ProjectMember GrabbedByMember = new ORM_TMS_PRO_ProjectMember(); GrabbedByMember.Load(Connection, Transaction, DeveloperTask.GrabbedByMember_RefID); if (GrabbedByMember != null) { ORM_TMP_PRO_ProjectMember_Type_AvailableChargingLevel.Query ChargingLevelQuery = new ORM_TMP_PRO_ProjectMember_Type_AvailableChargingLevel.Query(); ChargingLevelQuery.ProjectMember_Type_RefID = GrabbedByMember.ProjectMember_Type_RefID; ChargingLevelQuery.IsDeleted = false; List <ORM_TMP_PRO_ProjectMember_Type_AvailableChargingLevel> AvailbaleChargingLevels = ORM_TMP_PRO_ProjectMember_Type_AvailableChargingLevel.Query.Search(Connection, Transaction, ChargingLevelQuery); if (AvailbaleChargingLevels.Exists(acl => acl.IsDefault)) { DefaultChargingLevel = AvailbaleChargingLevels.Where(acl => acl.IsDefault).FirstOrDefault(); } else if (AvailbaleChargingLevels.Count > 0) { DefaultChargingLevel = AvailbaleChargingLevels.FirstOrDefault(); } } #endregion #region Invested WorkTimes //User Account ORM_USR_Account UserAccount = new ORM_USR_Account(); UserAccount.Load(Connection, Transaction, securityTicket.AccountID); ORM_CMN_BPT_InvestedWorkTime InvestedWorkTimes = new ORM_CMN_BPT_InvestedWorkTime(); InvestedWorkTimes.BusinessParticipant_RefID = UserAccount.BusinessParticipant_RefID; InvestedWorkTimes.WorkTime_Start = statusHistoryResult.OrderBy(c => c.Creation_Timestamp).LastOrDefault().Creation_Timestamp; InvestedWorkTimes.WorkTime_Amount_min = Parameter.DeveloperTask_InvestedTime; InvestedWorkTimes.WorkTime_InternalIdentifier = cls_Get_New_InvestedWorkTime_Identifier.Invoke(Connection, Transaction, securityTicket).Result.IWT_Identifier; InvestedWorkTimes.WorkTime_Source = "DanuTask - [D" + DeveloperTask.IdentificationNumber + "] " + DeveloperTask.Name; InvestedWorkTimes.WorkTime_Comment.AddEntry(Parameter.LanguageID, Parameter.DeveloperTask_Comment); InvestedWorkTimes.ChargingLevel_RefID = DefaultChargingLevel != null ? DefaultChargingLevel.ChargingLevel_RefID : Guid.Empty; InvestedWorkTimes.Tenant_RefID = securityTicket.TenantID; InvestedWorkTimes.Save(Connection, Transaction); #endregion #region Developer Task Involvements Invested time ORM_TMS_PRO_DeveloperTask_Involvements_InvestedWorkTime DeveloperTaskInvolvements_InvestedTime = new ORM_TMS_PRO_DeveloperTask_Involvements_InvestedWorkTime(); DeveloperTaskInvolvements_InvestedTime.CMN_BPT_InvestedWorkTime_RefID = InvestedWorkTimes.CMN_BPT_InvestedWorkTimeID; DeveloperTaskInvolvements_InvestedTime.TMS_PRO_DeveloperTask_Involvement_RefID = DeveloperTask_Involvemnet.TMS_PRO_DeveloperTask_InvolvementID; DeveloperTaskInvolvements_InvestedTime.Tenant_RefID = securityTicket.TenantID; DeveloperTaskInvolvements_InvestedTime.Save(Connection, Transaction); #endregion return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6DT_SDT_1700 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); if (Parameter.Delete) { //DELETING DEV TASK ORM_TMS_PRO_DeveloperTask developerTaskToDelete = ORM_TMS_PRO_DeveloperTask.Query.Search(Connection, Transaction, new ORM_TMS_PRO_DeveloperTask.Query() { TMS_PRO_DeveloperTaskID = Parameter.DeveloperTaskID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }).Single(); developerTaskToDelete.IsDeleted = true; developerTaskToDelete.Save(Connection, Transaction); //DELETING FEATURE 2 TAG ORM_TMS_PRO_Feature_2_DeveloperTask Feature_2_DeveloperTask2Delete = ORM_TMS_PRO_Feature_2_DeveloperTask.Query.Search(Connection, Transaction, new ORM_TMS_PRO_Feature_2_DeveloperTask.Query() { DeveloperTask_RefID = Parameter.DeveloperTaskID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }).Single(); Feature_2_DeveloperTask2Delete.IsDeleted = true; Feature_2_DeveloperTask2Delete.Save(Connection, Transaction); //DELETING STATUS HISTORY var statusHistory2Delete = ORM_TMS_PRO_DeveloperTask_StatusHistory.Query.Search(Connection, Transaction, new ORM_TMS_PRO_DeveloperTask_StatusHistory.Query() { DeveloperTask_RefID = Parameter.DeveloperTaskID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }); foreach (var history in statusHistory2Delete) { history.IsDeleted = true; history.Save(Connection, Transaction); } //DELETING DEV TASK 2 TAG var developerTask2Tags = ORM_TMS_PRO_DeveloperTask_2_Tag.Query.Search(Connection, Transaction, new ORM_TMS_PRO_DeveloperTask_2_Tag.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, DeveloperTask_RefID = Parameter.DeveloperTaskID } ); foreach (var developerTask2Tag in developerTask2Tags) { developerTask2Tag.IsDeleted = true; developerTask2Tag.Save(Connection, Transaction); } //DELETING PRODUCT RELEASES 2 DEV TASK var productReleases2DevTask = ORM_CMN_PRO_Product_Release_2_DeveloperTask.Query.Search(Connection, Transaction, new ORM_CMN_PRO_Product_Release_2_DeveloperTask.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, TMS_PRO_DeveloperTask_RefID = Parameter.DeveloperTaskID }); foreach (var productRelease in productReleases2DevTask) { productRelease.IsDeleted = true; productRelease.Save(Connection, Transaction); } //DELETING DEV TASK INVOLVEMENTS var involment_query = new ORM_TMS_PRO_DeveloperTask_Involvement.Query(); involment_query.DeveloperTask_RefID = Parameter.DeveloperTaskID; involment_query.Tenant_RefID = securityTicket.TenantID; 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); } } //DELETING RECOMENDATIONS var devTaskRecomentations = ORM_TMS_PRO_DeveloperTask_Recommendation.Query.Search(Connection, Transaction, new ORM_TMS_PRO_DeveloperTask_Recommendation.Query() { DeveloperTask_RefID = Parameter.DeveloperTaskID, Tenant_RefID = securityTicket.TenantID, IsDeleted = false }); foreach (var devTaskRecomendation in devTaskRecomentations) { devTaskRecomendation.IsDeleted = true; devTaskRecomendation.Save(Connection, Transaction); } //deleting peers development var peersDevelopment = ORM_TMS_PRO_Peers_Development.Query.Search(Connection, Transaction, new ORM_TMS_PRO_Peers_Development.Query() { DeveloperTask_RefID = Parameter.DeveloperTaskID, Tenant_RefID = securityTicket.TenantID, IsDeleted = false }); foreach (var item in peersDevelopment) { item.IsDeleted = true; item.Save(Connection, Transaction); } returnValue.Result = Parameter.DeveloperTaskID; } if (Parameter.Archive) { ORM_TMS_PRO_DeveloperTask developerTaskToArchive = ORM_TMS_PRO_DeveloperTask.Query.Search(Connection, Transaction, new ORM_TMS_PRO_DeveloperTask.Query() { TMS_PRO_DeveloperTaskID = Parameter.DeveloperTaskID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }).Single(); developerTaskToArchive.IsArchived = true; developerTaskToArchive.Save(Connection, Transaction); } return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6DT_CADT_1453 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_Guid(); #region Activated var activatedParam = new P_L2DT_GDTSfGPM_1121(); activatedParam.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EDeveloperTaskHistory.Activated); var activatedID = cls_Get_DeveloperTaskStatus_for_GlobalPropertyMatchingID.Invoke(Connection, Transaction, activatedParam, securityTicket).Result; #endregion #region Started var startedParam = new P_L2DT_GDTSfGPM_1121(); startedParam.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EDeveloperTaskHistory.Started); var startedID = cls_Get_DeveloperTaskStatus_for_GlobalPropertyMatchingID.Invoke(Connection, Transaction, startedParam, securityTicket).Result; #endregion #region Deactivated var deactivatedParam = new P_L2DT_GDTSfGPM_1121(); deactivatedParam.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EDeveloperTaskHistory.Deactivated); var deactivatedID = cls_Get_DeveloperTaskStatus_for_GlobalPropertyMatchingID.Invoke(Connection, Transaction, deactivatedParam, securityTicket).Result; #endregion #region ORM_TMS_PRO_DeveloperTask_2_ProjectMember //Load New ORM_TMS_PRO_DeveloperTask_Involvement newActive = new ORM_TMS_PRO_DeveloperTask_Involvement(); if (Parameter.AssignmentID_newActive != Guid.Empty) { newActive.Load(Connection, Transaction, Parameter.AssignmentID_newActive); } //Load Old ORM_TMS_PRO_DeveloperTask_Involvement oldActive = new ORM_TMS_PRO_DeveloperTask_Involvement(); if (Parameter.AssignmentID_oldActive != Guid.Empty) { oldActive.Load(Connection, Transaction, Parameter.AssignmentID_oldActive); } //Save New if (Parameter.AssignmentID_newActive != Guid.Empty) { newActive.IsActive = true; newActive.OrderSequence = 0; newActive.Save(Connection, Transaction); } //Save Old if (Parameter.AssignmentID_oldActive != Guid.Empty) { oldActive.IsActive = false; oldActive.OrderSequence = newActive.OrderSequence; oldActive.Save(Connection, Transaction); } #endregion ORM_TMS_PRO_DeveloperTask_2_ProjectMember #region ORM_TMS_PRO_DeveloperTask if (Parameter.AssignmentID_newActive != Guid.Empty) { ORM_TMS_PRO_DeveloperTask task = new ORM_TMS_PRO_DeveloperTask(); task.Load(Connection, Transaction, newActive.DeveloperTask_RefID); if (task.IsIncompleteInformation) { task.IsIncompleteInformation = false; task.Save(Connection, Transaction); } } #endregion #region ORM_DeveloperTask_StatusHistory_newActive if (Parameter.AssignmentID_newActive != Guid.Empty) { //Activated ORM_TMS_PRO_DeveloperTask_StatusHistory newActive_history = new ORM_TMS_PRO_DeveloperTask_StatusHistory(); newActive_history.DeveloperTask_RefID = newActive.DeveloperTask_RefID; newActive_history.DeveloperTask_Status_RefID = activatedID.TMS_PRO_DeveloperTask_StatusID; newActive_history.TriggeredBy_ProjectMember_RefID = newActive.ProjectMember_RefID; newActive_history.CreatedFor_ProjectMember_RefID = Guid.Empty; newActive_history.Comment = "Task is activated."; newActive_history.Tenant_RefID = securityTicket.TenantID; newActive_history.Creation_Timestamp = DateTime.Now; newActive_history.Save(Connection, Transaction); //Started newActive_history = new ORM_TMS_PRO_DeveloperTask_StatusHistory(); newActive_history.DeveloperTask_RefID = newActive.DeveloperTask_RefID; newActive_history.DeveloperTask_Status_RefID = startedID.TMS_PRO_DeveloperTask_StatusID; newActive_history.TriggeredBy_ProjectMember_RefID = newActive.ProjectMember_RefID; newActive_history.CreatedFor_ProjectMember_RefID = Guid.Empty; newActive_history.Comment = "Task is started."; newActive_history.Tenant_RefID = securityTicket.TenantID; newActive_history.Creation_Timestamp = DateTime.Now.AddSeconds(2); //add 2 sec to be shure that is last one newActive_history.Save(Connection, Transaction); } #endregion ORM_DeveloperTask_StatusHistory_newActive #region ORM_DeveloperTask_StatusHistory_oldActive if (Parameter.AssignmentID_oldActive != Guid.Empty) { ORM_TMS_PRO_DeveloperTask_StatusHistory oldActive_history = new ORM_TMS_PRO_DeveloperTask_StatusHistory(); //Deactivated oldActive_history.DeveloperTask_RefID = oldActive.DeveloperTask_RefID; oldActive_history.DeveloperTask_Status_RefID = deactivatedID.TMS_PRO_DeveloperTask_StatusID; oldActive_history.TriggeredBy_ProjectMember_RefID = oldActive.ProjectMember_RefID; oldActive_history.CreatedFor_ProjectMember_RefID = Guid.Empty; oldActive_history.Comment = "Task is deactivated."; oldActive_history.Tenant_RefID = securityTicket.TenantID; oldActive_history.Creation_Timestamp = DateTime.Now.AddSeconds(2); //add 2 sec to be shure that is last one oldActive_history.Save(Connection, Transaction); } #endregion ORM_DeveloperTask_StatusHistory_oldActive return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6DT_ADTbD_1314 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_Guid(); #region Assigned var assignedParam = new P_L2DT_GDTSfGPM_1121(); assignedParam.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EDeveloperTaskHistory.Assigned); var assignedID = cls_Get_DeveloperTaskStatus_for_GlobalPropertyMatchingID.Invoke(Connection, Transaction, assignedParam, securityTicket).Result; #endregion #region GetProjectMemeberID and AssignmentID P_L3DT_GPMaAfDTaA_1326 param1 = new P_L3DT_GPMaAfDTaA_1326(); param1.DTaskID = Parameter.DeveloperTask_RefID; L3DT_GPMaAfDTaA_1326 result1 = cls_Get_ProjectMemberID_and_AssignmentID_for_DTaskID_and_AccountID.Invoke(Connection, Transaction, param1, securityTicket).Result; #endregion #region ORM_DeveloperTask_2_ProjectMember #region cls_Get_AssignedTaskCount_for_Account L3DT_GATCfA_1333 result2 = cls_Get_AssignedTaskCount_for_Account.Invoke(Connection, Transaction, securityTicket).Result; if (result2 == null) { result2 = new L3DT_GATCfA_1333(); result2.TaskCount = 0; } #endregion var assignItem = new ORM_TMS_PRO_DeveloperTask_Involvement(); if (result1.TMS_PRO_DeveloperTask_InvolvementID != Guid.Empty) { assignItem.Load(Connection, Transaction, result1.TMS_PRO_DeveloperTask_InvolvementID); } else { assignItem.TMS_PRO_DeveloperTask_InvolvementID = Guid.NewGuid(); assignItem.Tenant_RefID = securityTicket.TenantID; } assignItem.ProjectMember_RefID = result1.TMS_PRO_ProjectMemberID; assignItem.DeveloperTask_RefID = Parameter.DeveloperTask_RefID; assignItem.OrderSequence = result2.TaskCount + 1; assignItem.IsActive = false; assignItem.IsArchived = false; assignItem.IsDeleted = false; assignItem.Developer_CompletionTimeEstimation_min = Parameter.Developer_TimeEstimation_min; assignItem.Save(Connection, Transaction); #endregion #region ORM_TMS_PRO_DeveloperTask var developerTask = new ORM_TMS_PRO_DeveloperTask(); if (Parameter.DeveloperTask_RefID != Guid.Empty) { developerTask.Load(Connection, Transaction, Parameter.DeveloperTask_RefID); } developerTask.GrabbedByMember_RefID = result1.TMS_PRO_ProjectMemberID; developerTask.Save(Connection, Transaction); #endregion #region ORM_DeveloperTask_StatusHistory ORM_TMS_PRO_DeveloperTask_StatusHistory statusHistory = new ORM_TMS_PRO_DeveloperTask_StatusHistory(); statusHistory.DeveloperTask_RefID = Parameter.DeveloperTask_RefID; statusHistory.DeveloperTask_Status_RefID = assignedID.TMS_PRO_DeveloperTask_StatusID; statusHistory.TriggeredBy_ProjectMember_RefID = result1.TMS_PRO_ProjectMemberID; statusHistory.CreatedFor_ProjectMember_RefID = Guid.Empty; statusHistory.Comment = "Estimated time: " + Parameter.Developer_TimeEstimation_min + "[min]"; statusHistory.Tenant_RefID = securityTicket.TenantID; statusHistory.Save(Connection, Transaction); #endregion ORM_DeveloperTask_StatusHistory #region projectInfo var project = new ORM_TMS_PRO_Project(); project.Load(Connection, Transaction, developerTask.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 returnValue.Result = assignItem.TMS_PRO_DeveloperTask_InvolvementID; #region MailSandout //try //{ // L3US_GAAPI_1057 userInfo = cls_Get_ActiveAccount_PersonalInformation.Invoke(Connection, Transaction, securityTicket).Result; // String frontHost = WebConfigurationManager.AppSettings["FrontHost"].ToString(); // String seeDetailsLink = String.Format((String)HttpContext.GetGlobalResourceObject("Global", "Mail_br_and_link"), frontHost, "DTask", developerTask.TMS_PRO_DeveloperTaskID); // String unsubscribeLink = String.Format((String)HttpContext.GetGlobalResourceObject("Global", "Mail_Unsubscribe_Link"), frontHost, "dtask", developerTask.TMS_PRO_DeveloperTaskID.ToString()); // String subject = String.Format((String)HttpContext.GetGlobalResourceObject("Global", "Mail_AssignDeveloperTaskByDeveloper_subject"), projectName, statusLabel, developerTask.IdentificationNumber, developerTask.Name); // P_L3DT_GPfDT_1659 prm = new P_L3DT_GPfDT_1659(); // prm.DTaskID = developerTask.TMS_PRO_DeveloperTaskID; // List<L3DT_GPfDT_1659> ress = cls_Get_Peers_for_DTaskID.Invoke(Connection, Transaction, prm, securityTicket).Result.ToList(); // P_L3US_GUIfA_1241 usParameter = new P_L3US_GUIfA_1241(); // usParameter.UserAccountID = securityTicket.AccountID; // L3US_GUIfA_1241 emailInfo = cls_Get_UserInformation_for_AccountID.Invoke(Connection, Transaction, usParameter, securityTicket).Result; // MailMessage mail = DanuTaskMailGenerator.formatMailMessage(false, false, EnumMailTypes.DTask); // foreach (var x in ress.Select(s => s.PrimaryEmail).Distinct()) // { // if (!mail.To.Contains(new MailAddress(x))) // mail.To.Add(x); // } // mail.Subject = subject; // mail.Body = mail.Body.Replace("{ProjectName}", projectName); // mail.Body = mail.Body.Replace("{Role}", String.Format((String)HttpContext.GetGlobalResourceObject("Global", "Developer"))); // mail.Body = mail.Body.Replace("{status}", statusLabel); // mail.Body = mail.Body.Replace("{DTaskNumber}", "D" + developerTask.IdentificationNumber); // mail.Body = mail.Body.Replace("{DTaskName}", developerTask.Name); // mail.Body = mail.Body.Replace("{action}", String.Format((String)HttpContext.GetGlobalResourceObject("Global", "Mail_DTask_AssignedbyDeveloper"))); // mail.Body = mail.Body.Replace("{FirstName}", userInfo.FirstName); // mail.Body = mail.Body.Replace("{LastName}", userInfo.LastName); // mail.Body = mail.Body.Replace("{userName}", userInfo.Username); // mail.Body = mail.Body.Replace("{UserFullName}", userInfo.FirstName + " " + userInfo.LastName); // mail.Body = mail.Body.Replace("{bodyText}", String.Format((String)HttpContext.GetGlobalResourceObject("Global", "Mail_DTask_AssignedDTask")) + " " + developerTask.Name + String.Format((String)HttpContext.GetGlobalResourceObject("Global", "Mail_inProject")) + " " + projectName + String.Format((String)HttpContext.GetGlobalResourceObject("Global", "Mail_DTaskAssignedToHimself"))); // DateTime dateToDisplay = DateTime.Now; // mail.Body = mail.Body.Replace("{date}", dateToDisplay.ToShortDateString()); // mail.Body = mail.Body.Replace("{time}", dateToDisplay.ToShortTimeString()); // mail.Body = mail.Body.Replace("{itemType}", String.Format((String)HttpContext.GetGlobalResourceObject("Global", "Mail_DeveloperTask"))); // mail.Body = mail.Body.Replace("{ItemName}", developerTask.Name); // mail.Body = mail.Body.Replace("$$$seeDetailsLink$$$", seeDetailsLink); // mail.Body = mail.Body.Replace("$$$unsubscribeLink$$$", unsubscribeLink); // if (mail.To.Count > 0) // { // SmtpClient smtpClient = new SmtpClient(); // smtpClient.Send(mail); // } //} //catch //{ //} #endregion return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3DT_SDT_1808 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 #region StatusID's var Parameter_StoppedStatus = new P_L2DT_GDTSfGPM_1121(); Parameter_StoppedStatus.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EDeveloperTaskHistory.Stopped); var StoppedStatus_ID = cls_Get_DeveloperTaskStatus_for_GlobalPropertyMatchingID.Invoke(Connection, Transaction, Parameter_StoppedStatus, securityTicket).Result; #endregion #region Involvement ORM_TMS_PRO_DeveloperTask_Involvement DeveloperTask_Involvement = new ORM_TMS_PRO_DeveloperTask_Involvement(); DeveloperTask_Involvement.Load(Connection, Transaction, Parameter.DeveloperTask_InvolvementID); //Update invested time on involvement DeveloperTask_Involvement.R_InvestedWorkingTime_min += Parameter.DeveloperTask_InvestedTime; DeveloperTask_Involvement.Save(Connection, Transaction); #endregion #region Developer task ORM_TMS_PRO_DeveloperTask DeveloperTask = new ORM_TMS_PRO_DeveloperTask(); DeveloperTask.Load(Connection, Transaction, Parameter.DeveloperTask_ID); DeveloperTask.IsIncompleteInformation = Parameter.DeveloperTask_IsMissingInfo; DeveloperTask.PercentageComplete = Parameter.DeveloperTask_PercentageComplete.ToString(); DeveloperTask.DeveloperTime_CurrentInvestment_min += Parameter.DeveloperTask_InvestedTime; DeveloperTask.Save(Connection, Transaction); #endregion #region Update developer task status history ORM_TMS_PRO_DeveloperTask_StatusHistory DeveloperTask_StatusHistory = new ORM_TMS_PRO_DeveloperTask_StatusHistory(); DeveloperTask_StatusHistory.DeveloperTask_RefID = Parameter.DeveloperTask_ID; DeveloperTask_StatusHistory.DeveloperTask_Status_RefID = StoppedStatus_ID.TMS_PRO_DeveloperTask_StatusID; DeveloperTask_StatusHistory.TriggeredBy_ProjectMember_RefID = DeveloperTask_Involvement.ProjectMember_RefID; DeveloperTask_StatusHistory.CreatedFor_ProjectMember_RefID = Guid.Empty; DeveloperTask_StatusHistory.Comment = Parameter.DeveloperTask_StopComment != "" ? "Comment: " + Parameter.DeveloperTask_StopComment + "</br>" : ""; DeveloperTask_StatusHistory.Comment += "Total invested time: " + DeveloperTask_Involvement.R_InvestedWorkingTime_min + " minutes" + "</br>" + "Current invested time: " + Parameter.DeveloperTask_InvestedTime + " minutes" + "</br>" + " Percentage complete: " + Parameter.DeveloperTask_PercentageComplete + "%\n"; DeveloperTask_StatusHistory.Tenant_RefID = securityTicket.TenantID; DeveloperTask_StatusHistory.Save(Connection, Transaction); if (Parameter.DeveloperTask_IsMissingInfo) { //TODO: Change active developer task var Parameter_MissingInfoStatus = new P_L2DT_GDTSfGPM_1121(); Parameter_MissingInfoStatus.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EDeveloperTaskHistory.MissingInfo); var MissingInfoStatus_ID = cls_Get_DeveloperTaskStatus_for_GlobalPropertyMatchingID.Invoke(Connection, Transaction, Parameter_MissingInfoStatus, securityTicket).Result; DeveloperTask_StatusHistory = new ORM_TMS_PRO_DeveloperTask_StatusHistory(); DeveloperTask_StatusHistory.DeveloperTask_RefID = Parameter.DeveloperTask_ID; DeveloperTask_StatusHistory.DeveloperTask_Status_RefID = MissingInfoStatus_ID.TMS_PRO_DeveloperTask_StatusID; DeveloperTask_StatusHistory.TriggeredBy_ProjectMember_RefID = DeveloperTask_Involvement.ProjectMember_RefID; DeveloperTask_StatusHistory.CreatedFor_ProjectMember_RefID = Guid.Empty; DeveloperTask_StatusHistory.Comment = Parameter.DeveloperTask_StopComment; DeveloperTask_StatusHistory.Tenant_RefID = securityTicket.TenantID; DeveloperTask_StatusHistory.Save(Connection, Transaction); } #endregion #region Load user account ORM_USR_Account UserAccount = new ORM_USR_Account(); UserAccount.Load(Connection, Transaction, securityTicket.AccountID); #endregion #region Default charging level ORM_TMP_PRO_ProjectMember_Type_AvailableChargingLevel DefaultChargingLevel = null; ORM_TMS_PRO_ProjectMember DeveloperTask_GrabbedByMember = new ORM_TMS_PRO_ProjectMember(); DeveloperTask_GrabbedByMember.Load(Connection, Transaction, DeveloperTask.GrabbedByMember_RefID); if (DeveloperTask_GrabbedByMember != null) { ORM_TMP_PRO_ProjectMember_Type_AvailableChargingLevel.Query SelectChargingLevel = new ORM_TMP_PRO_ProjectMember_Type_AvailableChargingLevel.Query(); SelectChargingLevel.ProjectMember_Type_RefID = DeveloperTask_GrabbedByMember.ProjectMember_Type_RefID; SelectChargingLevel.IsDeleted = false; List <ORM_TMP_PRO_ProjectMember_Type_AvailableChargingLevel> AvailableChargingLevels = ORM_TMP_PRO_ProjectMember_Type_AvailableChargingLevel.Query.Search(Connection, Transaction, SelectChargingLevel); if (AvailableChargingLevels.Count > 0) { if (AvailableChargingLevels.Exists(acl => acl.IsDefault)) { DefaultChargingLevel = AvailableChargingLevels.Where(acl => acl.IsDefault).FirstOrDefault(); } else { DefaultChargingLevel = AvailableChargingLevels.FirstOrDefault(); } } } #endregion #region Invested work times ORM_CMN_BPT_InvestedWorkTime InvestedWorkTimes = new ORM_CMN_BPT_InvestedWorkTime(); InvestedWorkTimes.BusinessParticipant_RefID = UserAccount.BusinessParticipant_RefID; InvestedWorkTimes.ChargingLevel_RefID = DefaultChargingLevel != null ? DefaultChargingLevel.ChargingLevel_RefID : Guid.Empty; InvestedWorkTimes.Tenant_RefID = securityTicket.TenantID; InvestedWorkTimes.WorkTime_Amount_min = Parameter.DeveloperTask_InvestedTime; InvestedWorkTimes.WorkTime_Comment.AddEntry(Parameter.LanguageID, Parameter.DeveloperTask_StopComment); InvestedWorkTimes.WorkTime_Start = DateTime.Now.AddMinutes(-Parameter.DeveloperTask_InvestedTime); InvestedWorkTimes.WorkTime_InternalIdentifier = cls_Get_New_InvestedWorkTime_Identifier.Invoke(Connection, Transaction, securityTicket).Result.IWT_Identifier; InvestedWorkTimes.WorkTime_Source = "Danutask - [D" + DeveloperTask.IdentificationNumber + "] " + DeveloperTask.Name; InvestedWorkTimes.Tenant_RefID = securityTicket.TenantID; InvestedWorkTimes.WorkTime_Comment.AddEntry(Parameter.LanguageID, Parameter.DeveloperTask_StopComment); InvestedWorkTimes.Save(Connection, Transaction); #endregion #region Developer task invested work times ORM_TMS_PRO_DeveloperTask_Involvements_InvestedWorkTime DeveloperTaskInvolvement_InvestedTime = new ORM_TMS_PRO_DeveloperTask_Involvements_InvestedWorkTime(); DeveloperTaskInvolvement_InvestedTime.CMN_BPT_InvestedWorkTime_RefID = InvestedWorkTimes.CMN_BPT_InvestedWorkTimeID; DeveloperTaskInvolvement_InvestedTime.TMS_PRO_DeveloperTask_Involvement_RefID = DeveloperTask_Involvement.TMS_PRO_DeveloperTask_InvolvementID; DeveloperTaskInvolvement_InvestedTime.Tenant_RefID = securityTicket.TenantID; DeveloperTaskInvolvement_InvestedTime.Save(Connection, Transaction); #endregion return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6DT_DDTbD_0958 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 #region Deassigned var deassignedParam = new P_L2DT_GDTSfGPM_1121(); deassignedParam.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EDeveloperTaskHistory.Deassigned); var deassignedID = cls_Get_DeveloperTaskStatus_for_GlobalPropertyMatchingID.Invoke(Connection, Transaction, deassignedParam, securityTicket).Result; #endregion #region Delete Assignement ORM_TMS_PRO_DeveloperTask_Involvement assignment = new ORM_TMS_PRO_DeveloperTask_Involvement(); assignment.Load(Connection, Transaction, Parameter.AssigmentID); assignment.IsActive = false; assignment.IsDeleted = true; assignment.Save(Connection, Transaction); #endregion #region Update Developer Task ORM_TMS_PRO_DeveloperTask task = new ORM_TMS_PRO_DeveloperTask(); task.Load(Connection, Transaction, assignment.DeveloperTask_RefID); task.GrabbedByMember_RefID = Guid.Empty; task.Save(Connection, Transaction); #endregion #region Create Developer Task Status History ORM_TMS_PRO_DeveloperTask_StatusHistory statusHistory = new ORM_TMS_PRO_DeveloperTask_StatusHistory(); statusHistory.TMS_PRO_DeveloperTask_StatusHistoryID = Guid.NewGuid(); statusHistory.DeveloperTask_RefID = assignment.DeveloperTask_RefID; statusHistory.DeveloperTask_Status_RefID = deassignedID.TMS_PRO_DeveloperTask_StatusID; statusHistory.TriggeredBy_ProjectMember_RefID = assignment.ProjectMember_RefID; statusHistory.CreatedFor_ProjectMember_RefID = Guid.Empty; statusHistory.Comment = "Task has been deasigned."; statusHistory.Creation_Timestamp = DateTime.Now.AddSeconds(6); statusHistory.Tenant_RefID = securityTicket.TenantID; statusHistory.Save(Connection, Transaction); #endregion #region projectInfo var project = new ORM_TMS_PRO_Project(); project.Load(Connection, Transaction, task.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 //TO DO: #region MailSandout //try //{ // var dt2pm = new ORM_TMS_PRO_DeveloperTask_Involvement(); // dt2pm.Load(Connection, Transaction, Parameter.AssigmentID); // var projectMember = new ORM_TMS_PRO_ProjectMember(); // projectMember.Load(Connection, Transaction, dt2pm.ProjectMember_RefID); // P_L3US_GUIfA_1241 userParam = new P_L3US_GUIfA_1241(); // userParam.UserAccountID = projectMember.USR_Account_RefID; // L3US_GUIfA_1241 devInfo = cls_Get_UserInformation_for_AccountID.Invoke(Connection, Transaction, userParam, securityTicket).Result; // String frontHost = WebConfigurationManager.AppSettings["FrontHost"].ToString(); // String unsubscribeLink = String.Format((String)HttpContext.GetGlobalResourceObject("Global", "Mail_Unsubscribe_Link"), frontHost, "dtask", task.TMS_PRO_DeveloperTaskID.ToString()); // String seeDetailsLink = String.Format((String)HttpContext.GetGlobalResourceObject("Global", "Mail_br_and_link"), frontHost, "DTask", task.TMS_PRO_DeveloperTaskID); // String subject = String.Format((String)HttpContext.GetGlobalResourceObject("Global", "Mail_DeasignDeveloperTask_subject"), projectName, statusLabel, task.IdentificationNumber, task.Name); // P_L3DT_GPfDT_1659 prm = new P_L3DT_GPfDT_1659(); // prm.DTaskID = task.TMS_PRO_DeveloperTaskID; // List<L3DT_GPfDT_1659> ress = cls_Get_Peers_for_DTaskID.Invoke(Connection, Transaction, prm, securityTicket).Result.ToList(); // P_L3US_GUIfA_1241 usParameter = new P_L3US_GUIfA_1241(); // usParameter.UserAccountID = securityTicket.AccountID; // L3US_GUIfA_1241 emailInfo = cls_Get_UserInformation_for_AccountID.Invoke(Connection, Transaction, usParameter, securityTicket).Result; // MailMessage mail = DanuTaskMailGenerator.formatMailMessage(true, false, EnumMailTypes.DTask); // foreach (var x in ress.Select(s => s.PrimaryEmail).Distinct()) // { // if (!mail.To.Contains(new MailAddress(x))) // mail.To.Add(x); // } // mail.Subject = subject; // mail.Body = mail.Body.Replace("{ProjectName}", projectName); // mail.Body = mail.Body.Replace("{Role}", String.Format((String)HttpContext.GetGlobalResourceObject("Global", "Developer"))); // mail.Body = mail.Body.Replace("{status}", statusLabel); // mail.Body = mail.Body.Replace("{DTaskNumber}", "D" + task.IdentificationNumber); // mail.Body = mail.Body.Replace("{DTaskName}", task.Name); // mail.Body = mail.Body.Replace("{action}", String.Format((String)HttpContext.GetGlobalResourceObject("Global", "Mail_DTask_Deassigned"))); // mail.Body = mail.Body.Replace("{FirstName}", devInfo.FirstName); // mail.Body = mail.Body.Replace("{LastName}", devInfo.LastName); // mail.Body = mail.Body.Replace("{userName}", devInfo.Username); // mail.Body = mail.Body.Replace("{bodyText}", String.Format((String)HttpContext.GetGlobalResourceObject("Global", "Mail_DTask_DeassignedDTask")) + " " + task.Name + String.Format((String)HttpContext.GetGlobalResourceObject("Global", "Mail_inProject")) + " " + projectName + " " + String.Format((String)HttpContext.GetGlobalResourceObject("Global", "Mail_Dtask_Deassigned_to"))); // mail.Body = mail.Body.Replace("{UserFullName}", devInfo.FirstName + " " + devInfo.LastName); // DateTime dateToDisplay = DateTime.Now; // mail.Body = mail.Body.Replace("{date}", dateToDisplay.ToShortDateString()); // mail.Body = mail.Body.Replace("{time}", dateToDisplay.ToShortTimeString()); // mail.Body = mail.Body.Replace("{itemType}", String.Format((String)HttpContext.GetGlobalResourceObject("Global", "Mail_DeveloperTask"))); // mail.Body = mail.Body.Replace("{ItemName}", task.Name); // mail.Body = mail.Body.Replace("{commentText}", "Task has been deasigned."); // mail.Body = mail.Body.Replace("$$$seeDetailsLink$$$", seeDetailsLink); // mail.Body = mail.Body.Replace("$$$unsubscribeLink$$$", unsubscribeLink); // if (mail.To.Count > 0) // { // SmtpClient smtpClient = new SmtpClient(); // smtpClient.Send(mail); // } //} //catch //{ //} #endregion return(returnValue); #endregion UserCode }