public List <Tax> LoadFromTxt()
{
List <Tax> results = new List <Tax>();
StreamReader sr = null;
try
{
sr = new StreamReader(FILENAME);
sr.ReadLine();
string row = "";
while ((row = sr.ReadLine()) != null)
{
Tax c = TaxMapper.StringToTax(row);
results.Add(c);
}
}
catch (FileNotFoundException fileNotFound)
{
Console.WriteLine(fileNotFound.FileName + " was not found");
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
if (sr != null)
{
sr.Close();
}
}
return(results);
}
public void ToTaxMapperTest(string row, string stateAbbreviation, string stateName, decimal taxRate)
{
Tax tax = new Tax();
tax.StateAbbreviation = stateAbbreviation;
tax.StateName = stateName;
tax.TaxRate = taxRate;
Tax result = TaxMapper.StringToTax(row);
Assert.AreEqual(result.StateAbbreviation, tax.StateAbbreviation);
Assert.AreEqual(result.StateName, tax.StateName);
Assert.AreEqual(result.TaxRate, tax.TaxRate);
}
public void TaxFromStringTest(string row, string abbreviation, string name, decimal taxRate)
{
FlooringTax actual = TaxMapper.ToTax(row);
FlooringTax expected = new FlooringTax
{
StateAbbreviation = abbreviation,
StateName = name,
TaxRate = taxRate,
};
Assert.AreEqual(expected.StateName, actual.StateName);
Assert.AreEqual(expected.StateAbbreviation, actual.StateAbbreviation);
Assert.AreEqual(expected.TaxRate, actual.TaxRate);
}
public static List <Tax> GetTaxes()
{
List <Tax> taxes = new List <Tax>();
string[] rows = File.ReadAllLines(@"C:\Users\nthny\Documents\Bitbucket\anthony-dahl-individual-work\MasteryFlooring\MasteryFlooring.Data\Taxes.txt");
foreach (string row in rows)
{
if (row != null)
{
taxes.Add(TaxMapper.StringToTax(row));
}
}
return(taxes);
}
private static void SaveTaxInformation(DataTable dataTable)
{
var taxMapper = new TaxMapper(dataTable);
var taxModel = taxMapper.Map();
using (var ctx = new MunicipalityDataContext())
{
foreach (var dataRow in dataTable.AsEnumerable())
{
var municipalityId = ctx.Municipalities.Where(x => x.Name == dataRow.Field <string>("Municipality") &&
x.Date == Convert.ToDateTime(dataRow.Field <string>("Date")))
.Select(x => x.MunicipalityId).FirstOrDefault();
var frequencyId = ctx.Frequencies.Where(x => x.Value == dataRow.Field <string>("Frequency"))
.Select(x => x.FrequencyId).FirstOrDefault();
bool isExistingTaxID = ctx.Taxes.Any(x => x.MunicipalityId == municipalityId &&
x.FrequencyId == frequencyId);
if (!isExistingTaxID)
{
var tax = new Tax()
{
TaxValue = dataRow.Field <string>("Tax"),
MunicipalityId = municipalityId,
FrequencyId = frequencyId
};
ctx.Add(tax);
}
}
ctx.SaveChanges();
}
}
