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 SiteContacts GetCompanySiteContact(Guid companyId, Guid siteId, Guid contactId)
{
SiteContacts contact = new SiteContacts();
if (siteId == null || contactId == null)
{
throw new ArgumentNullException(nameof(GetCompanySiteContact));
}
var siteContact = (from c in _context.Company
join con in _context.Contact on c.Id equals con.CompanyId
join sc in _context.SiteContacts on con.Id equals sc.ContactId
join s in _context.Site on sc.SiteId equals s.Id
where con.Id == contactId || sc.SiteId == siteId
select new { s.Id, sc.ContactId, s.SiteName, con.FirstName, con.LastName, con.Title, con.CountryCode, con.Phone, con.Mobile, con.Fax, con.Email });
foreach (var item in siteContact)
{
contact.SiteId = item.Id;
contact.ContactId = item.ContactId;
/* 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 CreateCompanySiteContact(SiteContacts SiteContacts)
{
if (SiteContacts == null)
{
throw new ArgumentNullException(nameof(SiteContacts));
}
_context.SiteContacts.Add(SiteContacts);
}
public void DeleteSiteContactsAssignment(SiteContacts siteContacts)
{
if (siteContacts == null)
{
throw new ArgumentNullException(nameof(siteContacts));
}
_context.SiteContacts.Remove(siteContacts);
}
public void CreateSiteContactsAssignment(SiteContacts siteContacts)
{
if (siteContacts == null)
{
throw new ArgumentNullException(nameof(siteContacts));
}
_context.SiteContacts.Add(siteContacts);
}
