public List <WCP_Family> GetEntireFamily(int familyId)
{
try
{
List <WCP_Family> familyList = new List <WCP_Family>();
var familyMember = familyEntity.tbl_Family.Where(obj1 =>
familyEntity.tbl_familyRelation.Any(obj2 =>
obj2.familyNo == familyId && obj1.familyMemberId == obj2.familyMemId));
foreach (var item in familyMember)
{
WCP_Family familyobj = new WCP_Family();
familyobj.suffix = item.suffix.ToUpper();
familyobj.firstName = item.firstName.ToUpper();
familyobj.middleName = item.middleName;
familyobj.lastName = item.lastName.ToUpper();
familyobj.dob = item.dob;
familyobj.gender = item.gender.ToUpper();
familyobj.memberCategory = item.memberCategory.ToUpper();
familyList.Add(familyobj);
}
return(familyList);
}
catch
{
return(null);
}
}
public List <WCP_Family> GetAllFamilyMember(int familyId)
{
try
{
List <WCP_Family> familyList = new List <WCP_Family>();
//var familyMember = from data in familyEntity.tbl_Family select data;
//var obj = db.tbl_User.Where(a => a.userName.Equals(objUser.userName) && a.passwd.Equals(objUser.passwd)).FirstOrDefault();
// from p in Projects
// join m in ProjectMembers on m.ProjectID equals p.ID
// where m.UserID == userID && p.ProjectOwner != userID
// group p by p.ID
//select p
//var familyMember=from family in familyEntity.tbl_Family
// join relation in familyEntity.tbl_familyRelation on family.familyMemberId equals relation.familyMemId
// where relation.familyMemId==familyId
// group by family.familyMemberId
// select family;
//var familyMember = from familyObject in familyEntity.tbl_Family
// from RelationObject in familyEntity.tbl_familyRelation
// where familyObject.familyMemberId == RelationObject.familyMemId && RelationObject.familyNo == familyId
// orderby familyObject.familyMemberId descending
// select familyObject
// ;
var familyMember = familyEntity.tbl_Family.Where(obj1 =>
familyEntity.tbl_familyRelation.Any(obj2 =>
obj2.familyNo == familyId && obj1.familyMemberId == obj2.familyMemId));
var FamilyHead = familyMember.Min(obj => obj.familyMemberId);
var presentUser = familyMember.Max(obj => obj.familyMemberId);
foreach (var item in familyMember)
{
if (item.memberCategory == null)
{
WCP_Family familyobj = new WCP_Family();
familyobj.suffix = item.suffix;
familyobj.firstName = item.firstName;
familyobj.middleName = item.middleName;
familyobj.lastName = item.lastName;
familyobj.dob = item.dob;
familyobj.gender = item.gender;
familyList.Add(familyobj);
}
}
return(familyList);
}
catch
{
return(null);
}
}
public int AddFamilyMember(WCP_Family family)
{
try
{
tbl_Family familyObject = new tbl_Family();
var config = new MapperConfiguration(cfg => cfg.CreateMap <WCP_Family, tbl_Family>());
var map = config.CreateMapper();
var data = map.Map <WCP_Family, tbl_Family>(family);
familyEntity.tbl_Family.Add(data);
familyEntity.SaveChanges();
int id = (familyEntity.tbl_Family.Where(p => p.firstName == family.firstName && p.lastName == family.lastName).Select(p => p.familyMemberId)).FirstOrDefault();
return(id);
}
catch
{
return(0);
}
}
public bool UpdateFamilyMember(WCP_Family family, int id)
{
try
{
tbl_Family familyObject = familyEntity.tbl_Family.Where(obj => obj.familyMemberId == id).First();
{
familyObject.suffix = family.suffix;
familyObject.firstName = family.firstName;
familyObject.middleName = family.middleName;
familyObject.lastName = family.lastName;
familyObject.gender = family.gender;
familyObject.dob = family.dob;
familyObject.memberCategory = family.memberCategory;
familyEntity.SaveChanges();
}
return(true);
}
catch
{
return(false);
}
}
