public CountryTaxRate this[int CountryID, int TaxClassID]
{
get
{
for (int i = 0; i < m_CountryTaxRates.Count; i++)
{
CountryTaxRate str = (CountryTaxRate)m_CountryTaxRates.GetByIndex(i);
if (str.CountryID == CountryID && str.TaxClassID == TaxClassID)
{
return(str);
}
}
return(null);
}
}
public decimal GetTaxRate(int CountryID, int TaxClassID)
{
if (CountryID == 0)
{
return(System.Decimal.Zero);
}
for (int i = 0; i < m_CountryTaxRates.Count; i++)
{
CountryTaxRate ctr = (CountryTaxRate)m_CountryTaxRates.GetByIndex(i);
if (ctr.CountryID == CountryID && ctr.TaxClassID == TaxClassID)
{
return(ctr.TaxRate);
}
}
return(System.Decimal.Zero);
}
static public CountryTaxRate Create(int CountryID, int TaxClassID, decimal TaxRate)
{
int CountryTaxID = 0;
string err = String.Empty;
SqlConnection cn = new SqlConnection(DB.GetDBConn());
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "dbo.aspdnsf_insCountryTaxRate";
cmd.Parameters.Add(new SqlParameter("@CountryID", SqlDbType.Int, 4));
cmd.Parameters.Add(new SqlParameter("@TaxClassID", SqlDbType.Int, 4));
cmd.Parameters.Add(new SqlParameter("@TaxRate", SqlDbType.Decimal, 8));
cmd.Parameters.Add(new SqlParameter("@CountryTaxID", SqlDbType.Int, 4)).Direction = ParameterDirection.Output;
cmd.Parameters["@CountryID"].Value = CountryID;
cmd.Parameters["@TaxClassID"].Value = TaxClassID;
cmd.Parameters["@TaxRate"].Value = TaxRate;
try
{
cmd.ExecuteNonQuery();
CountryTaxID = Int32.Parse(cmd.Parameters["@CountryTaxID"].Value.ToString());
}
catch (Exception ex)
{
err = ex.Message;
}
cn.Close();
cmd.Dispose();
cn.Dispose();
if (CountryTaxID > 0)
{
CountryTaxRate ctr = new CountryTaxRate(CountryTaxID);
return(ctr);
}
return(null);
}
/// <summary>
/// Creates a new CountryTaxRate record and adds it to the collection
/// </summary>
public void Add(int CountryID, int TaxClassID, decimal TaxRate)
{
this.Add(CountryTaxRate.Create(CountryID, TaxClassID, TaxRate));
}
/// <summary>
/// Adds an existing CountryTaxRate object to the collection
/// </summary>
public void Add(CountryTaxRate countrytaxrate)
{
m_CountryTaxRates.Add(countrytaxrate.CountryTaxID, countrytaxrate);
}