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); } }