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); } }