private void AddAlias_Click(object sender, EventArgs e)
{
if (this.ServerList.SelectedIndex >= 0)
{
Aliases newAlias = new Aliases();
newAlias.AliasName = "/www_folder";
newAlias.AliasFolder = Globals.AppFolder;
newAlias.VHostID = Globals.VHosts[this.ServerList.SelectedIndex].VHostID;
newAlias.AliasID = Database.AddUpdateAlias(newAlias);
Globals.VHosts[this.ServerList.SelectedIndex].Alias.Add(newAlias);
this.Alias.Items.Add(newAlias.AliasName);
this.Alias.SelectedIndex = this.Alias.Items.Count - 1;
this.Alias_DoubleClick(null, null);
}
}
public int AddUpdateAlias(Aliases Al)
{
if (Al.AliasID > 0)
{
try
{
return(Globals.dbConn.ExecuteNonQuery("UPDATE Aliases SET AliasFolder = '" + Al.AliasFolder + "', AliasName = '" + Al.AliasName + "' WHERE AliasID = " + Al.AliasID));
}
catch (Exception /*ex*/)
{
//Globals.Error.Show(ex.Message);
return(-1);
}
}
else
{
Globals.dbConn.ExecuteNonQuery("INSERT INTO Aliases ('AliasFolder', 'AliasName', 'VHostID') VALUES ('" + Al.AliasFolder + "', '" + Al.AliasName + "', " + Al.VHostID + ")");
return(Convert.ToInt32(Globals.dbConn.ExecuteScalar("SELECT MAX(AliasID) from Aliases")));
}
}
public void DeleteAlias(Aliases Al)
{
Globals.dbConn.ExecuteNonQuery("DELETE FROM Aliases WHERE AliasID = " + Al.AliasID);
}
public void LoadVirtualHosts()
{
Globals.VHosts.Clear();
// Load Virtual Hosts info from database.
DataTable DBVHosts = Globals.dbConn.GetDataTable("SELECT * FROM VirtualHosts");
foreach (DataRow rowVH in DBVHosts.Rows)
{
VirtualHost VH = new VirtualHost();
foreach (DataColumn colVH in DBVHosts.Columns)
{
try
{
PropertyInfo pi = VH.GetType().GetProperty(colVH.ToString());
pi.SetValue(VH, Convert.ChangeType(rowVH[colVH], pi.PropertyType), null);
//Object collection = pi.GetValue(VH, null);
}
catch (Exception /*ex*/)
{
//Globals.Error.Show("Column: " + colVH.ToString() + "\r\nContent: " + rowVH[colVH].ToString() + "\r\n" + ex.Message);
}
}
// Load Aliases info for each Virtual Host from database.
DataTable DBAliases = Globals.dbConn.GetDataTable("SELECT * FROM Aliases WHERE VHostID = " + rowVH["VHostID"].ToString());
foreach (DataRow rowAl in DBAliases.Rows)
{
Aliases Alias = new Aliases();
foreach (DataColumn colAl in DBAliases.Columns)
{
try
{
PropertyInfo pi = Alias.GetType().GetProperty(colAl.ToString());
pi.SetValue(Alias, Convert.ChangeType(rowAl[colAl], pi.PropertyType), null);
}
catch (Exception)
{
}
}
VH.Alias.Add(Alias);
}
// Load Directories info for each Virtual Host from database.
DataTable DBDirectories = Globals.dbConn.GetDataTable("SELECT * FROM Directories WHERE VHostID = " + rowVH["VHostID"].ToString());
foreach (DataRow rowDir in DBDirectories.Rows)
{
Directories Directory = new Directories();
foreach (DataColumn colDir in DBDirectories.Columns)
{
try
{
PropertyInfo pi = Directory.GetType().GetProperty(colDir.ToString());
pi.SetValue(Directory, Convert.ChangeType(rowDir[colDir], pi.PropertyType), null);
}
catch (Exception)
{
}
}
VH.Directory.Add(Directory);
}
Globals.VHosts.Add(VH);
}
}
