public bool DeleteMemberRelation(int memID) //Delete all relation of a member
{
FamilyManagementDataContext db = new FamilyManagementDataContext();
var delQuery = from Relationship in db.Relationships
where Relationship.person1ID == memID || Relationship.person2ID == memID
select Relationship;
db.Relationships.DeleteAllOnSubmit(delQuery);
db.SubmitChanges();
return(true);
}
public bool DeleteMember(int memID)
{
FamilyManagementDataContext db = new FamilyManagementDataContext();
var delQuery = (from Member in db.Members
where Member.memID == memID
select Member).Single();
db.Members.DeleteOnSubmit(delQuery);
db.SubmitChanges();
return(true);
}
public bool DeleteRelation(int p1ID, int p2ID) //Delete a specific relation satisfy p1ID and p2ID
{
FamilyManagementDataContext db = new FamilyManagementDataContext();
var delQuery = from Relationship in db.Relationships
where Relationship.person1ID == p1ID && Relationship.person2ID == p2ID || Relationship.person1ID == p2ID && Relationship.person2ID == p1ID
select Relationship;
db.Relationships.DeleteAllOnSubmit(delQuery);
db.SubmitChanges();
return(true);
}
public bool DeleteParentage(int pID)
{
FamilyManagementDataContext db = new FamilyManagementDataContext();
var delQuery = from Parentage in db.Parentages
where Parentage.pID == pID
select Parentage;
db.Parentages.DeleteAllOnSubmit(delQuery);
db.SubmitChanges();
return(true);
}
public bool InsertParentage(int pID, string pName)
{
FamilyManagementDataContext db = new FamilyManagementDataContext();
Parentage newParentage = new Parentage();
newParentage.pID = pID;
newParentage.pName = pName;
db.Parentages.InsertOnSubmit(newParentage);
db.SubmitChanges();
return(true);
}
public bool InsertRelation(int mem1ID, int mem2ID, string relation, int pID)
{
FamilyManagementDataContext db = new FamilyManagementDataContext();
Relationship newRelation = new Relationship();
newRelation.person1ID = mem1ID;
newRelation.person2ID = mem2ID;
newRelation.relation = relation;
newRelation.parentageID = pID;
db.Relationships.InsertOnSubmit(newRelation);
db.SubmitChanges();
return(true);
}
public bool ModifyRelation(int p1ID, int p2ID, string relation, int pID)
{
FamilyManagementDataContext db = new FamilyManagementDataContext();
var modQuery = (from Relationship in db.Relationships
where Relationship.person1ID == p1ID && Relationship.person2ID == p2ID
select Relationship).Single();
if (modQuery != null)
{
modQuery.relation = relation;
modQuery.parentageID = pID;
db.SubmitChanges();
}
return(true);
}
public bool ModifyParentage(int pID, string pName)
{
FamilyManagementDataContext db = new FamilyManagementDataContext();
var modQuery = (from Parentage in db.Parentages
where Parentage.pID == pID
select Parentage).Single();
if (modQuery != null)
{
modQuery.pID = pID;
modQuery.pName = pName;
db.SubmitChanges();
}
return(true);
}
public bool ModifyMember(int memID, string name, string rustic, string gender, DateTime dob, DateTime dod, string curAdd)
{
FamilyManagementDataContext db = new FamilyManagementDataContext();
var modQuery = (from Member in db.Members
where Member.memID == memID
select Member).Single();
if (modQuery != null)
{
modQuery.memName = name;
modQuery.memID = memID;
modQuery.rustic = rustic;
modQuery.gender = gender;
modQuery.dob = dob;
modQuery.dod = dod;
modQuery.address = curAdd;
db.SubmitChanges();
}
return(true);
}
