public SigmaResultType MultiMember(TypeMember clsObj)
        {
            SigmaResultType result = new SigmaResultType();

            try
            {
                MemberMgr memberMgr = new MemberMgr();
                result = memberMgr.MultiMember(clsObj);
                return result;
            }
            catch (Exception ex)
            {
                // Log Exception
                ExceptionHelper.logException(ex);
                result.IsSuccessful = false;
                result.ErrorMessage = ex.Message;
                return result;
            }
        }
        public SigmaResultType MultiProjectUserDiscipline(List<TypeProjectUserDiscipline> listObj)
        {
            SigmaResultType result = new SigmaResultType();

            try
            {
                MemberMgr memberMgr = new MemberMgr();
                result = memberMgr.MultiProjectUserDiscipline(listObj);
                return result;
            }
            catch (Exception ex)
            {
                // Log Exception
                ExceptionHelper.logException(ex);
                result.IsSuccessful = false;
                result.ErrorMessage = ex.Message;
                return result;
            }
        }
 public SigmaResultType ListRoleHierarchy()
 {
     SigmaResultType result = new SigmaResultType();
     try
     {
         var queryStr = WebOperationContext.Current.IncomingRequest.UriTemplateMatch.QueryParameters;
         MemberMgr memberMgr = new MemberMgr();
         result = memberMgr.ListRoleHierarchy();
         return result;
     }
     catch (Exception ex)
     {
         // Log Exception
         ExceptionHelper.logException(ex);
         result.IsSuccessful = false;
         result.ErrorMessage = ex.Message;
         return result;
     }
 }
        public SigmaResultType MultiHierarchy(List<TypeSigmaUserSigmaRole> listObj)
        {
            SigmaResultType result = new SigmaResultType();

            try
            {
                MemberMgr memberMgr = new MemberMgr();
                result = memberMgr.MultiHierarchy(listObj);
                return result;
            }
            catch (Exception ex)
            {
                // Log Exception
                ExceptionHelper.logException(ex);
                result.IsSuccessful = false;
                result.ErrorMessage = ex.Message;
                return result;
            }
        }
        public SigmaResultType ListProjectUserDiscipline()
        {
            SigmaResultType result = new SigmaResultType();
            try
            {
                var queryStr = WebOperationContext.Current.IncomingRequest.UriTemplateMatch.QueryParameters;
                string max = queryStr["max"];
                string offset = queryStr["offset"];
                string s_option = queryStr["s_option"];
                string s_key = queryStr["s_key"];
                string o_option = queryStr["o_option"];
                string o_desc = queryStr["o_desc"];

                MemberMgr memberMgr = new MemberMgr();
                result = memberMgr.ListProjectUserDiscipline(offset, max, s_option, s_key, o_option, o_desc);
                return result;
            }
            catch (Exception ex)
            {
                // Log Exception
                ExceptionHelper.logException(ex);
                result.IsSuccessful = false;
                result.ErrorMessage = ex.Message;
                return result;
            }
        }
 public SigmaResultType GetSigmaUserSigmaRole(string sigmaUserId)
 {
     SigmaResultType result = new SigmaResultType();
     try
     {
         MemberMgr memberMgr = new MemberMgr();
         result = memberMgr.GetSigmaUserSigmaRole(sigmaUserId);
         return result;
     }
     catch (Exception ex)
     {
         // Log Exception
         ExceptionHelper.logException(ex);
         result.IsSuccessful = false;
         result.ErrorMessage = ex.Message;
         return result;
     }
 }
        public SigmaResultType GetSigmaRoleBySigmaUser()
        {
            SigmaResultType result = new SigmaResultType();
            try
            {
                var queryStr = WebOperationContext.Current.IncomingRequest.UriTemplateMatch.QueryParameters;

                List<string> s_option = new List<string>();
                List<string> s_key = new List<string>();
                s_option.Add("@SigmaUserId");
                s_option.Add("@SigmaRoleId");
                s_key.Add(queryStr["SigmaUserId"]);
                s_key.Add(queryStr["SigmaRoleId"]);

                MemberMgr memberMgr = new MemberMgr();
                result = memberMgr.GetSigmaRoleBySigmaUser(s_option, s_key);
                return result;
            }
            catch (Exception ex)
            {
                // Log Exception
                ExceptionHelper.logException(ex);
                result.IsSuccessful = false;
                result.ErrorMessage = ex.Message;
                return result;
            }
        }
 public SigmaResultType AddSigmaUserSigmaRole(TypeSigmaUserSigmaRole objSigmaUserSigmaRole)
 {
     SigmaResultType result = new SigmaResultType();
     try
     {
         MemberMgr memberMgr = new MemberMgr();
         result = memberMgr.AddSigmaUserSigmaRole(objSigmaUserSigmaRole);
         return result;
     }
     catch (Exception ex)
     {
         // Log Exception
         ExceptionHelper.logException(ex);
         result.IsSuccessful = false;
         result.ErrorMessage = ex.Message;
         return result;
     }
 }
 public SigmaResultType AddProjectUserDiscipline(TypeProjectUserDiscipline objProjectUserDiscipline)
 {
     SigmaResultType result = new SigmaResultType();
     try
     {
         MemberMgr memberMgr = new MemberMgr();
         result = memberMgr.AddProjectUserDiscipline(objProjectUserDiscipline);
         return result;
     }
     catch (Exception ex)
     {
         // Log Exception
         ExceptionHelper.logException(ex);
         result.IsSuccessful = false;
         result.ErrorMessage = ex.Message;
         return result;
     }
 }