using System;
using System.Text;
using System.Xml;
using CMS.DataEngine;
using CMS.FormControls;
using CMS.Helpers;
using CMS.SiteProvider;

public partial class CMSFormControls_System_SelectColumns : FormEngineUserControl
{
    #region "Properties"

    /// <summary>
    /// Gets or sets the enabled state of the control.
    /// </summary>
    public override bool Enabled
    {
        get
        {
            return base.Enabled;
        }
        set
        {
            base.Enabled = value;
            txtColumns.Enabled = value;
            btnDesign.Enabled = value;
        }
    }


    ///<summary>Gets or sets field value.</summary>
    public override object Value
    {
        get
        {
            return hdnSelectedColumns.Value;
        }
        set
        {
            hdnSelectedColumns.Value = (string)value;
        }
    }

    #endregion


    #region "Methods"

    protected override void OnPreRender(EventArgs e)
    {
        base.OnPreRender(e);

        bool IsQuery = true;
        bool IsClassNames = true;
        bool IsCustomTable = true;
        string mJavaScript = "";

        ScriptHelper.RegisterDialogScript(Page);

        btnDesign.OnClientClick = "OpenModalDialog('" + hdnSelectedColumns.ClientID + "','" + txtColumns.ClientID + "'); return false;";

        mJavaScript += "function SetValue(input, txtInput,hdnSelColId,hdnColId){document.getElementById(hdnSelColId).value = input; document.getElementById(hdnColId).value = txtInput;return false }\n";
        mJavaScript += "function GetClassNames(hdnColId)  { return document.getElementById(hdnColId).value; return false;    }\n";
        mJavaScript += "function GetSelectedColumns(hdnSelColId) { return document.getElementById(hdnSelColId).value; return false;   }\n";

        // Try to find QueryName or ClassNames field

        object value;
        bool succ = Form.Data.TryGetValue("QueryName", out value);
        if (succ)
        {
            hdnProperties.Value = value.ToString();
            IsClassNames = false;
            IsCustomTable = false;
        }
        else
        {
            IsQuery = false;
        }

        // If it still can be custom table, try it
        if (IsCustomTable)
        {
            // Fake it as query
            succ = Form.Data.TryGetValue("CustomTable", out value);
            if (succ)
            {
                hdnProperties.Value = value.ToString();
                IsClassNames = false;
                IsQuery = true;
            }
            else
            {
                IsCustomTable = false;
            }
        }

        // If it still can be class names, try it
        if (IsClassNames)
        {
            value = String.Empty;
            succ = Form.Data.TryGetValue("ClassNames", out value);
            if (succ)
            {
                hdnProperties.Value = value.ToString();
            }
            else
            {
                IsClassNames = false;
            }
        }

        // if QueryName field was found
        if (IsQuery)
        {
            // if query name isnt empty
            if (!String.IsNullOrEmpty(hdnProperties.Value))
            {
                // Custom tables uses selectall query by default
                if (IsCustomTable)
                {
                    hdnProperties.Value += ".selectall";
                }

                string properties = ScriptHelper.GetString(hdnProperties.Value, false);

                mJavaScript += "function OpenModalDialog(hdnSelColId, hdnColId) { modalDialog('" + ResolveUrl("~/CMSFormControls/Selectors/GridColumnDesigner.aspx") + "?queryname=" + properties + "&SelColId=' + hdnSelColId + '&ColId=' + hdnColId + '&hash=" + ValidationHelper.GetHashString("?queryname=" + properties + "&SelColId=" + hdnSelectedColumns.ClientID + "&ColId=" + txtColumns.ClientID) + "' ,'GridColumnDesigner', 700, 560); return false;}\n";
            }
            else
            {
                string message;

                // Different message for query and custom table
                if (IsCustomTable)
                {
                    var classes = DataClassInfoProvider.GetClasses().Where("ClassIsCustomTable = 1 AND ClassID IN (SELECT ClassID FROM CMS_ClassSite WHERE SiteID = " + SiteContext.CurrentSiteID + ")");

                    message = classes.HasResults() ? GetString("SelectColumns.ApplyFirst") : GetString("SelectColumns.nocustomtablesavaible");
                }
                else
                {
                    message = GetString("SelectColumns.EmptyQueryName");
                }

                mJavaScript += "function OpenModalDialog(hdnSelColId, hdnColId) { alert('" + message + "'); return false;}\n";
            }
        }
        else if (IsClassNames)
        {
            mJavaScript += "function OpenModalDialog(hdnSelColId, hdnColId) { modalDialog('" + ResolveUrl("~/CMSFormControls/Selectors/GridColumnDesigner.aspx") + "?classnames=" + ScriptHelper.GetString(hdnProperties.Value, false) + "&SelColId=' + hdnSelColId + '&ColId=' + hdnColId ,'GridColumnDesigner', 700, 560); return false;}\n";
        }
        else // Cant find QueryName or ClassNames or Custom table fiels 
        {
            mJavaScript += "function OpenModalDialog(hdnSelColId, hdnColId) { alert(" + ScriptHelper.GetLocalizedString("SelectColumns.EmptyClassNamesAndQueryName") + ");}\n";
        }

        //Register JavaScript
        ScriptHelper.RegisterClientScriptBlock(this, typeof(string), "SelectColumsGlobal", ScriptHelper.GetScript(mJavaScript));

        btnDesign.Text = GetString("general.select");

        // Set to Textbox selected columns
        txtColumns.Text = ConvertXML(hdnSelectedColumns.Value);
    }


    /// <summary>
    /// Convert XML to TextBox.
    /// </summary>
    /// <param name="mXML">XML document</param>
    public string ConvertXML(string mXML)
    {
        if (DataHelper.GetNotEmpty(mXML, "") == "")
        {
            return "";
        }

        StringBuilder mToReturn = new StringBuilder();
        XmlDocument mXMLDocument = new XmlDocument();
        mXMLDocument.LoadXml(mXML);
        XmlNodeList NodeList = mXMLDocument.DocumentElement.GetElementsByTagName("column");

        int i = 0;

        foreach (XmlNode node in NodeList)
        {
            if (i > 0)
            {
                mToReturn.Append(";");
            }

            mToReturn.Append(XmlHelper.GetXmlAttributeValue(node.Attributes["name"], ""));

            i++;
        }

        return mToReturn.ToString();
    }

    #endregion
}