public object PostAddEdit(DBConnectionDTO DBConnectionDTO)
{
sysBpmsDBConnection dBConnection = new sysBpmsDBConnection();
ResultOperation resultOperation = dBConnection.Update(DBConnectionDTO.ID, DBConnectionDTO.Name, DBConnectionDTO.DataSource, DBConnectionDTO.InitialCatalog, DBConnectionDTO.UserID, DBConnectionDTO.Password, DBConnectionDTO.IntegratedSecurity);
if (!resultOperation.IsSuccess)
{
return(new PostMethodMessage(resultOperation.GetErrors(), DisplayMessageType.error));
}
using (DBConnectionService dBConnectionService = new DBConnectionService())
{
if (dBConnection.ID != Guid.Empty)
{
resultOperation = dBConnectionService.Update(dBConnection);
}
else
{
resultOperation = dBConnectionService.Add(dBConnection);
}
if (resultOperation.IsSuccess)
{
return(new PostMethodMessage(SharedLang.Get("Success.Text"), DisplayMessageType.success));
}
else
{
return(new PostMethodMessage(resultOperation.GetErrors(), DisplayMessageType.error));
}
}
}
public void Delete(Guid DBConnectionId)
{
sysBpmsDBConnection DBConnection = this.Context.sysBpmsDBConnections.FirstOrDefault(d => d.ID == DBConnectionId);
if (DBConnection != null)
{
this.Context.sysBpmsDBConnections.Remove(DBConnection);
}
}
public DBConnectionDTO(sysBpmsDBConnection dBConnection)
{
this.ID = dBConnection.ID;
this.Name = dBConnection.Name;
this.DataSource = dBConnection.DataSource;
this.InitialCatalog = dBConnection.InitialCatalog;
this.UserID = dBConnection.UserID;
this.Password = dBConnection.Password;
this.IntegratedSecurity = dBConnection.IntegratedSecurity;
}
public ResultOperation Update(sysBpmsDBConnection dBConnection)
{
ResultOperation resultOperation = new ResultOperation();
if (this.GetList(dBConnection.Name).Any(c => c.ID != dBConnection.ID))
{
resultOperation.AddError(LangUtility.Get("RepetitiveNameError.Text", nameof(sysBpmsDBConnection)));
}
if (resultOperation.IsSuccess)
{
this.UnitOfWork.Repository <IDBConnectionRepository>().Update(dBConnection);
this.UnitOfWork.Save();
}
return(resultOperation);
}
/// <summary>
/// Tests connection string by opening it
/// </summary>
/// <returns></returns>
public bool TestConnection(sysBpmsDBConnection DBConnection)
{
try
{
string connectionString = GetSqlConnectionString(DBConnection);
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open(); // throws if invalid
return(true);
}
}
catch (Exception)
{
return(false);
}
}
/// <summary>
/// Creates a connection string by SqlConnectionStringBuilder and returns it.
/// </summary>
/// <returns></returns>
public string GetSqlConnectionString(sysBpmsDBConnection DBConnection)
{
SqlConnectionStringBuilder connectionString = new SqlConnectionStringBuilder()
{
DataSource = DBConnection.DataSource,
InitialCatalog = DBConnection.InitialCatalog,
MultipleActiveResultSets = true,
};
// Check current Windows account credentials are used for authentication
if (DBConnection.IntegratedSecurity)
{
connectionString.IntegratedSecurity = true;
}
else
{
connectionString.Password = DBConnection.Password;
connectionString.UserID = DBConnection.UserID;
}
return(connectionString.ConnectionString);
}
public void Update(sysBpmsDBConnection dbConnection)
{
this.Context.Entry(dbConnection).State = EntityState.Modified;
}
public void Add(sysBpmsDBConnection DBConnection)
{
DBConnection.ID = Guid.NewGuid();
this.Context.sysBpmsDBConnections.Add(DBConnection);
}
