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
}
