private void loadCotactFromDatabase()
{
using (SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Roba\Documents\Visual Studio 2013\Projects\Todo+duomb\WindowsFormsApplication6\Database.mdf;Integrated Security=True"))
{
con.Open();
using (SqlCommand command = new SqlCommand("SELECT * FROM contact", con))
{
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
int id = reader.GetInt32(0);
string name = reader.GetString(1);
string surname = reader.GetString(2);
string phone = reader.GetString(3);
string address = reader.GetString(4);
ContactItem contact = new ContactItem(id, name, surname, phone, address);
list2.AddLast(contact);
}
}
}
refreshContact();
}
private void loadContactFile()
{
XmlDocument doc = new XmlDocument();
if (new FileInfo("contact.xml").Length < 10)
{
return;
}
doc.Load("contact.xml");
XmlNodeList elemList = doc.GetElementsByTagName("Contact");
list2.Clear();
foreach (XmlNode element in elemList)
{
string number = element["Number"].InnerText;
string name = element["Name"].InnerText;
string surname = element["Surname"].InnerText;
string phone = element["Phone"].InnerText;
string address = element["Address"].InnerText;
int num = Convert.ToInt32(number);
ContactItem contact = new ContactItem(num ,name, surname, phone, address);
list2.AddLast(contact);
}
refreshContactsView();
doc.Save("contact.xml");
}
private void addContact_Click(object sender, EventArgs e)
{
ContactItem contact = new ContactItem(0,"","","","");
Form3 thirdForm = new Form3(contact);
if (thirdForm.ShowDialog(this) == DialogResult.OK)
{
var item = new ListViewItem();
item.Tag = contact;
item.SubItems.Add(contact.name);
item.SubItems.Add(contact.surname);
item.SubItems.Add(contact.phoneNumber);
item.SubItems.Add(contact.address);
listView2.Items.Add(item);
list2.AddLast(contact);
}
writeContactsToDatabase();
}
public Form3(ContactItem item)
{
InitializeComponent();
this.item = item;
Edit();
}
