public OrganizationDatabaseDetail UpdateOrganizationDatabaseDetail(int id, OrganizationDatabaseDetail organizationDatabaseDetail)
{
try
{
var _organizationDatabaseDetail = _context.OrganizationDatabaseDetail.Where(h => h.Id == id).FirstOrDefault();
_organizationDatabaseDetail.DatabaseName = organizationDatabaseDetail.DatabaseName;
//_organizationDatabaseDetail.IsActive = organizationDatabaseDetail.IsActive;
_organizationDatabaseDetail.IsCentralised = organizationDatabaseDetail.IsCentralised;
_organizationDatabaseDetail.Password = organizationDatabaseDetail.Password;
_organizationDatabaseDetail.ServerName = organizationDatabaseDetail.ServerName;
_organizationDatabaseDetail.UpdatedBy = organizationDatabaseDetail.UpdatedBy;
_organizationDatabaseDetail.UpdatedDate = DateTime.UtcNow;
_organizationDatabaseDetail.UserName = organizationDatabaseDetail.UserName;
//_context.Add(_organizationDatabaseDetail);
var result = _context.SaveChanges();
if (result > 0)
{
return(_organizationDatabaseDetail);
}
else
{
return(null);
}
}
catch (Exception)
{
return(null);
}
}
public string GetDomain(string host)
{
//TO DO Master connection string should be from app-setings
var optionsBuilder = new DbContextOptionsBuilder <HCMasterContext>();
optionsBuilder.UseSqlServer(CreateMasterConnectionString());
HCMasterContext masterContext = new HCMasterContext(optionsBuilder.Options);
string con = string.Empty;
//get the organization from Business-Name
MasterOrganization org = masterContext.MasterOrganization.Where(a => a.BusinessName == host && a.IsDeleted == false).FirstOrDefault();
if (org != null)
{
//get the db credentials for new connection
OrganizationDatabaseDetail orgData = masterContext.OrganizationDatabaseDetail.Where(a => a.Id == org.DatabaseDetailId && a.IsDeleted == false).FirstOrDefault();
//initialize Domain token model to create new connection string
DomainToken domainData = new DomainToken();
domainData.ServerName = orgData.ServerName;
domainData.DatabaseName = orgData.DatabaseName;
domainData.Password = orgData.Password;
domainData.UserName = orgData.UserName;
con = ConnectionString(domainData);
}
//return new connection string
return(con);
}
public OrganizationDatabaseDetail SaveOrganizationDatabaseDetail(OrganizationDatabaseDetail organizationDatabaseDetail)
{
try
{
_context.Add(organizationDatabaseDetail);
var result = _context.SaveChanges();
if (result > 0)
{
return(organizationDatabaseDetail);
}
else
{
return(null);
}
}
catch (System.Exception)
{
return(null);
}
}