Samuele Locatelli
71 lines
2.1 KiB
C#
71 lines
2.1 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
|
|
namespace Lux.Report.Data
|
|
{
|
|
public class DbConfig
|
|
{
|
|
#region Public Fields
|
|
|
|
public static string DATABASE_NAME = "LUX";
|
|
|
|
public static int DATABASE_PROCESS_TIMEOUT = 5;
|
|
public static string DATABASE_PWD = "viadante16";
|
|
|
|
// Database config
|
|
public static string DATABASE_SERV = "127.0.0.1";
|
|
|
|
public static string DATABASE_USER = "Lux_User";
|
|
|
|
#endregion Public Fields
|
|
|
|
#region Public Properties
|
|
|
|
/// <summary>
|
|
/// DB Connection string per azioni amministrative
|
|
/// </summary>
|
|
public static string ADMIN_CONNECTION_STRING { get; set; } = "";
|
|
|
|
/// <summary>
|
|
/// DB Connection string
|
|
/// </summary>
|
|
public static string CONNECTION_STRING { get; set; } = "";
|
|
|
|
#endregion Public Properties
|
|
|
|
#region Public Methods
|
|
|
|
public static void InitDb(string server, string nKey, string sKey)
|
|
{
|
|
DATABASE_SERV = server;
|
|
DATABASE_NAME = $"Lux_{nKey}";
|
|
DATABASE_USER = $"user_{nKey}";
|
|
DATABASE_PWD = $"pwd_{sKey}";
|
|
// stringa admin con utente root egalware...
|
|
#if DEBUG
|
|
CONNECTION_STRING = $"server={DATABASE_SERV};port=3306;database={DATABASE_NAME}_dev;uid={DATABASE_USER};pwd={DATABASE_PWD};sslmode=None";
|
|
#else
|
|
CONNECTION_STRING = $"server={DATABASE_SERV};port=3306;database={DATABASE_NAME};uid={DATABASE_USER};pwd={DATABASE_PWD};sslmode=None";
|
|
#endif
|
|
ADMIN_CONNECTION_STRING = $"server={DATABASE_SERV};port=3306;database=mysql;uid=root;pwd=Egalware_24068!;sslmode=None";
|
|
}
|
|
|
|
public static ServerVersion MysqlServerVersion(string connString)
|
|
{
|
|
ServerVersion serverVersion = ServerVersion.AutoDetect(connString);
|
|
return serverVersion;
|
|
}
|
|
|
|
#endregion Public Methods
|
|
|
|
#region Private Fields
|
|
|
|
private static Logger Log = LogManager.GetCurrentClassLogger();
|
|
|
|
#endregion Private Fields
|
|
}
|
|
}
|