public ContactForm SaveContactForm(ContactForm form)
        {
            using (var context = new Data.ContactFormsContext()) {
                context.ContactForms.Add(form);

                context.SaveChanges();
            }
            return(form);
        }
        public ContactForm SaveContactForm(ContactForm form)
        {
            using (var context = new Data.ContactFormsContext()) {
                context.ContactForms.Add(form);

                context.SaveChanges();
            }
            return form;
        }
        public IEnumerable <ContactForm> GetForms(string filter, int skip, int top, string order = "Date", DateTime?createdFrom = null, DateTime?createdTo = null)
        {
            using (var context = new Data.ContactFormsContext()) {
                IQueryable <ContactForm> forms = null;

                forms = context.ContactForms;

                if (createdFrom.HasValue)
                {
                    forms = forms.Where(f => f.CreateDate >= createdFrom.Value);
                }

                if (createdTo.HasValue)
                {
                    forms = forms.Where(f => f.CreateDate <= createdTo.Value);
                }

                if (!String.IsNullOrEmpty(filter))
                {
                    filter = filter.ToLower();
                    forms  = forms.Where(f =>
                                         f.ContactName.ToLower().Contains(filter) ||
                                         f.ContactEmail.ToLower().Contains(filter) ||
                                         f.ContactPersonalId.ToLower().Contains(filter) ||
                                         f.ContactPersonalId2.ToLower().Contains(filter) ||
                                         f.Subject.ToLower().Contains(filter) ||
                                         f.ShortMessage.ToLower().Contains(filter) ||
                                         f.ContactCountry.ToLower().Equals(filter) ||
                                         f.ContactCity.ToLower().Equals(filter) ||
                                         f.ContactState.ToLower().Equals(filter));
                }

                forms = OrderForms(forms, order);

                if (skip != 0)
                {
                    forms = forms.Skip(skip);
                }

                if (top != 0)
                {
                    forms = forms.Take(top);
                }

                return(forms.ToArray());
            }
        }
        public IEnumerable<ContactForm> GetForms(string filter, int skip, int top, string order = "Date", DateTime? createdFrom = null, DateTime? createdTo = null)
        {
            using (var context = new Data.ContactFormsContext()) {
                IQueryable<ContactForm> forms = null;

                forms = context.ContactForms;

                if (createdFrom.HasValue)
                    forms = forms.Where(f => f.CreateDate >= createdFrom.Value);

                if (createdTo.HasValue)
                    forms = forms.Where(f => f.CreateDate <= createdTo.Value);

                if (!String.IsNullOrEmpty(filter)) {
                    filter = filter.ToLower();
                    forms = forms.Where(f =>
                        f.ContactName.ToLower().Contains(filter) ||
                        f.ContactEmail.ToLower().Contains(filter) ||
                        f.ContactPersonalId.ToLower().Contains(filter) ||
                        f.ContactPersonalId2.ToLower().Contains(filter) ||
                        f.Subject.ToLower().Contains(filter) ||
                        f.ShortMessage.ToLower().Contains(filter) ||
                        f.ContactCountry.ToLower().Equals(filter) ||
                        f.ContactCity.ToLower().Equals(filter) ||
                        f.ContactState.ToLower().Equals(filter));
                }

                forms = OrderForms(forms, order);

                if (skip != 0)
                    forms = forms.Skip(skip);

                if (top != 0)
                    forms = forms.Take(top);

                return forms.ToArray();
            }
        }
 public ContactForm GetForm(string formId)
 {
     using (var context = new Data.ContactFormsContext()) {
         return(context.ContactForms.Include("Data").SingleOrDefault(f => f.ContactFormUId == formId));
     }
 }
 public ContactForm GetForm(string formId)
 {
     using (var context = new Data.ContactFormsContext()) {
         return context.ContactForms.Include("Data").SingleOrDefault(f => f.ContactFormUId == formId);
     }
 }