//----------------- save and update tax rates--------------------------
public static void SaveAndUpdateTaxRates(TaxRateDataTnfo taxRateDataObj, AspxCommonInfo aspxCommonObj)
{
try
{
AspxTaxMgntProvider.SaveAndUpdateTaxRates(taxRateDataObj, aspxCommonObj);
}
catch (Exception e)
{
throw e;
}
}
//----------------- save and update tax rates--------------------------
public static void SaveAndUpdateTaxRates(TaxRateDataTnfo taxRateDataObj, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@TaxRateID", taxRateDataObj.TaxRateID));
parameter.Add(new KeyValuePair <string, object>("@TaxRateTitle", taxRateDataObj.TaxRateTitle));
parameter.Add(new KeyValuePair <string, object>("@TaxCountryCode", taxRateDataObj.Country));
parameter.Add(new KeyValuePair <string, object>("@TaxStateCode", taxRateDataObj.State));
parameter.Add(new KeyValuePair <string, object>("@ZipPostCode", taxRateDataObj.Zip));
parameter.Add(new KeyValuePair <string, object>("@IsZipPostRange", taxRateDataObj.IsZipPostRange));
parameter.Add(new KeyValuePair <string, object>("@TaxRateValue", taxRateDataObj.TaxRateValue));
parameter.Add(new KeyValuePair <string, object>("@RateType", taxRateDataObj.RateType));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_SaveAndUpdateTaxRates", parameter);
}
catch (Exception e)
{
throw e;
}
}
//----------------- save and update tax rates--------------------------
public static void SaveAndUpdateTaxRates(TaxRateDataTnfo taxRateDataObj, AspxCommonInfo aspxCommonObj)
{
try
{
AspxTaxMgntProvider.SaveAndUpdateTaxRates(taxRateDataObj, aspxCommonObj);
}
catch (Exception e)
{
throw e;
}
}
//--------------tax rates------------------
public static List<TaxRateInfo> GetTaxRateDetails(int offset, System.Nullable<int> limit, TaxRateDataTnfo taxRateDataObj, AspxCommonInfo aspxCommonObj)
{
try
{
List<TaxRateInfo> lstTaxRate = AspxTaxMgntProvider.GetTaxRateDetails(offset, limit, taxRateDataObj, aspxCommonObj);
return lstTaxRate;
}
catch (Exception e)
{
throw e;
}
}
//--------------tax rates------------------
public static List <TaxRateInfo> GetTaxRateDetails(int offset, System.Nullable <int> limit, TaxRateDataTnfo taxRateDataObj, AspxCommonInfo aspxCommonObj)
{
try
{
List <TaxRateInfo> lstTaxRate = AspxTaxMgntProvider.GetTaxRateDetails(offset, limit, taxRateDataObj, aspxCommonObj);
return(lstTaxRate);
}
catch (Exception e)
{
throw e;
}
}
//----------------- save and update tax rates--------------------------
public void SaveAndUpdateTaxRates(TaxRateDataTnfo taxRateDataObj, AspxCommonInfo aspxCommonObj)
{
try
{
AspxTaxMgntController.SaveAndUpdateTaxRates(taxRateDataObj, aspxCommonObj);
}
catch (Exception ex)
{
throw ex;
}
}
//--------------tax rates------------------
public static List <TaxRateInfo> GetTaxRateDetails(int offset, System.Nullable <int> limit, TaxRateDataTnfo taxRateDataObj, 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>("@TaxName", taxRateDataObj.TaxName));
parameter.Add(new KeyValuePair <string, object>("@SearchCountry", taxRateDataObj.Country));
parameter.Add(new KeyValuePair <string, object>("@SerachState", taxRateDataObj.State));
parameter.Add(new KeyValuePair <string, object>("@Zip", taxRateDataObj.Zip));
SQLHandler sqlh = new SQLHandler();
List <TaxRateInfo> lstTaxRate = sqlh.ExecuteAsList <TaxRateInfo>("usp_Aspx_GetTaxRates", parameter);
return(lstTaxRate);
}
catch (Exception e)
{
throw e;
}
}
//----------------- save and update tax rates--------------------------
public static void SaveAndUpdateTaxRates(TaxRateDataTnfo taxRateDataObj, AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@TaxRateID", taxRateDataObj.TaxRateID));
parameter.Add(new KeyValuePair<string, object>("@TaxRateTitle", taxRateDataObj.TaxRateTitle));
parameter.Add(new KeyValuePair<string, object>("@TaxCountryCode", taxRateDataObj.Country));
parameter.Add(new KeyValuePair<string, object>("@TaxStateCode", taxRateDataObj.State));
parameter.Add(new KeyValuePair<string, object>("@ZipPostCode", taxRateDataObj.Zip));
parameter.Add(new KeyValuePair<string, object>("@IsZipPostRange", taxRateDataObj.IsZipPostRange));
parameter.Add(new KeyValuePair<string, object>("@TaxRateValue", taxRateDataObj.TaxRateValue));
parameter.Add(new KeyValuePair<string, object>("@RateType", taxRateDataObj.RateType));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_SaveAndUpdateTaxRates", parameter);
}
catch (Exception e)
{
throw e;
}
}
//--------------tax rates------------------
public static List<TaxRateInfo> GetTaxRateDetails(int offset, System.Nullable<int> limit, TaxRateDataTnfo taxRateDataObj, 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>("@TaxName", taxRateDataObj.TaxName));
parameter.Add(new KeyValuePair<string, object>("@SearchCountry", taxRateDataObj.Country));
parameter.Add(new KeyValuePair<string, object>("@SerachState", taxRateDataObj.State));
parameter.Add(new KeyValuePair<string, object>("@Zip", taxRateDataObj.Zip));
SQLHandler sqlh = new SQLHandler();
List<TaxRateInfo> lstTaxRate= sqlh.ExecuteAsList<TaxRateInfo>("usp_Aspx_GetTaxRates", parameter);
return lstTaxRate;
}
catch (Exception e)
{
throw e;
}
}
