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();
}
}