Beispiel #1
0
        protected void dgEtFieldsAttributes_ItemCommand(Object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
        {
            int    attributeId;
            int    tableId   = int.Parse(ddlTableDefs.SelectedValue);
            string tableName = lblEtTableName.Text;

            MetadataNewDa MNDa = new MetadataNewDa();

            switch (e.CommandName)
            {
            case "Delete":

                attributeId = int.Parse(e.Item.Cells[0].Text);
                MNDa.DeleteAttribute(attributeId);

                break;

            case "SaveAttributes":
                DataGrid dgAttributes = (DataGrid)source;
                foreach (DataGridItem dgi in dgAttributes.Items)
                {
                    if (dgi.ItemType == ListItemType.Item || dgi.ItemType == ListItemType.AlternatingItem)
                    {
                        int          fieldAttributeId = int.Parse(dgi.Cells[0].Text);
                        DropDownList ddl = (DropDownList)dgi.FindControl("attDdlAttributeValue");
                        TextBox      txt = (TextBox)dgi.FindControl("attTxtAttributeValue");
                        string       theValue;
                        if (((TextBox)dgi.FindControl("attTxtAttributeValueCtrlUsed")).Text == "txt")
                        {
                            theValue = txt.Text;
                        }
                        else
                        {
                            theValue = ddl.SelectedValue;
                        }

                        theValue = PageUtil.EscapeSingleQuotesForSql(theValue);
                        MNDa.UpdateAttribute(fieldAttributeId, theValue);
                    }
                }
                TextBox txtNewAttributesList = (TextBox)Page.FindControl("attTxtNewAttributesList");

                string[] atts = txtNewAttributesList.Text.Split(char.Parse("@"));
                for (int k = 0; k < atts.Length; k++)
                {
                    string[] anAtt = atts[k].Split(char.Parse(";"));
                    if (anAtt.Length == 3 && PageUtil.IsInteger(anAtt[0]) && PageUtil.IsInteger(anAtt[1]))
                    {
                        string attValue = PageUtil.EscapeSingleQuotesForSql(anAtt[2]);

                        MNDa.DeleteAttribute(int.Parse(anAtt[0]), int.Parse(anAtt[1]));
                        MNDa.AddAttribute(int.Parse(anAtt[0]), int.Parse(anAtt[1]), attValue);
                    }
                }
                txtNewAttributesList.Text = "";
                break;
            }
            viewMode = "editTable";
            setViewMode();
            updateEditTableView(tableId, tableName);
        }