public JsonResult GetFlatsMemberInfoByMobileNo(string MobileNo) { var flatMembers = db.FlatMembers.Include(a => a.HouseRepresentatives).Include(a => a.Occupations).Where(a => a.MobileNo == MobileNo).ToList(); List <ViewMemberList> viewMemberLists = new List <ViewMemberList>(); foreach (var flatMember in flatMembers) { string to; if (flatMember.LeavingDate == null) { to = "Not Leave"; } else { to = flatMember.LeavingDate.Value.ToString(); } ViewMemberList viewMemberList = new ViewMemberList() { Name = flatMember.Name, Occupations = flatMember.Occupations.Name, NationalId = flatMember.NationalIdOrBirthCertificate, RepresentativeMobileNo = flatMember.HouseRepresentatives.MobileNo, RepresentativeName = flatMember.HouseRepresentatives.Name, From = flatMember.EntryDate.Date.ToString(), To = to }; viewMemberLists.Add(viewMemberList); } return(Json(viewMemberLists, JsonRequestBehavior.AllowGet)); }
public JsonResult GetFlatsMemberInfo(string HouseRenter) { var HRs = db.HouseRepresentatives.ToList(); HouseRepresentative HR = HRs.Find(a => a.MobileNo == HouseRenter); var flatMembers = db.FlatMembers.Where(a => a.HouseRepresentativeId == HR.Id).ToList(); List <ViewMemberList> viewMemberLists = new List <ViewMemberList>(); foreach (var flatMember in flatMembers) { string to; if (flatMember.LeavingDate == null) { to = "Not Leave"; } else { to = flatMember.LeavingDate.Value.ToString(); } ViewMemberList viewMemberList = new ViewMemberList() { Name = flatMember.Name, MobileNo = flatMember.MobileNo, From = flatMember.EntryDate.Date.ToString(), To = to }; viewMemberLists.Add(viewMemberList); } return(Json(viewMemberLists, JsonRequestBehavior.AllowGet)); }