private DBTaxRate GetTaxRateFromReader(IDataReader dataReader)
{
DBTaxRate taxRate = new DBTaxRate();
taxRate.TaxRateID = NopSqlDataHelper.GetInt(dataReader, "TaxRateID");
taxRate.TaxCategoryID = NopSqlDataHelper.GetInt(dataReader, "TaxCategoryID");
taxRate.CountryID = NopSqlDataHelper.GetInt(dataReader, "CountryID");
taxRate.StateProvinceID = NopSqlDataHelper.GetInt(dataReader, "StateProvinceID");
taxRate.Zip = NopSqlDataHelper.GetString(dataReader, "Zip");
taxRate.Percentage = NopSqlDataHelper.GetDecimal(dataReader, "Percentage");
return(taxRate);
}
private DBTaxRate GetTaxRateFromReader(IDataReader dataReader)
{
var item = new DBTaxRate();
item.TaxRateId = NopSqlDataHelper.GetInt(dataReader, "TaxRateID");
item.TaxCategoryId = NopSqlDataHelper.GetInt(dataReader, "TaxCategoryID");
item.CountryId = NopSqlDataHelper.GetInt(dataReader, "CountryID");
item.StateProvinceId = NopSqlDataHelper.GetInt(dataReader, "StateProvinceID");
item.Zip = NopSqlDataHelper.GetString(dataReader, "Zip");
item.Percentage = NopSqlDataHelper.GetDecimal(dataReader, "Percentage");
return(item);
}
private static TaxRate DBMapping(DBTaxRate dbItem)
{
if (dbItem == null)
return null;
TaxRate item = new TaxRate();
item.TaxRateID = dbItem.TaxRateID;
item.TaxCategoryID = dbItem.TaxCategoryID;
item.CountryID = dbItem.CountryID;
item.StateProvinceID = dbItem.StateProvinceID;
item.Zip = dbItem.Zip;
item.Percentage = dbItem.Percentage;
return item;
}
/// <summary>
/// Gets all tax rates
/// </summary>
/// <returns>Tax rate collection</returns>
public override DBTaxRateCollection GetAllTaxRates()
{
DBTaxRateCollection taxRateCollection = new DBTaxRateCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_TaxRateLoadAll");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBTaxRate taxRate = GetTaxRateFromReader(dataReader);
taxRateCollection.Add(taxRate);
}
}
return(taxRateCollection);
}
/// <summary>
/// Inserts a tax rate
/// </summary>
/// <param name="taxCategoryId">The tax category identifier</param>
/// <param name="countryId">The country identifier</param>
/// <param name="stateProvinceId">The state/province identifier</param>
/// <param name="zip">The zip</param>
/// <param name="percentage">The percentage</param>
/// <returns>Tax rate</returns>
public override DBTaxRate InsertTaxRate(int taxCategoryId, int countryId,
int stateProvinceId, string zip, decimal percentage)
{
DBTaxRate item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_TaxRateInsert");
db.AddOutParameter(dbCommand, "TaxRateID", DbType.Int32, 0);
db.AddInParameter(dbCommand, "TaxCategoryID", DbType.Int32, taxCategoryId);
db.AddInParameter(dbCommand, "CountryID", DbType.Int32, countryId);
db.AddInParameter(dbCommand, "StateProvinceID", DbType.Int32, stateProvinceId);
db.AddInParameter(dbCommand, "Zip", DbType.String, zip);
db.AddInParameter(dbCommand, "Percentage", DbType.Decimal, percentage);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
int taxRateId = Convert.ToInt32(db.GetParameterValue(dbCommand, "@TaxRateID"));
item = GetTaxRateById(taxRateId);
}
return(item);
}
/// <summary>
/// Updates the tax rate
/// </summary>
/// <param name="TaxRateID">The tax rate identifier</param>
/// <param name="TaxCategoryID">The tax category identifier</param>
/// <param name="CountryID">The country identifier</param>
/// <param name="StateProvinceID">The state/province identifier</param>
/// <param name="Zip">The zip</param>
/// <param name="Percentage">The percentage</param>
/// <returns>Tax rate</returns>
public override DBTaxRate UpdateTaxRate(int TaxRateID, int TaxCategoryID, int CountryID,
int StateProvinceID, string Zip, decimal Percentage)
{
DBTaxRate taxRate = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_TaxRateUpdate");
db.AddInParameter(dbCommand, "TaxRateID", DbType.Int32, TaxRateID);
db.AddInParameter(dbCommand, "TaxCategoryID", DbType.Int32, TaxCategoryID);
db.AddInParameter(dbCommand, "CountryID", DbType.Int32, CountryID);
db.AddInParameter(dbCommand, "StateProvinceID", DbType.Int32, StateProvinceID);
db.AddInParameter(dbCommand, "Zip", DbType.String, Zip);
db.AddInParameter(dbCommand, "Percentage", DbType.Decimal, Percentage);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
taxRate = GetTaxRateByID(TaxRateID);
}
return(taxRate);
}
/// <summary>
/// Gets a tax rate
/// </summary>
/// <param name="taxRateId">Tax rate identifier</param>
/// <returns>Tax rate</returns>
public override DBTaxRate GetTaxRateById(int taxRateId)
{
DBTaxRate item = null;
if (taxRateId == 0)
{
return(item);
}
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_TaxRateLoadByPrimaryKey");
db.AddInParameter(dbCommand, "TaxRateID", DbType.Int32, taxRateId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
item = GetTaxRateFromReader(dataReader);
}
}
return(item);
}