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