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