public void AddPhone(Phone phone) { using (var context = new UchOtdContext(ConnectionString)) { phone.PhoneId = 0; context.Phones.Add(phone); context.SaveChanges(); } }
public void AddNote(Note note) { using (var context = new UchOtdContext(ConnectionString)) { note.NoteId = 0; context.Notes.Add(note); context.SaveChanges(); } }
public void AddPhonesRange(IEnumerable<Phone> phoneList) { using (var context = new UchOtdContext(ConnectionString)) { foreach (var phone in phoneList) { phone.PhoneId = 0; context.Phones.Add(phone); } context.SaveChanges(); } }
public void AddNotesRange(IEnumerable<Note> noteList) { using (var context = new UchOtdContext(ConnectionString)) { foreach (var note in noteList) { note.NoteId = 0; context.Notes.Add(note); } context.SaveChanges(); } }
public void UpdatePhone(Phone phone) { using (var context = new UchOtdContext(ConnectionString)) { var curPhone = GetPhone(phone.PhoneId); curPhone.Name = phone.Name; curPhone.Number = phone.Number; context.SaveChanges(); } }
public void UpdateNote(Note note) { using (var context = new UchOtdContext(ConnectionString)) { var curNote = GetNote(note.NoteId); curNote.Text = note.Text; curNote.Moment = note.Moment; curNote.TargetComputer = note.TargetComputer; context.SaveChanges(); } }
public void SaveChanges() { using (var context = new UchOtdContext(ConnectionString)) { context.SaveChanges(); } }
public void RemovePhone(int phoneId) { using (var context = new UchOtdContext(ConnectionString)) { var phone = context.Phones.FirstOrDefault(p => p.PhoneId == phoneId); context.Phones.Remove(phone); context.SaveChanges(); } }
public void RemoveNote(int noteId) { using (var context = new UchOtdContext(ConnectionString)) { var note = context.Notes.FirstOrDefault(n => n.NoteId == noteId); context.Notes.Remove(note); context.SaveChanges(); } }