//-------------------save and update tax rules--------------------------------------

        public static void SaveAndUpdateTaxRule(TaxRuleDataInfo taxRuleDataObj, AspxCommonInfo aspxCommonObj)
        {
            try
            {
                AspxTaxMgntProvider.SaveAndUpdateTaxRule(taxRuleDataObj, aspxCommonObj);
            }
            catch (Exception e)
            {
                throw e;
            }
        }
        //--------------------------get customer class----------------

        public static List <TaxManageRulesInfo> GetTaxRules(int offset, int limit, TaxRuleDataInfo taxRuleDataObj, AspxCommonInfo aspxCommonObj)
        {
            try
            {
                List <TaxManageRulesInfo> lstTaxManage = AspxTaxMgntProvider.GetTaxRules(offset, limit, taxRuleDataObj, aspxCommonObj);
                return(lstTaxManage);
            }
            catch (Exception e)
            {
                throw e;
            }
        }
        //-------------------save and update tax rules--------------------------------------

        public static void SaveAndUpdateTaxRule(TaxRuleDataInfo taxRuleDataObj, AspxCommonInfo aspxCommonObj)
        {
            try
            {
                List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
                parameter.Add(new KeyValuePair <string, object>("@TaxManageRuleID", taxRuleDataObj.TaxManageRuleID));
                parameter.Add(new KeyValuePair <string, object>("@TaxManageRuleName", taxRuleDataObj.TaxManageRuleName));
                parameter.Add(new KeyValuePair <string, object>("@RoleID", taxRuleDataObj.RoleID));
                parameter.Add(new KeyValuePair <string, object>("@RoleName", taxRuleDataObj.RoleName));
                parameter.Add(new KeyValuePair <string, object>("@TaxItemClassID", taxRuleDataObj.TaxItemClassID));
                parameter.Add(new KeyValuePair <string, object>("@TaxRateID", taxRuleDataObj.TaxRateID));
                parameter.Add(new KeyValuePair <string, object>("@Priority", taxRuleDataObj.Priority));
                parameter.Add(new KeyValuePair <string, object>("@DisplayOrder", taxRuleDataObj.DisplayOrder));
                SQLHandler sqlH = new SQLHandler();
                sqlH.ExecuteNonQuery("usp_Aspx_SaveAndUpdateTaxRules", parameter);
            }
            catch (Exception e)
            {
                throw e;
            }
        }
        //--------------------------get customer class----------------

        public static List <TaxManageRulesInfo> GetTaxRules(int offset, int limit, TaxRuleDataInfo taxRuleDataObj, AspxCommonInfo aspxCommonObj)
        {
            try
            {
                List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
                parameter.Add(new KeyValuePair <string, object>("@offset", offset));
                parameter.Add(new KeyValuePair <string, object>("@limit", limit));
                parameter.Add(new KeyValuePair <string, object>("@RuleName", taxRuleDataObj.TaxManageRuleName));
                parameter.Add(new KeyValuePair <string, object>("@RoleName", taxRuleDataObj.RoleName));
                parameter.Add(new KeyValuePair <string, object>("@ItemClassName", taxRuleDataObj.TaxItemClassName));
                parameter.Add(new KeyValuePair <string, object>("@RateTitle", taxRuleDataObj.TaxRateTitle));
                parameter.Add(new KeyValuePair <string, object>("@SearchPriority", taxRuleDataObj.Priority));
                parameter.Add(new KeyValuePair <string, object>("@SearchDisplayOrder", taxRuleDataObj.DisplayOrder));
                SQLHandler sqlh = new SQLHandler();
                List <TaxManageRulesInfo> lstTaxManage = sqlh.ExecuteAsList <TaxManageRulesInfo>("usp_Aspx_GetTaxManageRules", parameter);
                return(lstTaxManage);
            }
            catch (Exception e)
            {
                throw e;
            }
        }
      //-------------------save and update tax rules--------------------------------------

      public static void SaveAndUpdateTaxRule(TaxRuleDataInfo taxRuleDataObj, AspxCommonInfo aspxCommonObj)
      {
          try
          {
              AspxTaxMgntProvider.SaveAndUpdateTaxRule(taxRuleDataObj, aspxCommonObj);
          }
          catch (Exception e)
          {
              throw e;
          }
      }
      //--------------------------get customer class----------------

      public static List<TaxManageRulesInfo> GetTaxRules(int offset, int limit, TaxRuleDataInfo taxRuleDataObj, AspxCommonInfo aspxCommonObj)
      {
          try
          {

              List<TaxManageRulesInfo> lstTaxManage = AspxTaxMgntProvider.GetTaxRules(offset, limit, taxRuleDataObj, aspxCommonObj);
              return lstTaxManage;
          }
          catch (Exception e)
          {
              throw e;
          }
      }
        //-------------------save and update tax rules--------------------------------------

        public void SaveAndUpdateTaxRule(TaxRuleDataInfo taxRuleDataObj, AspxCommonInfo aspxCommonObj)
        {
            try
            {
                AspxTaxMgntController.SaveAndUpdateTaxRule(taxRuleDataObj, aspxCommonObj);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
 //-------------------save and update tax rules--------------------------------------
 
 public static void SaveAndUpdateTaxRule(TaxRuleDataInfo taxRuleDataObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
         parameter.Add(new KeyValuePair<string, object>("@TaxManageRuleID", taxRuleDataObj.TaxManageRuleID));
         parameter.Add(new KeyValuePair<string, object>("@TaxManageRuleName", taxRuleDataObj.TaxManageRuleName));
         parameter.Add(new KeyValuePair<string, object>("@RoleID", taxRuleDataObj.RoleID));
         parameter.Add(new KeyValuePair<string, object>("@RoleName", taxRuleDataObj.RoleName));
         parameter.Add(new KeyValuePair<string, object>("@TaxItemClassID", taxRuleDataObj.TaxItemClassID));
         parameter.Add(new KeyValuePair<string, object>("@TaxRateID", taxRuleDataObj.TaxRateID));
         parameter.Add(new KeyValuePair<string, object>("@Priority", taxRuleDataObj.Priority));
         parameter.Add(new KeyValuePair<string, object>("@DisplayOrder", taxRuleDataObj.DisplayOrder));
         SQLHandler sqlH = new SQLHandler();
         sqlH.ExecuteNonQuery("usp_Aspx_SaveAndUpdateTaxRules", parameter);
     }
     catch (Exception e)
     {
         throw e;
     }
 }  
 //--------------------------get customer class----------------
 
 public static List<TaxManageRulesInfo> GetTaxRules(int offset, int limit, TaxRuleDataInfo taxRuleDataObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
         parameter.Add(new KeyValuePair<string, object>("@offset", offset));
         parameter.Add(new KeyValuePair<string, object>("@limit", limit));
         parameter.Add(new KeyValuePair<string, object>("@RuleName", taxRuleDataObj.TaxManageRuleName));
         parameter.Add(new KeyValuePair<string, object>("@RoleName", taxRuleDataObj.RoleName));
         parameter.Add(new KeyValuePair<string, object>("@ItemClassName", taxRuleDataObj.TaxItemClassName));
         parameter.Add(new KeyValuePair<string, object>("@RateTitle", taxRuleDataObj.TaxRateTitle));
         parameter.Add(new KeyValuePair<string, object>("@SearchPriority", taxRuleDataObj.Priority));
         parameter.Add(new KeyValuePair<string, object>("@SearchDisplayOrder", taxRuleDataObj.DisplayOrder));
         SQLHandler sqlh = new SQLHandler();
         List<TaxManageRulesInfo> lstTaxManage= sqlh.ExecuteAsList<TaxManageRulesInfo>("usp_Aspx_GetTaxManageRules", parameter);
         return lstTaxManage;
     }
     catch (Exception e)
     {
         throw e;
     }
 }