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); }