private void AddContacts() { clstbl_Contacts objContacts = new clstbl_Contacts(WPFnMVVM.Common.clsSettings.ConStr); objContacts.First_Name = First_Name; objContacts.Last_Name = Last_Name; objContacts.DOB = DOB; objContacts.Insert(); }
private void LoadContacts() { clstbl_Contacts objContact = new clstbl_Contacts(WPFnMVVM.Common.clsSettings.ConStr); DataTable dt = objContact.Select(); _ContactsList = new ObservableCollection <clstbl_Contacts>(); for (int i = 0; i < dt.Rows.Count; i++) { _ContactsList.Add(new clstbl_Contacts { Id = Convert.ToInt16(dt.Rows[i]["ID"].ToString()) , First_Name = dt.Rows[i]["First_Name"].ToString(), Last_Name = dt.Rows[i]["Last_Name"].ToString(), DOB = Convert.ToDateTime(dt.Rows[i]["DOB"].ToString()) }); } }