MARKUS

        public List<MarkupKeyValue> GetMarkupDataForPage(string project_no, string _markupinfoid, int _pageNo)

        {

            List<MarkupKeyValue> markupdata = new List<MarkupKeyValue>();

            MARKUP_INFO_VERSION markup_info_version = new MARKUP_INFO_VERSION();

            try

            {

                using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))

                {

                    markup_info_version = (from version in Entity.MARKUP_INFO_VERSION

                                           where version.MARKUPINFO_ID == _markupinfoid

                                           orderby version.CREATE_DATE descending

                                           select version).First();

                    markupdata = (from data in Entity.MARKUP_DATA

                                  where data.MARKUPINFO_VERSION_ID == markup_info_version.ID && data.PAGENUMBER == _pageNo

                                  select new MarkupKeyValue { ID = data.ID, Data = data.DATA }).ToList();

                }

            }

            catch (Exception)

            {

                return null;

            }

            return markupdata;

        }

        [OperationContract]