using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using FrameworkDAL.CustomCode.Parameter;
using FrameworkDAL.Query.Parameter;

namespace FrameworkDAL.Query.Parameter
{
    public class ParameterQB
    {
        public const string GET_PARAMETER = @"SELECT
                                            PARAMETERID AS ParameterId,
                                            PARAMETERCODE AS ParameterCode,
                                            PARAMETERNAME AS ParameterName,
                                            PARAMETERDATATYPE AS ParameterDataType,
                                            PARAMETERDATASIZE AS ParameterDataSize,
                                            UOMID AS ParameterUOMId,
                                            MINVALUE AS ParameterMinValue,
                                            MAXVALUE AS ParameterMaxValue,
                                            TYPEOFINFO AS ParameterTypeOfInfo,
                                            LOVTYPEID AS LovTypeId,
                                            ISFORMULAFIELD AS ParameterIsFormulaField,
                                            REMARKS AS ParameterRemarks,
                                            FIELDMIN AS ParameterFieldMin,
                                            FIELDMAX AS ParameterFieldMax,
                                            ISCRITICAL AS ParameterIsCritical,
                                            SORTORDER AS ParameterSortOrder,
                                            STATUS AS ParameterStatus,
                                            VERSION AS ParameterVersion,
                                            SOURCETYPE AS ParameterSourceType,
                                            CREATEDBYID AS ParameterCreatedById,
                                            CREATEDON AS ParameterCreatedOn,
                                            MODIFIEDBYID AS ParameterModifiedById,
                                            MODIFIEDON AS ParameterModifiedOn,
                                            TENANTID AS ParameterTenantId,
                                            CONSOLIDATIONTYPE AS ParameterConsolidationType
                                            FROM MPARAMETER P
                                            WHERE P.PARAMETERID = @parameterid;";


        public const string GET_SELECTLIST_PARAMETER = @"SELECT
                                                        P.PARAMETERID    AS Id,
                                                        P.PARAMETERCODE  AS Code,
                                                        P.PARAMETERNAME  AS Name,
                                                        P.PARAMETERDATATYPE       AS DataType,
                                                        P.PARAMETERDATASIZE       AS DataSize,
                                                        P.TYPEOFINFO     AS TypeOfInfo
                                                    FROM dbo.MPARAMETER P;";


        public const string SAVE_PARAMETER = @"INSERT INTO MPARAMETER
                                                        (
                                                            PARAMETERID,
                                                            PARAMETERCODE,
                                                            PARAMETERNAME,
                                                            PARAMETERDATATYPE,
                                                            PARAMETERDATASIZE,
                                                            UOMID,
                                                            MINVALUE,
                                                            MAXVALUE,
                                                            TYPEOFINFO,
                                                            LOVTYPEID,
                                                            ISFORMULAFIELD,
                                                            REMARKS,
                                                            FIELDMIN,
                                                            FIELDMAX,
                                                            ISCRITICAL,
                                                            SORTORDER,
                                                            STATUS,
                                                            VERSION,
                                                            SOURCETYPE,
                                                            CREATEDBYID,
                                                            CREATEDON,
                                                            MODIFIEDBYID,
                                                            MODIFIEDON,
                                                            TENANTID,
                                                            CONSOLIDATIONTYPE
                                                        )
                                                        VALUES
                                                        (
                                                            @ParameterId,
                                                            @ParameterCode,
                                                            @ParameterName,
                                                            @ParameterDataType,
                                                            @ParameterDataSize,
                                                            @ParameterUOMId,
                                                            @ParameterMinValue,
                                                            @ParameterMaxValue,
                                                            @ParameterTypeOfInfo,
                                                            @LovTypeId,
                                                            @ParameterIsFormulaField,
                                                            @ParameterRemarks,
                                                            @ParameterFieldMin,
                                                            @ParameterFieldMax,
                                                            @ParameterIsCritical,
                                                            @ParameterSortOrder,
                                                            @ParameterStatus,
                                                            @ParameterVersion,
                                                            @ParameterSourceType,
                                                            @ParameterCreatedById,
                                                            @ParameterCreatedOn,
                                                            @ParameterModifiedById,
                                                            @ParameterModifiedOn,
                                                            @ParameterTenantId,
                                                            @ParameterConsolidationType
                                                        );";

        public const string UPDATE_PARAMETER = @"UPDATE MPARAMETER
                                            SET
                                            PARAMETERCODE = @ParameterCode,
                                            PARAMETERNAME = @ParameterName,
                                            PARAMETERDATATYPE = @ParameterDataType,
                                            PARAMETERDATASIZE = @ParameterDataSize,
                                            UOMID = @ParameterUOMId,
                                            MINVALUE = @ParameterMinValue,
                                            MAXVALUE = @ParameterMaxValue,
                                            TYPEOFINFO = @ParameterTypeOfInfo,
                                            LOVTYPEID = @LovTypeId,
                                            ISFORMULAFIELD = @ParameterIsFormulaField,
                                            REMARKS = @ParameterRemarks,
                                            FIELDMIN = @ParameterFieldMin,
                                            FIELDMAX = @ParameterFieldMax,
                                            ISCRITICAL = @ParameterIsCritical,
                                            SORTORDER = @ParameterSortOrder,
                                            STATUS = @ParameterStatus,
                                            VERSION = @ParameterVersion,
                                            SOURCETYPE = @ParameterSourceType,
                                            CREATEDBYID = @ParameterCreatedById,
                                            CREATEDON = @ParameterCreatedOn,
                                            MODIFIEDBYID = @ParameterModifiedById,
                                            MODIFIEDON = @ParameterModifiedOn,
                                            TENANTID = @ParameterTenantId,
                                            CONSOLIDATIONTYPE = @ParameterConsolidationType
                                        WHERE PARAMETERID = @ParameterId;";


        public const string DELETE_PARAMETER = @"DELETE FROM MPARAMETER
                                        WHERE PARAMETERID = @ParameterId;";


    }
}