/*

* Copyright (c) 2006 Nokia Corporation and/or its subsidiary(-ies).

* All rights reserved.

* This component and the accompanying materials are made available

* under the terms of "Eclipse Public License v1.0"

* which accompanies this distribution, and is available

* at the URL "http://www.eclipse.org/legal/epl-v10.html".

*

* Initial Contributors:

* Nokia Corporation - initial contribution.

*

* Contributors:

*

* Description:  The class MPXDbUtil which contains utilities functions

*

*/

#ifndef MPXDBUTIL_H

#define MPXDBUTIL_H

// INCLUDES

#include <mpxpodcastdefs.h> // Podcast specific

// FORWARD DECLARATIONS

class CMPXMedia;

class CMPXMediaArray;

class RSqlStatement;

// CLASS DECLARATION

/**

* This static class contains utilities functions used by Podcast Collection

*

* @lib mpxpodcastdbplugin.lib

*/

class MPXDbUtil

    {

    public:

        /**

        * Create a media object with title, podcast type, podcast category

        * and ID then append it to the media array

        * @param aArray media array

        * @param aTitle title

        * @param aType attribute type

        * @param aCat attribute category

        * @param aPodcastType attribute podcast type

        * @param aPodcastCat attribute podcast category

        * @param aId unique ID

        * @param aNonPermissibleActions bitmask specifying the non-permissible

        *       actions for the entry

        */

        static void AppendMediaL(CMPXMediaArray& aArray, const TDesC& aTitle,

            TMPXGeneralType aType, TMPXGeneralCategory aCat,

            TMPXPodcastType aPodcastType, TMPXPodcastCategory aPodcastCat,

            TMPXItemId aId = 0, TInt aNonPermissibleActions = 0);

        /**

        * Returns the Podcast field name for a specified category

        * @param aCategory identifies the category

        * @return corresponding field name

        */

        static TPtrC PodcastFieldNameForCategoryL(TMPXGeneralCategory aCategory);

        /**

        * Returns today's date (no hour, minutes, seconds)

        * @return date value

        */

        static TTime Today();

        /**

        * Returns this month' start date (no hour, minutes, seconds)

        * @return date value

        */

        static TTime MonthStart();

        /**

        * Returns the index of the current day in week (0-6)

        * @return index value

        */

        static TInt DayNoInWeek();

        /**

        * Returns the table name for a specified category

        * @param aCategory identifies the category

        * @return corresponding table name

        */

        static TPtrC TableNameForCategoryL(TMPXGeneralCategory aCategory);

    };

#endif // MPXDBUTIL_H

// End of File