private void ReloadData(string xmlPath)
{
p1 = new project1();
XmlSerializer serializer = new XmlSerializer(p1.GetType());
FileStream fs = new FileStream(xmlPath, FileMode.Open);
p1 = (project1)serializer.Deserialize(fs);
textBox30.Text = p1.pdfForclosureOrder;
textBox31.Text = p1.pdfDisbursement;
textBox32.Text = p1.pdfNotification;
textBox33.Text = p1.pdfDeed;
textBox34.Text = p1.pdfSheriffDeed;
foreach (string misc in p1.miscPdfs)
{
listBoxPDF.Items.Add(misc);
}
tbName.Text = p1.mtgName;
tbDeedHolder.Text = p1.deedHolder;
tbFile.Text = p1.fileNumber;
tbSurplus.Text = p1.surplusAmount.ToString();
tbState.Text = p1.state;
tbCounty.Text = p1.county;
dateReviewed.SelectedDate = p1.dateReviewed;
tbResearcher.Text = p1.researcher;
tbHeld.Text = p1.verifyBy;
tbVerify.Text = p1.verifyHow;
tbAddress.Text = p1.foreclosedAdd;
dateRecorded.SelectedDate = p1.dateRecorded;
tbBook.Text = p1.book;
tbPage.Text = p1.page;
dateForclosed.SelectedDate = p1.dateForclosed;
tbNote.Text = p1.amountOnNote.ToString();
tbBeneficiary.Text = p1.beneficiary;
if (p1.hasEstatesForm)
cbAddEstates.IsChecked = true;
tbEstatesNameDeceased.Text = p1.mtgName.Split(new char[] { ',' })[0];
tbEstatesFileNumber.Text = p1.fileNumber;
tbEstatesFunds.Text = p1.surplusAmount.ToString();
cbEstatesCounty.Text = p1.county;
cbEstatesState.Text = p1.state;
dtEstateDateReviewed.SelectedDate = p1.dateReviewed;
tbEstatesResearcher.Text = p1.researcher;
tbEstatePartOf.Text = p1.estatePartOf;
tbEstatesHow.Text = p1.verifyHow + " " + p1.verifyBy;
tbEstatesDeathAtt.Text = p1.pdfEstateDeathCert;
tbEstatesWillAtt.Text = p1.pdfEstateWill;
tbEstatesNotifAtt.Text = p1.pdfEstateNotif;
foreach (string itm in p1.pdfEstateAnyDocsList)
{
listEstateAnyDocs.Items.Add(itm);
}
foreach (string itm in p1.pdfEstateAnyOtherDocsList)
{
listEstateAnyOtherDocs.Items.Add(itm);
}
try
{
tbEstatesName1.Text = p1.conclusionList[0].Name;
tbEstatesAmount1.Text = p1.conclusionList[0].Amount;
tbEstatesName2.Text = p1.conclusionList[1].Name;
tbEstatesAmount2.Text = p1.conclusionList[1].Amount;
tbEstatesName3.Text = p1.conclusionList[2].Name;
tbEstatesAmount3.Text = p1.conclusionList[2].Amount;
tbEstatesName4.Text = p1.conclusionList[3].Name;
tbEstatesAmount4.Text = p1.conclusionList[3].Amount;
}
catch{}
mtgList.Clear();
judList.Clear();
claimantList.Clear();
conclusionList.Clear();
List<mtgClass> mtgList2 = new List<mtgClass>();
List<judgementClass> judList2 = new List<judgementClass>();
List<conclusionClass> conclusionList2 = new List<conclusionClass>();
List<claimantsClass> claimantList2 = new List<claimantsClass>();
mtgList2 = p1.mtgList;
judList2 = p1.judgmentList;
claimantList2 = p1.claimantList;
conclusionList2 = p1.conclusionList;
foreach (mtgClass mtg in mtgList2)
{
AddMtgs(mtg);
}
foreach (claimantsClass cls in claimantList2)
{
AddClaimants(cls);
}
foreach (judgementClass jud in judList2)
{
AddJudgCases(jud);
}
foreach (conclusionClass conCls in conclusionList2)
{
AddConclusion(conCls);
}
fs.Close();
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
ScrollViewer.Visibility = System.Windows.Visibility.Hidden;
p1 = new project1();
ClearStatic();
Retry:
if (!File.Exists(Properties.Settings.Default.pathTemplate))
{
MessageBox.Show("Missing path to Excel TEMPLATE. Please select the file");
OpenFileDialog opendialog = new OpenFileDialog();
opendialog.Filter = "Excel files|*.xl*";
opendialog.Title = "EXCEL TEMPLATE";
if (opendialog.ShowDialog() == true)
{
Properties.Settings.Default.pathTemplate = opendialog.FileName;
Properties.Settings.Default.Save();
}
else
{
MessageBox.Show("No files selected. File path is required!");
goto Retry;
}
}
if (!File.Exists(Properties.Settings.Default.pathDeeds))
{
MessageBox.Show("Missing path to Excel DEEDS. Please select the file");
OpenFileDialog opendialog = new OpenFileDialog();
opendialog.Filter = "Excel files|*.xl*";
opendialog.Title = "EXCEL DEEDS";
if (opendialog.ShowDialog() == true)
{
Properties.Settings.Default.pathDeeds = opendialog.FileName;
Properties.Settings.Default.Save();
}
else
{
MessageBox.Show("No files selected. File path is required!");
goto Retry;
}
}
if (!Directory.Exists(Properties.Settings.Default.pathSaveFolder))
{
MessageBox.Show("Missing folder path for <EXCEL> saving. Please select the folder.");
Winforms.FolderBrowserDialog fdiag = new Winforms.FolderBrowserDialog();
fdiag.Description = "EXCEL SAVE FOLDER";
if (fdiag.ShowDialog() == Winforms.DialogResult.OK)
{
Properties.Settings.Default.pathSaveFolder = fdiag.SelectedPath;
Properties.Settings.Default.Save();
}
else
{
MessageBox.Show("Path to <EXCEL> save folder is not set. Path required!");
goto Retry;
}
}
Excel.Application xlApp = new Excel.Application();
Excel.Workbook xlWb = xlApp.Workbooks.Open(Properties.Settings.Default.pathTemplate, false, false);
Excel.Worksheet xlWs = xlWb.Worksheets["countylist"];
for (int rowx = 2; rowx <= xlWs.UsedRange.Rows.Count; rowx++)
{
if (!tbState.Items.Contains(xlWs.Cells[rowx, 2].Value2))
{
tbState.Items.Add(xlWs.Cells[rowx, 2].Value2);
cbEstatesState.Items.Add(xlWs.Cells[rowx, 2].Value2);
}
CountyStateList.Add(new Tuple<string, string>(xlWs.Cells[rowx, 1].value, xlWs.Cells[rowx, 2].Value2));
if (!tbHeld.Items.Contains(xlWs.Cells[rowx, 3].Value2))
tbHeld.Items.Add(xlWs.Cells[rowx, 3].Value2);
}
try
{
tbHeld.SelectedIndex = 0;
}
catch
{
}
xlWb.Close(false);
xlApp.Quit();
mtgID = 101;
mtgLabelCount.Content = "0 OF 13";
judgementID = 201;
judgementLabelCount.Content = "0 OF 12";
claimantID = 1;
claimantsLabelCount.Content = "0 OF 7";
conclusionID = 301;
tbResearcher.SelectedIndex = 0;
tbEstatesResearcher.Text = tbResearcher.Text;
tbHeld.SelectedIndex = 0;
tbEstatesHow.Text = tbHeld.Text;
tbName.Focus();
if (isTaxForm)
{
lblmtgDateForclosed.Margin = lblmtgDateRec.Margin;
lblmtgDateRec.Visibility = System.Windows.Visibility.Collapsed;
dateForclosed.Margin = dateRecorded.Margin;
dateRecorded.Visibility = System.Windows.Visibility.Collapsed;
lblmtgBook.Visibility = System.Windows.Visibility.Collapsed;
lblmtgPage.Visibility = System.Windows.Visibility.Collapsed;
tbBook.Visibility = System.Windows.Visibility.Collapsed;
tbPage.Visibility = System.Windows.Visibility.Collapsed;
lblmtgAmountNote.Content = "AMOUNT OF FORECLOSED ON(JUDGEMENT AMOUNT)";
lblmtgBeneficiary.Content = "FORECLOSING ENTITY (COUNTRY OR CITY NAME)";
lblmtgAmountNote.Margin = new Thickness(lblmtgAmountNote.Margin.Left, lblmtgAmountNote.Margin.Top - 70, lblmtgAmountNote.Margin.Right, lblmtgAmountNote.Margin.Bottom);
lblmtgBeneficiary.Margin = new Thickness(lblmtgBeneficiary.Margin.Left, lblmtgBeneficiary.Margin.Top - 70, lblmtgBeneficiary.Margin.Right, lblmtgBeneficiary.Margin.Bottom);
tbNote.Margin = new Thickness(tbNote.Margin.Left, tbNote.Margin.Top - 70, tbNote.Margin.Right, tbNote.Margin.Bottom);
tbBeneficiary.Margin = new Thickness(tbBeneficiary.Margin.Left, tbBeneficiary.Margin.Top - 70, tbBeneficiary.Margin.Right, tbBeneficiary.Margin.Bottom);
}
expander8.Visibility = System.Windows.Visibility.Collapsed;
}
