private static void ImportContactToDatabase(ContactDTO contactDTO)
{
if (contactDTO.Name == null)
{
throw new ArgumentException("Name is required");
}
var newContact = new Contact()
{
Name = contactDTO.Name,
Company = contactDTO.Company,
Position = contactDTO.Position,
Url = contactDTO.Site,
Notes = contactDTO.Notes
};
if (contactDTO.Emails != null)
{
newContact.Emails = contactDTO.Emails.Select(e => new Email() { EmailAddress = e }).ToList();
}
if (contactDTO.Phones != null)
{
newContact.Phones = contactDTO.Phones.Select(p => new Phone() { PhoneNumber = p }).ToList();
}
var context = new PhonebookContext();
context.Contacts.Add(newContact);
context.SaveChanges();
}
public static void Main()
{
var context = new PhonebookContext();
var contacts = context.Contacts
.Include(c => c.Emails)
.Include(c => c.Phones);
foreach (var contact in contacts)
{
Console.WriteLine("Name: {0}{7}Company: {1}{7}Position: {2}{7}Note: {3}{7}Url: {4}{7}Emails: {5}{7}Phones: {6}{7}",
contact.Name,
contact.Company,
contact.Position,
contact.Note ?? string.Empty,
contact.Url ?? string.Empty,
string.Join(", ", contact.Emails.Select(e => e.EmailAddress)),
string.Join(", ", contact.Phones.Select(p => p.PhoneNumber)),
Environment.NewLine);
}
}
public static void Main()
{
var context = new PhonebookContext();
var json = File.ReadAllText(@"..\..\contacts.json");
var jsonSerializer = new JavaScriptSerializer();
var parsedContacts = jsonSerializer.Deserialize<ContactDTO[]>(json);
foreach (var contactDTO in parsedContacts)
{
try
{
ImportContactToDatabase(contactDTO);
Console.WriteLine("Contact {0} imported", contactDTO.Name);
}
catch (Exception ex)
{
Console.WriteLine("Error: {0}", ex.Message);
}
}
}
static void Main()
{
var context = new PhonebookContext();
var contacts = context.Contacts
.Include(c => c.Phones)
.Include(c => c.Emails)
.ToList();
foreach (var contact in contacts)
{
Console.WriteLine("Name: {0}", contact.Name);
Console.WriteLine(" Position: {0}", contact.Position);
Console.WriteLine(" Company: {0}", contact.Company);
Console.WriteLine(" Emails: {0}",
string.Join(", ", contact.Emails.Select(e => e.EmailAddress)));
Console.WriteLine(" Phones: {0}",
string.Join(", ", contact.Phones.Select(e => e.PhoneNumber)));
Console.WriteLine(" Url: {0}", contact.Url);
Console.WriteLine(" Notes: {0}", contact.Notes);
Console.WriteLine();
}
}
static void Main()
{
var context = new PhonebookContext();
var contacts = context.Contacts
.Include(c => c.Phones)
.Include(c => c.Emails)
.ToList();
foreach (var contact in contacts)
{
Console.WriteLine("Name: {0}", contact.Name);
Console.WriteLine(" Position: {0}", contact.Position);
Console.WriteLine(" Company: {0}", contact.Company);
Console.WriteLine(" Emails: {0}",
string.Join(", ", contact.Emails.Select(e => e.EmailAddress)));
Console.WriteLine(" Phones: {0}",
string.Join(", ", contact.Phones.Select(e => e.PhoneNumber)));
Console.WriteLine(" Url: {0}", contact.Url);
Console.WriteLine(" Notes: {0}", contact.Notes);
Console.WriteLine();
}
}