protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6DT_ADTD_0945 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); //Put your code here P_L6DT_ADTbD_1314 assignParametar = new P_L6DT_ADTbD_1314(); P_L6DT_DDTbD_0958 deassignParametar = new P_L6DT_DDTbD_0958(); if (Parameter.Deassign_DeveloperTaskByDeveloper != null && Parameter.Deassign_DeveloperTaskByDeveloper.ToList().Count() != 0) { foreach (var developerTask in Parameter.Deassign_DeveloperTaskByDeveloper.ToList()) { if (developerTask != Guid.Empty) { deassignParametar.AssigmentID = developerTask; var deassigndeveloperTask = cls_Deassign_DeveloperTask_by_Developer.Invoke(Connection, Transaction, deassignParametar, securityTicket).Result; } } } if (Parameter.Assign_DeveloperTaskByDeveloper != null && Parameter.Assign_DeveloperTaskByDeveloper.ToList().Count() != 0) { foreach (var developertask in Parameter.Assign_DeveloperTaskByDeveloper.ToList()) { if (developertask != Guid.Empty) { assignParametar.DeveloperTask_RefID = developertask; assignParametar.Developer_TimeEstimation_min = Parameter.Estimated_Time; var assigndeveloperTask = cls_Assign_DeveloperTask_by_Developer.Invoke(Connection, Transaction, assignParametar, securityTicket).Result; } } } 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 }
///<summary> /// Method Invocation of wrapper classes ///<summary> protected static FR_Guid Invoke(DbConnection Connection, DbTransaction Transaction, string ConnectionString, P_L6DT_DDTbD_0958 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { bool cleanupConnection = Connection == null; bool cleanupTransaction = Transaction == null; FR_Guid functionReturn = new FR_Guid(); try { if (cleanupConnection == true) { Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString); Connection.Open(); } if (cleanupTransaction == true) { Transaction = Connection.BeginTransaction(); } functionReturn = Execute(Connection, Transaction, Parameter, securityTicket); #region Cleanup Connection/Transaction //Commit the transaction if (cleanupTransaction == true) { Transaction.Commit(); } //Close the connection if (cleanupConnection == true) { Connection.Close(); } #endregion } catch (Exception ex) { try { if (cleanupTransaction == true && Transaction != null) { Transaction.Rollback(); } } catch { } try { if (cleanupConnection == true && Connection != null) { Connection.Close(); } } catch { } throw new Exception("Exception occured in method cls_Deassign_DeveloperTask_by_Developer", ex); } return(functionReturn); }
///<summary> /// Invokes the method for the given Connection, and Transaction, leaving them open/not commited if no exceptions occured ///<summary> public static FR_Guid Invoke(DbConnection Connection, DbTransaction Transaction, P_L6DT_DDTbD_0958 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { return(Invoke(Connection, Transaction, null, Parameter, securityTicket)); }
///<summary> /// Opens the connection/transaction for the given connectionString, and closes them when complete ///<summary> public static FR_Guid Invoke(string ConnectionString, P_L6DT_DDTbD_0958 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { return(Invoke(null, null, ConnectionString, Parameter, securityTicket)); }