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