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;
}
}
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;
}
}