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

namespace FrameworkDAL.Query.Role
{
    public static class RoleQB
    {

        public const string GET_SELECTLIST_ROLE = @"SELECT 
                                        R.ROLEID           AS RoleId,
                                        R.ROLECODE         AS RoleCode,
                                        R.ROLENAME         AS RoleName
                                        FROM MROLE R";



        public const string GET_ROLE = @"SELECT 
                                        R.ROLEID           AS RoleId,
                                        R.ROLECODE         AS RoleCode,
                                        R.ROLENAME         AS RoleName,
                                        R.REMARKS          AS RoleRemarks,
                                        R.SORTORDER        AS RoleSortOrder,
                                        R.STATUS           AS RoleStatus,
                                        R.VERSION          AS RoleVersion,
                                        R.SOURCETYPE       AS RoleSourceType,
                                        R.CREATEDBYID      AS RoleCreatedById,
                                        R.CREATEDON        AS RoleCreatedOn,
                                        R.MODIFIEDBYID     AS RoleModifiedById,
                                        R.MODIFIEDON       AS RoleModifiedOn,
                                        R.TENANTID         AS TenantId
                                    FROM MROLE R
                                    WHERE R.ROLEID = @RoleId;";

        public const string SAVE_ROLE = @"INSERT INTO MROLE (
                                            ROLEID,
                                            ROLECODE,
                                            ROLENAME,
                                            REMARKS,
                                            SORTORDER,
                                            STATUS,
                                            VERSION,
                                            SOURCETYPE,
                                            CREATEDBYID,
                                            CREATEDON,
                                            MODIFIEDBYID,
                                            MODIFIEDON,
                                            TENANTID
                                        )
                                        VALUES (
                                            @RoleId,
                                            @RoleCode,
                                            @RoleName,
                                            @RoleRemarks,
                                            @RoleSortOrder,
                                            @RoleStatus,
                                            @RoleVersion,
                                            @RoleSourceType,
                                            @RoleCreatedById,
                                            @RoleCreatedOn,
                                            @RoleModifiedById,
                                            @RoleModifiedOn,
                                            @TenantId
                                        );
                                        ";

        public const string UPDATE_ROLE = @"
                                    UPDATE MROLE
                                    SET
                                        ROLECODE = @RoleCode,
                                        ROLENAME = @RoleName,
                                        REMARKS = @RoleRemarks,
                                        SORTORDER = @RoleSortOrder,
                                        STATUS = @RoleStatus,
                                        VERSION = @RoleVersion,
                                        SOURCETYPE = @RoleSourceType,
                                        MODIFIEDBYID = @RoleModifiedById,
                                        MODIFIEDON = @RoleModifiedOn,
                                        TENANTID = @TenantId
                                    WHERE
                                        ROLEID = @RoleId;
                                        ";

        public const string DELETE_ROLE = @"DELETE FROM MROLE
                                            WHERE ROLEID = @RoleId;";

    }
}