public List <StaffEntity> GetStaff(STAFF_TYPE sType) { List <StaffEntity> staff = new List <StaffEntity>(); SqlConnection conn = new SqlConnection(STAFF_DB_CONN_STRING); SqlCommand command = new SqlCommand("GetActiveStaffByType", conn) { CommandType = CommandType.StoredProcedure }; command.Parameters.Clear(); int typeCode = ConvertStaffTypeToInt(sType); if (typeCode > 0) { command.Parameters.Add(new SqlParameter("@staffType", typeCode)); } try { conn.Open(); var reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { StaffEntity member = new StaffEntity(); member.FirstName = reader.GetString(reader.GetOrdinal("FirstName")); member.LastName = reader.GetString(reader.GetOrdinal("LastName")); member.Role = reader.GetString(reader.GetOrdinal("Role")); member.Bio = reader.GetString(reader.GetOrdinal("Bio")); string mType = reader.GetString(reader.GetOrdinal("StaffType")); member.Category = ConvertStringToStaffType(mType); string imgFilename = reader.GetString(reader.GetOrdinal("ImgFileName")); member.ImgUrl = IMG_URL_PREFIX + imgFilename; staff.Add(member); } } } catch (Exception ex) { } finally { conn.Close(); } return(staff); }
private int ConvertStaffTypeToInt(STAFF_TYPE sType) { switch (sType) { case STAFF_TYPE.FullTimeStaff: return(1); case STAFF_TYPE.PartTimeStaff: return(2); case STAFF_TYPE.Volunteer: return(3); default: return(0); } }