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(); } }