/// <summary>
/// Builds a connection string based on the connection settings.
/// </summary>
private string BuildConnectionsString()
{
DataSourceType dataSourceType = (DataSourceType)cbDataSourceType.SelectedIndex;
DbConnSettings connSettings = new DbConnSettings()
{
Server = txtServer.Text,
Database = txtDatabase.Text,
User = txtUser.Text,
Password = txtPassword.Text
};
switch (dataSourceType)
{
case DataSourceType.MSSQL:
return(SqlDataSource.BuildSqlConnectionString(connSettings));
case DataSourceType.Oracle:
return(OraDataSource.BuildOraConnectionString(connSettings));
case DataSourceType.PostgreSQL:
return(PgSqlDataSource.BuildPgSqlConnectionString(connSettings));
case DataSourceType.MySQL:
return(MySqlDataSource.BuildMySqlConnectionString(connSettings));
case DataSourceType.OLEDB:
return(OleDbDataSource.BuildOleDbConnectionString(connSettings));
default:
return("");
}
}
/// <summary>
/// Builds a connection string based on the specified connection settings.
/// </summary>
public static string BuildSqlConnectionString(DbConnSettings connSettings)
{
if (connSettings == null)
{
throw new ArgumentNullException("connSettings");
}
return(string.Format("Server={0};Database={1};User ID={2};Password={3}",
connSettings.Server, connSettings.Database, connSettings.User, connSettings.Password));
}
/// <summary>
/// Builds a connection string based on the specified connection settings.
/// </summary>
public static string BuildSqlConnectionString(DbConnSettings connSettings)
{
if (connSettings == null)
{
throw new ArgumentNullException(nameof(connSettings));
}
return
($"Server={connSettings.Server};Database={connSettings.Database};User ID={connSettings.User};Password={connSettings.Password}");
}
/// <summary>
/// Builds a connection string based on the specified connection settings.
/// </summary>
public static string BuildOraConnectionString(DbConnSettings connSettings)
{
if (connSettings == null)
{
throw new ArgumentNullException(nameof(connSettings));
}
return
($"Server={connSettings.Server}{(string.IsNullOrEmpty(connSettings.Database) ? "" : "/" + connSettings.Database)};User ID={connSettings.User};Password={connSettings.Password}");
}
/// <summary>
/// Builds a connection string based on the specified connection settings.
/// </summary>
public static string BuildOraConnectionString(DbConnSettings connSettings)
{
if (connSettings == null)
{
throw new ArgumentNullException("connSettings");
}
return(string.Format("Server={0}{1};User ID={2};Password={3}", connSettings.Server,
string.IsNullOrEmpty(connSettings.Database) ? "" : "/" + connSettings.Database,
connSettings.User, connSettings.Password));
}
/// <summary>
/// Builds a connection string based on the specified connection settings.
/// </summary>
public static string BuildPgSqlConnectionString(DbConnSettings connSettings)
{
if (connSettings == null)
{
throw new ArgumentNullException(nameof(connSettings));
}
ExtractHostAndPort(connSettings.Server, DefaultPort, out string host, out int port);
return
($"Server={host};Port={port};Database={connSettings.Database};User Id={connSettings.User};Password={connSettings.Password}");
}
/// <summary>
/// Builds a connection string based on the specified connection settings.
/// </summary>
public static string BuildPgSqlConnectionString(DbConnSettings connSettings)
{
if (connSettings == null)
{
throw new ArgumentNullException("connSettings");
}
ExtractHostAndPort(connSettings.Server, DefaultPort, out string host, out int port);
return(string.Format("Server={0};Port={1};Database={2};User Id={3};Password={4}",
host, port, connSettings.Database, connSettings.User, connSettings.Password));
}
/// <summary>
/// Builds a connection string based on the specified connection settings.
/// </summary>
public static string BuildMySqlConnectionString(DbConnSettings connSettings)
{
if (connSettings == null)
{
throw new ArgumentNullException("connSettings");
}
ExtractHostAndPort(connSettings.Server, DefaultPort, out string host, out int port);
return(new MySqlConnectionStringBuilder()
{
Server = host,
Port = (uint)port,
Database = connSettings.Database,
UserID = connSettings.User,
Password = connSettings.Password
}
.ToString());
}
private int GetGarsonLastFiscalNumber()
{
int fiscalNumber = 0;
DbConnSettings dbc = new DbConnSettings
{
DatabaseHost = Properties.Settings.Default.GarsonHost,
DatabasePath = Properties.Settings.Default.GarsonDatabase,
Username = "******",
Password = "******"
};
DbConn conn = new DbConn(dbc);
if (conn.TestConnection())
{
FbCommand cmd = new FbCommand();
cmd.CommandText = @"select max(broj_isecka) from r_racuni_dnevni where id_radne_stanice=" + Properties.Settings.Default.Stanica1.ToString();
FbCommand cmd2 = new FbCommand();
cmd2.CommandText = @"select max(broj_isecka) from r_racuni_dnevni where id_radne_stanice=" + Properties.Settings.Default.Stanica2.ToString();
object o = conn.ExeScalar(cmd);
if (o == DBNull.Value)
{
o = 0;
}
object o2 = conn.ExeScalar(cmd2);
if (o2 == DBNull.Value)
{
o2 = 0;
}
logger.Info("MAX broj fiskalnog isjecka = " + ((int)o + (int)o2).ToString());
if (!(o == DBNull.Value))
{
fiscalNumber = (int)o + (int)o2 + Properties.Settings.Default.GarsonFiscalNumber;
}
}
return(fiscalNumber);
}
/// <summary>
/// Builds a connection string based on the specified connection settings.
/// </summary>
public static string BuildOleDbConnectionString(DbConnSettings connSettings)
{
return("");
}
/// <summary>
/// Builds a connection string based on the specified connection settings.
/// </summary>
public override string BuildConnectionString(DbConnSettings connSettings)
{
return(BuildOleDbConnectionString(connSettings));
}
/// <summary> /// Builds a connection string based on the specified connection settings. /// </summary> public abstract string BuildConnectionString(DbConnSettings connSettings);
