Exemple #1
0
        public void Insert(ID formId, AdaptedResultList fields, ID sessionID, string data)
        {
            Assert.ArgumentNotNull(formId, "formId");
            Assert.ArgumentNotNull(fields, "fields");

            Infrastructure.Data.Form form = _formFactory.Create(formId, fields, sessionID, data);
            using (WebFormForMarketersDataContext webFormForMarketersDataContext = new WebFormForMarketersDataContext(ConnectionString))
            {
                webFormForMarketersDataContext.Forms.InsertOnSubmit(form);
                webFormForMarketersDataContext.SubmitChanges();
            }
        }
Exemple #2
0
        public DateTime OldestFormSubmission(ID formId)
        {
            var dt = DateTime.Now;

            using (WebFormForMarketersDataContext webFormForMarketersDataContext = new WebFormForMarketersDataContext(ConnectionString))
            {
                var forms = webFormForMarketersDataContext.Forms.Where(f => f.FormItemId == formId.Guid);
                if (forms.Count() > 0)
                {
                    dt = forms.Min(f => f.Timestamp);
                }
            }
            return(dt);
        }
        public IEnumerable<IForm> Get(ID formId)
        {
            List<IForm> forms = new List<IForm>();

            using (WebFormForMarketersDataContext webFormForMarketersDataContext = new WebFormForMarketersDataContext(ConnectionString))
            {
                IQueryable<Infrastructure.Data.Form> dataForms = webFormForMarketersDataContext.Forms.Where(f => f.FormItemId == formId.Guid).OrderBy(f => f.Timestamp);
                foreach (Infrastructure.Data.Form dataForm in dataForms)
                {
                    Model.Form form = _formFactory.Create(dataForm);
                    if (form != null)
                        forms.Add(form);
                }
            }
            return forms;
        }
Exemple #4
0
        public IEnumerable <IForm> Get(ID formId)
        {
            List <IForm> forms = new List <IForm>();

            using (WebFormForMarketersDataContext webFormForMarketersDataContext = new WebFormForMarketersDataContext(ConnectionString))
            {
                IQueryable <Infrastructure.Data.Form> dataForms = webFormForMarketersDataContext.Forms.Where(f => f.FormItemId == formId.Guid).OrderBy(f => f.Timestamp);
                foreach (Infrastructure.Data.Form dataForm in dataForms)
                {
                    Model.Form form = _formFactory.Create(dataForm);
                    if (form != null)
                    {
                        forms.Add(form);
                    }
                }
            }
            return(forms);
        }
        public void Insert(ID formId, AdaptedResultList fields, ID sessionID, string data)
        {
            Assert.ArgumentNotNull(formId, "formId");
            Assert.ArgumentNotNull(fields, "fields");

            Infrastructure.Data.Form form = _formFactory.Create(formId, fields, sessionID, data);
            using (WebFormForMarketersDataContext webFormForMarketersDataContext = new WebFormForMarketersDataContext(ConnectionString))
            {
                webFormForMarketersDataContext.Forms.InsertOnSubmit(form);
                webFormForMarketersDataContext.SubmitChanges();
            }
        }
 public DateTime OldestFormSubmission(ID formId)
 {
     var dt = DateTime.Now;
     using (WebFormForMarketersDataContext webFormForMarketersDataContext = new WebFormForMarketersDataContext(ConnectionString))
     {
         var forms = webFormForMarketersDataContext.Forms.Where(f => f.FormItemId == formId.Guid);
         if (forms.Count() > 0)
             dt = forms.Min(f => f.Timestamp);
     }
     return dt;
 }