public static void AddCusipFromUnitTestFolderToTestDatabase(string cusip)
{
string filePath =
SPFileManagementUtils.GetPathToTextFileInUnitTestFolder(cusip);
AddDealFromTextFileToDatabase(
filePath, SPFileManagementUtils.ConnectionStringSPTestDatabase);
}
private void saveProspectusesFromUrlsInXmlFile()
{
folderBrowserDialogToSaveProspectuses.ShowDialog();
string folderSavePath = folderBrowserDialogToSaveProspectuses.SelectedPath + @"\";
string [] urls =
SPFileManagementUtils.GetListOfUrlsFromXmlFile(_URL_LIST_XML_FILE_PATH).ToArray();
ProspectusRipping.BulkProspectusRipper ripper =
new ProspectusRipping.BulkProspectusRipper(folderSavePath, urls);
ripper.SaveProspectusesFromUrls(true, false, true, false);
ripper.SaveExecutionSummary();
ripper.SaveErrorLog();
MessageBox.Show("Finished ripping prospectus documents.", "Done");
}
private void buttonSave_Click(object sender, EventArgs e)
{
Visible = false;
try
{
string desiredRegexType = comboBoxRegexTypes.SelectedItem.ToString();
EStructureDetailRegexType type =
_regexTypesAndDescriptions.FirstOrDefault(x => x.Value == desiredRegexType).Key;
string fileName = textBoxRegexFileNameSave.Text;
SPFileManagementUtils.SaveRegularExpressionToExperimentalRegexFolder(type, fileName);
MessageBox.Show("Finished saving the regular expression to file.", "Done");
}
catch (Exception exc)
{
MessageBox.Show("Details: " + exc, "Error encountered");
}
finally
{
Application.Exit();
}
}
// Parses all text files in a given folder to add them to the desired database.
public static void AddAllDealsFromFolderToSPDatabase(
string pathToFolderContainingTextFiles,
string databaseConnectionString,
string filePathToSaveErrorLog)
{
IEnumerable <string> textFilePaths =
SPFileManagementUtils.GetNamesOfFilesInFolder(pathToFolderContainingTextFiles);
List <string> errorLog = new List <string> ();
int successfulFileAdditionCount = 0;
int failedFileAdditionCount = 0;
foreach (string path in textFilePaths)
{
try
{
AddDealFromTextFileToDatabase(path, databaseConnectionString);
successfulFileAdditionCount++;
}
catch (Exception e)
{
errorLog.Add("Failed file: " + path);
errorLog.Add("Error: " + e);
errorLog.Add("");
failedFileAdditionCount++;
}
}
string resultsSummary = String.Format(
"*** Results Summary ***\n\n" +
"{0} files were successfully ripped.\n" +
"{1} files encountered an exception.\n" +
"***********************\n\n",
successfulFileAdditionCount,
failedFileAdditionCount);
errorLog.Insert(0, resultsSummary);
saveErrorLog(errorLog, filePathToSaveErrorLog);
}
