protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6PG_ACLtPMT_1610 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
ORM_TMP_PRO_ProjectMember_Type_AvailableChargingLevel.Query searchQuery = new ORM_TMP_PRO_ProjectMember_Type_AvailableChargingLevel.Query();
searchQuery.ProjectMember_Type_RefID = Parameter.ProjectMemberTypeID;
ORM_TMP_PRO_ProjectMember_Type_AvailableChargingLevel.Query updateQuery = new ORM_TMP_PRO_ProjectMember_Type_AvailableChargingLevel.Query();
updateQuery.IsDeleted = true;
ORM_TMP_PRO_ProjectMember_Type_AvailableChargingLevel.Query.Update(Connection, Transaction, searchQuery, updateQuery);
foreach (Guid currentChargingLevel in Parameter.ChargingLevelIDs)
{
ORM_TMP_PRO_ProjectMember_Type_AvailableChargingLevel cl = new ORM_TMP_PRO_ProjectMember_Type_AvailableChargingLevel();
cl.ChargingLevel_RefID = currentChargingLevel;
cl.ProjectMember_Type_RefID = Parameter.ProjectMemberTypeID;
cl.Tenant_RefID = securityTicket.TenantID;
if (Parameter.DefaultLevelID == currentChargingLevel)
{
cl.IsDefault = true;
}
else
{
cl.IsDefault = false;
}
cl.Save(Connection, Transaction);
}
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_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
}
