/// <summary>
/// Gets the zip from city state instance.
/// </summary>
/// <param name="city">The city.</param>
/// <param name="state">The state.</param>
/// <param name="instance">The instance.</param>
/// <returns></returns>
public static string GetZipFromCityStateInstance(string city, string state, string instance)
{
string results = String.Empty;
try
{
if (city.Length > 0 && state.Length == 2)
{
GetZipFromCityState location = new GetZipFromCityState(instance);
location.City = city.ToUpper();
location.State = state.ToUpper();
if (location.Execute())
{
results = location.Zip;
}
}
}
catch (Exception ex)
{
GeneralUtility.DebugLog(ex.Message, "GetZipFromCityStateInstance");
}
return(results);
}
/// <summary>
/// Generates the insert SQL.
/// </summary>
/// <returns></returns>
//protected override string GenerateInsertSql()
//{
// var sql = new StringBuilder("INSERT INTO CALL (CALL_ID, ACCNT_HRCY_STEP_ID, ENTRY_POINT_HRCY_STEP_ID, LOB_CD, ");
// sql.Append("CLIENT_HRCY_STEP_ID, CALL_START_TIME, STATUS,USER_ID, ");
// sql.Append("INPUT_SYSTEM_NAME, CALLER_INFO, ORGINAL_CALL_ID, SERVER_NAME) VALUES(");
// sql.AppendFormat("{0}, {1}, {2}, '{3}', {4}, sysdate, 'INPROC', {5}, 'FNS NET', '{6}', {7}, '{8}')",
// CallId, AccntHrcyStepId, ClientHrcyStepId, LobCd, ClientHrcyStepId, UserId, CallerInfo, (OrginalCallId.Length > 0 ? OrginalCallId : "NULL"),ServerName );
// return sql.ToString();
//}
/// <summary>
/// Gets the ahs id from call id.
/// </summary>
/// <param name="callId">The call id.</param>
/// <param name="instance">The instance.</param>
/// <returns></returns>
public static string GetAhsIdFromCallId(string callId, string instance)
{
var results = string.Empty;
try
{
var record = new CallRecord {
Instance = instance, CallId = callId
};
if (record.Execute())
{
results = record.AccntHrcyStepId;
}
else
{
throw new ApplicationException(record.LastError);
}
}
catch (Exception ex)
{
GeneralUtility.LogError(ex.Message, "GetAhsIdFromCallId");
}
return(results);
}
static public int GetSequence(string table)
{
return(GetSequence(table, GeneralUtility.GetDbInstanceFromRegistry()));
}
/// <summary>
/// Execute stored procedure as defined by derived classes
/// </summary>
/// <returns>true if no errors</returns>
/// <remarks>submits parameters and executes target procedure</remarks>
/// <exception cref="FormatException"><c>FormatException</c>.</exception>
public bool Execute()
{
try
{
GeneralUtility.DebugLog("Execute entered", _name);
if (_databaseInstance.Length == 0)
{
_databaseInstance = ApplicationConfiguration.Instance.DefaultInstance;
}
var db = new OracleDatabase(GeneralUtility.GetConnectStringFromInstance(_databaseInstance));
GeneralUtility.DebugLog("Database created", _name);
var cmd = (OracleCommand)db.GetStoredProcCommand(_name);
if (_alParameters.Count > 0)
{
for (var i = 0; i < _alParameters.Count; i++)
{
var paramList = (SpParameters)_alParameters[_alParamNames[i]];
if (paramList.Direction == ParameterDirection.Input)
{
if (string.IsNullOrEmpty(paramList.Value))
{
db.AddInParameter(cmd, paramList.Name, paramList.DataType);
}
else
{
try
{
switch (paramList.DataType)
{
case DbType.Date:
GeneralUtility.DebugLog("converting date " + paramList.Value, _name);
var myDateParm = Convert.ToDateTime(paramList.Value);
db.AddInParameter(cmd, paramList.Name, paramList.DataType, myDateParm);
break;
case DbType.Int32:
var myInt32Parm = Convert.ToInt32(paramList.Value);
db.AddInParameter(cmd, paramList.Name, paramList.DataType, myInt32Parm);
break;
case DbType.Double:
var myDoubleParm = Convert.ToDouble(paramList.Value);
db.AddInParameter(cmd, paramList.Name, paramList.DataType, myDoubleParm);
break;
case DbType.Byte:
var val = Convert.ToByte(paramList.Value[0]);
db.AddInParameter(cmd, paramList.Name, paramList.DataType, val);
break;
default:
db.AddInParameter(cmd, paramList.Name, paramList.DataType, paramList.Value);
break;
}
}
catch (FormatException formatException)
{
throw new FormatException(string.Format("{0}'s value \"{1}\" is not of type {2}.", paramList.Name, paramList.Value, paramList.DataType), formatException);
}
}
}
else
{
if (paramList.DataType == DbType.Object)
{
_hasCursor = true;
db.AddParameter(cmd, paramList.Name, OracleDbType.RefCursor, 0, ParameterDirection.Output, true, 0, 0, String.Empty, DataRowVersion.Default, Convert.DBNull);
}
else if (paramList.Direction == ParameterDirection.ReturnValue)
{
db.AddParameter(cmd, paramList.Name, paramList.DataType, 4000, ParameterDirection.ReturnValue, true, 0, 0, String.Empty, DataRowVersion.Default, Convert.DBNull);
}
else
{
db.AddOutParameter(cmd, paramList.Name, paramList.DataType, 4000);
}
}
}
if (_hasCursor == false)
{
GeneralUtility.DebugLog("ExecuteNonQuery -start", _name);
db.ExecuteNonQuery(cmd);
GeneralUtility.DebugLog("ExecuteNonQuery -finish", _name);
for (var i = 0; i < _alParameters.Count; i++)
{
var paramList = (SpParameters)_alParameters[_alParamNames[i]];
if (paramList.Direction != ParameterDirection.Input)
{
paramList.Value = db.GetParameterValue(cmd, paramList.Name).ToString();
}
}
}
else
{
if (_data != null)
{
_data.Dispose();
_data = null;
GeneralUtility.DebugLog("Dataset reset", _name);
}
GeneralUtility.DebugLog("ExecuteDataSet -start", _name);
_data = db.ExecuteDataSet(cmd);
GeneralUtility.DebugLog("ExecuteDataSet -finish", _name);
}
}
return(true);
}
catch (Exception ex)
{
_lastErrorMessage = ex.Message;
GeneralUtility.DebugLog(_lastErrorMessage, _name);
return(false);
}
}
/// <summary>
/// Gets the call XML.
/// </summary>
/// <param name="callId">The call identifier.</param>
/// <returns></returns>
static public string GetCallXml(int callId)
{
return(GetCallXml(callId.ToString(CultureInfo.InvariantCulture), GeneralUtility.GetDbInstanceFromRegistry()));
}
/// <summary>
/// Commits this instance.
/// </summary>
/// <returns></returns>
public virtual bool Commit()
{
bool results;
try
{
GeneralUtility.DebugLog("Transaction started", ToString());
using (var oTranScope = new TransactionScope(TransactionScopeOption.RequiresNew))
{
if (DbInstance.Length == 0)
{
DbInstance = ApplicationConfiguration.Instance.DefaultInstance;
}
GeneralUtility.DebugLog("Execute entered", ToString());
var db = new Microsoft.Practices.EnterpriseLibrary.Data.Oracle.OracleDatabase(GeneralUtility.GetConnectStringFromInstance(DbInstance));
GeneralUtility.DebugLog("Database created", ToString());
results = CommitInserted(db);
if (results)
{
if (CommitUpdated(db))
{
oTranScope.Complete();
GeneralUtility.DebugLog("Transaction complete ", ToString());
}
}
}
}
catch (Exception ex)
{
LastError = ex.Message;
GeneralUtility.LogError(LastError, ToString());
results = false;
}
ClearAll();
return(results);
}
public override void ToJson(JsonWriter jsonWriter)
{
jsonWriter.WritePropertyName(GeneralUtility.PascalCase(Name));
jsonWriter.WriteValue(Value);
}
/// <summary>
/// Executes this instance.
/// </summary>
/// <returns>The resultSet as ADODB.RecordSetwvb
/// </returns>
public string Execute()
{
string results = String.Empty;
object dummy = Type.Missing;
try
{
Connection connection = new ConnectionClass();
connection.Open(GeneralUtility.GetAdoConnectStringFromInstance(dbInstance), String.Empty, String.Empty, -1);
Command command = new CommandClass();
command.ActiveConnection = connection;
command.CommandType = CommandTypeEnum.adCmdStoredProc;
command.CommandText = "DBCLASSLIBRARY.DoEsisLookupByPolicy";
//===========================================================
// ParentNodeId
//===========================================================
AddParameter(command, "p_parentNodeId", _parentNodeId, DataTypeEnum.adInteger, false);
//===========================================================
// Permitted
//===========================================================
AddParameter(command, "p_permittedNodeId", _permittedNodeId, DataTypeEnum.adInteger, false);
//===========================================================
// Policy Number
//===========================================================
AddParameter(command, "p_policyNumber", _policyNumber, DataTypeEnum.adVarChar, false);
//===========================================================
// LOB_CD
//===========================================================
AddParameter(command, "p_lobCd", _lobCd, DataTypeEnum.adVarChar, false);
//===========================================================
// LocationCode
//===========================================================
AddParameter(command, "p_locationCode", _locationCode, DataTypeEnum.adVarChar, false);
//===========================================================
// DepartmentCode
//===========================================================
AddParameter(command, "p_departmentCode", _departmentCode, DataTypeEnum.adVarChar, false);
//===========================================================
// ContractNumber
//===========================================================
AddParameter(command, "p_contractNumber", _contractNumber, DataTypeEnum.adVarChar, false);
//===========================================================
// Name
//===========================================================
AddParameter(command, "p_name", _name, DataTypeEnum.adVarChar, false);
//===========================================================
// City
//===========================================================
AddParameter(command, "p_city", _city, DataTypeEnum.adVarChar, false);
//===========================================================
// State
//===========================================================
AddParameter(command, "p_state", _state, DataTypeEnum.adVarChar, false);
//===========================================================
// Zip
//===========================================================
AddParameter(command, "p_zip", _zip, DataTypeEnum.adVarChar, false);
Recordset policies = command.Execute(out dummy, ref dummy, 0);
if (policies != null)
{
results = GeneralUtility.GetXmlFromAdoRecordset(policies);
policies.Close();
}
connection.Close();
}
catch (Exception ex)
{
_lastError = ex.Message;
}
return(results);
}
/// <summary>
/// Initializes a new instance of the <see cref="EntityResponse"/> class.
/// </summary>
public EntityResponse()
: this(GeneralUtility.GetDbInstanceFromRegistry())
{
}
public ClaimAssignment() : this(GeneralUtility.GetDbInstanceFromRegistry())
{
}