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

namespace MMDAL.Query.PriceCategory
{
    public class PriceCategoryQB
    {
        public const string GET_SELECTLIST_PRICECATEGORY = @"SELECT
                                                            PRICECATEGORYID     AS Id,
                                                            PRICECATEGORYCODE   AS Code,
                                                            PRICECATEGORYNAME   AS Name
                                                        FROM MPRICECATEGORY;";

        public const string GET_PRICECATEGORY = @"SELECT
                                                    PC.PRICECATEGORYID        AS PriceCategoryId,
                                                    PC.PRICECATEGORYCODE      AS PriceCategoryCode,
                                                    PC.PRICECATEGORYNAME      AS PriceCategoryName,
                                                    PC.ISSELECTED             AS PriceCategoryIsSelected,
                                                    PC.SORTORDER              AS PriceCategorySortOrder,
                                                    PC.STATUS                 AS PriceCategoryStatus,
                                                    PC.VERSION                AS PriceCategoryVersion,
                                                    PC.CREATEDBYID            AS PriceCategoryCreatedById,
                                                    PC.CREATEDON              AS PriceCategoryCreatedOn,
                                                    CU.USERNAME               AS PriceCategoryCreatedByName,
                                                    PC.MODIFIEDBYID           AS PriceCategoryModifiedById,
                                                    PC.MODIFIEDON             AS PriceCategoryModifiedOn,
                                                    MU.USERNAME               AS PriceCategoryModifiedByName
                                                FROM MPRICECATEGORY PC
                                                LEFT JOIN MUSER CU ON CU.USERID = PC.CREATEDBYID
                                                LEFT JOIN MUSER MU ON MU.USERID = PC.MODIFIEDBYID
                                                WHERE PC.PRICECATEGORYID = @pricecategoryid;";

        public const string SAVE_PRICECATEGORY = @"INSERT INTO MPRICECATEGORY
                                                    (
                                                        PRICECATEGORYID,
                                                        PRICECATEGORYCODE,
                                                        PRICECATEGORYNAME,
                                                        ISSELECTED,
                                                        SORTORDER,
                                                        STATUS,
                                                        VERSION,
                                                        CREATEDBYID,
                                                        CREATEDON,
                                                        MODIFIEDBYID,
                                                        MODIFIEDON
                                                    )
                                                    VALUES
                                                    (
                                                        @PriceCategoryId,
                                                        @PriceCategoryCode,
                                                        @PriceCategoryName,
                                                        @PriceCategoryIsSelected,
                                                        @PriceCategorySortOrder,
                                                        @PriceCategoryStatus,
                                                        @PriceCategoryVersion,
                                                        @PriceCategoryCreatedById,
                                                        @PriceCategoryCreatedOn,
                                                        @PriceCategoryModifiedById,
                                                        @PriceCategoryModifiedOn
                                                    );";

        public const string UPDATE_PRICECATEGORY = @"UPDATE MPRICECATEGORY
                                                    SET
                                                        PRICECATEGORYCODE     = @PriceCategoryCode,
                                                        PRICECATEGORYNAME     = @PriceCategoryName,
                                                        ISSELECTED            = @PriceCategoryIsSelected,
                                                        SORTORDER             = @PriceCategorySortOrder,
                                                        STATUS                = @PriceCategoryStatus,
                                                        VERSION               = @PriceCategoryVersion,
                                                        MODIFIEDBYID          = @PriceCategoryModifiedById,
                                                        MODIFIEDON            = @PriceCategoryModifiedOn
                                                    WHERE
                                                        PRICECATEGORYID = @PriceCategoryId;";

        public const string DELETE_PRICECATEGORY = @"DELETE FROM MPRICECATEGORY
                                                        WHERE PRICECATEGORYID = @pricecategoryid;";
    }
}