Beispiel #1
0
        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
        }
Beispiel #2
0
        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
        }