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