public void OpenDbConnection()
        {
            var conn = DbConnectionFactory.CreateDbConnection();

            conn.Open();
        }
        public void CloseDbConnection()
        {
            var conn = DbConnectionFactory.CreateDbConnection();

            conn.Close();
        }