public void AddToAndGetFromDBTest() { using (ContactTypeDBDataContext Context = new ContactTypeDBDataContext()) { ContactType newContact = new ContactType { Name = "New contact name", ModifiedDate = DateTime.Now }; Context.ContactType.InsertOnSubmit(newContact); Context.SubmitChanges(); } using (ContactTypeDBDataContext Context = new ContactTypeDBDataContext()) { ContactType readContact = Context.ContactType.FirstOrDefault(c => c.Name == "New contact name"); ContactType anotherReadContact = Context.ContactType.FirstOrDefault(c => c.Name == "A name that does not appear"); Assert.AreEqual("New contact name", readContact.Name); Assert.IsNull(anotherReadContact); Context.ContactType.DeleteOnSubmit(readContact); Context.SubmitChanges(); ContactType yetAnotherReadContact = Context.ContactType.FirstOrDefault(c => c.Name == "New contact name"); Assert.IsNull(yetAnotherReadContact); } }
public void RemoveContactType(int contactID) { using (ContactTypeDBDataContext Context = new ContactTypeDBDataContext()) { ContactType contactType = Context.ContactType.Where(ct => ct.ContactTypeID == contactID).FirstOrDefault(); Context.ContactType.DeleteOnSubmit(contactType); Context.SubmitChanges(); } }
public ContactTypeWrapper GetContactType(int id) { ContactType contact = new ContactType(); using (ContactTypeDBDataContext Context = new ContactTypeDBDataContext()) { contact = Context.ContactType.Where(ct => ct.ContactTypeID == id).FirstOrDefault(); } return(new ContactTypeWrapper(contact)); }
public int GetContactIDByName(string name) { ContactType contact = new ContactType(); using (ContactTypeDBDataContext Context = new ContactTypeDBDataContext()) { contact = Context.ContactType.Where(ct => ct.Name == name).FirstOrDefault(); } return(contact.ContactTypeID); }
public void UpdateContactType(int contactID, string name) { using (ContactTypeDBDataContext Context = new ContactTypeDBDataContext()) { ContactType contact = Context.ContactType.Where(ct => ct.ContactTypeID == contactID).FirstOrDefault(); contact.Name = name; contact.ModifiedDate = DateTime.Now; Context.SubmitChanges(); } }
public void AddContactType(string name) { ContactType newContact = new ContactType { Name = name, ModifiedDate = DateTime.Now }; using (ContactTypeDBDataContext Context = new ContactTypeDBDataContext()) { Context.ContactType.InsertOnSubmit(newContact); Context.SubmitChanges(); } }
public List <ContactTypeWrapper> GetContactTypes() { List <ContactType> contacts = new List <ContactType>(); using (ContactTypeDBDataContext Context = new ContactTypeDBDataContext()) { contacts = Context.ContactType.ToList(); } List <ContactTypeWrapper> contactTypeWrappers = new List <ContactTypeWrapper>(); foreach (ContactType contact in contacts) { contactTypeWrappers.Add(new ContactTypeWrapper(contact)); } return(contactTypeWrappers); }