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