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

namespace FrameworkDAL.Query.Template
{
    public static class TemplateQB
    {
        public const string GET_TEMPLATE = @"SELECT
                            T.TEMPLATEID AS TemplateId,
                            T.TEMPLATECODE AS TemplateCode,
                            T.TEMPLATENAME AS TemplateName,
                            T.REMARKS AS TemplateRemarks,
                            T.SORTORDER AS TemplateSortOrder,
                            T.STATUS AS TemplateStatus,
                            T.VERSION AS TemplateVersion,
                            T.SOURCETYPE AS TemplateSourceType,
                            T.CREATEDBYID AS TemplateCreatedById,
                            T.CREATEDON AS TemplateCreatedOn,
                            T.MODIFIEDBYID AS TemplateModifiedById,
                            T.MODIFIEDON AS TemplateModifiedOn
                            FROM MTEMPLATE T
                            WHERE T.TEMPLATEID = @templateid;
                            ";

        public const string GET_SELECTLIST_TEMPLATE = @"SELECT
                            T.TEMPLATEID AS Id,
                            T.TEMPLATECODE AS Code,
                            T.TEMPLATENAME AS Name
                            FROM MTEMPLATE T
                            WHERE T.STATUS <> 2
                            ORDER BY T.SORTORDER, T.TEMPLATECODE;
                            ";

        public const string SAVE_TEMPLATE = @"INSERT
                            INTO MTEMPLATE (
                                 TEMPLATEID,
                                 TEMPLATECODE,
                                 TEMPLATENAME,
                                 REMARKS,
                                 SORTORDER,
                                 STATUS,
                                 VERSION,
                                 SOURCETYPE,
                                 CREATEDBYID,
                                 CREATEDON,
                                 MODIFIEDBYID,
                                 MODIFIEDON
                            ) VALUES (
                                 @TemplateId,
                                 @TemplateCode,
                                 @TemplateName,
                                 @TemplateRemarks,
                                 @TemplateSortOrder,
                                 @TemplateStatus,
                                 @TemplateVersion,
                                 @TemplateSourceType,
                                 @TemplateCreatedById,
                                 @TemplateCreatedOn,
                                 @TemplateModifiedById,
                                 @TemplateModifiedOn
                            );
                            ";

        public const string UPDATE_TEMPLATE = @"UPDATE 
                            MTEMPLATE SET
                            TEMPLATECODE = @TemplateCode,
                            TEMPLATENAME = @TemplateName,
                            REMARKS = @TemplateRemarks,
                            SORTORDER = @TemplateSortOrder,
                            STATUS = @TemplateStatus,
                            VERSION = @TemplateVersion,
                            SOURCETYPE = @TemplateSourceType,
                            MODIFIEDBYID = @TemplateModifiedById,
                            MODIFIEDON = @TemplateModifiedOn
                            WHERE TEMPLATEID = @TemplateId;
                            ";

        public const string DELETE_TEMPLATE = @"DELETE 
                            FROM MTEMPLATE
                            WHERE TEMPLATEID = @templateid;
                            ";
    }
}