private int InsertItem(ContactForm form) { ValidateForm(form); using (ContactInformationDataContext repository = ContactDataSource.ContactDataContext()) { oc_contactlist contact = new oc_contactlist { business_area = form.BusinessArea, source_form_name = form.SourceFormName, source_form_path = form.SourcePath, external_key = form.ExternalKey, external_date = form.ExternalDate, contact_type = form.ContactTypes, contact_fullname = form.Name, contact_email = form.Email, contact_phone = form.Phone, company_name = form.Company, language = form.Language, xml_form_data = form.FormData, date_created = DateTime.Now }; repository.oc_contactlists.InsertOnSubmit(contact); repository.SubmitChanges(); return(contact.pk_id); } }
private IList <ContactForm> GetAllContactFormsFromRepository(ContactInformationDataContext repository) { IList <ContactForm> contacts = (from contact in repository.oc_contactlists select BuildContactForm(contact)).ToList(); return(contacts); }
public IList <ContactForm> GetAllContacts() { using (ContactInformationDataContext repository = ContactDataSource.ContactDataContext()) { IList <ContactForm> contacts = GetAllContactFormsFromRepository(repository); return(contacts); } }
public ContactForm GetContactFormById(int formId) { using (ContactInformationDataContext repository = ContactDataSource.ContactDataContext()) { ContactForm form = (from contact in repository.oc_contactlists where contact.pk_id == formId select BuildContactForm(contact)).FirstOrDefault(); return(form); } }
public IList <ContactForm> GetLast100Contacts() { // Just for convinience lets show last 100 contacts using (ContactInformationDataContext repository = ContactDataSource.ContactDataContext()) { // IList <ContactForm> contacts = (from contact in repository.oc_contactlists select BuildContactForm(contact)).Take(100).ToList(); return(contacts); } }
public IList <ContactFormType> GetContactFormTypes() { using (ContactInformationDataContext repository = ContactDataSource.ContactDataContext()) { var formTypes = (from contact in repository.oc_contactlists select contact.source_form_name).Distinct(); List <ContactFormType> formTypeList = new List <ContactFormType>(); foreach (var formType in formTypes) { formTypeList.Add(new ContactFormType { SourceFormName = formType }); } return(formTypeList); } }
public IList <ContactForm> GetContactsByCriteria(string formName, DateTime startingFrom) { // Just for convinience lets show last 100 contacts using (ContactInformationDataContext repository = ContactDataSource.ContactDataContext()) { // bool hasWhere = formName != string.Empty || startingFrom != DateTime.MinValue; IList <ContactForm> contactForms = (from contact in repository.oc_contactlists where (String.IsNullOrEmpty(formName) || contact.source_form_name == formName) && (DateTime.MinValue == startingFrom || contact.date_created > startingFrom) orderby contact.date_created descending select BuildContactForm(contact)).ToList(); return(contactForms); } }