public tbl_Site_Enterprise InsertSiteEnterprise(AdministrativeDomain domain, int siteId)
{
NewSiteEnterprise = mapper.MapSiteEnterprise(domain, siteId);
Context["backendAdmin"].GetTable <tbl_Site_Enterprise>().InsertOnSubmit(NewSiteEnterprise);
configuration.SaveAdminChanges();
return(NewSiteEnterprise);
}
public tbl_site InsertCentileSite(AdministrativeDomain domain, int siteNumber)
{
var centileSite = mapper.MapCentileSite(domain, siteNumber);
Context["centile"].GetTable <tbl_site>().InsertOnSubmit(centileSite);
configuration.SaveCentileChanges(centileSite.site_id_PK, siteNumber);
return(centileSite);
}
public tbl_Company InsertAdminCompany(AdministrativeDomain domain)
{
var company = mapper.MapAdminCompany(domain);
Context["backendAdmin"].GetTable <tbl_Company>().InsertOnSubmit(company);
configuration.SaveAdminChanges();
return(company);
}
public tbl_Site InsertAdminSite(AdministrativeDomain domain, int companyId)
{
var adminSite = mapper.MapAdminSite(domain, companyId);
Context["backendAdmin"].GetTable <tbl_Site>().InsertOnSubmit(adminSite);
configuration.SaveAdminChanges();
return(adminSite);
}
public tbl_Site_Enterprise MapSiteEnterprise(AdministrativeDomain domain, int siteId)
{
//TODO: need to get rid of magic numbers and strings
return(new tbl_Site_Enterprise
{
tbl_Site_EnterpriseId = 1,
tbl_SiteId = siteId,
tbl_Site_Enterprise_Name = $"{domain.AdmtiveDomainId}-{domain.DomainName}",
tbl_Site_Enterprise_Active = true
});
}
public tbl_company MapCentileCompany(AdministrativeDomain domain)
{
//TODO: need to get rid of magic numbers and strings
return(new tbl_company
{
company_name = domain.DomainName,
address_id_PK = 2,
branding_id = 3,
tbl_company_level_id_PK = 1,
tbl_Centile_Community_id_FK = domain.AdmtiveDomainId
});
}
public tbl_Company MapAdminCompany(AdministrativeDomain domain)
{
//TODO: need to get rid of magic numbers and strings
return(new tbl_Company
{
Company_Name = domain.DomainName,
tbl_AddressId = 2,
Company_Active = true,
tbl_Collection_ProcessId = 4,
tbl_Server_FTP_TypeId = 2
});
}
public tbl_site UpdateCentileSite(AdministrativeDomain enterprise, int siteNumber)
{
var tables = Context["centile"].GetTable <tbl_site>().AsEnumerable();
var centileSite = tables.FirstOrDefault(it => it.site_name.Equals(enterprise.DomainName));
if (centileSite == null)
{
return(null);
}
centileSite.site_number = siteNumber;
configuration.SaveCentileChanges(centileSite.site_id_PK, siteNumber);
return(centileSite);
}
public tbl_site MapCentileSite(AdministrativeDomain domain, int siteNumber)
{
//TODO: need to get rid of magic numbers and strings
return(new tbl_site
{
site_number = siteNumber,
site_name = domain.DomainName,
site_type = domain.DomainType,
site_userlimit = 15,
site_lastinfeedmodifieddate = DateTime.Now,
company_id_PK = 1,
address_id_PK = 1,
site_datadropfrequency = 1,
tbl_Centile_Community_Id = domain.AdmtiveDomainId
});
}
public tbl_Site MapAdminSite(AdministrativeDomain domain, int companyId)
{
//TODO: need to get rid of magic numbers and strings
return(new tbl_Site
{
tbl_companyId = companyId,
tbl_addressId = 11,
tbl_timezonesId = 1,
Site_name = domain.DomainName,
Site_active = true,
Site_MainLineNumber = domain.AdmtiveDomainId,
tbl_Server_DBDetailsId = 17,
tbl_Server_FTP_AccountId_Remote = 130,
tbl_Server_ArchiveFilesId = 8,
tbl_ContactFrequencyID = 2
});
}
private static bool IsTopLevel(AdministrativeDomain domain)
{
return(domain.AdmtiveDomainId.IsTopLevel());
}
public static bool IsTopLevel(this AdministrativeDomain domain) => domain.AdmtiveDomainId.Length == 2 && char.IsDigit(domain.AdmtiveDomainId, 0) && char.IsPunctuation(domain.AdmtiveDomainId, 1);
