public string PrepareAdoResultsFromDetail(TDetailResponse response) { var records = XmlUtility.CreateRecordSet(FieldNames); PopulateRecordsFromDetail(records, response); return(XmlUtility.GetXmlFromAdoRecordset(records)); }
/// <summary> /// Does the lookup. BUGBUG: we can refactor data access to DbClassLibrary /// need to build ADODB support -JJG /// </summary> /// <param name="vehicleId">The vehicle id.</param> /// <returns></returns> public static string DoLookup(int vehicleId) { string results = String.Empty; string connectString = GeneralUtility.GetFormattedConnectStringFromRegistry(); string connectionString = String.Format("Provider=MSDAORA.1;{0}", connectString); Assert.Test(connectionString.Length > 0, "VehicleLookup: unable to obtaing ConnectionString"); Connection conn = new Connection(); Command command = new Command(); try { conn.Open(connectionString, String.Empty, String.Empty, -1); command.ActiveConnection = conn; command.CommandType = CommandTypeEnum.adCmdStoredProc; command.CommandText = "GET_POL_VEHICLES_COV_PKG.GET_VEHICLE_COVERAGE"; command.Parameters.Append( command.CreateParameter("POLICY_ID_IN_PARAM", DataTypeEnum.adInteger, ParameterDirectionEnum.adParamInput, 4, vehicleId)); object dummy = Type.Missing; Recordset vehicles = command.Execute(out dummy, ref dummy, 0); if (vehicles != null) { results = XmlUtility.GetXmlFromAdoRecordset(vehicles); } } catch (Exception ex) { ErrorLog.LogError("GetXmlFromAdoRecordset(): Error " + ex.Message, "VehicleLookup"); } finally { conn.Close(); } return(results); }
public static string PrepareAdoResultsFromException(Exception response) { return(XmlUtility.GetXmlFromAdoRecordset(XmlUtility.CreateRecordSet(new string[] { "ERROR_MESSAGE" }))); }