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);
}
private static Exec GetExecFromDR(NpgsqlDataReader dr)
{
int intExecID = Convert.ToInt32(dr["intExecID"]);
string strPosition = dr["strPosition"].ToString();
int intMemberID = Convert.ToInt32(dr["intMemberID"]);
int intDateID = Convert.ToInt32(dr["intDateID"]);
int intClubID = Convert.ToInt32(dr["intClubID"]);
Member member = MembersDAL.GetMember(intMemberID);
Date date = DatesDAL.GetDate(intDateID);
Club club = ClubsDAL.GetClub(intClubID);
Exec exec = Exec.Of(intExecID, strPosition, intMemberID, member, intDateID, date, intClubID, club);
return(exec);
}