public IList <TaxRateInfo> GetMainTaxRate(int categoryId)
{
IList <TaxRateInfo> list = new List <TaxRateInfo>();
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("select isnull(b.TaxId,0) TaxId,isnull(b.TaxRate,0) TaxRate from Ecshop_Categories a left join Ecshop_TaxRate b on a.TaxRateId = b.TaxId where CategoryId = " + categoryId + " order by b.TaxId");
using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
while (dataReader.Read())
{
TaxRateInfo item = DataMapper.PopulateTaxRate(dataReader);
list.Add(item);
}
}
return(list);
}
public IList <TaxRateInfo> GetMainTaxRate()
{
IList <TaxRateInfo> list = new List <TaxRateInfo>();
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * From Ecshop_TaxRate ORDER BY TaxId");
using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
while (dataReader.Read())
{
TaxRateInfo item = DataMapper.PopulateTaxRate(dataReader);
list.Add(item);
}
}
return(list);
}
public HeaderInfo()
{
TaxRatesField = 3;
TaxRateInfo = new TaxRateInfo();
}
