public Simcha GetSimchaById(int simchaId) { using (var context = new SimchaDataContext(_connectionString)) { return(context.Simchas.FirstOrDefault(s => s.Id == simchaId)); } }
public void AddSimcha(Simcha simcha) { using (var context = new SimchaDataContext(_connectionString)) { context.Simchas.InsertOnSubmit(simcha); context.SubmitChanges(); } }
public IEnumerable <Simcha> GetAllSimchos() { List <Simcha> simchos = new List <Simcha>(); using (var context = new SimchaDataContext(_connectionString)) { simchos = context.Simchas.ToList(); } foreach (Simcha s in simchos) { SetSimchaTotals(s); } return(simchos); }