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

namespace FrameworkDAL.Query.EntityAddOnSet
{
    public static class EntityAddOnSetQB
    {
        public const string GET_ENTITYADDONSET = @"SELECT
                            EA.ENTITYID AS EntityId,
                            E.ENTITYCODE AS EntityCode,
                            E.ENTITYNAME AS EntityName,
                            EA.PARAMETERSETID AS ParameterSetId,
                            P.PARAMETERSETCODE AS ParameterSetCode,
                            P.PARAMETERSETNAME AS ParameterSetName
                            FROM MENTITYADDONSET EA
                            LEFT JOIN MENTITY E ON EA.ENTITYID = E.ENTITYID
                            LEFT JOIN MPARAMETERSET P ON EA.PARAMETERSETID = P.PARAMETERSETID
                            WHERE EA.ENTITYID = @entityid;
                            ";

        public const string SAVE_ENTITYADDONSET = @"INSERT 
                            INTO MENTITYADDONSET (
                                 ENTITYID,
                                 PARAMETERSETID
                            ) VALUES (
                                 @EntityId,
                                 @ParameterSetId
                            );
                            ";

        public const string DELETE_ENTITYADDONSET = @"DELETE 
                            FROM MENTITYADDONSET
                            WHERE ENTITYID = @entityid;
                            ";
    }
}