//public bool UpdateMember(Member member) // { // try // { // using (CensusDataContext context = new CensusDataContext()) // { // context.Entry(member).State = EntityState.Modified; // context.SaveChanges(); // return true; // } // } // catch // { // return false; // } // } public bool DeleteById(int id) { try { using (CensusDataContext context = new CensusDataContext()) { var memberEntry = (from m in context.Members where m.MemberId == id select m).ToList().First(); var requestStatusEntry = (from r in context.MemberRequestStatus where r.MemberId == id select r).ToList().First(); context.Members.Remove(memberEntry); context.MemberRequestStatus.Remove(requestStatusEntry); context.SaveChanges(); return(true); } } catch { return(false); } }
public bool Update(int id, RequestStatus status) { try { using (CensusDataContext context = new CensusDataContext()) { MemberRequestStatus requestStatus = GetById(id); if (requestStatus != null) { context.MemberRequestStatus.Attach(requestStatus); requestStatus.Status = status; context.SaveChanges(); return(true); } else { return(false); } } } catch { return(false); } }
public bool Create(Person person) { using (CensusDataContext context = new CensusDataContext()) { try { var result = (from h in context.House where h.HouseId == person.CensusHouseNumber select h).Single(); if (result == null) { throw new Exception(); } context.Persons.Add(person); context.SaveChanges(); return(true); } catch (Exception ex) { Console.WriteLine(ex.Message); return(false); } } }
public List <Member> GetAll() { try { using (CensusDataContext context = new CensusDataContext()) { List <Member> members = (from m in context.Members select m).ToList(); return(members); } } catch { return(null); } }
public IEnumerable <Person> GetAll() { try { using (CensusDataContext context = new CensusDataContext()) { IEnumerable <Person> persons = (from p in context.Persons select p).ToList(); return(persons); } } catch { return(null); } }
public House Create(House house) { using (CensusDataContext context = new CensusDataContext()) { try { context.House.Add(house); context.SaveChanges(); return(house); } catch { return(null); } } }
public IEnumerable <House> GetAll() { try { using (CensusDataContext context = new CensusDataContext()) { IEnumerable <House> houses = (from h in context.House select h).ToList(); return(houses); } } catch { return(null); } }
public Member GetById(int id) { using (CensusDataContext context = new CensusDataContext()) { try { Member member = (from m in context.Members where m.MemberId == id select m).Single(); return(member); } catch { return(null); } } }
public MemberRequestStatus GetById(int id) { try { using (CensusDataContext context = new CensusDataContext()) { MemberRequestStatus requestStatus = (from r in context.MemberRequestStatus where r.MemberId == id select r).Single(); return(requestStatus); } } catch { return(null); } }
public House GetById(int id) { using (CensusDataContext context = new CensusDataContext()) { try { House house = (from h in context.House where h.HouseId == id select h).Single(); return(house); } catch { return(null); } } }
public Member GetByEmail(string email) { using (CensusDataContext context = new CensusDataContext()) { try { Member member = (from m in context.Members where m.Email == email select m).Single(); return(member); } catch { return(null); } } }
//public IEnumerable<MemberRequestStatus> GetAll() // { // try // { // using (CensusDataContext context = new CensusDataContext()) // { // IEnumerable<MemberRequestStatus> result = (from r in context.MemberRequestStatus // select r).ToList(); // return result; // } // } // catch // { // return null; // } // } public List <MemberRequestStatus> GetByRequestStatus(RequestStatus requestStatus) { try { using (CensusDataContext context = new CensusDataContext()) { List <MemberRequestStatus> result = (from r in context.MemberRequestStatus where r.Status == requestStatus select r).ToList(); return(result); } } catch { return(null); } }
public bool Create(int id) { using (CensusDataContext context = new CensusDataContext()) { try { MemberRequestStatus requestStatus = new MemberRequestStatus(); requestStatus.MemberId = id; requestStatus.Status = RequestStatus.PENDING; context.MemberRequestStatus.Add(requestStatus); context.SaveChanges(); return(true); } catch { return(false); } } }
//public bool UpdateMember(Member member) // { // try // { // using (CensusDataContext context = new CensusDataContext()) // { // context.Entry(member).State = EntityState.Modified; // context.SaveChanges(); // return true; // } // } // catch // { // return false; // } // } public bool DeleteById(int id) { try { using (CensusDataContext context = new CensusDataContext()) { var result = (from m in context.House where m.HouseId == id select m).ToList().First(); context.House.Remove(result); context.SaveChanges(); return(true); } } catch { return(false); } }
public bool Create(Member member) { using (CensusDataContext context = new CensusDataContext()) { try { context.Members.Add(member); context.SaveChanges(); if (new MemberRequestStatusRepository().Create(member.MemberId)) { return(true); } context.Members.Remove(member); context.SaveChanges(); return(false); } catch { return(false); } } }
public IEnumerable <Person> Find(Expression <Func <Person, bool> > predicate) { CensusDataContext context = new CensusDataContext(); return(context.Persons.Where(predicate)); }
public IEnumerable <House> Find(Expression <Func <House, bool> > predicate) { CensusDataContext context = new CensusDataContext(); return(context.House.Where(predicate)); }