static public int ProcessImportedLineItems(PacerImportTransaction objPacerImportTransaction, bool GeocodeLocations) { List <PacerImportData> _data = PacerImportDataService.GetForImportTransaction(objPacerImportTransaction.ID); PacerImportData _previousRow = null; int insertedRowCount = 0; int updatedRowCount = 0; int formatErrors = 0; string StateCode = null; foreach (PacerImportData _row in _data) { if (_previousRow == null) { //first row - is this row a debtor - if this row fails we just exit with failure because the //file format is most likely incorrect. if (((_row.PartyCaseRole.ToUpper() == "DEBTOR") || (_row.PartyCaseRole.ToUpper() == "CO-DEBTOR") || (_row.PartyCaseRole.ToUpper() == "JOINT DEBTOR")) && _row.CareOfOK) { _row.Imported = true; PacerImportDataService.Save(_row); try { BankruptcyCase _case = new BankruptcyCase(_row); Debug.WriteLine(_case.CaseNumber4Digit); if (GeocodeLocations) { YahooGeoCoder.GeocodeCase(_case); } _case.IsModified = true; int returnvalue = BankruptcyCaseService.Save(_case, true); if (returnvalue == 1) { insertedRowCount++; } else if (returnvalue == 2) { updatedRowCount++; } } catch (Exception ex) { formatErrors++; } } _previousRow = _row; } else //previousrow != null if this row fails we do not exit with failure because the // it's just a bad row. { if (_row.PartyAddressLine1 != _previousRow.PartyAddressLine1 && ((_row.PartyCaseRole.ToUpper() == "DEBTOR") || (_row.PartyCaseRole.ToUpper() == "CO-DEBTOR") || (_row.PartyCaseRole.ToUpper() == "JOINT DEBTOR")) && _row.CareOfOK) { try { //debtor at different address _row.Imported = true; PacerImportDataService.Save(_row); BankruptcyCase _case = new BankruptcyCase(_row); if (GeocodeLocations) { YahooGeoCoder.GeocodeCase(_case); } if (insertedRowCount == 318) { Debug.WriteLine(_case.CaseNumber4Digit); } if (_case.LastName == "Babakatis") { Debug.WriteLine(_case.CaseNumber4Digit); } _case.IsModified = true; int returnvalue = BankruptcyCaseService.Save(_case, true); if (returnvalue == 1) { insertedRowCount++; if (insertedRowCount == 1654) { Debug.WriteLine(insertedRowCount); } } else if (returnvalue == 2) { updatedRowCount++; } } catch (Exception e) { formatErrors++; } } _previousRow = _row; } } // update counts for objPacerImportTransaction.InsertedCases = insertedRowCount; objPacerImportTransaction.LineCount = _data.Count; objPacerImportTransaction.TotalCases = insertedRowCount + updatedRowCount; if (objPacerImportTransaction.ImportMessage.Length > 0) { //we already have an import string - parse the result to add the previous total try { if (objPacerImportTransaction.ImportMessage.IndexOf("Unique Cases Added") > 0) { int previoustotal = Int32.Parse(objPacerImportTransaction.ImportMessage.Substring(0, objPacerImportTransaction.ImportMessage.IndexOf("Unique Cases Added") - 1)); objPacerImportTransaction.ImportMessage = previoustotal + insertedRowCount + " Unique Cases Added! " + updatedRowCount + " Cases Updated! " + formatErrors + " format Errors."; } else { objPacerImportTransaction.ImportMessage = insertedRowCount + " Unique Cases Added! " + updatedRowCount + " Cases Updated! " + formatErrors + " format Errors."; } } catch { } } else { objPacerImportTransaction.ImportMessage = insertedRowCount + " Unique Cases Added! " + updatedRowCount + " Cases Updated! " + formatErrors + " format Errors."; } objPacerImportTransaction.ImportStatus = "SUCCESS"; Save(objPacerImportTransaction); Court _court = CourtService.GetByID(objPacerImportTransaction.CourtID); ZipGeoCodeService.UpdateStatsForState(_court.StateCode); return(insertedRowCount); }
public PacerImportData Copy() { PacerImportData _pacerImportData = new PacerImportData(); _pacerImportData.ID = _iD; _pacerImportData.Imported = _imported; _pacerImportData.PacerImportTransactionID = _pacerImportTransactionID; _pacerImportData.CaseNumber2Digit = _caseNumber2Digit; _pacerImportData.CaseNumber4Digit = _caseNumber4Digit; _pacerImportData.CMECF = _cMECF; _pacerImportData.Chapter = _chapter; _pacerImportData.PreviousChapter = _previousChapter; _pacerImportData.ConversionDate = _conversionDate; _pacerImportData.DischargedDate = _dischargedDate; _pacerImportData.DismissedDate = _dismissedDate; _pacerImportData.FiledDate = _filedDate; _pacerImportData.EnteredDate = _enteredDate; _pacerImportData.ClosedDate = _closedDate; _pacerImportData.Disposition = _disposition; _pacerImportData.CaseType = _caseType; _pacerImportData.TrusteeLastName = _trusteeLastName; _pacerImportData.JudgeLastName = _judgeLastName; _pacerImportData.CountyFiled = _countyFiled; _pacerImportData.OfficeName = _officeName; _pacerImportData.FilingFeePaymentStatus = _filingFeePaymentStatus; _pacerImportData.AssetsInCase = _assetsInCase; _pacerImportData.CaseDisposition = _caseDisposition; _pacerImportData.JointDebtorDischargeDate = _jointDebtorDischargeDate; _pacerImportData.JointDebtorDismissalDate = _jointDebtorDismissalDate; _pacerImportData.JointDebtorDispositionCode = _jointDebtorDispositionCode; _pacerImportData.JointDebtorDisposition = _jointDebtorDisposition; _pacerImportData.DivisionalOfficeFiled = _divisionalOfficeFiled; _pacerImportData.AdversaryProceedingSeqNo = _adversaryProceedingSeqNo; _pacerImportData.AdversaryProceedingYear = _adversaryProceedingYear; _pacerImportData.AdversaryProceedingDisposition = _adversaryProceedingDisposition; _pacerImportData.PartyFirstName = _partyFirstName; _pacerImportData.PartyMiddleName = _partyMiddleName; _pacerImportData.PartyLastName = _partyLastName; _pacerImportData.PartyGeneration = _partyGeneration; _pacerImportData.PartyOffice = _partyOffice; _pacerImportData.PartyAddressLine1 = _partyAddressLine1; _pacerImportData.PartyAddressLine2 = _partyAddressLine2; _pacerImportData.PartyAddressLine3 = _partyAddressLine3; _pacerImportData.PartyCity = _partyCity; _pacerImportData.PartyState = _partyState; _pacerImportData.PartyZipCode = _partyZipCode; _pacerImportData.PartyCountry = _partyCountry; _pacerImportData.PartyPhone = _partyPhone; _pacerImportData.PartySSNo = _partySSNo; _pacerImportData.PartyTaxID = _partyTaxID; _pacerImportData.PartyCaseSeqNo = _partyCaseSeqNo; _pacerImportData.PartyCaseRole = _partyCaseRole; _pacerImportData.PartyTerminatedDate = _partyTerminatedDate; _pacerImportData.CaseTitle = _caseTitle; _pacerImportData.AttorneyFirstName = _attorneyFirstName; _pacerImportData.AttorneyMiddleName = _attorneyMiddleName; _pacerImportData.AttorneyLastName = _attorneyLastName; _pacerImportData.AttorneyGeneration = _attorneyGeneration; _pacerImportData.AttorneyOffice = _attorneyOffice; _pacerImportData.AttorneyOfficeLine1 = _attorneyOfficeLine1; _pacerImportData.AttorneyOfficeLine2 = _attorneyOfficeLine2; _pacerImportData.AttorneyOfficeLine3 = _attorneyOfficeLine3; _pacerImportData.AttorneyCity = _attorneyCity; _pacerImportData.AttorneyState = _attorneyState; _pacerImportData.AttorneyZipCode = _attorneyZipCode; _pacerImportData.AttorneyCountry = _attorneyCountry; _pacerImportData.AttorneyPhone = _attorneyPhone; _pacerImportData.CourtID = _courtID; _pacerImportData.DischargedCases = _dischargedCases; _pacerImportData.CourtName = _courtName; return(_pacerImportData); }
public BankruptcyCase(PacerImportData _row) { _iD = 0; _courtID = _row.CourtID; try { //this is what sharp used for the casenumber. _cMECF_Internal = Int32.Parse(_row.CMECF); } catch { } _caseNumber4Digit = _row.CaseNumber4Digit; _pacerImportTransactionID = _row.PacerImportTransactionID; _chapter = _row.Chapter; _filedOnly = !_row.DischargedCases; if (_row.FiledDate != null) { _filedDate = (DateTime)_row.FiledDate; } if (_row.DischargedDate != null) { _dischargeDate = (DateTime)_row.DischargedDate; } _trustee = _row.TrusteeLastName; _judge = _row.JudgeLastName; _county = _row.CountyFiled; _office = _row.OfficeName; _fee = _row.FilingFeePaymentStatus; _asset = _row.AssetsInCase; _firstName = _row.PartyFirstName; _middleName = _row.PartyMiddleName; _lastName = _row.PartyLastName; if (_firstName.ToLower().Contains("test") || _lastName.ToLower().Contains("test")) { throw new Exception("Test Data in production"); } //_suffix = _addrLine1 = _row.PartyAddressLine1; _addrLine2 = _row.PartyAddressLine2; _addrLine3 = _row.PartyAddressLine3; _city = _row.PartyCity; _stateCode = _row.PartyState; //if this fails let the error percolate so the transaction can be rolled back _postalCode = Int32.Parse(_row.PartyZipCode.Substring(0, 5)); //_postalLast4 = string.Empty; _country = _row.PartyCountry; _phone = _row.PartyPhone; try { if (_row.PartySSNo == "xxx-xx-2939") { Debug.WriteLine(_row.PartySSNo); } _ssnLast4 = _row.PartySSNo.Substring(_row.PartySSNo.LastIndexOf('-') + 1, 4); } catch { } //todo: hospital in Care of //_careOf = _row. //_dontSend = false; //_returned = false; //_soldCount = 0; //_lastSoldDate = System.DateTime.MinValue; }