internal override void DeleteLogin(string user, DBInfoDTO dmInfoDto, DbProviderFactory factory, DbCommand cmd) { try { base.ExecuteNoneQuery(string.Format("sp_droplogin '{0}'", user), cmd); } catch (Exception exception) { throw exception; } }
internal void RemoveUser(DBInfoDTO dmInfoDto, string user, bool all) { DbProviderFactory providerFactory = this.GetProviderFactory(); using (DbConnection connectionString = providerFactory.CreateConnection()) { connectionString.ConnectionString = this.GetConnectionString(dmInfoDto); connectionString.Open(); this.DeleteUser(user, dmInfoDto, providerFactory, DatabaseBase.GetCommand(connectionString)); } }
private static UserDTO GetInfoParser(string message, UserDTO user, string separator) { LOG.grabarLog("BxSG - Se inicia proceso GetInfoParser"); if (user == null) { throw new Exception("UserDTO no seteado"); } Hashtable hash = convertStringToHash(message, separator); PropertyInfo[] properties = user.GetType().GetProperties(); for (int i = 0; i < (int)properties.Length; i++) { PropertyInfo propertyInfo = properties[i]; if (hash.ContainsKey(propertyInfo.Name)) { string item = (string)hash[propertyInfo.Name]; item = item.Replace("\\n", ""); MethodInfo setMethod = propertyInfo.GetSetMethod(); object[] objArray = new object[] { item }; setMethod.Invoke(user, objArray); } } int num = 0; //int num = int.Parse(user.DatabaseCount); if (num > 0) { DBInfoDTO[] dBInfoDTOArray = new DBInfoDTO[num]; for (int j = 0; j < num; j++) { DBInfoDTO dBInfoDTO = new DBInfoDTO(); PropertyInfo[] propertyInfoArray = dBInfoDTO.GetType().GetProperties(); for (int k = 0; k < (int)propertyInfoArray.Length; k++) { PropertyInfo propertyInfo1 = propertyInfoArray[k]; string str = string.Concat(propertyInfo1.Name, j + 1); if (hash.ContainsKey(str)) { string item1 = (string)hash[str]; item1 = item1.Replace("\\n", ""); MethodInfo methodInfo = propertyInfo1.GetSetMethod(); object[] objArray1 = new object[] { item1 }; methodInfo.Invoke(dBInfoDTO, objArray1); } } dBInfoDTOArray[j] = dBInfoDTO; } user.DbInfo = dBInfoDTOArray; } return(user); }
internal void AddUser(DBInfoDTO db, string user) { string cSCredPwd = db.CSCredPwd; DbProviderFactory providerFactory = this.GetProviderFactory(); using (DbConnection connectionString = providerFactory.CreateConnection()) { connectionString.ConnectionString = this.GetConnectionString(db); connectionString.Open(); this.RemoveUser(db, user, true); this.DeleteRoles(user, providerFactory, connectionString); this.AddUserInDB(user, db.CSCredPwd, db.Roles, providerFactory, connectionString); } }
internal void RemoveLogin(DBInfoDTO dmInfoDto, string user) { try { DbProviderFactory providerFactory = this.GetProviderFactory(); using (DbConnection connectionString = providerFactory.CreateConnection()) { connectionString.ConnectionString = this.GetConnectionString(dmInfoDto); connectionString.Open(); this.Kill(user, connectionString); this.DeleteLogin(user, dmInfoDto, providerFactory, DatabaseBase.GetCommand(connectionString)); } } catch { } }
private void AddUser(UserDTO user) { DBInfoDTO[] dbInfo = user.DbInfo; for (int i = 0; i < (int)dbInfo.Length; i++) { DBInfoDTO dBInfoDTO = dbInfo[i]; try { //this._SGAdminPassword = dBInfoDTO.DatabasePassword; DatabaseBase databaseBase = DatabaseFactory.Create(dBInfoDTO); if (databaseBase != null) { databaseBase.AddUser(dBInfoDTO, user.CSCredUser); } } catch (Exception exception1) { Exception exception = exception1; object[] server = new object[] { dBInfoDTO.Server, dBInfoDTO.ServerPortNo, dBInfoDTO.DatabaseInstance, exception.Message }; throw new ApplicationException(string.Format("Error al crear usuario en {0}:{1}/{2}. {3}", server), exception); } } }
internal override string GetConnectionString(DBInfoDTO db) { object[] server = new object[] { db.Server, db.DatabaseInstance, db.DatabaseUserID, db.DatabasePassword, db.ServerPortNo }; return(string.Format("Server={0},{4}; Database={1}; User={2}; Password={3};", server)); }
internal abstract string GetConnectionString(DBInfoDTO dBInfoDTO);
internal abstract void DeleteUser(string user, DBInfoDTO dmInfoDto, DbProviderFactory factory, DbCommand cmd);
private void AddUserInDB(string dbUserName, DBInfoDTO dbInfo, string connectionString) { }