public SigmaResultType GetConsumable(string consumableId)
 {
     SigmaResultType result = new SigmaResultType();
     try
     {
         ConsumableMgr consumableMgr = new ConsumableMgr();
         result = consumableMgr.GetConsumable(consumableId);
         return result;
     }
     catch (Exception ex)
     {
         // Log Exception
         ExceptionHelper.logException(ex);
         result.IsSuccessful = false;
         result.ErrorMessage = ex.Message;
         return result;
     }
 }
        public SigmaResultType MultiConsumable(List<TypeConsumable> listObj)
        {
            SigmaResultType result = new SigmaResultType();

            try
            {
                ConsumableMgr consumableMgr = new ConsumableMgr();
                result = consumableMgr.MultiConsumable(listObj);
                return result;
            }
            catch (Exception ex)
            {
                // Log Exception
                ExceptionHelper.logException(ex);
                result.IsSuccessful = false;
                result.ErrorMessage = ex.Message;
                return result;
            }
        }
        public SigmaResultType RemoveConsumable(TypeConsumable objConsumable)
        {
            SigmaResultType result = new SigmaResultType();

            try
            {
                ConsumableMgr consumableMgr = new ConsumableMgr();
                result = consumableMgr.RemoveConsumable(objConsumable);
                return result;
            }
            catch (Exception ex)
            {
                // Log Exception
                ExceptionHelper.logException(ex);
                result.IsSuccessful = false;
                result.ErrorMessage = ex.Message;
                return result;
            }
        }
        public SigmaResultType ListConsumable()
        {
            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"];

                ConsumableMgr consumableMgr = new ConsumableMgr();
                result = consumableMgr.ListConsumable(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;
            }
        }