public MemberRequestDTO GetByEmail(string email)
        {
            Member member = memberRepository.GetByEmail(email);

            if (member == null)
            {
                return(null);
            }
            else
            {
                MemberRequestStatus requestStatus = statusRepository.GetById(member.MemberId);



                //MemberRequestDTO result = new MemberRequestDTO();
                return(new MemberRequestDTO
                {
                    MemberId = member.MemberId,
                    Email = member.Email,
                    AadharNumber = member.AadharNumber,
                    FullName = member.FirstName + " " + member.LastName,
                    Password = member.Password,
                    IsApprover = member.IsApprover,
                    Status = (requestStatus == null) ? "" : (requestStatus.Status.ToString()),
                });
            }
        }
 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 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 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);
         }
     }
 }