public string readCellFromDb(OracleDataReader reader, int i)
{
string type = reader.GetFieldType(i).ToString();
switch (type)
{
case "System.String":
return(reader.GetOracleString(i).IsNull ? "" : reader.GetString(i));
case "System.DateTime":
{
return(reader.GetOracleDate(i).IsNull ? "" : reader.GetDateTime(i).ToString());
}
case "System.Character":
{
return(reader.GetChar(i).ToString());
}
case "System.Decimal":
{
return(reader.GetOracleDecimal(i).IsNull ? "" : System.Convert.ToString(reader.GetDecimal(i)));
}
case "System.Int64":
{
return(System.Convert.ToString(reader.GetInt64(i)));
}
}
return("");
}
public override char GetChar(int ordinal)
{
var value = source.GetValue(ordinal);
if (value is string)
{
return(((string)value)[0]);
}
if (value is ValueType)
{
return(Convert.ToChar(value));
}
return(source.GetChar(ordinal));
}
public void Retrieve_theBlocked_Users_Data()
{
numofBlockedUsers = Num_of_Blocked_Users();
if (numofBlockedUsers == -1)
{
return;
}
userName = new string[numofBlockedUsers];
Email = new string[numofBlockedUsers];
Blocked = new char[numofBlockedUsers];
con = new OracleConnection(_connectionString);
cmd = new OracleCommand();
cmd.Connection = con;
cmd.CommandText = "Retrieve_theBlocked_Users_Data";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("cursor", OracleDbType.RefCursor, DBNull.Value, ParameterDirection.Output);
try
{
con.Open();
dr = cmd.ExecuteReader();
int count = 0;
while (dr.Read())
{
userName[count] = dr["userName"].ToString();
Email[count] = dr.GetString(1).ToString();
Blocked[count++] = dr.GetChar(2);
}
dr.Close();
}
catch (Exception e)
{ }
finally
{
if (con.State == System.Data.ConnectionState.Open)
{
con.Close();
}
}
}
private IEnumerable <IntegrityHash> GetDataIntegrityHash()
{
List <IntegrityHash> listIntegrityHash = new List <IntegrityHash>();
string sqlQuery = "SELECT * FROM CMP_VERIFIC_INTEGRIDADE_HASH";
try
{
using (OracleConnection oracleConnection = new OracleConnection(ConnectionString))
{
using (var command = new OracleCommand(sqlQuery, oracleConnection))
{
oracleConnection.Open();
command.CommandType = CommandType.Text;
OracleDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
listIntegrityHash.Add(new IntegrityHash()
{
ObjectSystemId = dataReader.GetDecimal("N_COD_SISTEMA_OBJETO"),
ObjectName = dataReader.GetString("S_NOME_OBJETO"),
ObjectType = dataReader.GetString("S_TIPO_OBJETO"),
VersionAlteredObject = dataReader.IsDBNull("S_VERSAO_ALTEROU_OBJETO") ? null : dataReader.GetString("S_VERSAO_ALTEROU_OBJETO"),
CreationDate = dataReader.GetDateTime("D_DATA_CRIACAO"),
ObjectHash = dataReader.GetString("S_HASH_OBJETO"),
Flag = dataReader.IsDBNull("S_FLAG") ? null : dataReader.GetChar("S_FLAG").ToString()
});
}
return(listIntegrityHash);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public char GetChar(int i)
{
return(reader.GetChar(i));
}