internal void Insert(TaxEntry newEntry)
{
var oldEntry = _ctx.TaxEntries.Where(te => te.TaxType == newEntry.TaxType && te.StartDate == newEntry.StartDate).FirstOrDefault();
if (oldEntry != null)
{
_ctx.TaxEntries.Remove(oldEntry);
_ctx.SaveChanges();
}
_ctx.TaxEntries.Add(newEntry);
_ctx.Entry(newEntry.Municipality).State = EntityState.Unchanged; //Municipality is guaranteed to already exist
_ctx.SaveChanges();
}
public async Task <MunicipalityTax> AddMunicipalityTaxes(MunicipalityTax municipalityTax, bool saveToDb = false)
{
var municipality = _context.Municapilities.Where(m => m.Name == municipalityTax.MunicipalityName).FirstOrDefault();
var tax = Tax.FromMunicipalityTax(municipalityTax);
if (municipality == null)
{
_context.Municapilities.Add(new Municipality {
Name = municipalityTax.MunicipalityName
});
_context.SaveChanges();
municipality = _context.Municapilities.Where(m => m.Name == municipalityTax.MunicipalityName).FirstOrDefault();
}
tax.MunicipalityId = municipality.Id;
if (!TaxIsValid(tax))
{
throw new Exception("Invalid tax");
}
_context.Taxes.Add(tax);
await _context.SaveChangesAsync();
municipalityTax.EndDate = tax.EndDate;
return(municipalityTax);
}
public VatControllers(TaxContext dbContext)
{
db = dbContext;
if (db.Vats.Count() == 0)
{
db.Vats.Add(new Vat {
VatId = 7,
EffectDate = DateTime.Now
});
db.SaveChanges();
}
taxRepo = new Repository(db);
}
public void AddMonth(TaxModel finance)
{
var existingRecord = context.Finances.Where(f => f.User.Name == finance.User.Name && f.Month.ToLower() == finance.Month.ToLower()).FirstOrDefault();
if (existingRecord == null)
{
context.Finances.Add(finance);
context.SaveChanges();
}
else
{
existingRecord.MonthlyIncome = finance.MonthlyIncome;
existingRecord.Medicare = finance.Medicare;
existingRecord.SocialSecurity = finance.SocialSecurity;
context.SaveChanges();
}
}
public Municipality GetByTitle(string title)
{
var returnVal = _ctx.Municipalities.Where(te => te.Title.ToLower() == title.ToLower()).FirstOrDefault();
if (returnVal != null)
{
return(returnVal);
}
else
{
Municipality newMunicipality = new Municipality {
Title = title
};
_ctx.Municipalities.Add(newMunicipality);
_ctx.SaveChanges();
return(newMunicipality);
}
}
public bool Save()
{
return(_context.SaveChanges() >= 0);
}