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

namespace MMDAL.Query.GradeSpecificationValue
{
    public class GradeSpecificationValueQB
    {
        public const string GET_GRADESPECIFICATIONVALUE = @"SELECT
                                                            GSV.GRADESPECIFICATIONVALUEID  AS GradeSpecificationValueId,
                                                            GSV.GRADESTANDARDCATEGORYID    AS GradeStandardCategoryId,
                                                            GSV.PARAMETERSETDETAILID       AS ParameterSetDetailId,
                                                            GSV.MINVALUE                   AS MinValue,
                                                            GSV.MAXVALUE                   AS MaxValue,
                                                            GSV.NOMINALVALUE               AS NominalValue,
                                                            GSV.TOLERANCE                  AS Tolerance,
                                                            GSV.TEXTVALUE                  AS TextValue,
                                                            GSV.REMARKS                    AS Remarks,
                                                            GSV.CREATEDBYID                AS GradeSpecificationValueCreatedById,
                                                            GSV.CREATEDON                  AS GradeSpecificationValueCreatedOn,
                                                            GSV.MODIFIEDBYID               AS GradeSpecificationValueModifiedById,
                                                            GSV.MODIFIEDON                 AS GradeSpecificationValueModifiedOn,
                                                            GSV.SORTORDER                  AS SortOrder,
                                                            GSV.STATUS                     AS Status,
                                                            GSV.VERSION                    AS Version,
                                                            GSV.SOURCETYPE                 AS SourceType,
                                                            GSV.TENANTID                   AS TenantId
                                                        FROM MGRADESPECIFICATIONVALUE GSV
                                                        LEFT JOIN GradeStandardCategory GSC ON GSV.GRADESTANDARDCATEGORYID = GSC.GRADESTANDARDCATEGORYID
                                                        LEFT JOIN ParameterSetDetail PSD ON GSV.PARAMETERSETDETAILID = PSD.PARAMETERSETDETAILID;";

        public const string SAVE_GRADESPECIFICATIONVALUE = @"INSERT INTO GradeSpecificationValue
                                                            (
                                                                GRADESTANDARDCATEGORYID,
                                                                PARAMETERSETDETAILID,
                                                                MINVALUE,  
                                                                MAXVALUE,
                                                                NOMINALVALUE,
                                                                TOLERANCE,
                                                                TEXTVALUE,  
                                                                REMARKS,
                                                                CREATEDBYID,
                                                                CREATEDON,
                                                                MODIFIEDBYID,
                                                                MODIFIEDON,
                                                                SORTORDER,
                                                                STATUS,
                                                                VERSION
                                                            )
                                                            VALUES
                                                            (
                                                                @GradeStandardCategoryId,
                                                                @ParameterSetDetailId,
                                                                @MinValue,
                                                                @MaxValue,
                                                                @NominalValue,
                                                                @Tolerance,
                                                                @TextValue,
                                                                @Remarks,
                                                                @GradeSpecificationValueCreatedById,
                                                                @GradeSpecificationValueCreatedOn,
                                                                @GradeSpecificationValueModifiedById,
                                                                @GradeSpecificationValueModifiedOn,
                                                                @SortOrder,
                                                                @Status,
                                                                @Version
                                                            );SELECT CAST(SCOPE_IDENTITY() AS INT);";

        public const string UPDATE_GRADESPECIFICATIONVALUE = @"";

        public const string DELETE_GRADESPECIFICATIONVALUE = @"DELETE FROM MGRADESPECIFICATIONVALUE WHERE GRADESPECIFICATIONVALUEID = @GradeSpecificationValueId";

        public const string GET_SELECTLIST_GRADESPECIFICATIONVALUE = @"SELECT GRADESPECIFICATIONVALUEID AS GradeSpecificationValueId, GRADESPECIFICATIONID AS GradeSpecificationId, VALUE AS Value FROM MGRADESPECIFICATIONVALUE WHERE GRADESPECIFICATIONID = @GradeSpecificationId";
    }
}