private void GetPassword(out int er)
{
DbConnection conn = DbSources.Sources().GetConnection(m_idListener, out er);
DataTable passTable = DbTSQLInterface.Select(ref conn, GetPassRequest(), null, null, out er);
if (er == 0)
{
if (!(passTable.Rows[0][0] is DBNull))
{
passReceive = passTable.Rows[0][0].ToString();
}
else
{
passResult = Errors.ParseError;
}
}
else
{
passResult = Errors.NoAccess;
}
}
public void Save(int idListener, List <ConnectionSettings> listConnSett, out int err)
{
err = 1;
int i = -1, c = -1;
string strQuery, psw
, hash;
//char []hash;
//StringBuilder sb;
strQuery = psw = string.Empty;
DbConnection conn = DbSources.Sources().GetConnection(idListener, out err);
//DbConnection conn = DbTSQLInterface.GetConnection (m_ConnectionSettings, out err);
if (err == 0)
{
DataTable tableSource = null,
tablePsw = null;
if (err == 0)
{
for (i = 0; i < listConnSett.Count; i++)
{
tableSource = DbTSQLInterface.Select(ref conn, ConnectionSettingsRequest(listConnSett[i].id), null, null, out err);
//TYPE_DATABASE_CFG.CFG_200 = ???
tablePsw = DbTSQLInterface.Select(ref conn, PasswordRequest(TYPE_DATABASE_CFG.CFG_200, listConnSett[i].id, 501), null, null, out err);
if (tableSource.Rows.Count == 0)
{//INSERT
}
else
if (tableSource.Rows.Count == 1)
{ //UPDATE
if ((listConnSett[i].server.Equals(tableSource.Rows [0]["IP"].ToString()) == false) ||
(listConnSett[i].dbName.Equals(tableSource.Rows[0]["DB_NAME"].ToString()) == false) ||
(listConnSett[i].userName.Equals(tableSource.Rows[0]["UID"].ToString()) == false))
{
strQuery += "UPDATE SOURCE SET ";
strQuery += "IP='" + listConnSett[i].server + "',";
strQuery += "DB_NAME='" + listConnSett[i].dbName + "',";
strQuery += "UID='" + listConnSett[i].userName + "'";
strQuery += " WHERE ID=" + listConnSett[i].id + ";";
}
else
{
; //Ничего не изменилось
}
if (listConnSett[i].password.Length > 0)
{
//sb = new StringBuilder(listConnSett[i].password);
//hash = Crypt.Crypting().to(sb, out err);
hash = Crypt.Crypting().Encrypt(listConnSett[i].password, Crypt.KEY);
//if (err > 0)
if (hash.Length > 0)
{
if (tablePsw.Rows.Count == 0)
{ //INSERT
strQuery += "INSERT INTO passwords (ID_EXT, ID_ROLE, HASH) VALUES (";
strQuery += listConnSett[i].id + ", ";
strQuery += 501 + ", ";
strQuery += "'" + hash + "'";
strQuery += ");";
}
else
if (tablePsw.Rows.Count == 1)
{ //UPDATE
strQuery += "UPDATE passwords SET ";
strQuery += "HASH='" + hash + "'";
strQuery += " WHERE ID_EXT=" + listConnSett[i].id;
strQuery += " AND ";
strQuery += "ID_ROLE=" + 501 + ";";
}
else
{
;
}
}
else
{
; //Ошибка шифрования пароля ИЛИ нет пароля
}
}
else
{
; //Нет пароля
}
}
else
{
;
}
}
DbTSQLInterface.ExecNonQuery(ref conn, strQuery, null, null, out err);
}
else
{
;
}
}
else
{
;
}
//DbTSQLInterface.CloseConnection (conn, out err);
}
