public Select_DataBase_Form(Form pParentForm,Log_DBConnection my_connection, string sTitle)
{
m_ParentForm = pParentForm;
m_Title = sTitle;
m_SQL_Connection = my_connection;
InitializeComponent();
}
public WriteLog2DB_Form(Log_DBConnection xm_LogDB_con, string xUserName, string xDescription)
{
InitializeComponent();
m_LogDB_con = xm_LogDB_con;
Log_PathFile = LogFile.LogFolder + LogFile.LogFileName;
m_UserName = xUserName;
m_Description = xDescription;
}
public TestConnectionForm(Form xParentForm,Log_DBConnection sqlCon, bool bTimerClose, bool bDataBaseConnection,string sTitle)
{
m_ParentForm = xParentForm;
this.Owner = m_ParentForm;
m_bDataBaseConnection = bDataBaseConnection;
m_Title = sTitle;
m_bTimerClose = bTimerClose;
sqlConn = sqlCon;
InitializeComponent();
m_eStartPositionOfTestConnectionForm = sqlCon.StartPositionOfTestConnectionForm;
}
public CreateDataBase_Form(ref Log_DBConnection con)
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
m_con = con;
//
// TODO: Add any constructor code after InitializeComponent call
//
}
public Log(Log_DBConnection xcon)
{
select = new selection(this);
where = new WHERE(this);
m_con = xcon;
tablename = Log.tablename_const;
myUpdateObjects = UpdateObjects;
o_id.col_name = Log.id.name;
o_id.col_type.m_Type = "int";
o_id.col_type.bPRIMARY_KEY = true;
o_id.col_type.bFOREIGN_KEY = false;
o_id.col_type.bUNIQUE = false;
o_id.col_type.bNULL = false;
Add(o_id);
o_LogFile_id.col_name = Log.LogFile_id.name;
o_LogFile_id.col_type.m_Type = "int";
o_LogFile_id.col_type.bPRIMARY_KEY = false;
o_LogFile_id.col_type.bFOREIGN_KEY = true;
o_LogFile_id.col_type.bUNIQUE = false;
o_LogFile_id.col_type.bNULL = false;
Add(o_LogFile_id);
o_LogTime.col_name = Log.LogTime.name;
o_LogTime.col_type.m_Type = "datetime";
o_LogTime.col_type.bPRIMARY_KEY = false;
o_LogTime.col_type.bFOREIGN_KEY = false;
o_LogTime.col_type.bUNIQUE = false;
o_LogTime.col_type.bNULL = false;
Add(o_LogTime);
o_Log_Type_id.col_name = Log.Log_Type_id.name;
o_Log_Type_id.col_type.m_Type = "int";
o_Log_Type_id.col_type.bPRIMARY_KEY = false;
o_Log_Type_id.col_type.bFOREIGN_KEY = true;
o_Log_Type_id.col_type.bUNIQUE = false;
o_Log_Type_id.col_type.bNULL = false;
Add(o_Log_Type_id);
o_Log_Description_id.col_name = Log.Log_Description_id.name;
o_Log_Description_id.col_type.m_Type = "int";
o_Log_Description_id.col_type.bPRIMARY_KEY = false;
o_Log_Description_id.col_type.bFOREIGN_KEY = true;
o_Log_Description_id.col_type.bUNIQUE = false;
o_Log_Description_id.col_type.bNULL = false;
Add(o_Log_Description_id);
}
public ConnectionDialog(Form parentForm, ConnectionDialog_enum ConnectionConnectionDialog_type, Log_DBConnection con, string sTitle)
{
m_Title = sTitle;
my_ConnectionDialog_enum = ConnectionConnectionDialog_type;
m_ParentForm = parentForm;
InitializeComponent();
this.cmb_ServerName.RecentItemsFolder = con.RecentItemsFolder;
this.cmb_DataBaseName.RecentItemsFolder = con.RecentItemsFolder;
this.cmb_UserName.RecentItemsFolder = con.RecentItemsFolder;
Y[0] = cmb_DataBaseName.Top;
Y[1] = rdb_UseWindowsAuthentication.Top;
Y[2] = rdb_SQL_Server_Authentication.Top;
Y[3] = cmb_UserName.Top;
Y[4] = txt_Password.Top;
m_con = con;
switch (m_con.DBType)
{
case Log_DBConnection.eDBType.MYSQL:
rdb_UseWindowsAuthentication.Enabled = false;
rdb_SQL_Server_Authentication.Enabled = false;
this.radioButton_MicrosoftSQL.Checked = false;
this.radioButton_MySqlServer.Checked = true;
break;
case Log_DBConnection.eDBType.MSSQL:
this.radioButton_MicrosoftSQL.Checked = true;
rdb_UseWindowsAuthentication.Enabled = true;
rdb_SQL_Server_Authentication.Enabled = true;
if (m_con.WindowsAuthentication)
{
rdb_UseWindowsAuthentication.Checked = true;
}
else
{
rdb_SQL_Server_Authentication.Checked = true;
}
break;
}
}
public Connection_Control(Log_DBConnection con)
{
InitializeComponent();
m_con = con;
this.lbl_DataSourceAndDatabase.AutoSize = true;
switch (m_con.DBType)
{
case Log_DBConnection.eDBType.SQLITE:
this.lbl_ServerType.Text = m_con.ConnectionName+":" + lngConn.s_ServerType.s + " = SQLITE";
this.lbl_DataSourceAndDatabase.Text = m_con.DataBase;
break;
case Log_DBConnection.eDBType.MSSQL:
this.lbl_ServerType.Text = m_con.ConnectionName + ":" + lngConn.s_ServerType.s + " = MSSQL";
this.lbl_DataSourceAndDatabase.Text = lngConn.s_Server.s + " = " + m_con.DataSource + ", " + lngConn.s_DataBase.s + " = " + m_con.DataBase;
break;
case Log_DBConnection.eDBType.MYSQL:
this.lbl_ServerType.Text = m_con.ConnectionName + ":" + lngConn.s_ServerType.s + " = MYSQL";
this.lbl_DataSourceAndDatabase.Text = lngConn.s_Server.s + " = " + m_con.DataSource + ", " + lngConn.s_DataBase.s + " = " + m_con.DataBase;
break;
}
this.Width = this.lbl_DataSourceAndDatabase.Left + this.lbl_DataSourceAndDatabase.Width + 10;
}
public LogFile_DataSet_ScalarFunctions(Log_DBConnection xcon)
{
m_con = xcon;
}
public LogFile_DataSet_Procedures(Log_DBConnection xcon)
{
m_con = xcon;
}
public LogFile_Attachment_VIEW(Log_DBConnection xcon)
{
select = new selection(this);
where = new WHERE(this);
m_con = xcon;
tablename = LogFile_Attachment_VIEW.tablename_const;
myUpdateObjects = UpdateObjects;
o_id.col_name = LogFile_Attachment_VIEW.id.name;
o_id.col_type.m_Type = "int";
Add(o_id);
o_LogFile_id.col_name = LogFile_Attachment_VIEW.LogFile_id.name;
o_LogFile_id.col_type.m_Type = "int";
Add(o_LogFile_id);
o_Attachment.col_name = LogFile_Attachment_VIEW.Attachment.name;
o_Attachment.col_type.m_Type = "varbinary";
Add(o_Attachment);
o_Attachment_type.col_name = LogFile_Attachment_VIEW.Attachment_type.name;
o_Attachment_type.col_type.m_Type = "nvarchar";
Add(o_Attachment_type);
o_LogFile_Attachment_Type_id.col_name = LogFile_Attachment_VIEW.LogFile_Attachment_Type_id.name;
o_LogFile_Attachment_Type_id.col_type.m_Type = "int";
Add(o_LogFile_Attachment_Type_id);
}
public LogFile_Attachment(Log_DBConnection xcon)
{
select = new selection(this);
where = new WHERE(this);
m_con = xcon;
tablename = LogFile_Attachment.tablename_const;
myUpdateObjects = UpdateObjects;
o_id.col_name = LogFile_Attachment.id.name;
o_id.col_type.m_Type = "int";
o_id.col_type.bPRIMARY_KEY = true;
o_id.col_type.bFOREIGN_KEY = false;
o_id.col_type.bUNIQUE = false;
o_id.col_type.bNULL = false;
Add(o_id);
o_LogFile_id.col_name = LogFile_Attachment.LogFile_id.name;
o_LogFile_id.col_type.m_Type = "int";
o_LogFile_id.col_type.bPRIMARY_KEY = false;
o_LogFile_id.col_type.bFOREIGN_KEY = true;
o_LogFile_id.col_type.bUNIQUE = false;
o_LogFile_id.col_type.bNULL = false;
Add(o_LogFile_id);
o_LogFile_Attachment_Type_id.col_name = LogFile_Attachment.LogFile_Attachment_Type_id.name;
o_LogFile_Attachment_Type_id.col_type.m_Type = "int";
o_LogFile_Attachment_Type_id.col_type.bPRIMARY_KEY = false;
o_LogFile_Attachment_Type_id.col_type.bFOREIGN_KEY = true;
o_LogFile_Attachment_Type_id.col_type.bUNIQUE = false;
o_LogFile_Attachment_Type_id.col_type.bNULL = false;
Add(o_LogFile_Attachment_Type_id);
o_Attachment.col_name = LogFile_Attachment.Attachment.name;
o_Attachment.col_type.m_Type = "varbinary";
o_Attachment.col_type.bPRIMARY_KEY = false;
o_Attachment.col_type.bFOREIGN_KEY = false;
o_Attachment.col_type.bUNIQUE = false;
o_Attachment.col_type.bNULL = true;
Add(o_Attachment);
o_Description.col_name = LogFile_Attachment.Description.name;
o_Description.col_type.m_Type = "nvarchar";
o_Description.col_type.bPRIMARY_KEY = false;
o_Description.col_type.bFOREIGN_KEY = false;
o_Description.col_type.bUNIQUE = false;
o_Description.col_type.bNULL = true;
Add(o_Description);
}
private static bool CheckTables(Log_DBConnection m_LogDB_con)
{
string Err = null;
LogFile_DataSet.Log_VIEW m_Log_VIEW = new LogFile_DataSet.Log_VIEW(m_LogDB_con);
m_Log_VIEW.Clear();
m_Log_VIEW.select.all(true);
if (m_Log_VIEW.Read(2, ref Err))
{
return true;
}
else
{
return false;
}
}
public sysdiagrams(Log_DBConnection xcon)
{
select = new selection(this);
where = new WHERE(this);
m_con = xcon;
tablename = sysdiagrams.tablename_const;
myUpdateObjects = UpdateObjects;
o_name.col_name = sysdiagrams.name__.name;
o_name.col_type.m_Type = "nvarchar";
o_name.col_type.bPRIMARY_KEY = false;
o_name.col_type.bFOREIGN_KEY = false;
o_name.col_type.bUNIQUE = true;
o_name.col_type.bNULL = false;
Add(o_name);
o_principal_id.col_name = sysdiagrams.principal_id.name;
o_principal_id.col_type.m_Type = "int";
o_principal_id.col_type.bPRIMARY_KEY = false;
o_principal_id.col_type.bFOREIGN_KEY = false;
o_principal_id.col_type.bUNIQUE = true;
o_principal_id.col_type.bNULL = false;
Add(o_principal_id);
o_diagram_id.col_name = sysdiagrams.diagram_id.name;
o_diagram_id.col_type.m_Type = "int";
o_diagram_id.col_type.bPRIMARY_KEY = true;
o_diagram_id.col_type.bFOREIGN_KEY = false;
o_diagram_id.col_type.bUNIQUE = false;
o_diagram_id.col_type.bNULL = false;
Add(o_diagram_id);
o_version.col_name = sysdiagrams.version.name;
o_version.col_type.m_Type = "int";
o_version.col_type.bPRIMARY_KEY = false;
o_version.col_type.bFOREIGN_KEY = false;
o_version.col_type.bUNIQUE = false;
o_version.col_type.bNULL = true;
Add(o_version);
o_definition.col_name = sysdiagrams.definition.name;
o_definition.col_type.m_Type = "varbinary";
o_definition.col_type.bPRIMARY_KEY = false;
o_definition.col_type.bFOREIGN_KEY = false;
o_definition.col_type.bUNIQUE = false;
o_definition.col_type.bNULL = true;
Add(o_definition);
}
public Log_VIEW(Log_DBConnection xcon)
{
select = new selection(this);
where = new WHERE(this);
m_con = xcon;
tablename = Log_VIEW.tablename_const;
myUpdateObjects = UpdateObjects;
o_LogFile_id.col_name = Log_VIEW.LogFile_id.name;
o_LogFile_id.col_type.m_Type = "int";
Add(o_LogFile_id);
o_Log_Time.col_name = Log_VIEW.Log_Time.name;
o_Log_Time.col_type.m_Type = "datetime";
Add(o_Log_Time);
o_Log_TypeName.col_name = Log_VIEW.Log_TypeName.name;
o_Log_TypeName.col_type.m_Type = "nvarchar";
Add(o_Log_TypeName);
o_Log_Type_id.col_name = Log_VIEW.Log_Type_id.name;
o_Log_Type_id.col_type.m_Type = "int";
Add(o_Log_Type_id);
o_Log_Description.col_name = Log_VIEW.Log_Description.name;
o_Log_Description.col_type.m_Type = "nvarchar";
Add(o_Log_Description);
o_Log_Description_id.col_name = Log_VIEW.Log_Description_id.name;
o_Log_Description_id.col_type.m_Type = "int";
Add(o_Log_Description_id);
o_ComputerName.col_name = Log_VIEW.ComputerName.name;
o_ComputerName.col_type.m_Type = "nvarchar";
Add(o_ComputerName);
o_Log_Computer_id.col_name = Log_VIEW.Log_Computer_id.name;
o_Log_Computer_id.col_type.m_Type = "int";
Add(o_Log_Computer_id);
o_UserName.col_name = Log_VIEW.UserName.name;
o_UserName.col_type.m_Type = "nvarchar";
Add(o_UserName);
o_Log_UserName_id.col_name = Log_VIEW.Log_UserName_id.name;
o_Log_UserName_id.col_type.m_Type = "int";
Add(o_Log_UserName_id);
o_Program.col_name = Log_VIEW.Program.name;
o_Program.col_type.m_Type = "nvarchar";
Add(o_Program);
o_Log_Program_id.col_name = Log_VIEW.Log_Program_id.name;
o_Log_Program_id.col_type.m_Type = "int";
Add(o_Log_Program_id);
o_LogFile_Description.col_name = Log_VIEW.LogFile_Description.name;
o_LogFile_Description.col_type.m_Type = "nvarchar";
Add(o_LogFile_Description);
o_LogFile_Description_id.col_name = Log_VIEW.LogFile_Description_id.name;
o_LogFile_Description_id.col_type.m_Type = "int";
Add(o_LogFile_Description_id);
}
public View_AccessR_Form(Log_DBConnection con)
{
m_con = con;
InitializeComponent();
}
public Log_UserName(Log_DBConnection xcon)
{
select = new selection(this);
where = new WHERE(this);
m_con = xcon;
tablename = Log_UserName.tablename_const;
myUpdateObjects = UpdateObjects;
o_id.col_name = Log_UserName.id.name;
o_id.col_type.m_Type = "int";
o_id.col_type.bPRIMARY_KEY = true;
o_id.col_type.bFOREIGN_KEY = false;
o_id.col_type.bUNIQUE = false;
o_id.col_type.bNULL = false;
Add(o_id);
o_UserName.col_name = Log_UserName.UserName.name;
o_UserName.col_type.m_Type = "nvarchar";
o_UserName.col_type.bPRIMARY_KEY = false;
o_UserName.col_type.bFOREIGN_KEY = false;
o_UserName.col_type.bUNIQUE = false;
o_UserName.col_type.bNULL = false;
Add(o_UserName);
}
public CheckConnectionThreadParam(Log_DBConnection xConn, bool bDataBaseConnection)
{
m_bDataBaseConnection = bDataBaseConnection;
m_Conn = xConn;
}
public LogFile(Log_DBConnection xcon)
{
select = new selection(this);
where = new WHERE(this);
m_con = xcon;
tablename = LogFile.tablename_const;
myUpdateObjects = UpdateObjects;
o_id.col_name = LogFile.id.name;
o_id.col_type.m_Type = "int";
o_id.col_type.bPRIMARY_KEY = true;
o_id.col_type.bFOREIGN_KEY = false;
o_id.col_type.bUNIQUE = false;
o_id.col_type.bNULL = false;
Add(o_id);
o_LogFileImportTime.col_name = LogFile.LogFileImportTime.name;
o_LogFileImportTime.col_type.m_Type = "datetime";
o_LogFileImportTime.col_type.bPRIMARY_KEY = false;
o_LogFileImportTime.col_type.bFOREIGN_KEY = false;
o_LogFileImportTime.col_type.bUNIQUE = false;
o_LogFileImportTime.col_type.bNULL = false;
Add(o_LogFileImportTime);
o_Log_Computer_id.col_name = LogFile.Log_Computer_id.name;
o_Log_Computer_id.col_type.m_Type = "int";
o_Log_Computer_id.col_type.bPRIMARY_KEY = false;
o_Log_Computer_id.col_type.bFOREIGN_KEY = true;
o_Log_Computer_id.col_type.bUNIQUE = false;
o_Log_Computer_id.col_type.bNULL = false;
Add(o_Log_Computer_id);
o_Log_UserName_id.col_name = LogFile.Log_UserName_id.name;
o_Log_UserName_id.col_type.m_Type = "int";
o_Log_UserName_id.col_type.bPRIMARY_KEY = false;
o_Log_UserName_id.col_type.bFOREIGN_KEY = true;
o_Log_UserName_id.col_type.bUNIQUE = false;
o_Log_UserName_id.col_type.bNULL = true;
Add(o_Log_UserName_id);
o_Log_Program_id.col_name = LogFile.Log_Program_id.name;
o_Log_Program_id.col_type.m_Type = "int";
o_Log_Program_id.col_type.bPRIMARY_KEY = false;
o_Log_Program_id.col_type.bFOREIGN_KEY = true;
o_Log_Program_id.col_type.bUNIQUE = false;
o_Log_Program_id.col_type.bNULL = false;
Add(o_Log_Program_id);
o_Log_PathFile_id.col_name = LogFile.Log_PathFile_id.name;
o_Log_PathFile_id.col_type.m_Type = "int";
o_Log_PathFile_id.col_type.bPRIMARY_KEY = false;
o_Log_PathFile_id.col_type.bFOREIGN_KEY = true;
o_Log_PathFile_id.col_type.bUNIQUE = false;
o_Log_PathFile_id.col_type.bNULL = false;
Add(o_Log_PathFile_id);
o_LogFile_Description_id.col_name = LogFile.LogFile_Description_id.name;
o_LogFile_Description_id.col_type.m_Type = "int";
o_LogFile_Description_id.col_type.bPRIMARY_KEY = false;
o_LogFile_Description_id.col_type.bFOREIGN_KEY = true;
o_LogFile_Description_id.col_type.bUNIQUE = false;
o_LogFile_Description_id.col_type.bNULL = true;
Add(o_LogFile_Description_id);
}
public SQL_LogTables(Log_DBConnection x_LogDB_con)
{
m_LogDB_con = x_LogDB_con;
}
public Select_DataSource_Form(Log_DBConnection con)
{
m_con = con;
InitializeComponent();
this.lbl_SelectedServer.Text = lngConn.s_Select_Server.s + ":";
}
public static bool Manage_DBConnection(Form ParentForm,string recent_items_folder, bool bChangeConnection)
{
if ((Settings.Log2DB_flags & const_Log2DB_flag_Write2DB_on_exit) > 0)
{
// Check LogDataBaseConnection
if (m_LogDB_con == null)
{
m_LogDB_con = new Log_DBConnection(recent_items_folder);
}
Log_RemoteDB_data_ProgramSettings = new Log_RemoteDB_data(const_inifile_prefix, 1, Log_DBConnection.eDBType.MSSQL, LanguageControl.lngRPM.s_Connection_To_LogTables_defualt_ProgramSettings.s);
return GetConnection(ParentForm, Log_RemoteDB_data_ProgramSettings, bChangeConnection);
}
else
{
return true;
}
}
