public IEnumerable <TaxRecord> GetTaxRecords()
{
using (var db = new TaxDB())
{
return(new List <TaxRecord>(db.TaxPeriods));
}
}
public IEnumerable <TaxRecord> GetMunicipalityTaxRecords(string municipality)
{
using (var db = new TaxDB())
{
return(db.TaxPeriods.FromSqlRaw("select * from TaxPeriods t where t.Municipality={0} and t.Deleted is null", municipality).ToList());
}
}
public IEnumerable <TaxRecord> RetrieveByMunicipality(string municipality)
{
using (var db = new TaxDB())
{
return(new List <TaxRecord>(db.TaxPeriods.AsQueryable().Where(x => x.Municipality == municipality)));
}
}
public TaxRecord Retrieve(long id)
{
using (var db = new TaxDB())
{
return(db.TaxPeriods.Find(id));
}
}
public IEnumerable <TaxRecord> RetrieveAll()
{
using (var db = new TaxDB())
{
return(new List <TaxRecord>(db.TaxPeriods));
}
}
public IEnumerable <TaxRecord> RetrieveAll()
{
using (var db = new TaxDB())
{
return(db.TaxPeriods.FromSqlRaw("select * from TaxPeriods t where t.Deleted is null").ToList());
}
}
public TaxRecord Retrieve(long id)
{
using (var db = new TaxDB())
{
return(db.TaxPeriods.FromSqlRaw("select * from TaxPeriods t Where t.ID={0} and t.Deleted is null", id).Single());
}
}
public TaxRecord Update(TaxRecord r)
{
using (var db = new TaxDB())
{
var res = db.Update(r);
db.SaveChanges();
return(res.Entity);
}
}
public void Delete(long id)
{
using (var db = new TaxDB())
{
var r = db.TaxPeriods.Find(id);
db.TaxPeriods.Remove(r);
db.SaveChanges();
};
}
public TaxRecord Create(TaxRecord t)
{
using (var db = new TaxDB())
{
var res = db.TaxPeriods.Add(t);
db.SaveChanges();
return(res.Entity);
};
}
public void Restore(long id)
{
using (var db = new TaxDB())
{
var r = db.TaxPeriods.Find(id);
r.Deleted = null;
db.SaveChanges();
};
}
public void Delete(long id)
{
using (var db = new TaxDB())
{
var r = db.TaxPeriods.Find(id);
r.Deleted = _time.CurrentTime();
db.SaveChanges();
};
}
public TaxRecord Update(TaxRecord r)
{
using (var db = new TaxDB())
{
r.Modified = _time.CurrentTime();
var res = db.Update(r);
db.SaveChanges();
return(res.Entity);
}
}
