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

namespace FrameworkDAL.Query.ProgramAssembly
{
    public static class ProgramAssemblyQB
    {
        public const string GET_PROGRAMASSEMBLY = @"
            SELECT
                A.ASSEMBLYID AS ProgramAssemblyId,
                A.ASSEMBLYNAME AS ProgramAssemblyName,
                A.SECTION AS ProgramAssemblySection,
                A.REMARKS AS ProgramAssemblyRemarks,

                A.MODULEID AS ModuleId,

                A.CREATEDBYID AS ProgramAssemblyCreatedById,
                A.CREATEDON AS ProgramAssemblyCreatedOn,
                UC.USERNAME AS ProgramAssemblyCreatedByName,

                A.MODIFIEDBYID AS ProgramAssemblyModifiedById,
                A.MODIFIEDON AS ProgramAssemblyModifiedOn,
                UM.USERNAME AS ProgramAssemblyModifiedByName,

                A.SORTORDER AS ProgramAssemblySortOrder,
                A.STATUS AS ProgramAssemblyStatus,
                A.VERSION AS ProgramAssemblyVersion,
                A.SOURCETYPE AS ProgramAssemblySourceType
            FROM MPROGRAMASSEMBLY A
            LEFT JOIN MMODULE M ON A.MODULEID = M.MODULEID
            LEFT JOIN MUSER UC ON A.CREATEDBYID = UC.USERID
            LEFT JOIN MUSER UM ON A.MODIFIEDBYID = UM.USERID
            WHERE A.ASSEMBLYID = @programassemblyid;
        ";


        public const string SAVE_PROGRAMASSEMBLY = @"
INSERT INTO MPROGRAMASSEMBLY
(
    ASSEMBLYID,
    ASSEMBLYNAME,
    MODULEID,
    SECTION,
    REMARKS,
    SORTORDER,
    STATUS,
    VERSION,
    SOURCETYPE,
    CREATEDBYID,
    CREATEDON,
    MODIFIEDBYID,
    MODIFIEDON
)
VALUES
(
    @ProgramAssemblyId,
    @ProgramAssemblyName,
    @ModuleId,
    @ProgramAssemblySection,
    @ProgramAssemblyRemarks,
    @ProgramAssemblySortOrder,
    @ProgramAssemblyStatus,
    @ProgramAssemblyVersion,
    @ProgramAssemblySourceType,
    @ProgramAssemblyCreatedById,
    @ProgramAssemblyCreatedOn,
    @ProgramAssemblyModifiedById,
    @ProgramAssemblyModifiedOn
);";


        public const string UPDATE_PROGRAMASSEMBLY = @"
            UPDATE MPROGRAMASSEMBLY
            SET
                ASSEMBLYNAME = @ProgramAssemblyName,
                MODULEID = @ModuleId,
                SECTION = @ProgramAssemblySection,
                REMARKS = @ProgramAssemblyRemarks,
                SORTORDER = @ProgramAssemblySortOrder,
                STATUS = @ProgramAssemblyStatus,
                VERSION = @ProgramAssemblyVersion,
                SOURCETYPE = @ProgramAssemblySourceType,
                MODIFIEDBYID = @ProgramAssemblyModifiedById,
                MODIFIEDON = @ProgramAssemblyModifiedOn
            WHERE ASSEMBLYID = @ProgramAssemblyId;
        ";


        public const string DELETE_PROGRAMASSEMBLY = @"
            DELETE FROM MPROGRAMASSEMBLY
            WHERE ASSEMBLYID = @ProgramAssemblyId;
        ";


        public const string GET_SELECTLIST_PROGRAMASSEMBLY = @"
            SELECT ASSEMBLYID AS Id, ASSEMBLYNAME AS Name
            FROM MPROGRAMASSEMBLY
            WHERE STATUS = 1
            ORDER BY ASSEMBLYNAME;
        ";
    }
}