//
// Deserialize JSON and load faculty information we need
//
public personInfo LoadFacultyInfo(NameValueCollection allFaculties, string personId)
{
HealthIS.Apps.MVC.Models.personInfo person = new HealthIS.Apps.MVC.Models.personInfo();
try
{
string jobTitle = allFaculties[personId];
jobTitle = jobTitle.Replace(";amp;", "&");
jobTitle = jobTitle.Replace(";eq;", "=");
jobTitle = jobTitle.Replace(";dump;", ""); // default value
person.jobTitle = jobTitle;
if (!personId.ToLower().Contains("temp_") && allFaculties.Count > 0)
{
// Get data from FacultyInfo method
System.Data.DataSet dataSet = Newtonsoft.Json.JsonConvert.DeserializeObject <System.Data.DataSet>(FacultyInfo(personId));
System.Data.DataTable dataTable = dataSet.Tables[0];
person.PERSON_ID = personId;
foreach (System.Data.DataRow row in dataTable.Rows)
{
person.FIRST_NAME = row["FIRST_NAME"].ToString();
person.LAST_NAME = row["LAST_NAME"].ToString();
person.TITLE = row["TITLE"].ToString();
person.EMAIL = row["EMAIL"].ToString();
var hscId = row["EMAIL"].ToString().Split('@');
person.HSCNET_ID = hscId[0].ToString();
}
// If FacultyInfo method doesn't have enough information, call SearchHD method to add more information
if (String.IsNullOrEmpty(person.EMAIL) && !String.IsNullOrEmpty(personId))
{
personInfo searchedData = SearchHD(person.FIRST_NAME, person.LAST_NAME, personId);
person.FIRST_NAME = searchedData.FIRST_NAME;
person.LAST_NAME = searchedData.LAST_NAME;
person.EMAIL = searchedData.EMAIL;
person.HSCNET_ID = searchedData.HSCNET_ID;
}
}
}
catch (Exception ex)
{
string error = "Error: " + ex.Message + "<br/>" + ex.StackTrace;
error += ex.InnerException == null ? "" : "<br/>Inner Exception: " + ex.InnerException.Message;
Sitecore.Diagnostics.Log.Error("Faculty Direcotry Error - 'LoadFacultyInfo' method: ", error);
}
return(person);
}
//
// This method is for addtional information, such as Credential and Email
//
public personInfo SearchHD(string fname, string lname, string personIdFromList)
{
string strConnect = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dbprod2.hscnet.hsc.usf.edu)(PORT=1522)))(CONNECT_DATA=(SID=DBAFRZN)(SERVER=DEDICATED)));User Id=hd_search_web;Password=flakSchn0z;";
HealthIS.Apps.MVC.Models.personInfo person = new HealthIS.Apps.MVC.Models.personInfo();
try
{
using (OracleConnection orCN = new OracleConnection(strConnect))
{
orCN.Open();
OracleCommand orCmd = new OracleCommand("hsc.hd_search.sel_matching_entries", orCN);
orCmd.CommandType = System.Data.CommandType.StoredProcedure;
orCmd.Parameters.Add("p_first_name", OracleDbType.Varchar2).Direction = System.Data.ParameterDirection.Input;
orCmd.Parameters["p_first_name"].Value = fname;
orCmd.Parameters.Add("p_last_name", OracleDbType.Varchar2).Direction = System.Data.ParameterDirection.Input;
orCmd.Parameters["p_last_name"].Value = lname;
orCmd.Parameters.Add("p_unique_id", OracleDbType.Varchar2).Direction = System.Data.ParameterDirection.Input;
orCmd.Parameters["p_unique_id"].Value = "";
orCmd.Parameters.Add("p_mdm_id", OracleDbType.Varchar2).Direction = System.Data.ParameterDirection.Input;
orCmd.Parameters["p_mdm_id"].Value = "";
orCmd.Parameters.Add("p_persons", OracleDbType.RefCursor).Direction = System.Data.ParameterDirection.Output;
orCmd.Parameters.Add("p_roles", OracleDbType.RefCursor).Direction = System.Data.ParameterDirection.Output;
orCmd.Parameters.Add("p_limit", OracleDbType.Int16).Direction = System.Data.ParameterDirection.Input;
orCmd.Parameters["p_limit"].Value = 10;
OracleDataAdapter adapt = new OracleDataAdapter(orCmd);
System.Data.DataSet orDS = new System.Data.DataSet();
orCmd.ExecuteNonQuery();
adapt.Fill(orDS);
foreach (System.Data.DataRow dr in orDS.Tables[0].Rows)
{
string personIdFromSearch = dr["PERSON_ID"].ToString();
if (personIdFromList == personIdFromSearch)
{
person.PERSON_ID = dr["PERSON_ID"].ToString();
person.FIRST_NAME = dr["FNAME"].ToString();
person.LAST_NAME = dr["LNAME"].ToString();
person.EMAIL = dr["EMAIL"].ToString();
person.HSCNET_ID = dr["HSCNET_ID"].ToString();
}
}
orDS.Dispose();
adapt.Dispose();
orCmd.Dispose();
orCN.Close();
orCN.Dispose();
}
}
catch (Exception ex)
{
string error = "Error: " + ex.Message + "<br/>" + ex.StackTrace;
error += ex.InnerException == null ? "" : "<br/>Inner Exception: " + ex.InnerException.Message;
Sitecore.Diagnostics.Log.Error("Faculty Direcotry Error - 'SearchHD' method: ", error);
}
return(person);
}
