protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6US_SURT_0947 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 //Save usr_account_applicationsetting-definition ORM_USR_Account_ApplicationSetting_Definition SettingsDefinition = new ORM_USR_Account_ApplicationSetting_Definition(); ORM_USR_Account_ApplicationSetting_Definition.Query ApplicationSettingsDefinitionQuery = new ORM_USR_Account_ApplicationSetting_Definition.Query(); ApplicationSettingsDefinitionQuery.ApplicationID = STDL_ApplicationIdentification.ApplicationID; ApplicationSettingsDefinitionQuery.ItemKey = EnumUtils.GetEnumDescription(RunningTimes.Item_Key); ApplicationSettingsDefinitionQuery.Tenant_RefID = securityTicket.TenantID; ApplicationSettingsDefinitionQuery.IsDeleted = false; if (!ORM_USR_Account_ApplicationSetting_Definition.Query.Exists(Connection, Transaction, ApplicationSettingsDefinitionQuery)) { SettingsDefinition.ApplicationID = STDL_ApplicationIdentification.ApplicationID; SettingsDefinition.DefaultValue = Parameter.RunningTimesXML; SettingsDefinition.ItemKey = EnumUtils.GetEnumDescription(RunningTimes.Item_Key); SettingsDefinition.Tenant_RefID = securityTicket.TenantID; SettingsDefinition.Save(Connection, Transaction); } else { SettingsDefinition = ORM_USR_Account_ApplicationSetting_Definition.Query.Search(Connection, Transaction, ApplicationSettingsDefinitionQuery).FirstOrDefault(); SettingsDefinition.DefaultValue = Parameter.RunningTimesXML; SettingsDefinition.Save(Connection, Transaction); } ORM_USR_Account_ApplicationSetting ApplicationSettings = new ORM_USR_Account_ApplicationSetting(); ORM_USR_Account_ApplicationSetting.Query ApplicationSettingsQuery = new ORM_USR_Account_ApplicationSetting.Query(); ApplicationSettingsQuery.Account_RefID = securityTicket.AccountID; ApplicationSettingsQuery.ApplicationSetting_Definition_RefID = SettingsDefinition.USR_Account_ApplicationSetting_DefinitionID; if (!ORM_USR_Account_ApplicationSetting.Query.Exists(Connection, Transaction, ApplicationSettingsQuery)) { ApplicationSettings.Account_RefID = securityTicket.AccountID; ApplicationSettings.ApplicationSetting_Definition_RefID = SettingsDefinition.USR_Account_ApplicationSetting_DefinitionID; ApplicationSettings.ItemValue = EnumUtils.GetEnumDescription(RunningTimes.Item_Key); ApplicationSettings.Tenant_RefID = securityTicket.TenantID; ApplicationSettings.Save(Connection, Transaction); } return(returnValue); #endregion UserCode }
protected static FR_L6US_GURT_1054 Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_L6US_GURT_1054(); //Put your code here returnValue.Result = new L6US_GURT_1054(); ORM_USR_Account_ApplicationSetting.Query ApplicationSettingsQuery = new ORM_USR_Account_ApplicationSetting.Query(); ApplicationSettingsQuery.Account_RefID = securityTicket.AccountID; ApplicationSettingsQuery.Tenant_RefID = securityTicket.TenantID; ApplicationSettingsQuery.ItemValue = EnumUtils.GetEnumDescription(RunningTimes.Item_Key); if (ORM_USR_Account_ApplicationSetting.Query.Exists(Connection, Transaction, ApplicationSettingsQuery)) { Guid DefinitionID = ORM_USR_Account_ApplicationSetting.Query.Search(Connection, Transaction, ApplicationSettingsQuery).FirstOrDefault().ApplicationSetting_Definition_RefID; ORM_USR_Account_ApplicationSetting_Definition ApplicationDefinition = new ORM_USR_Account_ApplicationSetting_Definition(); ApplicationDefinition.Load(Connection, Transaction, DefinitionID); returnValue.Result.UserRunningTimesXML = ApplicationDefinition.DefaultValue; } return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6US_SURTRWT_0947 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); //Put your code here ORM_USR_Account_ApplicationSetting.Query ApplicationSettingsQuery = new ORM_USR_Account_ApplicationSetting.Query(); ApplicationSettingsQuery.Account_RefID = securityTicket.AccountID; ApplicationSettingsQuery.Tenant_RefID = securityTicket.TenantID; ApplicationSettingsQuery.ItemValue = EnumUtils.GetEnumDescription(RunningTimes.Item_Key); if (ORM_USR_Account_ApplicationSetting.Query.Exists(Connection, Transaction, ApplicationSettingsQuery)) { Guid DefinitionID = ORM_USR_Account_ApplicationSetting.Query.Search(Connection, Transaction, ApplicationSettingsQuery).FirstOrDefault().ApplicationSetting_Definition_RefID; ORM_USR_Account_ApplicationSetting_Definition ApplicationDefinition = new ORM_USR_Account_ApplicationSetting_Definition(); ApplicationDefinition.Load(Connection, Transaction, DefinitionID); String runningTimesXml = ApplicationDefinition.DefaultValue; XDocument runningTimesDoc = XDocument.Parse(runningTimesXml); XElement currentRunningTime = runningTimesDoc.Root.Elements("RunningTime").Where(rt => Boolean.Parse(rt.Element("IsToFinish").Value)).FirstOrDefault(); P_L3QT_SQT_0905 SaveQuickTaskParameter = new P_L3QT_SQT_0905(); SaveQuickTaskParameter.AssignedTo_Project_RefID = Parameter.AssignedToProject_ID; if (Parameter.AssignedToBusinessTask_ID != null && Parameter.AssignedToBusinessTask_ID != Guid.Empty) { SaveQuickTaskParameter.AssignedTo_BusinessTask_RefID = Parameter.AssignedToBusinessTask_ID; } if (Parameter.AssignedToFeature_ID != null && Parameter.AssignedToFeature_ID != Guid.Empty) { SaveQuickTaskParameter.AssignedTo_Feature_RefID = Parameter.AssignedToFeature_ID; } if (Parameter.AssignedToDeveloperTask_ID != null && Parameter.AssignedToDeveloperTask_ID != Guid.Empty) { SaveQuickTaskParameter.AssignedTo_DeveloperTask_RefID = Parameter.AssignedToDeveloperTask_ID; } SaveQuickTaskParameter.IsDeleted = false; SaveQuickTaskParameter.LanguageID = Parameter.LanguageID; SaveQuickTaskParameter.QuickTask_Type_RefID = Parameter.WorkTimeType_ID; XElement LastInterval = currentRunningTime.Element("Intervals").Elements("Interval").Last(); foreach (XElement runnigTimeInterval in currentRunningTime.Element("Intervals").Elements("Interval")) { SaveQuickTaskParameter.QuickTask_Title = new Dict(ORM_TMS_QuickTask.TableName); SaveQuickTaskParameter.QuickTask_Title.AddEntry(Parameter.LanguageID, currentRunningTime.Element("Title").Value); SaveQuickTaskParameter.QuickTask_Description = new Dict(ORM_TMS_QuickTask.TableName); SaveQuickTaskParameter.QuickTask_Description.AddEntry(Parameter.LanguageID, Parameter.WorkTimeDescription); SaveQuickTaskParameter.QuickTask_StartTime = DateTime.Parse(runnigTimeInterval.Element("Start").Value); if (runnigTimeInterval == LastInterval) { SaveQuickTaskParameter.R_QuickTask_InvestedTime_min = Parameter.WorkTimeLastIntervalDurationMinutes; } else { SaveQuickTaskParameter.R_QuickTask_InvestedTime_min = Double.Parse(runnigTimeInterval.Element("Duration").Value) / 60; } cls_Save_TMS_QuickTask.Invoke(Connection, Transaction, SaveQuickTaskParameter, securityTicket); } runningTimesDoc.Root.Elements("RunningTime").Where(rt => Boolean.Parse(rt.Element("IsToFinish").Value)).Remove(); P_L6US_SURT_0947 UpdateRuningTimesParameter = new P_L6US_SURT_0947(); UpdateRuningTimesParameter.RunningTimesXML = runningTimesDoc.ToString(); cls_Save_UserRunningTimes.Invoke(Connection, Transaction, UpdateRuningTimesParameter, securityTicket); } return(returnValue); #endregion UserCode }