using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace MMDAL.Query.CycleClass
{
    public class CycleClassQB
    {
        public const string GET_CYCLECLASS = @"SELECT
                                                    CC.CYCLECLASSID          AS CycleClassId,
                                                    CC.CYCLECLASS            AS CycleClassCycleClasso,
                                                    CC.DESCRIPTION           AS CycleClassDescription,
                                                    CC.INTERVALDAYS          AS CycleClassIntervalDays,
                                                    CC.PERCENTAGEOFITEMS     AS CycleClassPercentageOfItems,
                                                    CC.VERSION               AS CycleClassVersion,
                                                    CC.STATUS                AS CycleClassStatus,
                                                    CC.CREATEDBYID           AS CycleClassCreatedById,
                                                    CC.CREATEDON             AS CycleClassCreatedOn,
                                                    CC.MODIFIEDBYID          AS CycleClassModifiedById,
                                                    CC.MODIFIEDON            AS CycleClassModifiedOn,
                                                    CC.SOURCETYPE            AS CycleClassSourceType,
                                                    CC.SORTORDER             AS CycleClassSortOrder
                                            FROM MCYCLECLASS CC
                                            LEFT JOIN MUSER CU ON CU.USERID = CC.CREATEDBYID
                                            LEFT JOIN MUSER MU ON MU.USERID = CC.MODIFIEDBYID
                                            WHERE CC.CYCLECLASSID = @cycleclassid;";

        public const string SAVE_CYCLECLASS= @"INSERT INTO MCYCLECLASS
                                                (
                                                    CYCLECLASSID,
                                                    CYCLECLASS,
                                                    DESCRIPTION,
                                                    INTERVALDAYS,
                                                    PERCENTAGEOFITEMS,
                                                    VERSION,
                                                    STATUS,
                                                    CREATEDBYID,
                                                    CREATEDON,
                                                    MODIFIEDBYID,
                                                    MODIFIEDON,
                                                    SOURCETYPE,
                                                    SORTORDER
                                                )
                                                VALUES
                                                (
                                                    @CycleClassId,
                                                    @CycleClassCycleClasso,
                                                    @CycleClassDescription,
                                                    @CycleClassIntervalDays,
                                                    @CycleClassPercentageOfItems,
                                                    @CycleClassVersion,
                                                    @CycleClassStatus,
                                                    @CycleClassCreatedById,
                                                    @CycleClassCreatedOn,
                                                    @CycleClassModifiedById,
                                                    @CycleClassModifiedOn,
                                                    @CycleClassSourceType,
                                                    @CycleClassSortOrder
                                                );";

        public const string UPDATE_CYCLECLASS = @"UPDATE MCYCLECLASS
                                                SET
                                                    CYCLECLASS          = @CycleClassCycleClasso,
                                                    DESCRIPTION         = @CycleClassDescription,
                                                    INTERVALDAYS        = @CycleClassIntervalDays,
                                                    PERCENTAGEOFITEMS   = @CycleClassPercentageOfItems,
                                                    VERSION             = @CycleClassVersion,
                                                    STATUS              = @CycleClassStatus,
                                                    MODIFIEDBYID        = @CycleClassModifiedById,
                                                    MODIFIEDON          = @CycleClassModifiedOn,
                                                    SOURCETYPE          = @CycleClassSourceType,
                                                    SORTORDER           = @CycleClassSortOrder
                                                WHERE
                                                    CYCLECLASSID        = @CycleClassId;";

        public const string DELETE_CYCLECLASS = @"DELETE FROM MCYCLECLASS
                                                   WHERE CYCLECLASSID = @cycleclassid;";

        public const string GET_SELECTLIST_CYCLECLASS = @"SELECT
                                                            CYCLECLASSID        AS Id,
                                                            CYCLECLASS          AS CycleClasso,
                                                            DESCRIPTION         AS Description
                                                        FROM MCYCLECLASS;";

    }
}