public Number FindNumber()
{
Console.Write("Enter number's id: ");
int id = int.Parse(Console.ReadLine());
var db = ObjectProvider.MakeDbInstance();
return(db.Numbers.FirstOrDefault(x => x.Id == id));
}
public PhoneBook FindPhonebook()
{
Console.Write("Enter phonebook's id: ");
int id = int.Parse(Console.ReadLine());
var db = ObjectProvider.MakeDbInstance();
return(db.PhoneBooks.FirstOrDefault(x => x.Id == id));
}
public int Delete()
{
var db = ObjectProvider.MakeDbInstance();
Console.Write("Enter phonebook's id: ");
int id = int.Parse(Console.ReadLine());
db.Remove(db.PhoneBooks.FirstOrDefault(x => x.Id == id));
db.SaveChanges();
return(id);
}
public int UpdatePhonebook()
{
PhoneBook foundPhonebook = FindPhonebook();
Console.Write("Enter new phonebook title: ");
foundPhonebook.Title = Console.ReadLine();
var db = ObjectProvider.MakeDbInstance();
db.Update(foundPhonebook);
db.SaveChanges();
return(foundPhonebook.Id);
}
public int Add()
{
var db = ObjectProvider.MakeDbInstance();
PhoneBook aPhonebook = ObjectProvider.MakePhonebookInstance();
Console.Write("Enter phonebook's title: ");
aPhonebook.Title = Console.ReadLine();
Console.Write("Enter the id of belonging person: ");
aPhonebook.PhonebookPersonId = int.Parse(Console.ReadLine());
db.Add(aPhonebook);
db.SaveChanges();
return(aPhonebook.Id);
}
public int UpdateNumber()
{
Number foundNumber = FindNumber();
Console.Write("Enter new phone number: ");
foundNumber.ContactValue = Console.ReadLine();
Console.Write("Enter new title for the phone number: ");
foundNumber.ContactTitle = Console.ReadLine();
var db = ObjectProvider.MakeDbInstance();
db.Update(foundNumber);
db.SaveChanges();
return(foundNumber.Id);
}
public int Add()
{
var db = ObjectProvider.MakeDbInstance();
Number aNumber = ObjectProvider.MakeNumberInstance();
Console.Write("Enter phone number: ");
aNumber.ContactValue = Console.ReadLine();
Console.Write("Enter a title for this phone number: ");
aNumber.ContactTitle = Console.ReadLine();
Console.Write("Enter the id of belonging phonebook: ");
aNumber.PhonebookId = int.Parse(Console.ReadLine());
db.Add(aNumber);
db.SaveChanges();
return(aNumber.Id);
}
public static void ShowAllInfos()
{
AppDbContext db = ObjectProvider.MakeDbInstance();
db.Persons.ToList().ForEach(eachPerson =>
{
Console.WriteLine($"\tPerson id is : {eachPerson.Id}");
var personPhonebooks = eachPerson.FindPhonebooksWithBelongingNumbers(eachPerson.Id);
personPhonebooks.ToList().ForEach(phonebook =>
{
Console.WriteLine($"\t\tphonebook id is : {phonebook.Id}");
phonebook.PhonebookNumbers.ToList().ForEach(number =>
{
Console.WriteLine($"\t\t\t{number.ContactTitle} {number.ContactValue}");
});
});
});
}
