private string ShowTaxes(IEnumerable <string> enumerable)
{
var date = DateTime.Parse(enumerable.Skip(1).FirstOrDefault());
ScheduledTax scheduledTax = null;
using (var context = new ScheduledTaxContext())
{
scheduledTax = context.ScheduledTaxes.Where(x => x.Municipality == enumerable.First() &&
x.From <= date && x.To >= date)
.OrderBy(x => x.To - x.From).SingleOrDefault();
}
return(scheduledTax != null ?
$"{scheduledTax.Municipality} tax rate is {scheduledTax.Rate} scheduled {scheduledTax.TaxType} from {scheduledTax.From} to {scheduledTax.To}"
: $"No entry with parameters {enumerable.First()} and {date}");
}
private string Insert(IEnumerable <string> enumerable)
{
using (var context = new ScheduledTaxContext())
{
context.ScheduledTaxes.Add(
new ScheduledTax
{
ScheduledTaxId = Guid.NewGuid(),
Municipality = enumerable.FirstOrDefault(),
TaxType = enumerable.Skip(1).FirstOrDefault(),
Rate = double.Parse(enumerable.Skip(2).FirstOrDefault()),
From = DateTime.Parse(enumerable.Skip(3).FirstOrDefault()),
To = DateTime.Parse(enumerable.Skip(4).FirstOrDefault())
});
context.SaveChanges();
}
return("Operation successful");
}
private string Import(IEnumerable <string> enumerable)
{
if (File.Exists(enumerable.First()))
{
return($"File not exist in path \"{enumerable.First()}\"");
}
IEnumerable <ScheduledTax> records = null;
using (var reader = new StreamReader(enumerable.First()))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
records = csv.GetRecords <ScheduledTax>();
}
using (var context = new ScheduledTaxContext())
{
context.ScheduledTaxes.AddRange(records);
context.SaveChanges();
}
return("Operation successful");
}