public void DeleteCompanyContact(Contact contact)
{
if (contact == null)
{
throw new ArgumentNullException(nameof(contact));
}
_context.Contact.Remove(contact);
//remove the company assignment
CompanyContacts companyContacts = new CompanyContacts();
companyContacts.ContactId = contact.Id;
DeleteCompanyContactsAssignment(companyContacts);
//remove the site assignment
SiteContacts siteContacts = new SiteContacts();
siteContacts.ContactId = contact.Id;
DeleteSiteContactsAssignment(siteContacts);
//remove the terminal assignment
TerminalContacts terminalContacts = new TerminalContacts();
terminalContacts.ContactId = contact.Id;
DeleteTerminalContactsAssignment(terminalContacts);
}
public TerminalContacts GetCompanySiteTerminalContact(Guid companyId, Guid terminalId, Guid contactId)
{
TerminalContacts contact = new TerminalContacts();
if (terminalId == null || contactId == null)
{
throw new ArgumentNullException(nameof(GetCompanySiteTerminalContact));
}
var terminalContact = (from c in _context.Company
join con in _context.Contact on c.Id equals con.CompanyId
join tc in _context.TerminalContacts on con.Id equals tc.ContactId
join t in _context.Terminal on tc.TerminalId equals t.Id
where con.Id == contactId || tc.TerminalId == terminalId
select new { tc.ContactId, tc.TerminalId, t.TerminalName, con.Id, con.FirstName, con.LastName, con.Title, con.CountryCode, con.Phone, con.Mobile, con.Fax, con.Email });
foreach (var item in terminalContact)
{
contact.ContactId = item.ContactId;
contact.TerminalId = item.TerminalId;
//contact.Id = item.Id;
//contact.FirstName = item.FirstName;
//contact.LastName = item.LastName;
//contact.Title = item.Title;
//contact.CountryCode = item.CountryCode;
//contact.Phone = item.Phone;
//contact.Mobile = item.Mobile;
//contact.Fax = item.Fax;
//contact.Email = item.Email;
}
return(contact);
}
public void CreateCompanySiteTerminalContact(TerminalContacts terminalContacts)
{
if (terminalContacts == null)
{
throw new ArgumentNullException(nameof(SiteContacts));
}
_context.TerminalContacts.Add(terminalContacts);
}
public void DeleteTerminalContactsAssignment(TerminalContacts terminalContacts)
{
if (terminalContacts == null)
{
throw new ArgumentNullException(nameof(terminalContacts));
}
_context.TerminalContacts.Remove(terminalContacts);
}
