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); } }
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) } }