public static Hrac selectHracById(string id)
        {

            Hrac hrac_ret = new Hrac();

            if (HracIdentityMapper.existP(id) == true)
            {
                hrac_ret = HracIdentityMapper.loadP(id);
                return hrac_ret;
            }
            else
            {
                conn = new DataL.Database();
                conn.Connect();

                OracleCommand comm = conn.CreateCommand("select * from hrac where id_hrac='" + id + "'");
                OracleDataReader reader = conn.Select(comm);

                reader.Read();

                hrac_ret.name = (reader.GetString(0));
                hrac_ret.surname = (reader.GetString(1));
                hrac_ret.id = (reader.GetString(2));
                hrac_ret.points = (0);
                reader.Close();
                HracIdentityMapper.addP(hrac_ret);
                return hrac_ret;
            }

        }