using CMS.DocumentEngine;
using CMS.SettingsProvider;
using System.Data;

[CustomDocumentEvents]
public partial class CMSModuleLoader
{
    /// <summary>
    /// Attribute class that ensures the loading of custom handlers
    /// </summary>
    private class CustomDocumentEventsAttribute : CMSLoaderAttribute
    {
        /// <summary>
        /// Called automatically when the application starts
        /// </summary>
        public override void Init()
        {
            // Assigns custom handlers to the appropriate events
            DocumentEvents.Insert.Before += Document_Insert_Before;
            DocumentEvents.Update.Before += Document_Update_Before;
        }

        private void Document_Insert_Before(object sender, DocumentEventArgs e)
        {
            // type the document as TreeNode
            TreeNode objDoc = (TreeNode)e.Node;
            updateHouseListingStateAndTitle(objDoc, "INSERT");
        }

        private void Document_Update_Before(object sender, DocumentEventArgs e)
        {
            // type the document as TreeNode
            TreeNode objDoc = (TreeNode)e.Node;
            updateHouseListingStateAndTitle(objDoc, "UPDATE");
        }

        private void updateHouseListingStateAndTitle(TreeNode objDoc, string InsertOrUpdate)
        {
            // handle the event only for house listing items
            if (objDoc.NodeClassName.ToLower() == "cms.houselisting")
            {
                TreeNode parentNode = objDoc.Parent;
                string state = parentNode.DocumentName;
                string street = objDoc.GetStringValue("Street", "");
                string city = objDoc.GetStringValue("City", "");
                string zip = objDoc.GetStringValue("Zip", "");
                string title = street + ", " + city + ", " + state + " " + zip;
                //make sure no other house listing already exists with this title... if so, throw error and cancel update?
                QueryDataParameters prms = new QueryDataParameters();
                prms.Add("@street", street);
                prms.Add("@city", city);
                prms.Add("@state", state);
                prms.Add("@zip", zip);
                DataSet ds = SqlHelperClass.ExecuteQuery("CMS.HouseListing.HouseListingLookupByAddress", prms, null, null);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    //cancel insert/update... this one exists! how to raise error to user?
                    if (InsertOrUpdate.Equals("UPDATE"))
                    {
                        DocumentEvents.Update.Allow = false;
                        DocumentEvents.Update.Continue = false;
                    }
                    else
                    {
                        DocumentEvents.Insert.Allow = false;
                        DocumentEvents.Insert.Continue = false;
                    }
                }
                else
                {
                    objDoc.SetValue("HouseListingTitle", title);
                    objDoc.SetValue("State", state);
                }               
            }
        }

    }
}