Beispiel #1
0
        public List <sp_StadiumDraft_Select_Result_DomainModel> DraftStadiumList(int SeasonID, Guid?OwnerUserID)
        {
            List <sp_StadiumDraft_Select_Result_DomainModel> listStadiums = new List <sp_StadiumDraft_Select_Result_DomainModel>();

            using (CSBAAzureEntities context = new CSBAAzureEntities())
            {
                listStadiums = (from result in context.sp_StadiumDraft_Select(SeasonID, OwnerUserID)
                                select new sp_StadiumDraft_Select_Result_DomainModel
                {
                    ActiveFlg = result.ActiveFlg,
                    IsOwner = result.IsOwner,
                    OwnerUserID = result.OwnerUserID,
                    Points = result.Points,
                    SeasonID = result.SeasonID,
                    StadiumOrder = result.StadiumOrder,
                    StadiumID = result.StadiumID,
                    TeamID = result.TeamID,
                    TeamName = result.TeamName,
                    StadiumName = result.StadiumName,
                    StadiumImage = result.StadiumImage
                }).ToList();
            } // Guaranteed to close the Connection

            return(listStadiums);
        }