Ejemplo n.º 1
0
        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);
        }
Ejemplo n.º 2
0
        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);
        }
Ejemplo n.º 3
0
        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);
        }
Ejemplo n.º 4
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);
        }