public SpinerBaseRep(Connection p_connection)
{
clsConfiguration dataBaseConfig;
try
{
this.connection = p_connection;
dataBaseConfig = new clsConfiguration();
if (p_connection.Instance.Trim() != "")
{
dataBaseConfig.Server = p_connection.Server + "/" + p_connection.Instance;
}
else
{
dataBaseConfig.Server = p_connection.Server;
}
if (p_connection.DataBaseType == enmDataBaseType.MsSQL)
{
dataBaseConfig.Type = DataBase.enmDataBaseType.MsSql;
}
else if (p_connection.DataBaseType == enmDataBaseType.MySQL)
{
dataBaseConfig.Type = DataBase.enmDataBaseType.MySql;
}
else if (p_connection.DataBaseType == enmDataBaseType.SQLite)
{
dataBaseConfig.Type = DataBase.enmDataBaseType.SqLite;
dataBaseConfig.Server = p_connection.Server + "\\" + p_connection.DataBase;
}
else if (p_connection.DataBaseType == enmDataBaseType.Oracle)
{
dataBaseConfig.Type = DataBase.enmDataBaseType.Oracle;
}
else
{
dataBaseConfig.Type = DataBase.enmDataBaseType.Postgre;
}
dataBaseConfig.DataBase = p_connection.DataBase;
dataBaseConfig.User = p_connection.User;
dataBaseConfig.Password = p_connection.Password;
dataBaseConfig.ConnetionTimeout = 5;
objDataBase = DataBase.fnOpenConnection(dataBaseConfig);
}
catch (Exception ex)
{
throw ex;
}
}
public BucketReportRep(string dbFile)
{
clsConfiguration config;
try
{
config = new clsConfiguration();
config.DataBase = dbFile;
config.Server = dbFile;
config.Type = DataBase.enmDataBaseType.SqLite;
dataBase = DataBase.fnOpenConnection(config);
initializeDataBase();
}
catch (Exception)
{
throw;
}
}