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

namespace MMDAL.Query.ItemFeature
{
    public class ItemFeatureQB
    {

        public const string GET_ITEMFEATURE = @"SELECT 
                                                IFTR.ITEMFEATUREID        AS ItemFeatureId,
                                                IFTR.ITEMID               AS ItemId,
                                                I.ITEMNAME                AS ItemName,    
                                                IFTR.SLNO                 AS ItemFeatureSlno,
                                                IFTR.FEATUREDESCRIPTION   AS ItemFeatureFeatureDescription,
                                                IFTR.TENANTID             AS ItemFeatureTenantId
                                            FROM MITEMFEATURE IFTR
                                            INNER JOIN MITEM I ON IFTR.ITEMID = I.ITEMID
                                                WHERE IFTR.ITEMFEATUREID = @itemfeatureid;";

        public const string SAVE_ITEMFEATURE = @"INSERT INTO MITEMFEATURE 
                                                (
                                                    ITEMFEATUREID,
                                                    ITEMID,
                                                    SLNO,
                                                    FEATUREDESCRIPTION,
                                                    TENANTID
                                                )
                                                VALUES 
                                                (
                                                    @ItemFeatureId,
                                                    @ItemId,
                                                    @ItemFeatureSlno,
                                                    @ItemFeatureFeatureDescription,
                                                    @ItemFeatureTenantId
                                                );";

        public const string UPDATE_ITEMFEATURE = @"UPDATE MITEMFEATURE
                                                    SET
                                                        ITEMID = @ItemId,
                                                        SLNO = @ItemFeatureSlno,
                                                        FEATUREDESCRIPTION = @ItemFeatureFeatureDescription,
                                                        TENANTID = @ItemFeatureTenantId
                                                    WHERE 
                                                        ITEMFEATUREID = @ItemFeatureId;";
        
        public const string GET_SELECTLIST_ITEMFEATURE = @"SELECT 
                                                        ITEMFEATUREID   AS ItemFeatureId,
                                                        ITEMID          AS ItemId,
                                                        SLNO            AS ItemFeatureSlno,
                                                        FEATUREDESCRIPTION AS ItemFeatureFeatureDescription
                                                    FROM MITEMFEATURE;";

        public const string DELETE_ITEMFEATURE = @"DELETE FROM MITEMFEATURE
                                                    WHERE ITEMFEATUREID = @itemfeatureid;";
    }
}