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);
}
private static Show GetShowFromDR(NpgsqlDataReader dr)
{
int intShowID = Convert.ToInt32(dr["intShowID"]);
string strName = dr["strName"].ToString();
string strAuthor = dr["strAuthor"].ToString();
int intBudget = Convert.ToInt32(dr["intBudget"]);
bool ysnIsMusical = Convert.ToBoolean(dr["ysnIsMusical"]);
int intClubID = Convert.ToInt32(dr["intClubID"]);
int intDateID = Convert.ToInt32(dr["intDateID"]);
Club club = ClubsDAL.GetClub(intClubID);
Date date = DatesDAL.GetDate(intDateID);
Show show = Show.Of(intShowID, strName, strAuthor, intBudget, ysnIsMusical, intClubID, club, intDateID, date);
return(show);
}