public AbstractDBProvider(IntegrationAdapter pAdapterMetadata, ApplicationDatabas pApplicationDatabaseMetadata, IAppRuntime pAppRuntime)
: base(pAdapterMetadata, pAppRuntime)
{
this.ApplicationDatabaseMetadata = pApplicationDatabaseMetadata;
if (this.ApplicationDatabaseMetadata != null)
{
this.ProviderType = this.ApplicationDatabaseMetadata.ApplicationDatabaseType.ToEnum <ApplicationDatabaseType>();
}
}
/// <summary>
/// Get Field Parameter Value
/// </summary>
/// <param name="pField"></param>
/// <param name="pRecordDataRow"></param>
/// <returns></returns>
public static object GetFieldParameterValue(IntegrationAdapterField pField, DataRow pRecordDataRow, ApplicationDatabaseType pApplicationDatabaseType)
{
object parameterValue = null;
try
{
parameterValue = pRecordDataRow[pField.FieldName];
if (parameterValue == DBNull.Value)
{
parameterValue = null;
}
else
{
switch (pApplicationDatabaseType)
{
case ApplicationDatabaseType.SQLServer:
{
parameterValue = DataUtilities.ConvertValueToDataColumnType(
parameterValue.SafeToString(),
DataUtilities.GetMappedType(DataUtilities.GetMappedDataType(pField.FieldSqlDbType)));
}
break;
case ApplicationDatabaseType.Oracle:
{
parameterValue = DataUtilities.ConvertValueToDataColumnType(
parameterValue.SafeToString(),
DataUtilities.GetMappedType(DataUtilities.GetMappedDataType(pField.FieldOracleDbType)));
}
break;
case ApplicationDatabaseType.None:
case ApplicationDatabaseType.MySQL:
case ApplicationDatabaseType.Sybase:
default:
{
parameterValue = DataUtilities.ConvertValueToDataColumnType(
parameterValue.SafeToString(),
DataUtilities.GetMappedType(DataUtilities.GetMappedDataType(pField.FieldSqlDbType)));
}
break;
}
}
}
catch (Exception ex)
{
LogManager.LogException(ex);
}
return(parameterValue);
}
