public void LoadFacultyInfo()
{
try
{
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=sitecore_web;Password=Garbl3ph!em;";
StaffList = new System.Collections.Generic.List <NursingPerson>();
using (OracleConnection dbConnection = new OracleConnection(strConnect))
{
dbConnection.Open();
OracleCommand oracleCommand = new OracleCommand("research_dir_user.profile_views.sel_nurse_personnel", dbConnection);
oracleCommand.CommandType = System.Data.CommandType.StoredProcedure;
oracleCommand.Parameters.Add("r_cur", OracleDbType.RefCursor, ParameterDirection.Output);
OracleDataAdapter oracleDataAdapter = new OracleDataAdapter(oracleCommand);
System.Data.DataSet dataSet = new System.Data.DataSet();
oracleCommand.ExecuteNonQuery();
oracleDataAdapter.Fill(dataSet);
foreach (DataRow dr in dataSet.Tables[0].Rows)
{
NursingPerson person = new NursingPerson();
person.PERSON_ID = dr["person_id"].ToString().Trim();
person.FIRST_NAME = dr["first_name"].ToString().Trim();
person.LAST_NAME = dr["last_name"].ToString().Trim();
person.ROLE = dr["role"].ToString().Trim();
person.CREDENTIALS = dr["credentials"].ToString().Trim();
person.EMAIL = dr["email"].ToString().Trim();
person.PHONE = dr["phone"].ToString().Trim();
person.PRIMARY_POSITION = dr["primary_position"].ToString().Trim();
person.BUILDING = dr["building"].ToString().Trim();
person.ROOM = dr["room"].ToString().Trim();
StaffList.Add(person);
}
// Remove duplicate data in case of the person have both staff and faculty status
StaffList = StaffList.GroupBy(p => p.PERSON_ID).Select(s => s.FirstOrDefault()).ToList();
dataSet.Dispose();
oracleDataAdapter.Dispose();
oracleCommand.Dispose();
dbConnection.Close();
dbConnection.Dispose();
}
}
catch (Exception ex)
{
errorMessage = "Error: " + ex.Message + "<br/>" + ex.StackTrace;
errorMessage += ex.InnerException == null ? "" : "<br/>Inner Exception: " + ex.InnerException.Message;
Sitecore.Diagnostics.Log.Error("Faculty Direcotry Error - 'LoadFacultyInfo' method: ", errorMessage);
}
}
public List <ResearchTeam> NGroup(int value)
{
var l = _list.GroupBy(team => team.Members.Count() == value);
List <ResearchTeam> list = new List <ResearchTeam>(l.Count());
foreach (ResearchTeam team in l.ElementAt(0))
{
list.Add(team);
}
return(list);
}