public void InsertPersonIntoFile(int personId, string filePath) { using (MemoriesManagerModelContainer context = new MemoriesManagerModelContainer()) { var person = context.People.SingleOrDefault(p => p.Id == personId); var file = context.Files.SingleOrDefault(f => f.Path == filePath); //retrive people of the file var people = context.Files .Where(f => f.Path == filePath) .SelectMany(p => p.People); //test if file people contains parameter person bool exists = false; foreach (Person p in people) { if (p == person) { exists = true; } } if (!exists) { file.People.Add(person); context.SaveChanges(); } } }
public void InsertKeywordIntoFile(string kword, string filePath) { using (MemoriesManagerModelContainer context = new MemoriesManagerModelContainer()) { var keyword = context.Keywords.SingleOrDefault(k => k.Kword == kword); var file = context.Files.SingleOrDefault(f => f.Path == filePath); //retrive all keywords of the file var keywords = context.Files .Where(f => f.Path == filePath) .SelectMany(k => k.Keywords); //test if file keywords contains parameter keyword bool exists = false; foreach (Keyword k in keywords) { if (k == keyword) { exists = true; } } if (!exists) { file.Keywords.Add(keyword); context.SaveChanges(); } } }
//Update a Keyword kword giving its id public Keyword UpdateKeywordKwordById(int id, string Kword) { using (MemoriesManagerModelContainer context = new MemoriesManagerModelContainer()) { var query = from k in context.Keywords where k.Id == id select k; var keyword = query.FirstOrDefault <Keyword>(); if (keyword != null) { keyword.Kword = Kword; context.SaveChanges(); } return(keyword); } }
//Update a person name giving its id public Person UpdatePersonNameById(int id, string First_name, string Last_name) { using (MemoriesManagerModelContainer context = new MemoriesManagerModelContainer()) { var query = from p in context.People where p.Id == id select p; var person = query.FirstOrDefault <Person>(); if (person != null) { person.First_name = First_name; person.Last_name = Last_name; context.Entry(person).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } return(person); } }
public bool CreateKeyword() { using (MemoriesManagerModelContainer context = new MemoriesManagerModelContainer()) { bool bResult = false; if (this == null) { return(bResult); } if (this.Id == 0) { context.Entry <Keyword>(this).State = EntityState.Added; context.SaveChanges(); bResult = true; } return(bResult); } }