public SigmaResultType AddImportedSchedule(TypeImportedSchedule paramObj)
 {
     SigmaResultType result = new SigmaResultType();
     try
     {
         ScheduleMgr scheduleMgr = new ScheduleMgr();
         result = scheduleMgr.AddImportedSchedule(paramObj);
         return result;
     }
     catch (Exception ex)
     {
         // Log Exception
         ExceptionHelper.logException(ex);
         result.IsSuccessful = false;
         result.ErrorMessage = ex.Message;
         return result;
     }
 }
        /// <summary>
        /// Read & Set WBS
        /// Project Control > Data > Schedule > ImportSchedule
        /// </summary>
        /// <param name="UserName"></param>
        /// <param name="PassWord"></param>
        /// <returns></returns>
        public SigmaResultType ReadP6WBSManager(string projectId, string url, string UserName, string PassWord)
        {
            SigmaResultType result = new SigmaResultType();

            try
            {
                ScheduleMgr schMgr = new ScheduleMgr();
                result = schMgr.ReadP6WBSManager(int.Parse(projectId));
                return result;
            }
            catch (Exception ex)
            {
                ExceptionHelper.logException(ex);
                result.IsSuccessful = false;
                result.ErrorMessage = ex.Message;
                return result;
            }
        }
 public SigmaResultType ListImportedSchedule()
 {
     SigmaResultType result = new SigmaResultType();
     try
     {
         ScheduleMgr scheduleMgr = new ScheduleMgr();
         var queryStr = WebOperationContext.Current.IncomingRequest.UriTemplateMatch.QueryParameters;
         result = scheduleMgr.ListImportedSchedule(WebOperationContext.Current.IncomingRequest.UriTemplateMatch.QueryParameters);
         return result;
     }
     catch (Exception ex)
     {
         // Log Exception
         ExceptionHelper.logException(ex);
         result.IsSuccessful = false;
         result.ErrorMessage = ex.Message;
         return result;
     }
 }
        /// <summary>
        /// Get P6 Project List
        /// Project Control > Data > Schedule > Get Project Info
        /// </summary>
        /// <param name="userName">userName</param>
        /// <param name="password">password</param>
        /// <returns></returns>
        public SigmaResultType GetP6ProjectCombo(string userName, string password)
        {
            SigmaResultType result = new SigmaResultType();

            try
            {
                ScheduleMgr schMgr = new ScheduleMgr();
                result = schMgr.P6ProjectCombo(userName, password);
                return result;
            }
            catch (Exception ex)
            {
                ExceptionHelper.logException(ex);
                result.IsSuccessful = false;
                result.ErrorMessage = ex.Message;
                return result;
            }
        }
 public SigmaResultType GetImportedSchedule(string scheduledworkitemid)
 {
     SigmaResultType result = new SigmaResultType();
     try
     {
         ScheduleMgr scheduleMgr = new ScheduleMgr();
         result = scheduleMgr.GetImportedSchedule(scheduledworkitemid);
         return result;
     }
     catch (Exception ex)
     {
         // Log Exception
         ExceptionHelper.logException(ex);
         result.IsSuccessful = false;
         result.ErrorMessage = ex.Message;
         return result;
     }
 }
        /// <summary>
        /// 2014-03-09
        /// Get GeneralForeman
        /// </summary>
        /// <returns></returns>
        public SigmaResultType GetGeneralForeManCombo()
        {
            SigmaResultType result = new SigmaResultType();

            try
            {
                ScheduleMgr schMgr = new ScheduleMgr();
                result = schMgr.GetGeneralForeManCombo();
                return result;
            }
            catch (Exception ex)
            {
                ExceptionHelper.logException(ex);
                result.IsSuccessful = false;
                result.ErrorMessage = ex.Message;
                return result;
            }
        }