public IEnumerable <MemberSearchDTO> GetAll()
{
IEnumerable <MemberSearchDTO> members = null;
try
{
CommunityEntities context = new CommunityEntities();
members = context.Members.Select(sel => new MemberSearchDTO {
Id = sel.Id, MemberId = sel.MemberID, FullName = sel.FullName, Mobile = sel.Mobile, FatherName = sel.FatherName
}).ToList();
}
catch (Exception ex)
{
}
return(members);
}
public bool TrySaveMember(ref MemberDTO memberDto)
{
try
{
CommunityEntities context = new CommunityEntities();
Member communityMember = new Member();
communityMember.FullName = memberDto.FullName;
communityMember.FatherName = memberDto.FatherName;
communityMember.GrandFatherName = memberDto.GrandFatherName;
communityMember.Mobile = memberDto.Mobile;
communityMember.DOB = memberDto.Dob;
communityMember.Address = memberDto.Address;
communityMember.EducationQualification = memberDto.EducationQualification;
if (string.IsNullOrWhiteSpace(memberDto.ImageLocation))
{
communityMember.ImageLocation = string.Empty;
}
else
{
communityMember.ImageLocation = memberDto.ImageLocation;
}
communityMember.GrandFatherName = string.Empty;
communityMember.MarriageDate = memberDto.MarriageDate;
communityMember.CreatedDate = DateTime.Now;
communityMember.CreatedBy = "System";
communityMember.MemberID = memberDto.MemberId;
context.Members.Add(communityMember);
var result = context.SaveChanges();
}
catch (Exception ex)
{
return(false);
}
return(true);
}
public IEnumerable <MemberSearchDTO> SearchMembers(string searchKeyWord)
{
IEnumerable <MemberSearchDTO> members = null;
try
{
searchKeyWord = searchKeyWord.Trim().ToLowerInvariant();
CommunityEntities context = new CommunityEntities();
members = context.Members.Where(wh => wh.FullName.Contains(searchKeyWord) || wh.FatherName.Contains(searchKeyWord) || wh.Mobile.Contains(searchKeyWord) || wh.MemberID.Contains(searchKeyWord))
.Select(sel => new MemberSearchDTO {
Id = sel.Id, MemberId = sel.MemberID, FullName = sel.FullName,
Address = sel.Address, FatherName = sel.FatherName, Mobile = sel.Mobile, GrandFatherName = sel.GrandFatherName
}).ToList();
}
catch (Exception ex)
{ }
return(members);
}