Exemple #1
0
        private void UpdateRecStatus(GridField gridField, bool isDelete, string globalRecordId)
        {
            Epi.Data.Services.CollectedDataProvider collectedData = this.EnterCheckCodeEngine.Project.CollectedData;

            Epi.Data.Query updateQuery = collectedData.CreateQuery("update " + gridField.TableName + " set [RecStatus] = @RecStatus where [FKEY] = @FKEY");
            updateQuery.Parameters.Add(new Epi.Data.QueryParameter("@RecStatus", DbType.Int32, isDelete ? 0 : 1));
            updateQuery.Parameters.Add(new Epi.Data.QueryParameter("@FKEY", DbType.String, globalRecordId));
            collectedData.ExecuteNonQuery(updateQuery);
        }
        private DataTable GetFromData(string toRecordGuid)
        {
            string uniqueKeys = "";
            string parens     = "";
            string joins      = "";

            foreach (Epi.View epiView in view.Project.Views)
            {
                if (!string.IsNullOrEmpty(epiView.TableName) && db.TableExists(epiView.TableName))
                {
                    uniqueKeys += "t" + epiView.Id + ".UniqueKey as Key" + epiView.Id + ", ";
                    parens     += "(";
                    joins      += "left outer join " + epiView.TableName + " t" + epiView.Id + " on m.FromRecordGuid = t" + epiView.Id + ".GlobalRecordId) ";
                }
            }
            uniqueKeys = uniqueKeys.Substring(0, uniqueKeys.Length - 2) + " ";

            Epi.Data.Query query = db.CreateQuery(@"Select FromRecordGuid, ToRecordGuid, FromViewId, ToViewId, " + uniqueKeys + " from " + parens + "metaLinks m " + joins + " where m.ToRecordGuid = @GlobalRecordId");
            query.Parameters.Add(new Epi.Data.QueryParameter("@GlobalRecordId", DbType.StringFixedLength, toRecordGuid));
            return(db.Select(query));
        }
Exemple #3
0
        private void UpdateRecStatus(View view, bool isDelete, string globalRecordId)
        {
            Epi.Data.Services.CollectedDataProvider collectedData = this.EnterCheckCodeEngine.Project.CollectedData;

            Epi.Data.Query updateQuery = collectedData.CreateQuery("update " + view.TableName + " set [RecStatus] = @RecStatus where [GlobalRecordId] = @GlobalRecordId");
            updateQuery.Parameters.Add(new Epi.Data.QueryParameter("@RecStatus", DbType.Int32, isDelete ? 0 : 1));
            updateQuery.Parameters.Add(new Epi.Data.QueryParameter("@GlobalRecordId", DbType.String, globalRecordId));
            collectedData.ExecuteNonQuery(updateQuery);

            // < GRID TABLES >

            foreach (GridField gridField in view.Fields.GridFields)
            {
                UpdateRecStatus(gridField, isDelete, globalRecordId);
            }

            // < CHILD VIEW >

            List <Epi.Fields.RelatedViewField> RelatedViewList = FindRelatedFields(view);

            foreach (Epi.Fields.RelatedViewField field in RelatedViewList)
            {
                View relatedView = this.EnterCheckCodeEngine.Project.GetViewById(field.RelatedViewID);

                if (collectedData.TableExists(relatedView.Name))
                {
                    Epi.Data.Query childRecordQuery = collectedData.CreateQuery("Select GlobalRecordId From " + relatedView.TableName + " Where [FKEY] = @FKEY");
                    childRecordQuery.Parameters.Add(new Epi.Data.QueryParameter("@FKEY", DbType.String, globalRecordId));
                    IDataReader dataReader = collectedData.ExecuteReader(childRecordQuery);

                    while (dataReader.Read())
                    {
                        string readerGlobalRecordId = dataReader["GlobalRecordId"].ToString();
                        UpdateRecStatus(relatedView, isDelete, readerGlobalRecordId);
                    }
                }
            }
        }
Exemple #4
0
        /// <summary>
        /// Load the form with the saved data
        /// </summary>
        private new void LoadFormData()
        {
            Configuration config = Configuration.GetNewInstance();
            FontStyle     style  = FontStyle.Regular;

            if (config.Settings.EditorFontBold)
            {
                style |= FontStyle.Bold;
            }
            if (config.Settings.EditorFontItalics)
            {
                style |= FontStyle.Italic;
            }
            field.PromptFont = new Font(config.Settings.EditorFontName, (float)config.Settings.EditorFontSize, style);

            style = FontStyle.Regular;
            if (config.Settings.ControlFontBold)
            {
                style |= FontStyle.Bold;
            }
            if (config.Settings.ControlFontItalics)
            {
                style |= FontStyle.Italic;
            }
            field.ControlFont = new Font(config.Settings.ControlFontName, (float)config.Settings.ControlFontSize, style);

            txtPrompt.Text    = field.PromptText;
            txtFieldName.Text = field.Name;
            if (!string.IsNullOrEmpty(field.SourceTableName))
            {
                this.sourceTableName = field.SourceTableName;
                this.textColumnName  = field.TextColumnName;
                txtDataSource.Text   = field.SourceTableName + " :: " + field.TextColumnName;
            }
            chkReadOnly.Checked   = field.IsReadOnly;
            chkRepeatLast.Checked = field.ShouldRepeatLast;
            chkRequired.Checked   = field.IsRequired;
            promptFont            = field.PromptFont;
            controlFont           = field.ControlFont;
            if (!(String.IsNullOrEmpty(txtPrompt.Text)))
            {
                btnDataSource.Enabled = true;
            }
            else
            {
                btnDataSource.Enabled = false;
            }

            Epi.Data.IDbDriver db    = Epi.Data.DBReadExecute.GetDataDriver(page.view.Project.CollectedDataConnectionString);
            Epi.Data.Query     query = db.CreateQuery("select [Name], [FieldId] " +
                                                      "from metaFields " +
                                                      "where [PageId] = @pageID and [FieldTypeId] in (1,3,4,17, 18, 19, 27) " +
                                                      " and [ViewId] = @viewID " +
                                                      "order by [Name]");
            query.Parameters.Add(new Epi.Data.QueryParameter("@pageID", DbType.Int32, page.Id));
            query.Parameters.Add(new Epi.Data.QueryParameter("@viewID", DbType.Int32, page.view.Id));

            //DataTable textFields = page.GetMetadata().GetTextFieldsForPage(page.GetView().Id, page.Id);
            DataTable textFields = db.Select(query);
            string    expression = "Name = '" + txtFieldName.Text + "'";
            string    sortOrder  = "Name DESC";

            DataRow[] rows = textFields.Select(expression, sortOrder);
            if (rows.Length > 0)
            {
                textFields.Rows.Remove(rows[0]);
            }
            lbxLinkedFields.DataSource    = textFields;
            lbxLinkedFields.DisplayMember = ColumnNames.NAME;

            if (!(string.IsNullOrEmpty(txtDataSource.Text)))
            {
                selectedIndex = page.GetProject().CollectedData.GetTableColumnNames(field.SourceTableName);

                String textFieldName = string.Empty;

                for (int i = 0; i < textFields.Rows.Count; i++)
                {
                    textFieldName = textFields.Rows[i][ColumnNames.NAME].ToString();

                    if (selectedIndex.Contains(textFieldName))
                    {
                        lbxLinkedFields.SetSelected(lbxLinkedFields.FindStringExact(textFieldName), true);
                    }
                    else
                    {
                        lbxLinkedFields.SetSelected(lbxLinkedFields.FindStringExact(textFieldName), false);
                    }
                }
                lbxLinkedFields.Enabled = true;
                lblSelectFields.Enabled = true;
                lbxLinkedFields.Visible = true;
                lblSelectFields.Visible = true;
                btnOk.Enabled           = true;
            }
            else
            {
                btnOk.Enabled = true;
            }
        }