protected override Entity OnAdd()
{
var newItem = new Tax();
using (var frm = new frmTaxTable_Add())
{
frm.ItemData = newItem;
if (frm.ShowDialog() != DialogResult.OK)
{
return(null);
}
}
ItemDataCollection.Add(newItem);
App.LogAction("Tax Table", "Created Tax Code : " + newItem.ShortDesc);
return(newItem);
}
public static TaxCollection GetTaxRate()
{
TaxCollection taxes;
//connect to database
using (SqlConnection conn = new SqlConnection(connString))
{
//query to retrieve data from Province table
string query = @"SELECT TaxCode, TaxRate
From TaxTable";
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText = query;
cmd.Connection = conn;
conn.Open();
taxes = new TaxCollection();
//read data
using (SqlDataReader reader = cmd.ExecuteReader())
{
string taxCode = null;
decimal taxRate = 0.00m;
while (reader.Read())
{
taxCode = reader["TaxCode"] as string;
taxRate = (decimal)reader["TaxRate"];
taxes.Add(new TaxRateTable {
Taxcode = taxCode, TaxRate = taxRate
});
}
return(taxes);
}
}
}
}