private void btnProcess_Click(object sender, RoutedEventArgs e) { if (txtFilePath.Text != string.Empty) { Mouse.OverrideCursor = Cursors.Wait; string _returnMessage = string.Empty; try { _returnMessage = BankruptcyCaseService.ProcessRemoveFile(txtFilePath.Text); } catch (Exception ex) { Mouse.OverrideCursor = Cursors.Arrow; MessageBox.Show("Error: Zip Import was unsuccessful, please contact your administrator!" + ": " + ex.ToString()); } Mouse.OverrideCursor = Cursors.Arrow; txtResults.Text = _returnMessage; } else { MessageBox.Show("Please select as filepath!"); } }
private void btnProcessSelected_Click(object sender, RoutedEventArgs e) { foreach (var _removeMail in grdViewRemoveEmails.SelectedItems.ToList()) { if (((RemoveMail)_removeMail).Subject.ToUpper() == "REMOVE") { string[] _body = ((RemoveMail)_removeMail).Body.Trim().Split(','); string[] _name = _body[0].Split(' '); BankruptcyCase _case = BankruptcyCaseService.GetByNameAndZip(_name[0], "", _name[1], Int32.Parse(_body[1].Trim())); if (_case != null) { _case.DontSend = true; BankruptcyCaseService.Save(_case, false); ((RemoveMail)_removeMail).Processed = true; ((RemoveMail)_removeMail).FoundAndRemoved = true; } else { ((RemoveMail)_removeMail).Processed = true; ((RemoveMail)_removeMail).FoundAndRemoved = false; } Imap.QuickDownloadMessages(ConfigurationManager.AppSettings["RemovePOP3Server"], ConfigurationManager.AppSettings["RemovePOP3User"], ConfigurationManager.AppSettings["RemovePOP3Password"], "Inbox"); } } }
private void btnSearchBankruptcyCases_Click(object sender, RoutedEventArgs e) { Mouse.OverrideCursor = Cursors.Wait; try { List <BankruptcyCase> _bankruptcyCases; if (cboCourt.SelectedIndex > -1) { _bankruptcyCases = BankruptcyCaseService.GetFiltered(txtPacerImportTransactionID.Text, txtCaseNumber.Text, txtDebtorFirstName.Text, txtDebtorLastName.Text, ((Court)cboCourt.SelectedValue).ID, txtPostalCode.Text, (bool)rdoUnsoldOnly.IsChecked); } else { _bankruptcyCases = BankruptcyCaseService.GetFiltered(txtPacerImportTransactionID.Text, txtCaseNumber.Text, txtDebtorFirstName.Text, txtDebtorLastName.Text, 0, txtPostalCode.Text, (bool)rdoUnsoldOnly.IsChecked); } GridViewBankruptcyCases.ItemsSource = _bankruptcyCases; } catch (Exception ex) { } //foreach (BankruptcyCase _BankruptcyCase in _BankruptcyCases) //{ // if (_BankruptcyCase.Latitude == null) // { // BingGeoCoder.GeocodeCase(_BankruptcyCase); // BankruptcyCaseService.Save(_BankruptcyCase); // } //} Mouse.OverrideCursor = Cursors.Arrow; }
private void LoadMailingTotals() { if (_dealer.ID > 0) { txtTotalMailingCases.Text = BankruptcyCaseService.getTotalAvailableCount(_dealer.ID, (DateTime)rdpStartSelectDate.SelectedDate, (DateTime)rdpEndSelectDate.SelectedDate, (bool)rdoFiledOnly.IsChecked).ToString(); txtTotalUnsoldCases.Text = BankruptcyCaseService.getTotalUnsoldCount(_dealer.ID, (DateTime)rdpStartSelectDate.SelectedDate, (DateTime)rdpEndSelectDate.SelectedDate, (bool)rdoFiledOnly.IsChecked).ToString(); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { if (_selectedBankruptcyCase == null) { _selectedBankruptcyCase = new BankruptcyCase(); } SaveScreenToBankruptcyCase(); BankruptcyCaseService.Save(_selectedBankruptcyCase, false); _rtc.Items.Remove(_rt); _rtc.SelectedItem = _rtc.Items[2]; }
private void btnExport_Click(object sender, RoutedEventArgs e) { State state = (State)cboState.SelectedItem; string stateCode = (state != null) ? state.StateCode : string.Empty; Court court = (Court)cboCourtExportCriteria.SelectedItem; string courtName = (court != null) ? court.CourtName : string.Empty; Dealer dealer = (Dealer)cboDealerExportCriteria.SelectedItem; int dealerId = (dealer != null) ? dealer.ID : 0; DateTime?startDate = rdpStartDateExportCriteria.SelectedDate; DateTime?endDate = rdpEndDateExportCriteria.SelectedDate; string saveToPath = txtFilePathExport.Text; List <BankruptcyCase> list = BankruptcyCaseService.GetAddressVerificationList(courtName, dealerId, stateCode, startDate, endDate); // Create CSV File bool created = BankruptcyCaseService.CreateAddressVerificationCSVFile(list, saveToPath); }
private void btnOpenCase_Click(object sender, RoutedEventArgs e) { RadButton _button = (RadButton)sender; int ID = ((BankruptcyCase)_button.DataContext).ID; BankruptcyCase _selectedBankruptcyCase = BankruptcyCaseService.GetByID(ID); //MessageBox.Show("The double-clicked row is " + ((PacerImportTransaction)row.DataContext).ID); RadTabItem tabToAdd = new RadTabItem(); tabToAdd.Header = "Case: " + _selectedBankruptcyCase.FullName; tabToAdd.Margin = new System.Windows.Thickness(0, 0, 5, 0); tabToAdd.Content = new BankruptcyCaseDetailUC(_selectedBankruptcyCase, tabCtrlMain, tabToAdd); tabToAdd.HorizontalContentAlignment = System.Windows.HorizontalAlignment.Stretch; //should only be one addTabItemMenu(tabToAdd); this.tabCtrlMain.Items.Add(tabToAdd); this.tabCtrlMain.SelectedItem = tabToAdd; }
public RawDataWindow(PacerImportTransaction _transaction) { InitializeComponent(); if (_transaction != null) { this._pITransaction = _transaction; txtCourtName.Text = _pITransaction.CourtName; txtBillablePages.Text = _pITransaction.BillablePages.ToString(); txtCost.Text = _pITransaction.Cost.ToString("c"); txtTimestamp.Text = _pITransaction.DownloadTimeStamp.ToLongTimeString(); txtStartDate.Text = _pITransaction.StartDate.ToShortDateString(); txtEndDate.Text = _pITransaction.EndDate.ToShortDateString(); txtLines.Text = _pITransaction.LineCount.ToString(); txtUniqueCases.Text = _pITransaction.TotalCases.ToString(); txtImportStatus.Text = _pITransaction.ImportStatus; try { // Read the file as one string. System.IO.StreamReader myFile = new System.IO.StreamReader(_pITransaction.FilePath); txtRawData.Text = myFile.ReadToEnd(); myFile.Close(); } catch (IOException e) { // Let the user know what went wrong. txtRawData.Text = "The original raw data file was not found and may have been moved/removed from the directory!"; } GridViewLineItems.ItemsSource = PacerImportDataService.GetForImportTransaction(_pITransaction.ID); GridViewBankruptcyCases.ItemsSource = BankruptcyCaseService.GetFiltered(_pITransaction.ID.ToString(), string.Empty, string.Empty, string.Empty, 0, string.Empty, false); Mouse.OverrideCursor = Cursors.Arrow; } }
private void LoadAndProcessRemoveEmails() { try { MailMessageCollection msgs; grdViewRemoveEmails.ItemsSource = null; Imap imp = new Imap(); imp.Connect(ConfigurationManager.AppSettings["RemovePOP3Server"]); imp.Login(ConfigurationManager.AppSettings["RemovePOP3User"], ConfigurationManager.AppSettings["RemovePOP3Password"]); imp.SelectFolder("Inbox"); int totalCount = imp.MessageCount; msgs = imp.DownloadEntireMessages("1:" + totalCount.ToString(), false); if (totalCount > 0) { _removeMailMessages = new List <RemoveMail>(); RemoveMail _removeMailMessage = new RemoveMail(); int i = 1; foreach (MailMessage _msg in msgs) { _removeMailMessage = new RemoveMail() { IndexOnMailServer = i, MsgDateTime = _msg.DateReceived, ToAddress = _msg.To.ToString(), FromAddress = _msg.From.ToString(), Body = _msg.BodyPlainText, Subject = _msg.Subject }; if (((RemoveMail)_removeMailMessage).Subject.ToUpper().Contains("REMOVE")) { try { string[] _body = ((RemoveMail)_removeMailMessage).Body.Trim().Split(','); string[] _name = _body[0].Split(' '); BankruptcyCase _case = BankruptcyCaseService.GetByNameAndZip(_name[0], "", _name[1], Int32.Parse(_body[1].Trim())); if (_case != null) { _case.DontSend = true; BankruptcyCaseService.Save(_case, false); ((RemoveMail)_removeMailMessage).Processed = true; ((RemoveMail)_removeMailMessage).FoundAndRemoved = true; } else { ((RemoveMail)_removeMailMessage).Processed = true; ((RemoveMail)_removeMailMessage).FoundAndRemoved = false; } } catch { } } _removeMailMessages.Add(_removeMailMessage); //save to the DB RemoveMailService.Save(_removeMailMessage); } grdViewRemoveEmails.ItemsSource = _removeMailMessages; } //delete the messages if (ConfigurationManager.AppSettings["RemovePOP3Messages"] == "true") { imp.DeleteMessages(Imap.AllMessages, false); //_removeMailMessages.Clear(); } imp.Close(); imp.Disconnect(); } catch (Exception ex) { Debug.WriteLine(ex.ToString()); } }
private void btnImport_Click(object sender, RoutedEventArgs e) { string filePath = txtFilePathImport.Text; BankruptcyCaseService.ProcessAddressVerificationFile(txtFilePathImport.Text); }
public void ProcessMailingList(bool processMailMerge) { List <BankruptcyCase> _mailingCases = null; Database db = DatabaseFactory.CreateDatabase("BRGCaseMail"); DbConnection conn = db.CreateConnection(); conn.Open(); DbTransaction trans = conn.BeginTransaction(); try { // check the ID of the mailing list. If it is > 0 we know we are reprocessing a list so reload he old list minus the inactive people if (_dealerMailingList.ID > 0) { //get the old list for this mailing _mailingCases = BankruptcyCaseService.getMailingList(_dealerMailingList.ID); BankruptcyCaseService.UpdateLastSoldDateForMailingList(_dealerMailingList.ID, db, trans, false); //update the count as it could be less because of "do not send"'s and returned mail _dealerMailingList.NumberCases = _mailingCases.Count(); _dealerMailingList.CreationDate = DateTime.Now; DealerMailingListService.Save(_dealerMailingList, db, trans, false); } else { //get a new list for this mailing DealerMailingListService.Save(_dealerMailingList, db, trans, false); //get the mailing list and update the last sold date _mailingCases = BankruptcyCaseService.getMailingList(_dealerMailingList, db, trans, false); } string filePath = ConfigurationManager.AppSettings.Get("CSVFilePath") + _dealer.CompanyName.Replace(" ", "_") + "_" + _dealerMailingList.StartFilterDate.Month + _dealerMailingList.StartFilterDate.Day + _dealerMailingList.StartFilterDate.Year + "_" + _dealerMailingList.EndFilterDate.Month + _dealerMailingList.EndFilterDate.Day + _dealerMailingList.EndFilterDate.Year + "_" + _dealerMailingList.ID.ToString() + ".csv"; string delimiter = ","; string[] _columnHeadings = new string[] { "CaseNumber", "Case Number - 4 Digit", "FiledDate", "DischargedDate", "FirstName", "MiddleName", "LastName", "Suffix", "Address1", "Address2", "City", "State", "PostalCode", "Callsource" }; StringBuilder sb = new StringBuilder(); sb.AppendLine(string.Join(delimiter, _columnHeadings)); //put in the trackng letter: string[] _trackingLetter = new string[] { "000000", "000000", "", "", "Bankruptcy Resource Group", "", "", "", "10830 SW Tualatin Sherwood RD", "", "Tualatin", "OR", "97062", _dealer.CompanyName + ": " + DateTime.Now.ToShortDateString() + "; ID: " + _dealerMailingList.ID }; sb.AppendLine(string.Join(delimiter, _trackingLetter)); foreach (BankruptcyCase _case in _mailingCases) { //do this in a stored procedure in the "getMailingList" for speed. // _case.LastSoldDate = DateTime.Parse(DateTime.Now.ToShortDateString()); // _case.SoldCount += 1; // BankruptcyCaseService.Save(_case, db, trans, false) ; try { sb.AppendLine(string.Join(delimiter, _case.ToMailingStringArray(_dealer.CallSource))); } catch (Exception ex) { Debug.WriteLine(ex.ToString()); } //do this in a stored procedure in the "getMailingList" for speed. // DealerMailingListService.AddDealerMailingListCase(_dealerMailingList.ID, _case.ID, db, trans, false); } File.WriteAllText(filePath, sb.ToString()); //MailMergeStagingService.InsertList(_mailingCases, _dealer.CallSource, db, trans, false); _dealerMailingList.CsvFilePath = filePath; //create Mail merge if (processMailMerge) { ProcessWordMailMerge(false); } DealerMailingListService.Save(_dealerMailingList, db, trans, false); trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw ex; } }
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); }