Exemple #1
0
        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);
        }