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_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_L3QT_SQT_0905 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
var item = new ORM_TMS_QuickTask();
if (Parameter.TMS_QuickTaskID != Guid.Empty)
{
var result = item.Load(Connection, Transaction, Parameter.TMS_QuickTaskID);
if (result.Status != FR_Status.Success || item.TMS_QuickTaskID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
if (Parameter.IsDeleted == true)
{
#region Delete ORM_CMN_BPT_InvestedWorkTime
var qtinv_query = new ORM_TMS_QuickTask_InvestedWorkTime.Query();
qtinv_query.TMS_QuickTasks_RefID = item.TMS_QuickTaskID;
qtinv_query.IsDeleted = false;
var qtinv = ORM_TMS_QuickTask_InvestedWorkTime.Query.Search(Connection, Transaction, qtinv_query);
foreach (var qt in qtinv)
{
qt.IsDeleted = true;
qt.Save(Connection, Transaction);
var inv_query = new ORM_CMN_BPT_InvestedWorkTime.Query();
inv_query.CMN_BPT_InvestedWorkTimeID = qt.CMN_BPT_InvestedWorkTime_RefID;
inv_query.IsDeleted = false;
ORM_CMN_BPT_InvestedWorkTime.Query.SoftDelete(Connection, Transaction, inv_query);
}
#endregion
item.IsDeleted = true;
return(new FR_Guid(item.Save(Connection, Transaction), item.TMS_QuickTaskID));
}
//Creation specific parameters (Tenant, Account ... )
if (Parameter.TMS_QuickTaskID == Guid.Empty)
{
item.QuickTask_CreatedByAccount_RefID = securityTicket.AccountID;
item.Tenant_RefID = securityTicket.TenantID;
#region Define IdentificationNumber
ORM_TMS_QuickTask.Query query = new ORM_TMS_QuickTask.Query();
query.Tenant_RefID = securityTicket.TenantID;
var count = ORM_TMS_QuickTask.Query.Search(Connection, Transaction, query).Count() + 1;
String identifier = "000000" + count.ToString();
item.IdentificationNumber = identifier.Substring(identifier.Length - 6);
#endregion
#region Define DocumentsL3FE_GFIfF_1455
var structureHeader = new ORM_DOC_Structure_Header();
structureHeader.DOC_Structure_HeaderID = Guid.NewGuid();
structureHeader.Label = Parameter.QuickTask_Title.GetContent(Parameter.LanguageID);
structureHeader.Tenant_RefID = securityTicket.TenantID;
var structureStatusSave = structureHeader.Save(Connection, Transaction);
item.QuickTask_DocumentStructureHeader_RefID = structureHeader.DOC_Structure_HeaderID;
#endregion
#region BusinessParticipient
ORM_USR_Account userAcc = new ORM_USR_Account();
userAcc.Load(Connection, Transaction, securityTicket.AccountID);
#endregion
#region Invested work times
ORM_CMN_BPT_InvestedWorkTime iwt = new ORM_CMN_BPT_InvestedWorkTime();
iwt.BusinessParticipant_RefID = userAcc.BusinessParticipant_RefID;
iwt.WorkTime_Source = "DanuTask - [W" + item.IdentificationNumber + "] " + Parameter.QuickTask_Title.GetContent(Parameter.LanguageID);
iwt.CMN_BPT_InvestedWorkTimeID = Guid.NewGuid();
iwt.WorkTime_Start = Parameter.QuickTask_StartTime;
iwt.WorkTime_Amount_min = (long)Parameter.R_QuickTask_InvestedTime_min;
iwt.WorkTime_InternalIdentifier = cls_Get_NewInvestedWTimeIdentifier.Invoke(Connection, Transaction, securityTicket).Result.Identifier;
iwt.Tenant_RefID = securityTicket.TenantID;
iwt.Save(Connection, Transaction);
ORM_TMS_QuickTask_InvestedWorkTime qtiwt = new ORM_TMS_QuickTask_InvestedWorkTime();
qtiwt.CMN_BPT_InvestedWorkTime_RefID = iwt.CMN_BPT_InvestedWorkTimeID;
qtiwt.Creation_Timestamp = DateTime.Now;
qtiwt.Tenant_RefID = securityTicket.TenantID;
qtiwt.TMS_QuickTask_InvestedWorkTimeID = Guid.NewGuid();
qtiwt.TMS_QuickTasks_RefID = item.TMS_QuickTaskID;
qtiwt.Save(Connection, Transaction);
#endregion
}
else
{
var query = new ORM_TMS_QuickTask_InvestedWorkTime.Query();
query.TMS_QuickTasks_RefID = item.TMS_QuickTaskID;
query.IsDeleted = false;
var result = ORM_TMS_QuickTask_InvestedWorkTime.Query.Search(Connection, Transaction, query).ToArray();
if (result.Count() == 1)
{
ORM_CMN_BPT_InvestedWorkTime iwt = new ORM_CMN_BPT_InvestedWorkTime();
iwt.Load(Connection, Transaction, result[0].CMN_BPT_InvestedWorkTime_RefID);
iwt.WorkTime_Source = "DanuTask - [W" + item.IdentificationNumber + "] " + Parameter.QuickTask_Title.GetContent(Parameter.LanguageID);
iwt.WorkTime_Start = Parameter.QuickTask_StartTime;
iwt.WorkTime_Amount_min = (long)Parameter.R_QuickTask_InvestedTime_min;
iwt.WorkTime_InternalIdentifier = cls_Get_NewInvestedWTimeIdentifier.Invoke(Connection, Transaction, securityTicket).Result.Identifier;
iwt.Save(Connection, Transaction);
}
}
if (item.QuickTask_StartTime != Parameter.QuickTask_StartTime)
{
item.IsManuallyEntered = true;
}
if (item.R_QuickTask_InvestedTime_min != Parameter.R_QuickTask_InvestedTime_min)
{
item.IsManuallyEntered = true;
}
item.QuickTask_Title = Parameter.QuickTask_Title;
item.QuickTask_Description = Parameter.QuickTask_Description;
item.QuickTask_Type_RefID = Parameter.QuickTask_Type_RefID;
item.R_QuickTask_InvestedTime_min = Parameter.R_QuickTask_InvestedTime_min;
item.AssignedTo_Project_RefID = Parameter.AssignedTo_Project_RefID;
item.AssignedTo_BusinessTask_RefID = Parameter.AssignedTo_BusinessTask_RefID;
item.AssignedTo_Feature_RefID = Parameter.AssignedTo_Feature_RefID;
item.AssignedTo_DeveloperTask_RefID = Parameter.AssignedTo_DeveloperTask_RefID;
item.QuickTask_StartTime = Parameter.QuickTask_StartTime;
return(new FR_Guid(item.Save(Connection, Transaction), item.TMS_QuickTaskID));
#endregion UserCode
}
