private void insertItem_Click(object sender, EventArgs e)
        {
            dbConnection.Open();

            //TUObjectDTO tuObjectData = new TUObjectDTO();
            int classId = System.Convert.ToInt32(((ToolStripMenuItem)sender).Tag);

            dbCommand.CommandText = "Select FormName From Classes_ Where ClassId = " + classId;
            string className = (string)dbCommand.ExecuteScalar();

            TUObjects tuObject;
            Type t = Type.GetType(DefinedConstants.logicLeyerNameSpace + "." + className + ", " + DefinedConstants.logicLeyerNameSpace);

            tuObject = (TUObjects)Activator.CreateInstance(t, dbConnection, dbServer);

            TUObjectsDTO tuObjectData;
            Type tDTO = Type.GetType(DefinedConstants.dataLeyerNameSpace + "." + className + "DTO, " + DefinedConstants.dataLeyerNameSpace);

            tuObjectData = (TUObjectsDTO)Activator.CreateInstance(tDTO);

            tuObjectData.ClassId = classId;
            tuObjectData.Major = ((TreeNodeData)clickNode.Tag).Id;

            //showing dialog

            ViewDataClient editDialog = new ViewDataClient(tuObject, tuObjectData, DBAction.Insert);
            if (editDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                dbCommand.CommandText = "Select Count(Id) From TUObjects Where Major = " + ((TreeNodeData)clickNode.Tag).Id;
                int count = (int)dbCommand.ExecuteScalar();

                dbCommand.CommandText = "Select Max(Id) From TUObjects";
                int tmpId = (int)dbCommand.ExecuteScalar();

                //tree modification
                if (((TreeNodeData)clickNode.Tag).WasOpened)
                {
                    string connectionStr = ((TreeNodeData)clickNode.Tag).ConnectionStringName;
                    TreeNode tmp = new TreeNode(tuObjectData.Name);
                    TreeNodeData cls = new TreeNodeData(tmpId, false, connectionStr);
                    tmp.Tag = cls;
                    tmp.ContextMenuStrip = clickNode.ContextMenuStrip;

                    clickNode.Nodes.Add(tmp);
                }
                else if (count == 1)
                {
                    clickNode.Nodes.Add("Virtual Node");
                }
            }

            dbConnection.Close();
        }
        private void editToolStripMenuItem_Click(object sender, EventArgs e)
        {
            //string connectionStringName = ((TreeNodeData)(clickNode.Tag)).ConnectionStringName;
            //string providerName = ConfigurationManager.ConnectionStrings[connectionStringName].ProviderName;

            //switch (providerName)
            //{
            //    case "System.Data.SqlClient":
            //        {
            //            dbConnection = sqlConnection;
            //            dbCommand = sqlCommand;

            //            dbConnectionDaughter = sqlConnectionDaughter;
            //            dbCommandDaughter = sqlCommandDaughter;

            //            break;
            //        }
            //    case "FirebirdSql.Data.FirebirdClient":
            //        {
            //            dbConnection = fbConnection;
            //            dbCommand = fbCommand;

            //            dbConnectionDaughter = fbConnectionDaughter;
            //            dbCommandDaughter = fbCommandDaughter;

            //            break;
            //        }
            //    default:
            //        {
            //            throw new Exception("Bad  name of current connection string");
            //        }
            //}

            dbConnection.Open();

            TUObjectsDTO tuObjectData = new TUObjectsDTO()
            {
                Id = ((TreeNodeData)(clickNode.Tag)).Id

            };

            dbCommand.CommandText = "Select ClassId From TUObjects Where Id = " + tuObjectData.Id;
            int classId = (int)dbCommand.ExecuteScalar();

            dbCommand.CommandText = "Select FormName From Classes_ Where ClassId = " + classId;
            string className = (string)dbCommand.ExecuteScalar();

            TUObjects tuObject;
            Type t = Type.GetType(DefinedConstants.logicLeyerNameSpace+ "." + className+", "+DefinedConstants.logicLeyerNameSpace);

            tuObject = (TUObjects)Activator.CreateInstance(t, dbConnection, dbServer);

            //showing dialog

            ViewDataClient editDialog = new ViewDataClient(tuObject, tuObjectData, DBAction.Edit);
            if (editDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                clickNode.Text = editDialog.TuObjectName;
            }

            dbConnection.Close();
        }