static public bool ProcessManualImportTransaction(PacerImportTransaction objPacerImportTransaction) { //use this when the SSIS import fails. Database db = DatabaseFactory.CreateDatabase("BRGCaseMail"); if (objPacerImportTransaction.PacerFileFormatID == 0) { throw new ArgumentException("Pacer File Format not specified!"); } PacerFileFormat _format = PacerFileFormatService.GetByID(objPacerImportTransaction.PacerFileFormatID); // Read and display lines from the file until the end of // the file is reached. DbConnection conn = db.CreateConnection(); conn.Open(); DbTransaction trans = conn.BeginTransaction(); try { using (TextReader tr = File.OpenText(objPacerImportTransaction.FilePath)) { String line; int i = 0; while ((line = tr.ReadLine()) != null) { PacerTempRawImportData _data = new PacerTempRawImportData(line, _format); PacerTempRawImportDataService.Insert(_data, db, trans); if (i == 1167) { Debug.WriteLine("line:" + i.ToString() + " " + _data.CaseNumber4Digit); } i++; Debug.WriteLine("line:" + i.ToString() + " " + _data.CaseNumber4Digit); } System.Data.Common.DbCommand dbCommand = db.GetStoredProcCommand("p_ImportRawPACERData"); db.AddInParameter(dbCommand, "PacerImportTransactionID", DbType.Int32, objPacerImportTransaction.ID); db.ExecuteNonQuery(dbCommand, trans); trans.Commit(); return(true); } } catch (Exception ex) { objPacerImportTransaction.ImportMessage = "Import Failed. Error: " + ex.Message; objPacerImportTransaction.ImportStatus = "FAILURE"; trans.Rollback(); //Save trans we're done. PacerImportTransactionService.Save(objPacerImportTransaction); return(false); } }
static public void Delete(PacerFileFormat objPacerFileFormat) { Database db = DatabaseFactory.CreateDatabase("BRGCaseMail"); System.Data.Common.DbCommand dbCommand = db.GetStoredProcCommand("p_PacerFileFormatDelete"); db.AddInParameter(dbCommand, "ID", DbType.Int32, objPacerFileFormat.ID); db.ExecuteNonQuery(dbCommand); }
public PacerFileFormat Copy() { PacerFileFormat _pacerFileFormat = new PacerFileFormat(); _pacerFileFormat.ID = _iD; _pacerFileFormat.PacerFileVersion = _pacerFileVersion; _pacerFileFormat.NumberColumns = _numberColumns; return(_pacerFileFormat); }
static private void Update(PacerFileFormat objPacerFileFormat) { Database db = DatabaseFactory.CreateDatabase("BRGCaseMail"); System.Data.Common.DbCommand dbCommand = db.GetStoredProcCommand("p_PacerFileFormatUpdate"); db.AddInParameter(dbCommand, "ID", DbType.Int32, objPacerFileFormat.ID); db.AddInParameter(dbCommand, "PacerFileVersion", DbType.String, objPacerFileFormat.PacerFileVersion); db.AddInParameter(dbCommand, "NumberColumns", DbType.Int32, objPacerFileFormat.NumberColumns); db.ExecuteNonQuery(dbCommand); }
static private void Insert(PacerFileFormat objPacerFileFormat) { Database db = DatabaseFactory.CreateDatabase("BRGCaseMail"); System.Data.Common.DbCommand dbCommand = db.GetStoredProcCommand("p_PacerFileFormatInsert"); db.AddOutParameter(dbCommand, "ID", DbType.Int32, 4); db.AddInParameter(dbCommand, "PacerFileVersion", DbType.String, objPacerFileFormat.PacerFileVersion); db.AddInParameter(dbCommand, "NumberColumns", DbType.Int32, objPacerFileFormat.NumberColumns); db.ExecuteNonQuery(dbCommand); objPacerFileFormat.ID = Int32.Parse(db.GetParameterValue(dbCommand, "ID").ToString()); }
static public string CheckECFVersions() { ECFVersionByCourt _version = new ECFVersionByCourt(); List <ECFVersion> _versions = _version.GetBankruptcyCourtVersions(); int iUnknownFormat = 0; int iUnknownCourt = 0; int iUpdated = 0; int iMatch = 0; foreach (ECFVersion _ecf in _versions) { PacerFileFormat _format = PacerFileFormatService.GetByVersionString(_ecf.versionString); if (_format == null) { iUnknownFormat++; } else { Court _icourt = CourtService.GetByECFCourtString(_ecf.courtName); //if ( _icourt.CourtName == "Illinois Central") // Debug.WriteLine(_icourt.CourtAndFileVersion); if (_icourt != null && _icourt.PacerFileFormatID == _format.ID) { iMatch++; } else if (_icourt != null) { _icourt.PacerFileFormatID = _format.ID; _icourt.PacerFileVersion = _format.PacerFileVersion; CourtService.Save(_icourt); iUpdated++; } else { iUnknownCourt++; } } } return(iUpdated + " courts updated, " + iMatch + " court versions matched, " + iUnknownFormat + " pacer file formats unknown, " + iUnknownCourt + " Courts unknown "); }
static public List <PacerFileFormat> GetAll() { List <PacerFileFormat> objPacerFileFormats = new List <PacerFileFormat>(); Database db = DatabaseFactory.CreateDatabase("BRGCaseMail"); using (IDataReader reader = db.ExecuteReader(CommandType.Text, _selectViewSQL)) { while (reader.Read()) { PacerFileFormat objPacerFileFormat = new PacerFileFormat(); LoadPacerFileFormat(objPacerFileFormat, reader); objPacerFileFormat.IsModified = false; objPacerFileFormats.Add(objPacerFileFormat); } // always call Close when done reading. reader.Close(); return(objPacerFileFormats); } }
static public PacerFileFormat GetByVersionString(string _version) { PacerFileFormat objPacerFileFormat = new PacerFileFormat(); string query = _selectViewSQL + " where PacerFileVersion = '" + _version + "'"; Database db = DatabaseFactory.CreateDatabase("BRGCaseMail"); using (IDataReader reader = db.ExecuteReader(CommandType.Text, query)) { if (reader.Read()) { LoadPacerFileFormat(objPacerFileFormat, reader); // always call Close when done reading. reader.Close(); objPacerFileFormat.IsModified = false; return(objPacerFileFormat); } else { return(null); } } }
public bool Reprocess(bool GeoCodeAddresses) { //ceck if we've established conection and queried for the data if (this.FilePath.Length > 0) { try { // Read the file as one string. System.IO.StreamReader myFile = new System.IO.StreamReader(this.FilePath); string _rawData = myFile.ReadToEnd(); myFile.Close(); if (_rawData == null || _rawData.Length == 0) { _importStatus = "NO DATA"; return(false); } //delete all imported data but don;t bother deleting bankruptcy case data as it will get written over //if already exists PacerImportDataService.DeleteForTransaction(this.ID); //get the court //Court _court = CourtService.GetByID(this.CourtID); //this.PacerFileFormatID = _format.ID; PacerFileFormat _format = PacerFileFormatService.GetByID(this.PacerFileFormatID); //on a reprocess we use the current format for the court if (BRGCaseMailServer.PacerImportTransactionService.ProcessManualImportTransaction(this, _format) == true) { //process imported lines int rows = PacerImportTransactionService.ProcessImportedLineItems(this, GeoCodeAddresses); if (_court == null) { _court = CourtService.GetByID(this.CourtID); } if (this._dischargedCases == true) { _court.LastPacerLoadDischargeDate = this.EndDate; } else { _court.LastPacerLoadFileDate = this.EndDate; } CourtService.Save((Court)_court); return(true); } else { return(false); } } catch (Exception ex) { this.ImportMessage = ex.Message; this.ImportStatus = "FAILURE"; PacerImportTransactionService.Save(this); return(false); } } else { PacerImportTransactionService.Save(this); return(false); //end if (_status == true || _result != null) } }