MARKUS

using KCOMDataModel.DataModel;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace KCOMDataModel.Common

{

    public static class ObjectQuery

    {

        public static List<MEMBER> GetMemberQuery(System.Data.Objects.ObjectContext context, string UserID)

        {

            List<MEMBER> result = new List<MEMBER>();

            try

            {

                string query = "SELECT members.ID,members.NAME,members.DEPARTMENT FROM CIEntities.MEMBER as members where members.ID = @userId";

                var param = new[] { new System.Data.Objects.ObjectParameter("userId", UserID) };

                System.Data.Objects.ObjectQuery<System.Data.Common.DbDataRecord> memberQuery

                              = context.CreateQuery<System.Data.Common.DbDataRecord>(query, param);

                if (memberQuery.Count() > 0)

                {

                    foreach (var dataRecord in memberQuery)

                    {

                        MEMBER member = new MEMBER();

                        string userName = dataRecord["NAME"]?.ToString().Trim();

                        string ID = dataRecord["ID"]?.ToString().Trim();

                        string depatment = dataRecord["DEPARTMENT"]?.ToString().Trim();

                        member.NAME = userName;

                        member.ID = ID;

                        member.DEPARTMENT = depatment;

                        result.Add(member);

                    }

                }

            }

            catch (Exception ex)

            {

                throw new Exception("GetMember(System.Data.Objects.ObjectContext context, string UserID) ", ex);

            }

            return result;

        }

    }

}