public static void AddPersonToGroup(int groupId, int personId) { using (oikonomosEntities context = new oikonomosEntities(ConfigurationManager.ConnectionStrings["oikonomosEntities"].ConnectionString)) { //First check to see if they are not already there var check = (from pg in context.PersonGroups where pg.PersonId == personId && pg.GroupId == groupId select pg).FirstOrDefault(); if (check == null) { //Add them PersonGroup personGroup = new PersonGroup(); context.PersonGroups.AddObject(personGroup); personGroup.Created = DateTime.Now; personGroup.Changed = DateTime.Now; personGroup.PersonId = personId; personGroup.GroupId = groupId; personGroup.Joined = DateTime.Now; context.SaveChanges(); } } }
/// <summary> /// Deprecated Method for adding a new object to the PersonGroups EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToPersonGroups(PersonGroup personGroup) { base.AddObject("PersonGroups", personGroup); }
/// <summary> /// Create a new PersonGroup object. /// </summary> /// <param name="personGroupId">Initial value of the PersonGroupId property.</param> /// <param name="personId">Initial value of the PersonId property.</param> /// <param name="groupId">Initial value of the GroupId property.</param> /// <param name="joined">Initial value of the Joined property.</param> /// <param name="created">Initial value of the Created property.</param> /// <param name="changed">Initial value of the Changed property.</param> public static PersonGroup CreatePersonGroup(global::System.Int32 personGroupId, global::System.Int32 personId, global::System.Int32 groupId, global::System.DateTime joined, global::System.DateTime created, global::System.DateTime changed) { PersonGroup personGroup = new PersonGroup(); personGroup.PersonGroupId = personGroupId; personGroup.PersonId = personId; personGroup.GroupId = groupId; personGroup.Joined = joined; personGroup.Created = created; personGroup.Changed = changed; return personGroup; }
public Person UpdatePerson(PersonViewModel person, Person currentPerson, out bool sendWelcomeEmail, out Church church) { sendWelcomeEmail = false; //We need some settings from the Church table church = _churchRepository.GetChurch(currentPerson.ChurchId); var personToSave = new Person(); if (person.PersonId != 0) { personToSave = FetchPerson(person.PersonId, currentPerson); } else { Context.AddToPeople(personToSave); personToSave.ChurchId = church.ChurchId; personToSave.Church = church; personToSave.Created = DateTime.Now; if (church.SendWelcome) { sendWelcomeEmail = true; } if (person.GroupId > 0) { var pg = new PersonGroup { GroupId = person.GroupId, Person = personToSave, Joined = DateTime.Now, Created = DateTime.Now, Changed = DateTime.Now }; personToSave.PersonGroups.Add(pg); } } if (person.FamilyId == 0) { if (person.FindFamily) { var family = (from f in Context.Families join p in Context.People on f.FamilyId equals p.FamilyId join g in Context.PersonGroups on p.PersonId equals g.PersonId where f.FamilyName == person.Surname && g.GroupId == person.GroupId select f).FirstOrDefault(); personToSave.Family = family ?? new Family {Created = DateTime.Now}; } else { personToSave.Family = new Family {Created = DateTime.Now}; } } else { personToSave.Family = (from f in Context.Families where f.FamilyId == person.FamilyId select f).FirstOrDefault() ?? new Family {Created = DateTime.Now}; } personToSave.Family.Changed = DateTime.Now; personToSave.Changed = DateTime.Now; personToSave.Firstname = person.Firstname; personToSave.Family.FamilyName = person.Surname; personToSave.Email = person.Email; personToSave.DateOfBirth = person.DateOfBirth_Value; Context.SaveChanges(); return personToSave; }