private static Staff GetStaffFromDR(NpgsqlDataReader dr)
{
int intStaffID = Convert.ToInt32(dr["intStaffID"]);
string strPosition = dr["strPosition"].ToString();
int intMemberID = Convert.ToInt32(dr["intMemberID"]);
int intShowID = Convert.ToInt32(dr["intShowID"]);
Show show = ShowsDAL.GetShow(intShowID);
Member member = MembersDAL.GetMember(intMemberID);
Staff staff = Staff.Of(intStaffID, strPosition, intMemberID, member, intShowID, show);
return(staff);
}
private static Cast GetCastFromDR(NpgsqlDataReader dr)
{
int intCastID = Convert.ToInt32(dr["intCastID"]);
string strVoicePart = dr["strVoicePart"].ToString();
string strRole = dr["strRole"].ToString();
int intMemberID = Convert.ToInt32(dr["intMemberID"]);
int intShowID = Convert.ToInt32(dr["intShowID"]);
Show show = ShowsDAL.GetShow(intShowID);
Member member = MembersDAL.GetMember(intMemberID);
Cast cast = Cast.Of(intCastID, strVoicePart, strRole, intMemberID, member, intShowID, show);
return(cast);
}
private static Pit GetPitFromDR(NpgsqlDataReader dr)
{
int intPitID = Convert.ToInt32(dr["intPitID"]);
string strInstrument = dr["strInstrument"].ToString();
int intSeat = Convert.ToInt32(dr["intSeat"]);
int intMemberID = Convert.ToInt32(dr["intMemberID"]);
int intShowID = Convert.ToInt32(dr["intShowID"]);
Show show = ShowsDAL.GetShow(intShowID);
Member member = MembersDAL.GetMember(intMemberID);
Pit pit = Pit.Of(intPitID, strInstrument, intSeat, intMemberID, member, intShowID, show);
return(pit);
}