static void Main()
{
var context = new PhonebookEntities();
Console.WriteLine(context.Contacts.Count());
Contact petar = new Contact()
{
Name = "Peter Ivanov",
Position = "CTO",
Company = "Smart Ideas",
Emails = new List<Email>{
new Email(){EmailAddress = "*****@*****.**"},
new Email(){EmailAddress ="peter_ivanov @yahoo.com"}
},
Phones = new List<Phone>{
new Phone()
{PhoneNumber = "(+359) 2 22 22 22"},
new Phone()
{PhoneNumber = "+359 88 77 88 99"}
},
Site = "http: //blog.peter.com",
Notes = "Friend from school"
};
Contact maria = new Contact()
{
Name = "Maria",
Phones = new List<Phone>
{
new Phone()
{PhoneNumber = "+359 22 33 44 55"}
}
};
Contact angie = new Contact()
{
Name = "Angie Stanton",
Site = "http://angiestanton.com",
Emails = new List<Email>
{
new Email()
{EmailAddress = "*****@*****.**"}
}
};
context.Contacts.Add(petar);
context.Contacts.Add(maria);
context.Contacts.Add(angie);
context.SaveChanges();
}
static void Main()
{
var context = new PhonebookEntities();
string text = System.IO.File.ReadAllText("../../contacts.json");
JArray arr = JArray.Parse(text);
foreach (JToken contact in arr)
{
string name = null;
string company = null;
string position = null;
string site = null;
string note = null;
if (contact["name"] != null)
{
name = contact["name"].ToString();
}
else if (contact["firstName"] != null)
{
name = contact["firstName"].ToString() + " " + contact["lastName"].ToString();
}
else
{
Console.WriteLine("Error: Name is required");
continue;
}
if (contact["company"] != null)
{
company = contact["company"].ToString();
}
if (contact["position"] != null)
{
position = contact["position"].ToString();
}
if (contact["site"] != null)
{
site = contact["site"].ToString();
}
if (contact["notes"] != null)
{
note = contact["notes"].ToString();
}
Contact person = new Contact()
{
Name = name,
Company = company,
Position = position,
Site = site,
Notes = note
};
if (contact["phones"] != null)
{
var query = contact["phones"].Select(c => c.ToString());
foreach (var phone in query)
{
Phone num = new Phone()
{
PhoneNumber = phone.ToString()
};
person.Phones.Add(num);
}
}
if (contact["emails"] != null)
{
var mails = contact["emails"].Select(e => e.ToString());
foreach (var mail in mails)
{
Email email = new Email()
{
EmailAddress = mail
};
person.Emails.Add(email);
}
}
context.Contacts.Add(person);
context.SaveChanges();
Console.WriteLine("Contact {0} imported", name);
}
}