public void getCurrentEmpIdAndName(string login, string pass)
        {
            OracleConnection conn = DBUtils.GetDBConnection();


            try
            {
                conn.Open();
                // MessageBox.Show("Open1");
                OracleCommand cmd = new OracleCommand();
                cmd.Connection  = conn;
                cmd.CommandText = "System.cwpack2.getCurrentEmplIdAndName";
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.Add("lgine", OracleDbType.NVarchar2).Value        = Login;
                cmd.Parameters.Add("psde", OracleDbType.NVarchar2).Value         = Password;
                cmd.Parameters.Add("id_rete", OracleDbType.Int64).Direction      = ParameterDirection.Output;
                cmd.Parameters.Add("fioe", OracleDbType.NVarchar2, 50).Direction = ParameterDirection.Output;
                // Выполнить процедуру.
                cmd.ExecuteNonQuery();
                string name = cmd.Parameters["id_rete"].Value.ToString();
                string id   = cmd.Parameters["fioe"].Value.ToString();
                Name1          = id.ToString();
                UserLabel.Text = id.ToString();
                Id             = int.Parse(name);
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error: " + ex);
                MessageBox.Show(ex.StackTrace);
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }
        }
        public int getLastMakers()
        {
            int result = 0;

            OracleConnection conn = DBUtils.GetDBConnection();


            try
            {
                conn.Open();
                // MessageBox.Show("Open1");
                OracleCommand cmd = new OracleCommand();
                cmd.Connection  = conn;
                cmd.CommandText = "System.cwpack2.getLastMakers";
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.Add("idmk", OracleDbType.Int64).Direction = ParameterDirection.Output;

                // Выполнить процедуру.
                cmd.ExecuteNonQuery();
                string ct = cmd.Parameters["idmk"].Value.ToString();
                result = int.Parse(ct.ToString());
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error: " + ex);
                MessageBox.Show(ex.StackTrace);
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }


            return(result);
        }