private void DoSearchAllIndividualsinSEC()
{
var dal = new IndividualManager();
var dalL = new LinkManager();
var dalI = new InvestigationManager();
var aux = new Batch2WebAux(Response, BatchManager.BatchNamesEnum.SECLookupIndividuals);
aux.AddHead();
var table = dalI.GetInvestigatedIndividuals();
var c = 0D;
var alreadySearched = new List <string>();
foreach (var ii in table)
{
if (alreadySearched.Contains(ii.individual_name.ToLower()))
{
c++;
continue;
}
var names = new List <string> {
ii.individual_name
};
var aliases = dalL.GetIILByName(ii.individual_name);
foreach (var alias in aliases)
{
if (alias.link_type == "alias" & !names.Contains(alias.individual_alias))
{
names.Add(alias.individual_alias);
}
}
NameAnalyzer.AutoAliases(ii.individual_name, names);
foreach (var name in names)
{
if (alreadySearched.Contains(name.ToLower()))
{
continue;
}
try
{
if (ii.individual_name != name)
{
aux.WriteLine("Searcing ALL SEC filings for: " + ii.individual_name + " under alias: " + name);
}
else
{
aux.WriteLine("Searcing ALL SEC filings for: " + ii.individual_name);
}
dal.ImportIndividualFromSrc10(ii.individual_name, name);
}catch (Exception ex2)
{ aux.WriteLine(string.Format("<hr /><b>Exception:<br />\r\n</b>{0}<hr/>", ex2)); }
alreadySearched.Add(name.ToLower());
}
c++;
aux.SetProgress(c / table.Rows.Count);
}
aux.AddFoot();
aux.Save();
}
private void PopulateAllIndividualNames()
{
var individualManager = new IndividualManager();
var table = individualManager.GetIndividuals();
DropExistingIndividuals.DataSource = table;
DropExistingIndividuals.DataTextField = table.individual_nameColumn.ColumnName;
DropExistingIndividuals.DataValueField = table.individual_nameColumn.ColumnName;
DropExistingIndividuals.DataBind();
}
protected void ButtonSerachMentions_Click(object sender, EventArgs e)
{
if (TextBoxPrimaryName.Text.Trim() == string.Empty)
{
LabelAlarm.Text = "Please specify at least the primary name";
return;
}
TextBoxPrimaryName.Text = NameAnalyzer.NameCapitalizer(TextBoxPrimaryName.Text);
if (TextBoxAliases.Text.Trim() == string.Empty)
{
TextBoxAliases.Text = TextBoxPrimaryName.Text;
}
var aliases = TextBoxAliases.Text.Replace("\r\n", "\n").Split('\n');
var aliasesList = new List <string> ();
foreach (var s in aliases)
{
if (!aliasesList.Contains(s))
{
aliasesList.Add(s);
}
}
foreach (var s in aliasesList)
{
try
{
var dal = new IndividualManager();
dal.ImportIndividualFromSrc10(TextBoxPrimaryName.Text, s);
}
catch (Exception ex)
{
LabelAlarm.Text += ex.Message + "<br />";
return;
}
}
if (CheckUseInvestigation.Checked)
{
var dali = new InvestigationManager();
var invID = int.Parse(DropInvestigations.SelectedValue);
var table = dali.GetInvestigatedIndividuals(invID);
var row = table.FindByindividual_nameinvestigation_id(TextBoxPrimaryName.Text, invID);
if (row == null)
{
table.Addinvestigated_individualRow(TextBoxPrimaryName.Text, invID);
}
dali.Save(table);
}
LabelAlarm.Text = "processed with no errors";
}
protected void ButtonFilterIndividual_Click(object sender, EventArgs e)
{
if (TextBoxIndividual.Text.Trim() == string.Empty)
{
return;
}
var manager = new IndividualManager();
var table = manager.SearchByName(TextBoxIndividual.Text.Trim().ToLower());
DropIndividual.Items.Clear();
DropIndividual.DataSource = table;
DropIndividual.DataTextField = table.individual_nameColumn.ColumnName;
DropIndividual.DataValueField = table.individual_nameColumn.ColumnName;
DropIndividual.DataBind();
DropIndividual.Enabled = DropIndividual.Items.Count > 0;
}
protected void ButtonSrchPerson_Click(object sender, EventArgs e)
{
if (TextNamePerson.Text.Trim().Length < 1)
{
return;
}
var dal = new IndividualManager();
var table = dal.SearchByName(this.TextNamePerson.Text);
CheckAll.Checked = false;
CheckResults.Items.Clear();
CheckResults.DataSource = table;
CheckResults.DataTextField = table.individual_nameColumn.ColumnName;
CheckResults.DataValueField = table.individual_nameColumn.ColumnName;
CheckResults.DataBind();
Panel1.Visible = true;
}
protected void ButtonP2A_Click(object sender, EventArgs e)
{
try
{
if (TextNamePerson.Text.Trim().Length < 2)
{
return;
}
if (TextAliasPerson.Text.Trim().Length < 2)
{
return;
}
var dal = new IndividualManager();
dal.ConvertIndividualToAlias(TextNamePerson.Text, TextAliasPerson.Text);
LabelOut.Text = "Conversion reported no errors";
}
catch (Exception ex)
{
LabelOut.Text = ex.Message;
}
}
protected void AddNewIndividual(List <string> names)
{
var individualManager = new IndividualManager();
var tableI = individualManager.GetIndividuals();
var table = _dal.GetInvestigatedIndividuals(_investigationId);
foreach (var name in names)
{
if (tableI.FindByindividual_name(name) == null)
{
tableI.AddindividualRow(name, true);
individualManager.Save(tableI);
}
var existing = table.FindByindividual_nameinvestigation_id(name, _investigationId);
if (existing != null)
{
continue;
}
table.Addinvestigated_individualRow(name, _investigationId);
_dal.Save(table);
}
}
