public void CreateNewContact(Contact contact, AddressModel address, string contactType) { using (var dataContext = new DataContext.AdressbookDataContext()) { var newContact = new DataContext.Contact(); newContact.Name = contact.Name; newContact.Email = contact.Email; newContact.Telephone = contact.Telephone; var newAddress = new DataContext.Address(); newAddress.StreetAddress = address.StreetAddress; newAddress.City = address.City; newAddress.PostalCode = address.PostalCode; var contactId = newContact.Id; var newContactType = new DataContext.ContactType(); newContactType.ContactType1 = contactType; newContactType.ContactId = contactId; var newAddressContactLink = new DataContext.AddressContactLink(); newAddressContactLink.ContactId = newContact.Id; newAddressContactLink.AddressId = newAddress.Id; dataContext.Contact.Add(newContact); dataContext.Address.Add(newAddress); dataContext.ContactType.Add(newContactType); dataContext.AddressContactLink.Add(newAddressContactLink); dataContext.SaveChanges(); } }
public BindingList <View_Models.AddressModel> GetAddress() { BindingList <AddressModel> addresses; using (var dataContext = new DataContext.AdressbookDataContext()) { var addressQuery = from address in dataContext.Address select new View_Models.AddressModel() { Id = address.Id, StreetAddress = address.StreetAddress, PostalCode = address.PostalCode, City = address.City }; addresses = new BindingList <AddressModel>(addressQuery.ToList()); } return(addresses); }
public BindingList <View_Models.Contact> GetContacts() { BindingList <Contact> contacts; using (var dataContext = new DataContext.AdressbookDataContext()) { var contactQuery = from contact in dataContext.Contact join contactType in dataContext.ContactType on contact.Id equals contactType.ContactId select new View_Models.Contact() { Id = contact.Id, Name = contact.Name, Email = contact.Email, Telephone = contact.Telephone, Contact_Type = contactType.ContactType1 }; contacts = new BindingList <Contact>(contactQuery.ToList()); } return(contacts); }
public BindingList <View_Models.Contact> GetContacts(int addressId) { BindingList <Contact> contacts; using (var dataContext = new DataContext.AdressbookDataContext()) { var result = from link in dataContext.AddressContactLink join address in dataContext.Address on link.AddressId equals addressId join typeOfContact in dataContext.ContactType on link.ContactId equals typeOfContact.ContactId where address.Id == addressId select new View_Models.Contact() { Id = link.Id, Name = link.Contact.Name, Email = link.Contact.Email, Telephone = link.Contact.Telephone, Contact_Type = typeOfContact.ContactType1 }; contacts = new BindingList <Contact>(result.ToList()); } return(contacts); }