public AceChangeRecordWriter(AceConnectionMetadata poConnMetadata)
{
moDbLock = new object();
ConnectionMetadata = poConnMetadata;
InitDbMembers();
}
public AceChangeProcessWriter(AceConnectionMetadata poStgConnMetadata)
{
CurrentProcessID = -1;
CurrentChangeSeq = -1;
DbLock = new object();
ConnMetadata = poStgConnMetadata;
InitDbMembers();
}
public AceChangeRecordReader(AceConnectionMetadata poDbConnMetadata, AceProcess poAceProcess)
{
DbConnMetadata = poDbConnMetadata;
AceProcess = poAceProcess;
DbConnection = null;
RetrieveProducts = null;
ProductReader = null;
InitDBMembers();
StartEnumerator();
}
private void InitMembers()
{
string sFormatString = "user id={0};password={1};database={2};server={3};connection timeout=120;";
string[] asConnectionParams = new string[4];
moStgConnectionMetadata = new AceConnectionMetadata();
DebugFlag = Properties.Settings.Default.DEBUG_MODE;
UseTaskMaxTime = Properties.Settings.Default.USE_TASK_MAX_TIME;
LogDirectory = Properties.Settings.Default.LOG_DIRECTORY;
asConnectionParams[0] = moStgConnectionMetadata.DBUser = Properties.Settings.Default.ACE_DB_USER;
asConnectionParams[1] = moStgConnectionMetadata.DBPassword = Properties.Settings.Default.ACE_DB_PASSWORD;
asConnectionParams[2] = moStgConnectionMetadata.DBTarget = Properties.Settings.Default.ACE_DB_TARGET;
asConnectionParams[3] = moStgConnectionMetadata.DBMachine = Properties.Settings.Default.ACE_DB_MACHINE;
moStgConnectionMetadata.DBConnectionString = string.Format(sFormatString, asConnectionParams);
InitLogging();
} // method()
public AceApplyManager(AceConnectionMetadata poConnMetadata, AceAPIBucket poBucketConfiguration)
{
DbConn = new SqlConnection(poConnMetadata.DBConnectionString);
DbConn.Open();
CountCommand = InsertCommand = UpdateCommand = RetrieveCommand = null;
BucketConfiguration = poBucketConfiguration;
InitPreparedStatements();
lock (ListsLock)
{
if (DateTypeList == null)
{
DateTypeList =
new List <SqlDbType> {
SqlDbType.Date, SqlDbType.DateTime, SqlDbType.DateTime2,
SqlDbType.SmallDateTime, SqlDbType.Time, SqlDbType.Time
};
}
if (NumericTypeList == null)
{
NumericTypeList =
new List <SqlDbType> {
SqlDbType.BigInt, SqlDbType.Bit, SqlDbType.Int,
SqlDbType.SmallInt, SqlDbType.TinyInt
};
}
if (DoubleTypeList == null)
{
DoubleTypeList =
new List <SqlDbType> {
SqlDbType.Decimal, SqlDbType.Float, SqlDbType.Money,
SqlDbType.Real, SqlDbType.SmallMoney
};
}
}
}
public AceMetadataFactory(AceConnectionMetadata ConnMetadata)
{
this.ConnectionMetadata = ConnMetadata;
InitDbMembers();
}
