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