public string CreateDbRecordsForNameChange(CompanyManager dal, LinkManager dalL, string oldName, string newName, DateTime dateOfChange, DtstCOI.documentRow dbDoc) { const string eventType = "name/symbol change"; const string linkType = "previous"; var log = new StringWriter(); //company names var companies = dal.SearchCompanies(oldName); var oldCo = companies.FindBycompany_name(oldName); if (oldCo == null) { companies.AddcompanyRow(oldName); dal.Save(companies); log.WriteLine("created co: {0}", oldName); } companies = dal.SearchCompanies(newName); var newco = companies.FindBycompany_name(newName); if (newco == null) { companies.AddcompanyRow(newName); dal.Save(companies); log.WriteLine("created co: {0}", newName); } //name change events and links var links = dalL.GetCoCoLinks(oldName, linkType); var link = links.FindBycompany_namecompany_name2supporting_doc_idlink_type(oldName, newName, dbDoc.document_id, linkType); if (link == null) { links.Addcompany_company_linkRow(oldName, newName, SourceId, dbDoc.document_id, linkType, linkType, dateOfChange, dateOfChange); dalL.Save(links); log.WriteLine("created company-company link"); } var events = dal.GetEventsByCo(oldName); if (events.FindBycompany_nameevent_typeevent_date(oldName, eventType, dateOfChange) == null) { events.Addcompany_eventRow(oldName, eventType, eventType, dateOfChange, dbDoc.document_id, SourceId, string.Empty, false); dal.SaveEvents(events); log.WriteLine("created event {0} for company {1}", eventType, oldName); } events = dal.GetEventsByCo(newName); if (events.FindBycompany_nameevent_typeevent_date(newName, eventType, dateOfChange) == null) { events.Addcompany_eventRow(newName, eventType, eventType, dateOfChange, dbDoc.document_id, SourceId, string.Empty, false); dal.SaveEvents(events); log.WriteLine("created event {0} for company {1}", eventType, newName); } return(log.ToString()); }
private static string GetCompaniesRows(string coName) { const string indRow = "<tr><td>{0}</td><td>{1}</td><td>{2:yyyy-MM-dd}</td><td>{3}</td></tr>"; var linMan = new LinkManager(); var companyLinks = linMan.GetCoCoLinks(coName); var s = new StringWriter(); foreach (var link in companyLinks) { object[] args = { link.company_name, link.link_type, link.link_date, link.supporting_doc_id }; if (args[0].ToString() == coName) { args[0] = link.company_name2; } s.WriteLine(indRow, args); } return(s.ToString()); }
private void PopulateLists() { _icl = _dal.GetIndividualCompanyLink(_investigationID); foreach (var row in _icl) { row.individual_name = ReplaceAllSpecialCharectersWith_(row.individual_name); if (_ppl.IndexOf(row.individual_name) == -1 && _ppl.Count < MaxNodes) { _ppl.Add(row.individual_name); } row.company_name = ReplaceAllSpecialCharectersWith_(row.company_name); if (_cos.IndexOf(row.company_name) == -1 && _cos.Count < MaxNodes) { _cos.Add(row.company_name); } } _ccl = _dal.GetCoCoLinks(_investigationID); foreach (var ccl in _ccl) { ccl.company_name = ReplaceAllSpecialCharectersWith_(ccl.company_name); ccl.company_name2 = ReplaceAllSpecialCharectersWith_(ccl.company_name2); } }
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; } }