public string listFields(string personID, string fieldName)
{
string json = "";
//using (OracleConnection dbConnection = Util.getDBConnection())
using (OracleConnection dbConnection = new OracleConnection(FacultyDirectoryListItem.getConnectionString()))
{
string str = "research_dir_user.profile_views.sel_research_view";
OracleCommand oracleCommand = new OracleCommand();
oracleCommand.Connection = dbConnection;
((DbCommand)oracleCommand).CommandText = str;
((DbCommand)oracleCommand).CommandType = CommandType.StoredProcedure;
oracleCommand.Parameters.Add("p_person_id", OracleDbType.Long, personID, ParameterDirection.Input);
oracleCommand.Parameters.Add("r_research", OracleDbType.RefCursor, ParameterDirection.Output);
oracleCommand.Parameters.Add("r_progs", OracleDbType.RefCursor, ParameterDirection.Output);
oracleCommand.Parameters.Add("r_title_depts", OracleDbType.RefCursor, ParameterDirection.Output);
oracleCommand.Parameters.Add("r_publications", OracleDbType.RefCursor, ParameterDirection.Output);
oracleCommand.Parameters.Add("r_degrees", OracleDbType.RefCursor, ParameterDirection.Output);
oracleCommand.Parameters.Add("r_lectures", OracleDbType.RefCursor, ParameterDirection.Output);
oracleCommand.Parameters.Add("r_positions", OracleDbType.RefCursor, ParameterDirection.Output);
oracleCommand.Parameters.Add("r_specialty", OracleDbType.RefCursor, ParameterDirection.Output);
oracleCommand.Parameters.Add("r_memberships", OracleDbType.RefCursor, ParameterDirection.Output);
oracleCommand.Parameters.Add("r_awards", OracleDbType.RefCursor, ParameterDirection.Output);
oracleCommand.Parameters.Add("r_grants", OracleDbType.RefCursor, ParameterDirection.Output);
oracleCommand.Parameters.Add("r_patents", OracleDbType.RefCursor, ParameterDirection.Output);
OracleDataAdapter oracleDataAdapter = new OracleDataAdapter(oracleCommand);
((DbConnection)dbConnection).Open();
((DbCommand)oracleCommand).ExecuteNonQuery();
DataSet dataSet = new DataSet();
((DataAdapter)oracleDataAdapter).Fill(dataSet);
//json = "success!";
//json = Newtonsoft.Json.JsonConvert.SerializeObject(dataSet, new Newtonsoft.Json.Converters.DataSetConverter());
var table = dataSet.Tables[0];
if (table.Rows.Count > 0)
{
json = table.ToString();
//json = dataSet.Tables[0].Rows[0][fieldName].ToString();
}
}
return(json);
}
public string doTest(string personID, FacultyDirectoryListItem item)
{
string json = "Nothing!!";
string title = "";
using (OracleConnection dbConnection = new OracleConnection(FacultyDirectoryListItem.getConnectionString()))
{
string str = "research_dir_user.profile_views.sel_research_view";
OracleCommand oracleCommand = new OracleCommand();
oracleCommand.Connection = dbConnection;
((DbCommand)oracleCommand).CommandText = str;
((DbCommand)oracleCommand).CommandType = CommandType.StoredProcedure;
oracleCommand.Parameters.Add("p_person_id", OracleDbType.Long, personID, ParameterDirection.Input);
oracleCommand.Parameters.Add("r_research", OracleDbType.RefCursor, ParameterDirection.Output);
oracleCommand.Parameters.Add("r_progs", OracleDbType.RefCursor, ParameterDirection.Output);
oracleCommand.Parameters.Add("r_title_depts", OracleDbType.RefCursor, ParameterDirection.Output);
oracleCommand.Parameters.Add("r_publications", OracleDbType.RefCursor, ParameterDirection.Output);
oracleCommand.Parameters.Add("r_degrees", OracleDbType.RefCursor, ParameterDirection.Output);
oracleCommand.Parameters.Add("r_lectures", OracleDbType.RefCursor, ParameterDirection.Output);
oracleCommand.Parameters.Add("r_positions", OracleDbType.RefCursor, ParameterDirection.Output);
oracleCommand.Parameters.Add("r_specialty", OracleDbType.RefCursor, ParameterDirection.Output);
oracleCommand.Parameters.Add("r_memberships", OracleDbType.RefCursor, ParameterDirection.Output);
oracleCommand.Parameters.Add("r_awards", OracleDbType.RefCursor, ParameterDirection.Output);
oracleCommand.Parameters.Add("r_grants", OracleDbType.RefCursor, ParameterDirection.Output);
oracleCommand.Parameters.Add("r_patents", OracleDbType.RefCursor, ParameterDirection.Output);
OracleDataAdapter oracleDataAdapter = new OracleDataAdapter(oracleCommand);
((DbConnection)dbConnection).Open();
((DbCommand)oracleCommand).ExecuteNonQuery();
DataSet dataSet = new DataSet();
((DataAdapter)oracleDataAdapter).Fill(dataSet);
//json = "success!";
json = Newtonsoft.Json.JsonConvert.SerializeObject(dataSet, new Newtonsoft.Json.Converters.DataSetConverter());
foreach (DataRow dataRow in (InternalDataCollectionBase)dataSet.Tables[0].Rows)
{
title = dataRow["title"].ToString();
//json += "Building = " + dataRow["bldg"].ToString();
//json += ", last_login = "******"last_login"].ToString();
//json += ", email = " + dataRow["email"].ToString();
//json += ", update_date = " + dataRow["update_date"].ToString();
}
//var table = dataSet.Tables[0];
//if (table.Rows.Count > 0)
//{
// json = dataSet.Tables[0].Rows[0][fieldName].ToString();
//}
//json = dataSet.Tables[0].Rows[0]["TITLE"].ToString();
//item.SCItem.Editing.BeginEdit();
//using (new EditContext(item.SCItem))
//{
// item.SCItem.Fields["Credentials"].Value = title;
//}
//item.SCItem.Editing.EndEdit();
}
return("");
}