using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Xml;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.ApplicationBlocks.Data;
using umbraco;
using umbraco.BusinessLogic;
using umbraco.cms.businesslogic.datatype;
using umbraco.cms.businesslogic.datatype.controls;
using umbraco.cms.businesslogic.web;
using umbraco.interfaces;
namespace FtpMedia
{
public partial class Installer : System.Web.UI.UserControl
{
protected void Page_Load(object sender, EventArgs e)
{
try
{
//create user instance
User u = new User(0);
//create datatypes
DataTypeDefinition dtdMediaFile = null;
DataTypeDefinition dtdMediaVideo = null;
//iterate data type definitions
foreach (DataTypeDefinition dt in DataTypeDefinition.GetAll())
{
//check if media file
if (dt.Text == "FTP Media File")
dtdMediaFile = dt;
//check if video file
if (dt.Text == "FTP Media Video")
dtdMediaVideo = dt;
}
//create new media file data type
if (dtdMediaFile == null)
{
dtdMediaFile = DataTypeDefinition.MakeNew(u, "FTP Media File");
dtdMediaFile.DataType = new Factory().DataType(new Guid("d15e1281-e456-4b24-aa86-1dda3e4299d5")); // The guid of the data type definition (umbraco usercontrol wrapper)
updateDbType(dtdMediaFile.Id, "Nvarchar");
}
//create new media video data type
if (dtdMediaVideo == null)
{
dtdMediaVideo = DataTypeDefinition.MakeNew(u, "FTP Media Video");
dtdMediaVideo.DataType = new Factory().DataType(new Guid("d15e1281-e456-4b24-aa86-1dda3e4299d5")); // The guid of the data type definition (umbraco usercontrol wrapper)
updateDbType(dtdMediaVideo.Id, "Nvarchar");
}
// add control path pre-values
addPreValue(dtdMediaFile.Id, "/usercontrols/FtpMedia/FtpMedia_FileUpload.ascx");
addPreValue(dtdMediaVideo.Id, "/usercontrols/FtpMedia/FtpMedia_VideoUpload.ascx");
//get media types
umbraco.cms.businesslogic.media.MediaType ftpFile = null;
umbraco.cms.businesslogic.media.MediaType ftpVideo = null;
//iterate media type definitions
foreach (umbraco.cms.businesslogic.media.MediaType mt in umbraco.cms.businesslogic.media.MediaType.GetAll)
{
//check if media file
if (mt.Text == "FTPFile")
ftpFile = mt;
//check if video file
if (mt.Text == "FTPVideo")
ftpVideo = mt;
}
//create tab id holders
int ftpFileTabId = 0;
int ftpVideoTabId = 0;
//if not exists
if (ftpFile == null)
{
//create new media type
ftpFile = umbraco.cms.businesslogic.media.MediaType.MakeNew(u, "FTP File");
//create new media tab
ftpFileTabId = ftpFile.AddVirtualTab("File");
}
else //try to get existing tab id
ftpFileTabId = getMediaTabId("File", ftpFile);
//set media file type properties
ftpFile.AddPropertyType(new DataTypeDefinition(dtdMediaFile.Id), "FTPFile", "FTP File");
ftpFile.SetTabOnPropertyType(ftpFile.getPropertyType("FTPFile"), ftpFileTabId);
updateContentImageType(ftpFile.Id, "mediaMulti.gif");
//if not exists
if (ftpVideo == null)
{
//create new media type
ftpVideo = umbraco.cms.businesslogic.media.MediaType.MakeNew(u, "FTP Video");
//create new media tab
ftpVideoTabId = ftpVideo.AddVirtualTab("Video");
}
else //try to get existing tab id
ftpVideoTabId = getMediaTabId("Video", ftpVideo);
//set media video type properties
ftpVideo.AddPropertyType(new DataTypeDefinition(dtdMediaVideo.Id), "FTPVideo", "FTP Video");
ftpVideo.SetTabOnPropertyType(ftpVideo.getPropertyType("FTPVideo"), ftpVideoTabId);
updateContentImageType(ftpVideo.Id, "mediaMulti.gif");
//update xslt extensions config setting
updateXsltExtensions();
//display success message and config example to user
lblMessage.Text = "<p>Congratulations! The FTP Media package has successfully installed!</p>";
litConfig.Visible = true;
}
catch (System.Exception err)
{
//display error message and hide config example to user
lblMessage.Text = "<p>The following error has occured:<br/><br/>" + err.Message + "</p>";
litConfig.Visible = false;
}
}
private void addPreValue(int dataTypeId, string Text)
{
//add prevalue to db
SqlHelper.ExecuteNonQuery(
GlobalSettings.DbDSN,
CommandType.Text,
"insert into cmsDataTypePrevalues (datatypenodeid,[value],sortorder,alias) values (@dtdefid,@value,0,'')",
new SqlParameter("@dtdefid", dataTypeId),
new SqlParameter("@value", Text));
}
private int getPreValueId(int dataTypeId, string Text)
{
//get prevalue from db
return int.Parse(
SqlHelper.ExecuteScalar(
GlobalSettings.DbDSN,
CommandType.Text,
"select id from cmsDataTypePrevalues where datatypenodeid = @dtdefid and [value] = @value",
new SqlParameter("@dtdefid", dataTypeId),
new SqlParameter("@value", Text)).ToString());
}
private int updateDbType(int dataTypeId, string dbType)
{
//update db type value
return int.Parse(
SqlHelper.ExecuteNonQuery(GlobalSettings.DbDSN,
CommandType.Text, "update cmsDataType set dbType = '" + dbType + "' where nodeId = @datadefinitionid",
new SqlParameter("@datadefinitionid", dataTypeId)).ToString());
}
private int updateContentImageType(int dataTypeId, string imageType)
{
//update db type value
return int.Parse(
SqlHelper.ExecuteNonQuery(GlobalSettings.DbDSN,
CommandType.Text, "update cmsContentType set icon = '" + imageType + "' where nodeId = @datadefinitionid",
new SqlParameter("@datadefinitionid", dataTypeId)).ToString());
}
private int getContentTabId(string caption, umbraco.cms.businesslogic.ContentType ContentType)
{
//iterate content types
foreach (umbraco.cms.businesslogic.ContentType.TabI t in ContentType.getVirtualTabs)
{
//if match, return id
if (t.Caption.ToLower() == caption)
return t.Id;
}
return 0;
}
private int getMediaTabId(string caption, umbraco.cms.businesslogic.media.MediaType MediaType)
{
//iterate media types
foreach (umbraco.cms.businesslogic.media.MediaType.TabI t in MediaType.getVirtualTabs)
{
//if match, return id
if (t.Caption.ToLower() == caption)
return t.Id;
}
return 0;
}
private void updateXsltExtensions()
{
//create new xml doc object
XmlDocument document = new XmlDocument();
//load config file values
document.Load(Server.MapPath("/config/") + "xsltExtensions.config");
//get root node
XmlNode node = document.SelectSingleNode("/XsltExtensions");
//create new element
XmlNode newChild = document.CreateElement("ext");
//add element assembly attribute
XmlAttribute AtAssembly = document.CreateAttribute("assembly");
AtAssembly.Value = "/bin/FtpMedia";
newChild.Attributes.Append(AtAssembly);
//add element assembly type attribute
XmlAttribute atType = document.CreateAttribute("type");
atType.Value = "FtpMedia.XsltHelper";
newChild.Attributes.Append(atType);
//add element assembly alias attribute
XmlAttribute atAlias = document.CreateAttribute("alias");
atAlias.Value = "XsltHelper";
newChild.Attributes.Append(atAlias);
//add child element
node.AppendChild(newChild);
//save changes
document.Save(Server.MapPath("/config/") + "xsltExtensions.config");
}
}
}