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

namespace DMSDAL.Query.Folder
{
    public class FolderQB
    {
        public const string GET_FOLDER = @"SELECT 
                                            SF.SPACEFOLDERID          AS SpaceFolderId,
                                            SF.SPACEFOLDERNAME        AS SpaceFolderName,
                                            SF.SPACEFOLDERDESCRIPTION AS SpaceFolderDescription,
                                            SF.SPACEFOLDERSTATUS      AS SpaceFolderStatus,
                                            SF.PERMISSION             AS Permission,
                                            SF.SORTORDER              AS SortOrder,
                                            SF.STATUS                 AS Status,
                                            SF.VERSION                AS Version,
                                            SF.SOURCETYPE             AS SourceType,
                                            SF.CREATEDBYID            AS FolderCreatedById,
                                            SF.CREATEDON              AS FolderCreatedOn,
                                            SF.MODIFIEDBYID           AS FolderModifiedById,
                                            SF.MODIFIEDON             AS FolderModifiedOn
                                        FROM MSPACEFOLDER SF
                                        WHERE SF.SPACEFOLDERID =@spacefolderid;";

        public const string GET_SELECTLIST_FOLDER = @"";

        public const string SAVE_FOLDER = @"INSERT INTO MSPACEFOLDER 
                                            (
                                                SPACEFOLDERID,
                                                SPACEFOLDERNAME,
                                                SPACEFOLDERDESCRIPTION,
                                                SPACEFOLDERSTATUS,
                                                PERMISSION,
                                                SORTORDER,
                                                STATUS,
                                                VERSION,
                                                SOURCETYPE,
                                                CREATEDBYID,
                                                CREATEDON,
                                                MODIFIEDBYID,
                                                MODIFIEDON
                                            )
                                            VALUES
                                            (
                                                @SpaceFolderId,            
                                                @SpaceFolderName,         
                                                @SpaceFolderDescription,  
                                                @SpaceFolderStatus,       
                                                @Permission,            
                                                @SortOrder,            
                                                @Status,          
                                                @Version,  
                                                @SourceType, 
                                                @FolderCreatedById,        
                                                @FolderCreatedOn,         
                                                @FolderModifiedById,     
                                                @FolderModifiedOn        
                                            );";

        public const string UPDATE_FOLDER = @"UPDATE MSPACEFOLDER 
                                            SET
                                                    SPACEFOLDERNAME = @SpaceFolderName,
                                                    SPACEFOLDERDESCRIPTION = @SpaceFolderDescription,
                                                    SPACEFOLDERSTATUS = @SpaceFolderStatus,
                                                    PERMISSION = @Permission,
                                                    SORTORDER = @SortOrder,
                                                    STATUS = @Status,
                                                    VERSION = @Version,
                                                    SOURCETYPE = @SourceType,
                                                    MODIFIEDBYID = @FolderModifiedById,
                                                    MODIFIEDON = @FolderModifiedOn
                                                WHERE SPACEFOLDERID = @SpaceFolderId";

        public const string DELETE_FOLDER = @"DELETE FROM MSPACEFOLDER
                                            WHERE SPACEFOLDERID = @spacefolderid";
    }
}