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

namespace WiDAL.Query.Wi
{
    internal class WiSkillRequirementQB
    {
        public const string GET_BY_ID = @"SELECT 
                                            WSR.WISKILLREQUIREMENTID AS WiSkillRequirementId,
                                            WSR.WIID                AS WiId,
                                            WSR.SKILLID             AS SkillId,
                                            S.SKILLNAME             AS SkillName,
                                            WSR.MINLEVELNO          AS MinLevelNo,
                                            WSR.ENFORCEMENT         AS Enforcement,
                                            WSR.ISMANDATORY         AS IsMandatory,
                                            WSR.REMARKS             AS Remarks
                                        FROM WI.MWISKILLREQUIREMENT WSR
                                        LEFT JOIN DBO.MSKILL S 
                                            ON S.SKILLID = WSR.SKILLID
                                        WHERE WRS.WISKILLREQUIREMENTID = @wiskillrequirementid;";

        public const string SAVE_WISKILLREQUIREMENT = @"INSERT INTO WI.MWISKILLREQUIREMENT
                                                        (
                                                            WISKILLREQUIREMENTID,
                                                            WIID,
                                                            SKILLID,
                                                            MINLEVELNO,
                                                            ENFORCEMENT,
                                                            ISMANDATORY,
                                                            REMARKS
                                                        )
                                                        VALUES
                                                        (
                                                            @WiSkillRequirementId,
                                                            @WiId,
                                                            @SkillId,
                                                            @MinLevelNo,
                                                            @Enforcement,
                                                            @IsMandatory,
                                                            @Remarks
                                                        );";

        public const string UPDATE_WISKILLREQUIREMENT = @"UPDATE WI.MWISKILLREQUIREMENT
                                                        SET
                                                            WIID         = @WiId,
                                                            SKILLID      = @SkillId,
                                                            MINLEVELNO   = @MinLevelNo,
                                                            ENFORCEMENT  = @Enforcement,
                                                            ISMANDATORY  = @IsMandatory,
                                                            REMARKS      = @Remarks
                                                        WHERE
                                                            WISKILLREQUIREMENTID = @WiSkillRequirementId;";

        public const string DELETE_WISKILLREQUIREMENT = @"DELETE FROM WI.MWISKILLREQUIREMENT
                                                         WHERE WISKILLREQUIREMENTID = @wiskillrequirementid;";

        public const string GET_SELECTLIST_WISKILLREQUIREMENT = @"";
    }
}