public void SetSQlData(string stringConnection, StorageDiscriptionEvent test)
        {
            SqlConnection conn = new SqlConnection(stringConnection);
            conn.Open();
            Logger logger = LogManager.GetCurrentClassLogger();
            logger.Info("Inside");

            string strInsert = @"insert into Person (Age_Limit,Location_Event,Person,Access_Level,Discription_Events,Time_Begin,Time_End)
            values('@_Age_Limit','@_Location_Event','@_Person','@_Access_Level','@_Discription_Events','@_Time_Begin','@_Time_End')";
            SqlCommand cmd = new SqlCommand(strInsert, conn);
            cmd.Parameters.AddWithValue("@_Age_Limit", test.Age_Limit);
            cmd.Parameters.AddWithValue("@_Location_Event", test.Location_Event);
            cmd.Parameters.AddWithValue("@_Person", test.Person);
            cmd.Parameters.AddWithValue("@_Access_Level", test.Access_Level);
            cmd.Parameters.AddWithValue("@_Discription_Events", test.Discription_Events);
            cmd.Parameters.AddWithValue("@_Time_Begin", test.Time_Begin);
            cmd.Parameters.AddWithValue("@_Time_End", test.Time_End);
            cmd.ExecuteNonQuery();
            if (conn != null)
            {
                conn.Close();
                conn.Dispose();
            }
            else
            {
                logger.Warn("SQlConnection not close");
            }
        }
        public StorageDiscriptionEvent GetSQlData(string stringConnection, int _Id)
        {
            SqlConnection conn = new SqlConnection(stringConnection);
            conn.Open();
            Logger logger = LogManager.GetCurrentClassLogger();
            logger.Info("Inside");

            string sqlGetCmd = @"select Age_Limit,Location_Event,Person,Access_Level,Discription_Events,Time_Begin,Time_End
            from DiscriptionEvent where IdDiscriptionEvent = @_IdDiscriptionEvent";
            StorageDiscriptionEvent discriptionEvent = new StorageDiscriptionEvent();
            SqlCommand cmd = new SqlCommand(sqlGetCmd, conn);
            cmd.Parameters.AddWithValue("_IdDiscriptionEvent", _Id);
            SqlDataReader rdb = cmd.ExecuteReader();
            rdb.Read();
            discriptionEvent.IdDiscriptionEvent = _Id;
            discriptionEvent.Age_Limit = (int)GetUnoSQlValue(rdb,"Age_Limit");
            discriptionEvent.Location_Event = (int)GetUnoSQlValue(rdb,"Location_Event");
            discriptionEvent.Person = (int)GetUnoSQlValue(rdb,"Person");
            discriptionEvent.Access_Level = (int)GetUnoSQlValue(rdb,"Access_Level");
            discriptionEvent.Discription_Events = (string)GetUnoSQlValue(rdb,"Discription_Events");
            discriptionEvent.Time_Begin = (DateTime)GetUnoSQlValue(rdb,"Time_Begin");
            //discriptionEvent.Time_Begin = rdb.GetDateTime(rdb.GetOrdinal("Time_Begin"));
            discriptionEvent.Time_End = (DateTime)GetUnoSQlValue(rdb,"Time_End");
            if (conn != null)
            {
                conn.Close();
                conn.Dispose();
            }
            else
            {
                logger.Warn("SQlConnection not close");
            }
            if (rdb != null)
            {
                rdb.Close();
            }
            return discriptionEvent;
        }