public Task <bool> UpdateExternalConnectionsAsync(ExternalConnectionsDTO objExternalConnectionsDTO)
{
try
{
int intExternalConnectionsId = Convert.ToInt32(objExternalConnectionsDTO.Id);
var ExistingExternalConnections =
_context.ExternalConnections
.Where(x => x.Id == intExternalConnectionsId)
.FirstOrDefault();
if (ExistingExternalConnections != null)
{
ExistingExternalConnections.ServerName =
objExternalConnectionsDTO.ServerName;
ExistingExternalConnections.DatabaseName =
objExternalConnectionsDTO.DatabaseName;
ExistingExternalConnections.DatabaseUsername =
objExternalConnectionsDTO.DatabaseUsername;
ExistingExternalConnections.DatabasePassword =
objExternalConnectionsDTO.DatabasePassword;
ExistingExternalConnections.IntegratedSecurity =
objExternalConnectionsDTO.IntegratedSecurity;
_context.SaveChanges();
}
else
{
return(Task.FromResult(false));
}
return(Task.FromResult(true));
}
catch (Exception ex)
{
DetachAllEntities();
throw ex;
}
}
public Task <bool> DeleteExternalConnectionsAsync(ExternalConnectionsDTO objExternalConnectionsDTO)
{
int intExternalConnectionsId = Convert.ToInt32(objExternalConnectionsDTO.Id);
var ExistingExternalConnections =
_context.ExternalConnections
.Where(x => x.Id == intExternalConnectionsId)
.FirstOrDefault();
if (ExistingExternalConnections != null)
{
_context.ExternalConnections.Remove(ExistingExternalConnections);
_context.SaveChanges();
}
else
{
return(Task.FromResult(false));
}
return(Task.FromResult(true));
}
public Task <ExternalConnections> CreateExternalConnectionsAsync(ExternalConnectionsDTO objExternalConnectionsDTO)
{
try
{
ExternalConnections objExternalConnections = new ExternalConnections();
objExternalConnections.ServerName = objExternalConnectionsDTO.ServerName;
objExternalConnections.DatabaseName = objExternalConnectionsDTO.DatabaseName;
objExternalConnections.DatabaseUsername = objExternalConnectionsDTO.DatabaseUsername;
objExternalConnections.DatabasePassword = objExternalConnectionsDTO.DatabasePassword;
objExternalConnections.IntegratedSecurity = objExternalConnectionsDTO.IntegratedSecurity;
_context.ExternalConnections.Add(objExternalConnections);
_context.SaveChanges();
return(Task.FromResult(objExternalConnections));
}
catch (Exception ex)
{
DetachAllEntities();
throw ex;
}
}
