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