Esempio n. 1
0
        public List<sp_Vol_GroupVol_DM> ListGroupVols(sp_Vol_GroupVol_DM GroupVol)
        {
            List<sp_Vol_GroupVol_DM> list = new List<sp_Vol_GroupVol_DM>();
            try
            {
                using (VolTeerEntities context = new VolTeerEntities())
                {
                    list = (from result in context.sp_GroupVol_Select(GroupVol.GroupID, GroupVol.VolID)
                            select new sp_Vol_GroupVol_DM
                            {
                                GroupName = result.GroupName,
                                ParticipationLevelID = result.ParticipationLevelID,
                                Admin = result.Admin,
                                GroupActive = result.GroupActive,
                                GroupID = result.GroupID,
                                PrimaryVolID = result.PrimaryVolID,
                                VolActive = result.VolActive,
                                VolFirstName = result.VolFirstName,
                                VolMiddleName = result.VolMiddleName,
                                VolLastName = result.VolLastName,
                                VolID = result.VolID
                            }).ToList();
                } // Guaranteed to close the Connection
            }
            catch (Exception ex)
            {
                throw (ex);
            }

            return list;
        }