public static string GetEncryptionKey() { WEBeSettings settings = new WEBeSettings(); OracleDataAccess.OracleCommandData data = new OracleDataAccess.OracleCommandData(); try { data._CommandType = CommandType.Text; data.CommandText = "select encryptionkey from WEBESETTINGS"; data.OpenWithOutTrans(); //Executing Query DataSet ds = data.Execute(OracleDataAccess.ExecutionType.ExecuteDataSet) as DataSet; if ((ds != null) && (ds.Tables.Count > 0) && (ds.Tables[0].Rows.Count > 0)) { settings.dt = ds.Tables[0]; settings.isValid = true; } } catch (Exception ex) { settings.Error = ex.Message.ToString(); //throw; } finally { data.Close(); } return(settings.dt.Rows[0]["encryptionkey"].ToString()); }
public static string GetDecryptedStringWithID(string ID, string Type) { WEBeSettings settings = new WEBeSettings(); OracleDataAccess.OracleCommandData data = new OracleDataAccess.OracleCommandData(); string DecryptedString = string.Empty; try { data._CommandType = CommandType.Text; if (Type.ToLower() == "master") { data.CommandText = "select note, hash from events where event_id =" + ID; } else if (Type.ToLower() == "detail") { data.CommandText = "select note, hash from EVENTS_DATA where note_id =" + ID; } data.OpenWithOutTrans(); //Executing Query DataSet ds = data.Execute(OracleDataAccess.ExecutionType.ExecuteDataSet) as DataSet; if ((ds != null) && (ds.Tables.Count > 0) && (ds.Tables[0].Rows.Count > 0)) { string EncryptedString = ds.Tables[0].Rows[0]["note"].ToString(); string Hash = ds.Tables[0].Rows[0]["hash"].ToString(); DecryptedString = DecryptAESCalculateHash(EncryptedString, Hash); } if (string.IsNullOrWhiteSpace((DecryptedString))) { DecryptedString = "Error: Message integrity has been lost."; } } catch (Exception ex) { settings.Error = ex.Message.ToString(); //throw; } finally { data.Close(); } return(DecryptedString); }