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_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
}
///<summary>
/// Method Invocation of wrapper classes
///<summary>
protected static FR_Guid Invoke(DbConnection Connection, DbTransaction Transaction, string ConnectionString, P_L6DT_ADTbD_1314 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_Assign_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_ADTbD_1314 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_ADTbD_1314 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
return(Invoke(null, null, ConnectionString, Parameter, securityTicket));
}
