MARKUS

using KCOMDataModel.Common;

using KCOMDataModel.DataModel;

using System;

using System.Collections.Generic;

using System.IO;

using System.Linq;

using System.Text;

namespace MarkupToPDF.Common

{

    public class GetUserSign

    {

        /// <summary>

        /// get signature of given user of given project

        /// </summary>

        /// <param name="UserID"></param>

        /// <param name="ProjectNo"></param>

        /// <returns></returns>

        public string GetSign(string UserID, string ProjectNo)

        {

            var ModelWFConnectionString = ConnectStringBuilder.ProjectCIConnectString(ProjectNo).ToString();

            if (null != ModelWFConnectionString)

            {

                using (CIEntities entity = new CIEntities(ModelWFConnectionString))

                {

                    var _sign = entity.SIGN_INFO.Where(sin => sin.MEMBER_USER_ID == UserID);

                    if (_sign.Count() > 0)

                    {

                        return _sign.First().SIGN_STR;

                    }

                    else

                    {

                        return null;

                    }

                }

            }

            return null;

        }

    }

}