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

namespace MMDAL.Query.GradeStandard
{
    public static class GradeStandardQB
    {
        public const string GET_GRADESTANDARD = @"SELECT
                            GS.GRADESTANDARDID AS GradeStandardId,
                            GS.GRADESTANDARDCODE AS GradeStandardCode,
                            GS.GRADESTANDARDNAME AS GradeStandardName,
                            GS.GRADEID AS GradeId,
                            PS.PARAMETERSETCODE AS GradeCode,
                            PS.PARAMETERSETNAME AS GradeName,
                            GS.ISDEFAULT AS GradeStandardIsDefault,
                            GS.REMARKS AS GradeStandardRemarks,
                            GS.SORTORDER AS GradeStandardSortOrder,
                            GS.STATUS AS GradeStandardStatus,
                            GS.VERSION AS GradeStandardVersion,
                            GS.CREATEDBYID AS GradeStandardCreatedById,
                            GS.CREATEDON AS GradeStandardCreatedOn,
                            GS.MODIFIEDBYID AS GradeStandardModifiedById,
                            GS.MODIFIEDON AS GradeStandardModifiedOn,
                            GS.SOURCETYPE AS GradeStandardSourceType,
                            GS.TENANTID AS GradeStandardTenantId
                            FROM MGRADESTANDARD GS
                            LEFT JOIN MPARAMETERSET PS ON GS.GRADEID = PS.PARAMETERSETID
                            WHERE GS.GRADESTANDARDID = @gradestandardid;
                            ";

        public const string SAVE_GRADESTANDARD = @"INSERT 
                            INTO MGRADESTANDARD (
                                 GRADEID,
                                 GRADESTANDARDCODE,
                                 GRADESTANDARDNAME,
                                 ISDEFAULT,
                                 REMARKS,
                                 CREATEDBYID,
                                 CREATEDON,
                                 MODIFIEDBYID,
                                 MODIFIEDON,
                                 SORTORDER,
                                 STATUS,
                                 VERSION,
                                 TENANTID
                            ) VALUES (
                                 @GradeId,
                                 @GradeStandardCode,
                                 @GradeStandardName,
                                 @GradeStandardIsDefault,
                                 @GradeStandardRemarks,
                                 @GradeStandardCreatedById,
                                 @GradeStandardCreatedOn,
                                 @GradeStandardModifiedById,
                                 @GradeStandardModifiedOn,
                                 @GradeStandardSortOrder,
                                 @GradeStandardStatus,
                                 @GradeStandardVersion,
                                 @GradeStandardTenantId
                            );
                            SELECT CAST(SCOPE_IDENTITY() AS INT);
                            ";

        public const string UPDATE_GRADESTANDARD = @"UPDATE 
                            MGRADESTANDARD SET
                            GRADEID = @GradeId,
                            GRADESTANDARDCODE = @GradeStandardCode,
                            GRADESTANDARDNAME = @GradeStandardName,
                            ISDEFAULT = @GradeStandardIsDefault,
                            REMARKS = @GradeStandardRemarks,
                            MODIFIEDBYID = @GradeStandardModifiedById,
                            MODIFIEDON = @GradeStandardModifiedOn,
                            SORTORDER = @GradeStandardSortOrder,
                            STATUS = @GradeStandardStatus,
                            VERSION = @GradeStandardVersion,
                            TENANTID = @GradeStandardTenantId
                            WHERE GRADESTANDARDID = @GradeStandardId;
                            ";
    }
}