public void OpenCloseDataBase(bool flOpen)
{
if (databaseConnection == null)
{
return;
}
databaseConnectionState = enumDatabaseConnectionsState.Open;
try
{
if (flOpen == true)
{
databaseConnection.Open();
}
else
{
databaseConnection.Close();
}
}
catch
{
databaseConnectionState = enumDatabaseConnectionsState.Close;
}
if (databaseConnection.State == ConnectionState.Closed)
{
databaseConnectionState = enumDatabaseConnectionsState.Close;
}
}
public ClassSQLDatabase()
{
string strProjectName = System.Reflection.Assembly.GetEntryAssembly().GetName().Name;
// Путь к .exe
string strBaseDirectory = AppDomain.CurrentDomain.BaseDirectory;
string connetionString = null;
string s = strBaseDirectory + strProjectName + ".ini";
ClassIniFiles classIniFiles = new ClassIniFiles(@s);
String inStrPath = classIniFiles.ReadString("Common", "DataBase", "");
connetionString = inStrPath;
databaseConnection = new SqlConnection(connetionString);
databaseConnectionState = enumDatabaseConnectionsState.Close;
}
