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 }
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 }
///<summary> /// Ivokes the method with the given Connection, leaving it open if no exceptions occured ///<summary> public static FR_Guid Invoke(DbConnection Connection, P_L6US_SURT_0947 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { return(Invoke(Connection, null, null, Parameter, securityTicket)); }
///<summary> /// Method Invocation of wrapper classes ///<summary> protected static FR_Guid Invoke(DbConnection Connection, DbTransaction Transaction, string ConnectionString, P_L6US_SURT_0947 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_Save_UserRunningTimes", ex); } return(functionReturn); }