public double GetRate(string town, string date)
{
DateTime dt;
DateTime.TryParseExact(date,
"yyyy.MM.dd",
CultureInfo.InvariantCulture,
DateTimeStyles.None,
out dt);
if (dt != null)
{
TaxClassesDataContext dc = new TaxClassesDataContext();
List <Tax> result = dc.Taxes.Where(t => t.Town.Equals(town) && dt >= t.DateBegin && dt <= t.DateEnd).OrderBy(t => t.TimeSpan).ToList();
if (result.Count > 0)
{
return(result.Last().Rate);
}
else
{
return(0.0);
}
}
else
{
return(0.0);
}
}
public void DeleteTaxes(string town)
{
TaxClassesDataContext dc = new TaxClassesDataContext();
List <Tax> matchedTaxes = dc.Taxes.Where(t => t.Town.Equals(town)).ToList();
dc.Taxes.DeleteAllOnSubmit(matchedTaxes);
dc.SubmitChanges();
}
public Tax CreateTax(Tax createTax)
{
Table <Tax> taxes = new TaxClassesDataContext().Taxes;
try
{
taxes.InsertOnSubmit(createTax);
}
catch (Exception)
{
return(null);
}
taxes.Context.SubmitChanges();
return(createTax);
}
public List <Tax> CreateTaxes(List <Tax> createTaxes)
{
var dc = new TaxClassesDataContext();
dc.ExecuteCommand("TRUNCATE TABLE Tax");
Table <Tax> taxes = dc.Taxes;
foreach (Tax t in createTaxes)
{
try
{
taxes.InsertOnSubmit(t);
}
catch (Exception)
{
return(null);
}
}
taxes.Context.SubmitChanges();
return(createTaxes);
}
public List <Tax> GetAllTaxesOfTown(string town)
{
TaxClassesDataContext dc = new TaxClassesDataContext();
return(dc.Taxes.Where(t => t.Town.Equals(town)).ToList());
}
public List <Tax> GetAllTaxes()
{
TaxClassesDataContext dc = new TaxClassesDataContext();
return(dc.Taxes.ToList());
}