private void ConnectToDatabase() { cs.LoadConnectionConfig(); if (con != null && con.State == System.Data.ConnectionState.Open) { foreach (Form form in this.MdiChildren) { form.Close(); form.Dispose(); } con.Close(); } if (!cs.IsEmpty()) { con = new NpgsqlConnection(cs.GetConnectionString()); try { con.Open(); ownersService = new OwnersService(con); SetCurrentOwner(ownersService.GetDefaultOwner()); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error"); } } SetMenuChoices(); }
public static string GetConnectionString() { ConnectionConfiguration connectionConfiguration = new ConnectionConfiguration(); connectionConfiguration.LoadConnectionConfig(); connectionConfiguration.Database = "GTSport_Test"; /* * connectionConfiguration.Host = ""; * connectionConfiguration.Port = ""; * connectionConfiguration.UserName = ""; * connectionConfiguration.Password = ToSecureString(""); * connectionConfiguration.SaveConnectionConfig(); */ return(connectionConfiguration.GetConnectionString()); }