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

namespace MMDAL.Query.GradeStandardCategory
{
    public static class GradeStandardCategoryQB
    {
        public const string GET_GRADESTANDARDCATEGORY = @"SELECT
                            GSC.GRADESTANDARDCATEGORYID AS GradeStandardCategoryId,
                            GSC.GRADESTANDARDID AS GradeStandardId,
                            GS.GRADESTANDARDCODE AS GradeStandardCode,
                            GS.GRADESTANDARDNAME AS GradeStandardName,
                            GSC.CATEGORYID AS CategoryId,
                            GSC.PARAMETERSETID AS ParameterSetId,
                            PS.PARAMETERSETCODE AS ParameterSetCode,
                            PS.PARAMETERSETNAME AS ParameterSetName,
                            GSC.SORTORDER AS GradeStandardCategorySortOrder,
                            GSC.STATUS AS GradeStandardCategoryStatus,
                            GSC.VERSION AS GradeStandardCategoryVersion,
                            GSC.CREATEDBYID AS GradeStandardCategoryCreatedById,
                            GSC.CREATEDON AS GradeStandardCategoryCreatedOn,
                            GSC.MODIFIEDBYID AS GradeStandardCategoryModifiedById,
                            GSC.MODIFIEDON AS GradeStandardCategoryModifiedOn,
                            GSC.SOURCETYPE AS GradeStandardCategorySourceType
                            FROM MGRADESTANDARDCATEGORY GSC
                            LEFT JOIN MGRADESTANDARD GS ON GSC.GRADESTANDARDID = GS.GRADESTANDARDID
                            LEFT JOIN MPARAMETERSET PS ON GSC.PARAMETERSETID = PS.PARAMETERSETID
                            WHERE GSC.GRADESTANDARDCATEGORYID = @gradestandardcategoryid;
                            ";

        public const string SAVE_GRADESTANDARDCATEGORY = @"INSERT 
                            INTO MGRADESTANDARDCATEGORY (
                                 GRADESTANDARDID,
                                 CATEGORYID,
                                 PARAMETERSETID,
                                 CREATEDBYID,
                                 CREATEDON,
                                 MODIFIEDBYID,
                                 MODIFIEDON,
                                 SORTORDER,
                                 STATUS,
                                 VERSION,
                                 TENANTID
                            ) VALUES (
                                 @GradeStandardId,
                                 @CategoryId,
                                 @ParameterSetId,
                                 @GradeStandardCategoryCreatedById,
                                 @GradeStandardCategoryCreatedOn,
                                 @GradeStandardCategoryModifiedById,
                                 @GradeStandardCategoryModifiedOn,
                                 @GradeStandardCategorySortOrder,
                                 @GradeStandardCategoryStatus,
                                 @GradeStandardCategoryVersion,
                                 @GradeStandardCategoryTenantId
                            );
                            SELECT CAST(SCOPE_IDENTITY() AS INT);
                            ";

        public const string UPDATE_GRADESTANDARDCATEGORY = @"UPDATE 
                            MGRADESTANDARDCATEGORY SET
                            GRADESTANDARDID = @GradeStandardId,
                            CATEGORYID = @CategoryId,
                            PARAMETERSETID = @ParameterSetId,
                            MODIFIEDBYID = @GradeStandardCategoryModifiedById,
                            MODIFIEDON = @GradeStandardCategoryModifiedOn,
                            SORTORDER = @GradeStandardCategorySortOrder,
                            STATUS = @GradeStandardCategoryStatus,
                            VERSION = @GradeStandardCategoryVersion,
                            TENANTID = @GradeStandardCategoryTenantId
                            WHERE GRADESTANDARDCATEGORYID = @GradeStandardCategoryId;
                            ";
    }
}