public static List <StoreTaxesInfo> GetStoreSalesTaxes(TaxDateData taxDataObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
         parameter.Add(new KeyValuePair <string, object>("@offset", taxDataObj.offset));
         parameter.Add(new KeyValuePair <string, object>("@limit", taxDataObj.limit));
         parameter.Add(new KeyValuePair <string, object>("@TaxManageRuleName", taxDataObj.taxRuleName));
         SQLHandler sqlh = new SQLHandler();
         if (taxDataObj.monthly == true)
         {
             return(sqlh.ExecuteAsList <StoreTaxesInfo>("usp_Aspx_GetTaxRuleForStoreTaxReport", parameter));
         }
         if (taxDataObj.weekly == true)
         {
             return(sqlh.ExecuteAsList <StoreTaxesInfo>("usp_Aspx_GetTaxDetailsByCurrentMonth", parameter));
         }
         if (taxDataObj.hourly == true)
         {
             return(sqlh.ExecuteAsList <StoreTaxesInfo>("usp_Aspx_GetTaxReportDetailsBy24hours", parameter));
         }
         else
         {
             return(new List <StoreTaxesInfo>());
         }
     }
     catch (Exception e)
     {
         throw e;
     }
 }
Example #2
0
 public static List <StoreTaxesInfo> GetStoreSalesTaxes(TaxDateData taxDataObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List <StoreTaxesInfo> lstStoreTax = AspxTaxMgntProvider.GetStoreSalesTaxes(taxDataObj, aspxCommonObj);
         return(lstStoreTax);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 public static List<StoreTaxesInfo> GetStoreSalesTaxes(int offset, int limit, TaxDateData taxDataObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List<StoreTaxesInfo> lstStoreTax = AspxTaxMgntProvider.GetStoreSalesTaxes( offset,  limit, taxDataObj, aspxCommonObj);
         return lstStoreTax;
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 public static List<StoreTaxesInfo> GetStoreSalesTaxes(int offset, int limit, TaxDateData taxDataObj, 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>("@TaxManageRuleName", taxDataObj.taxRuleName));
        
         SQLHandler sqlh = new SQLHandler();
         if (taxDataObj.monthly == true)
         {
             return sqlh.ExecuteAsList<StoreTaxesInfo>("usp_Aspx_GetTaxRuleForStoreTaxReport", parameter);
         }
         if (taxDataObj.weekly == true)
         {                  
             return sqlh.ExecuteAsList<StoreTaxesInfo>("usp_Aspx_GetTaxDetailsByCurrentMonth", parameter);
         }
         if (taxDataObj.hourly == true)
         {
             return sqlh.ExecuteAsList<StoreTaxesInfo>("usp_Aspx_GetTaxReportDetailsBy24hours", parameter);
         }
         else
             return new List<StoreTaxesInfo>();
     }
     catch (Exception e)
     {
         throw e;
     }
 }