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