public static string GetTaxType(string code)
{
var factory = new PSContextFactory();
using (var context = factory.Create())
{
var query = from item in context.CodeTaxTypes
where (item.Code.Equals(code))
select item;
return(query.FirstOrDefault().Type);
}
}
public static int?GetRate(int income)
{
var factory = new PSContextFactory();
using (var context = factory.Create())
{
var query = from item in context.ProgressiveRateLookup
where (income >= item.From && income <= item.To)
select item;
return(query.FirstOrDefault().Rate);
}
}
private void SaveChanges(int income, string code, decimal tax)
{
var result = Convert.ToInt32(tax);
var factory = new PSContextFactory();
using (var context = factory.Create())
{
context.TaxCalculationResult.Add(new TaxCalculationResult
{
Code = code,
Income = income,
Result = result
});
context.SaveChanges();
}
}
