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