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);
}
}
