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); }