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); }