public void AddRecord(object obj)
{
try
{
using (RelationEntities dbEntities = new RelationEntities())
{
/*** ADD PERSON **/
perObject.Gender = _selectedGender.GenderName;
perObject.Name = PersonFirstName;
perObject.MaidenName = PersonMaidenName;
perObject.LastName = PersonLastName;
dbEntities.People.Add(perObject);
dbEntities.SaveChanges();
/***END***/
/***ADD RELATION ***/
var relation = new Relationship();
relation.RelationTypeID = _selectedRelation.RelationId;
relation.FirstPersonID = perObject.PersonID;
relation.SecondPersonID = _selectedPerson.PersonId;
dbEntities.Relationships.Add(relation);
dbEntities.SaveChanges();
/****END**/
ClearControls();
this.Message = "Person Added Successfully.";
}
}
catch (Exception ex)
{
this.Message = ex.Message;
}
}
public RelationEntity GetRelation(string relationName, string schemaName = DefaultSchema)
{
if (!RelationExists(relationName, schemaName))
{
throw new DbException($"Relation does not exist: '{relationName}'.'{schemaName}'");
}
return(RelationEntities.Single(q => q.RelationName == relationName && q.SchemaName == schemaName));
}
public void PopulateRelations()
{
using (RelationEntities dbEntities = new RelationEntities())
{
var raltionList = dbEntities.RelationShipTypes.ToList();
foreach (var relation in raltionList)
{
RelationShipModel item = new RelationShipModel
{
RelationName = relation.Name,
RelationId = Convert.ToInt32(relation.ID)
};
_relationList.Add(item);
}
}
}
public void PopulatePerson()
{
using (RelationEntities dbEntities = new RelationEntities())
{
var raltionList = dbEntities.People.ToList();
foreach (var relation in raltionList)
{
PersonModel item = new PersonModel
{
PersonName = relation.Name,
PersonId = Convert.ToInt32(relation.PersonID)
};
_personList.Add(item);
}
}
}
public void PopulateNetworkView()
{
using (RelationEntities dbEntities = new RelationEntities())
{
var relationList = dbEntities.Relationships.Where(x => x.FirstPersonID == _selectedPerson.PersonId || x.SecondPersonID == _selectedPerson.PersonId).ToList();
foreach (var relation in relationList)
{
//RelationShipModel item = new RelationShipModel
//{
// PersonName = relation.Name,
// PersonId = Convert.ToInt32(relation.PersonID)
//};
//_personList.Add(item);
}
}
}
private void AddRelation(object obj)
{
using (RelationEntities dbEntities = new RelationEntities())
{
try
{
/***ADD RELATION ***/
var relation = new Relationship();
relation.RelationTypeID = _selectedRelation.RelationId;
relation.FirstPersonID = _selectedPerson.PersonId;
relation.SecondPersonID = _secondSelectedPerson.PersonId;
dbEntities.Relationships.Add(relation);
dbEntities.SaveChanges();
/****END**/
this.Message = "Relation Added Successfully.";
}
catch (Exception ex)
{
this.Message = ex.Message;
}
}
}
public bool RelationExists(string relationName, string schemaName)
{
return(RelationEntities.Any(q => q.RelationName == relationName && q.SchemaName == schemaName));
}
