private void BindConnection() { Localization.LocalizeDataGrid(ref dgConnection, LocalResourceFile); var objConnectionList = default(ArrayList); var objConnectionController = new ConnectionController(); objConnectionList = objConnectionController.ListConnection(PortalId, false, false); // bind dgConnection.DataSource = objConnectionList; dgConnection.DataBind(); }
private string ExportConnection(PortalSettings portalSettings) { var ctrl = new ConnectionController(); var al = ctrl.ListConnection(Convert.ToInt32(portalSettings.PortalId), false, false); var info = default(ConnectionInfo); var s = "<connections>"; for (var i = 0; i <= al.Count - 1; i++) { info = (ConnectionInfo)(al[i]); s += "<connection>"; s += "<id>" + XmlUtils.XMLEncode(info.ConnectionId.ToString()) + "</id>"; s += "<name>" + XmlUtils.XMLEncode(info.ConnectionName) + "</name>"; s += "<string>" + XmlUtils.XMLEncode(info.ConnectionString) + "</string>"; s += "</connection>"; } s += "</connections>"; return(s); }
private int ImportConnection(string connectionName, string connectionString) { var portalSettings = (PortalSettings)(HttpContext.Current.Items["PortalSettings"]); var ctrl = new ConnectionController(); // see if we can find the connection string and return the id var connections = ctrl.ListConnection(Convert.ToInt32(portalSettings.PortalId), false, false); foreach (ConnectionInfo info in connections) { if (info.ConnectionString == connectionString) { return(info.ConnectionId); } } // we'll have to make a new one var connectionId = default(int); connectionId = ctrl.UpdateConnection(Convert.ToInt32(portalSettings.PortalId), -1, connectionName, connectionString); return(connectionId); }