private string CreateOwnerLinks(List <string> owners, string companyName, DtstCOI.documentRow dbdoc)
{
if (ReadOnly)
{
return("Readonly mode detected, Not creating links");
}
var log = new StringWriter();
var dal = new LinkManager();
foreach (var owner in owners)
{
try
{
var details = owner.Split('|');
var date = DateTime.Parse(details[1]);
var positions =
details[2].ToLower().Replace("&", ",").Replace(" and ", ",").Replace(":", ",").Split(',');
foreach (var p in positions)
{
if (!NameAnalyzer.IsCompanyName(details[0]))
{
dal.CreateOrUpdate(InvestigationId, companyName, details[0], details[0],
SourceId, dbdoc.document_id, "Owner", date, p.Trim());
}
else
{
dal.CreateOrUpdateCoCoLink(companyName, details[0], 10, dbdoc.document_id, "Owner", p.Trim(), date);
}
}
}
catch (Exception ex)
{ log.WriteLine(ex.Message); }
}
return(log.ToString());
}
private void CreateLinks(DtstCOI.documentRow doc,
IList <string> officers, string registeredAgent, string companyName)
{
//officers
var dal = new LinkManager();
for (var i = 0; i < officers.Count; i++)
{
var pos = officers[i].Split('-')[0].Trim().ToLower();
var name = NameAnalyzer.NameCapitalizer(officers[i].Split('-')[1].Trim());
dal.CreateOrUpdate(InvestigationId, companyName, name, name, SourceId, doc.document_id,
"Officer", doc.document_date, pos);
}
//registred agent
if (NameAnalyzer.IsCompanyName(registeredAgent))
{
registeredAgent = Dbo.FilterName(registeredAgent);
companyName = Dbo.FilterName(companyName);
var table = dal.GetLinksByCoDateAndLinkType(companyName, registeredAgent, doc.document_id, RegistredAgent);
if (table.Rows.Count == 0)
{
table.Addcompany_company_linkRow(companyName, registeredAgent, SourceId, doc.document_id,
RegistredAgent, RegistredAgent, doc.document_date, doc.document_date
);
dal.Save(table);
}
var dal3 = new CompanyManager();
var companies = dal3.SearchCompanies(registeredAgent);
if (companies.FindBycompany_name(registeredAgent) == null)
{
companies.AddcompanyRow(registeredAgent);
dal3.Save(companies);
}
}
else
{
dal.CreateOrUpdate(InvestigationId, companyName, registeredAgent, registeredAgent, SourceId, doc.document_id,
"Registered Agent", doc.document_date, "Registered Agent");
}
}
public void CreateLinksManually()
{
try
{ if (HttpUtility.UrlDecode(TextURL.Text) == string.Empty)
{
throw new Exception("The URL does not appeat to be valid");
}
var d = new DocumentManager();
var doc = d.CreateOrGetDocumentByURL(this.TextURL.Text, _infoSourceId, Calendar1.SelectedDate, 0, "", "WebPage");
if (doc.Rows.Count == 0)
{
throw new Exception("Unable to create or retrieve database document for URL " + TextURL.Text);
}
var m = new LinkManager();
if (CheckBoxIIL.Checked)
{
var table = m.GetIILByName(TextIndName.Text);
table.Addindividual_individual_linkRow(TextIndName.Text, TextIndAlias.Text, _infoSourceId,
doc[0].document_id, TextLinkType.Text, Calendar1.SelectedDate);
m.Save(table);
LabelAlarm.Text += "Individual-individual link created<br />";
}
if (CheckBoxICoL.Checked)
{
var alias = TextIndAlias.Text == string.Empty ? TextIndName.Text : TextIndAlias.Text;
if (CheckBoxDateEnds.Checked)
{
m.CreateOrUpdate(_investigationId, TextCoName.Text, TextIndName.Text, alias, _infoSourceId,
doc[0].document_id, TextLinkType.Text, Calendar1.SelectedDate, TextPosition.Text, Calendar2.SelectedDate);
}
else
{
m.CreateOrUpdate(_investigationId, TextCoName.Text, TextIndName.Text, alias, _infoSourceId,
doc[0].document_id, TextLinkType.Text, Calendar1.SelectedDate, TextPosition.Text);
}
LabelAlarm.Text += "Individual-Company link created<br />";
}
if (CheckBoxCoCoL.Checked)
{
var title = TextPosition.Text == string.Empty ? TextLinkType.Text : TextPosition.Text;
var table = m.GetCoCoLinks(TextCoName.Text);
var row = table.FindBycompany_namecompany_name2supporting_doc_idlink_type(TextCoName.Text,
TextCoName2.Text,
doc[0].document_id,
TextLinkType.Text);
if (row == null)
{
if (CheckBoxDateEnds.Checked)
{
row = table.Addcompany_company_linkRow(TextCoName.Text, TextCoName2.Text, _infoSourceId
, doc[0].document_id, TextLinkType.Text,
title, Calendar1.SelectedDate,
Calendar2.SelectedDate);
}
else
{
row = table.Addcompany_company_linkRow(TextCoName.Text, TextCoName2.Text, _infoSourceId
, doc[0].document_id, TextLinkType.Text,
title, Calendar1.SelectedDate,
Calendar1.SelectedDate);
}
}
else
{
row.link_date = Calendar1.SelectedDate;
row.link_date_end = CheckBoxDateEnds.Checked ? Calendar2.SelectedDate : Calendar1.SelectedDate;
row.link_title = title;
}
m.Save(table);
}
}
catch (Exception e)
{
LabelAlarm.Text = e.Message;
}
}
