protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_MD_SCS_1700 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 //create xml file var ms = new MemoryStream(); var w = new XmlTextWriter(ms, new UTF8Encoding(false)) { Formatting = Formatting.Indented }; w.WriteStartDocument(); w.WriteStartElement("AppSettings"); w.WriteElementString("AccountID", Parameter.AccountID.ToString()); w.WriteElementString("Email", Parameter.Email); w.WriteElementString("ImmediateOrderInterval", Parameter.ImmediateOrderInterval.ToString()); w.WriteElementString("OrderInterval", Parameter.OrderInterval.ToString()); w.WriteEndElement(); w.WriteEndDocument(); w.Flush(); var xml = Encoding.UTF8.GetString(ms.ToArray()); var tenantSettingsQ = ORM_CMN_Tenant_ApplicationSetting.Query.Search(Connection, Transaction, new ORM_CMN_Tenant_ApplicationSetting.Query() { IsDeleted = false, Tenant_RefID = securityTicket.TenantID }).SingleOrDefault(); if (tenantSettingsQ == null) { var tenantSettings = new ORM_CMN_Tenant_ApplicationSetting(); tenantSettings.IsDeleted = false; tenantSettings.Tenant_RefID = securityTicket.TenantID; tenantSettings.ItemValue = xml; tenantSettings.Creation_Timestamp = DateTime.Now; tenantSettings.Save(Connection, Transaction); } else { tenantSettingsQ.ItemValue = xml; tenantSettingsQ.Save(Connection, Transaction); } return(returnValue); #endregion UserCode }
public static void Add_Company_Settings_for_Tenant(string connectionString, SessionSecurityTicket securityTicket) { DbConnection Connection = null; DbTransaction Transaction = null; bool cleanupConnection = Connection == null; bool cleanupTransaction = Transaction == null; try { if (cleanupConnection == true) { Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(connectionString); Connection.Open(); } if (cleanupTransaction == true) { Transaction = Connection.BeginTransaction(); } var tenantSettingsQ = ORM_CMN_Tenant_ApplicationSetting.Query.Search(Connection, Transaction, new ORM_CMN_Tenant_ApplicationSetting.Query() { IsDeleted = false, Tenant_RefID = securityTicket.TenantID }).SingleOrDefault(); if (tenantSettingsQ == null) { //create xml file var ms = new MemoryStream(); var w = new XmlTextWriter(ms, new UTF8Encoding(false)) { Formatting = System.Xml.Formatting.Indented }; w.WriteStartDocument(); w.WriteStartElement("AppSettings"); w.WriteElementString("AccountID", securityTicket.AccountID.ToString()); w.WriteElementString("Email", ConfigurationManager.AppSettings["mailFrom"]); w.WriteElementString("ImmediateOrderInterval", "120"); w.WriteElementString("OrderInterval", "120"); w.WriteEndElement(); w.WriteEndDocument(); w.Flush(); var xml = Encoding.UTF8.GetString(ms.ToArray()); var tenantSettings = new ORM_CMN_Tenant_ApplicationSetting(); tenantSettings.IsDeleted = false; tenantSettings.Tenant_RefID = securityTicket.TenantID; tenantSettings.ItemValue = xml; tenantSettings.Creation_Timestamp = DateTime.Now; tenantSettings.Save(Connection, Transaction); } } catch (Exception ex) { try { if (cleanupTransaction == true && Transaction != null) { Transaction.Rollback(); } } catch { } try { if (cleanupConnection == true && Connection != null) { Connection.Close(); } } catch { } throw ex; } }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L2AS_AAS_1631 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); foreach (var item in Parameter.Settings) { ORM_CMN_Tenant_ApplicationSettings_Definition.Query definitionExistsQuery = new ORM_CMN_Tenant_ApplicationSettings_Definition.Query() { ApplicationID = Parameter.ApplicationID, Tenant_RefID = securityTicket.TenantID, ItemKey = item.SettingsName, IsDeleted = false }; // Check if settings definition exists var tenantApplicationSettingsDefinition = new ORM_CMN_Tenant_ApplicationSettings_Definition(); if (ORM_CMN_Tenant_ApplicationSettings_Definition.Query.Exists(Connection, Transaction, definitionExistsQuery)) { tenantApplicationSettingsDefinition = ORM_CMN_Tenant_ApplicationSettings_Definition.Query.Search(Connection, Transaction, definitionExistsQuery).Single(); } else { tenantApplicationSettingsDefinition.CMN_Tenant_ApplicationSettings_DefinitionsID = Guid.NewGuid(); } tenantApplicationSettingsDefinition.ApplicationID = Parameter.ApplicationID; tenantApplicationSettingsDefinition.ItemKey = item.SettingsName; tenantApplicationSettingsDefinition.Tenant_RefID = securityTicket.TenantID; tenantApplicationSettingsDefinition.Creation_Timestamp = DateTime.Now; tenantApplicationSettingsDefinition.Save(Connection, Transaction); ORM_CMN_Tenant_ApplicationSetting.Query settingsQuery = new ORM_CMN_Tenant_ApplicationSetting.Query() { ApplicationSettings_Definition_RefID = tenantApplicationSettingsDefinition.CMN_Tenant_ApplicationSettings_DefinitionsID, Tenant_RefID = securityTicket.TenantID, IsDeleted = false }; // Check if settings value for definition exists var tenantApplicationSettings = new ORM_CMN_Tenant_ApplicationSetting(); if (ORM_CMN_Tenant_ApplicationSetting.Query.Exists(Connection, Transaction, settingsQuery)) { tenantApplicationSettings = ORM_CMN_Tenant_ApplicationSetting.Query.Search(Connection, Transaction, settingsQuery).Single(); } else { tenantApplicationSettings.CMN_Tenant_ApplicationSettingsID = Guid.NewGuid(); } tenantApplicationSettings.ApplicationSettings_Definition_RefID = tenantApplicationSettingsDefinition.CMN_Tenant_ApplicationSettings_DefinitionsID; tenantApplicationSettings.ItemValue = item.SettingsValue; tenantApplicationSettings.Creation_Timestamp = DateTime.Now; tenantApplicationSettings.Tenant_RefID = securityTicket.TenantID; tenantApplicationSettings.Save(Connection, Transaction); } return(returnValue); #endregion UserCode }