using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

// Kentico Specific
using CMS.FormControls;
using CMS.GlobalHelper;
using System.Text.RegularExpressions;
using CMS.DataEngine;
using CMS.SettingsProvider;
using System.Data;
using CMS.FormEngine;


public partial class CMSFormControls_LocationPicker : FormEngineUserControl
{
    /// <summary>
    /// Gets or sets the value entered into the field
    /// </summary>

    public override Object Value
    {
        get
        {
            return DrpLocation.SelectedItem.Value;
        }
        set
        {
            // Ensure drop down list options
            PopulateLocations();
            DrpLocation.SelectedValue = System.Convert.ToString(value);
        }
    }

    /// <summary>
    /// Property used to access the Width parameter of the form control.
    /// </summary>
    public string PropertyValue
    {
        get
        {

            return ValidationHelper.GetString(this.GetValue("PhoneVar"), "");
        }
        set
        {
            //SetValue(ValidationHelper.GetString(this.GetValue("PhoneVar"), ""), value);
        }
    }

       
    /// <summary>
    /// Property used to access the Location parameter of the form control.
    /// </summary>
    public string Dependant
    {
        
        get
        {
            return ValidationHelper.GetString(DrpPhoneList.SelectedItem.Value, "");
            
        }
        set
        {
            this.SetValue(PropertyValue, value);
        }
    }

    /// </summary>

    /// <returns>It returns an array where the first dimension is the attribute name and the second is its value.</returns>
    /// 

    public override object[,] GetOtherValues()
    {
        if (!String.IsNullOrEmpty(Dependant))
        {
            object[,] result = new object[1, 2];
            result[0, 0] = PropertyValue; // MAKE SURE THIS VALUE IS THE NAME OF YOUR FIELD
            result[0, 1] = Dependant; // Use the same variable you are checking for nullorempty for consistency.
            return result;
        }
        else
        {
            return base.GetOtherValues();
        }
    }

    /// <summary>
    /// Returns true if selected. Otherwise, it returns false and displays an error message.
    /// </summary>

    public override bool IsValid()
    {
        if ((string)Value != "")
        {
            return true;
        }

        else
        {
            // Set form control validation error message.
            this.ValidationError = "Please choose a location.";
            return false;
        }
    }

    /// <summary>
    /// Sets up the internal DropDownList control.
    /// </summary>
    protected void PopulateLocations()
    {
        if (DrpLocation.Items.Count == 0)
        {
            DrpLocation.Items.Add(new ListItem("(select a location)", ""));

            // Get SQL query text
            string sqlText = "SELECT LocationID, OfficeName FROM custom_location";

            if (!sqlText.Contains("@"))
            {
                DataSet ds = null;

                try
                {
                    ds = ConnectionHelper.ExecuteQuery(sqlText, null, QueryTypeEnum.SQLQuery, false);
                }
                catch { }

                if (!DataHelper.DataSourceIsEmpty(ds))
                {
                    // Initialize control
                    DrpLocation.DataSource = ds;
                    DrpLocation.DataValueField = ds.Tables[0].Columns[0].ColumnName;
                    DrpLocation.DataTextField = ds.Tables[0].Columns[1].ColumnName;
                    DrpLocation.DataBind();
                }
            }
        }
    }

    /// <summary>
    /// Handler for the Load event of the control.
    /// </summary>

    protected void Page_Load(object sender, EventArgs e)
    {

        if (!IsPostBack)
        {
            // Ensure drop-down list options
            PopulateLocations();
            string SelectedPhone = ValidationHelper.GetString(Form.Data.GetValue(PropertyValue), "");

            if (DrpLocation.SelectedItem.Value != "")
            {
                PopulatePhoneList();

                if (SelectedPhone != "")
                {
                    DrpPhoneList.SelectedValue = SelectedPhone;
                }
            }
        }
    }

    protected void DrpLocation_SelectedIndexChanged(object sender, EventArgs e)
    {
        string LocationID = DrpLocation.SelectedItem.Value;
        DrpPhoneList.Items.Clear();

        if (DrpPhoneList.Items.Count == 0)
        {
            PopulatePhoneList();
        }
    }

    protected void PopulatePhoneList()
    {
        string LocationID = DrpLocation.SelectedItem.Value;
        DrpPhoneList.Items.Add(new ListItem("(select a phone number)", ""));

        // Get SQL query text
        string sqlText = "SELECT PhonenumberID, PhoneNumber FROM custom_phonenumber WHERE PhoneLocation =" + LocationID;

        if (!sqlText.Contains("@"))
        {
            DataSet ds = null;

            try
            {
                ds = ConnectionHelper.ExecuteQuery(sqlText, null, QueryTypeEnum.SQLQuery, false);
            }
            catch { }

            if (!DataHelper.DataSourceIsEmpty(ds))
            {
                // Initialize control
                DrpPhoneList.DataSource = ds;
                DrpPhoneList.DataValueField = ds.Tables[0].Columns[0].ColumnName;
                DrpPhoneList.DataTextField = ds.Tables[0].Columns[1].ColumnName;
                DrpPhoneList.DataBind();
            }
        }
    }
}