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

namespace AdminDAL.Query.AllocationType
{
    public static class AllocationTypeQB
    {
        public const string GET_ALLOCATIONTYPE_SELECTLIST = @"SELECT
                                                            A.ALLOCATIONTYPEID AS Id,
                                                            A.ALLOCATIONTYPECODE AS Code,
                                                            A.ALLOCATIONTYPENAME AS Name
                                                            FROM 
                                                            MALLOCATIONTYPE A";


        public const string GET_ALLOCATIONTYPE = @"SELECT 
                                                ALLOCATIONTYPEID    AS AllocationTypeId,
                                                ALLOCATIONTYPECODE  AS AllocationTypeCode,
                                                ALLOCATIONTYPENAME  AS AllocationTypeName,
                                                ISPOSTCOSTCENTER    AS IsPostCostCenter,
                                                COSTCATEGORYID      AS CostCategoryId,
                                                ISMULTILEVEL        AS AllocationTypeIsMultiLevel,
                                                ISDATEBASED         AS AllocationTypeIsDateBased,
                                                OBJECTTYPEID        AS EntityId,
                                                ISCAPITAL           AS AllocationTypeIsCapital,
                                                SORTORDER           AS AllocationTypeSortOrder,
                                                STATUS              AS AllocationTypeStatus,
                                                VERSION             AS AllocationTypeVersion,
                                                CREATEDBYID         AS AllocationTypeCreatedById,
                                                CREATEDON           AS AllocationTypeCreatedOn,
                                                MODIFIEDBYID        AS AllocationTypeModifiedById,
                                                MODIFIEDON          AS AllocationTypeModifiedOn,
                                                SOURCETYPE          AS SourceType,
                                                TENANTID            AS TenantId
                                            FROM MALLOCATIONTYPE AT
                                            WHERE ALLOCATIONTYPEID = @allocationtypeid";

        public const string SAVE_ALLOCATIONTYPE = @"INSERT INTO MALLOCATIONTYPE 
                                                    (
                                                        ALLOCATIONTYPEID,
                                                        ALLOCATIONTYPECODE,
                                                        ALLOCATIONTYPENAME,
                                                        ISPOSTCOSTCENTER,
                                                        COSTCATEGORYID,
                                                        ISMULTILEVEL,
                                                        ISDATEBASED,
                                                        OBJECTTYPEID,
                                                        ISCAPITAL,
                                                        STATUS,
                                                        VERSION,
                                                        CREATEDBYID,
                                                        CREATEDON,
                                                        MODIFIEDBYID,
                                                        MODIFIEDON                                                    )
                                                    VALUES 
                                                    (
                                                        @AllocationTypeId,
                                                        @AllocationTypeCode,
                                                        @AllocationTypeName,
                                                        @IsPostCostCenter,
                                                        @CostCategoryId,
                                                        @AllocationTypeIsMultiLevel,
                                                        @AllocationTypeIsDateBased,
                                                        @EntityId,
                                                        @AllocationTypeIsCapital,
                                                        @AllocationTypeStatus,
                                                        @AllocationTypeVersion,
                                                        @AllocationTypeCreatedById,
                                                        @AllocationTypeCreatedOn,
                                                        @AllocationTypeModifiedById,
                                                        @AllocationTypeModifiedOn
                                                    );";

        public const string UPDATE_ALLOCATIONTYPE = @"UPDATE MALLOCATIONTYPE
                                                        SET 
                                                            ALLOCATIONTYPECODE   = @AllocationTypeCode,
                                                            ALLOCATIONTYPENAME   = @AllocationTypeName,
                                                            ISPOSTCOSTCENTER     = @IsPostCostCenter,
                                                            COSTCATEGORYID       = @CostCategoryId,
                                                            ISMULTILEVEL         = @AllocationTypeIsMultiLevel,
                                                            ISDATEBASED          = @AllocationTypeIsDateBased,
                                                            OBJECTTYPEID         = @EntityId,
                                                            ISCAPITAL            = @AllocationTypeIsCapital,
                                                            STATUS               = @AllocationTypeStatus,
                                                            VERSION              = @AllocationTypeVersion,
                                                            MODIFIEDBYID         = @AllocationTypeModifiedById,
                                                            MODIFIEDON           = @AllocationTypeModifiedOn
                                                        WHERE 
                                                            ALLOCATIONTYPEID = @AllocationTypeId;";


        public const string DELETE_ALLOCATIONTYPE = @"DELETE FROM MALLOCATIONTYPE
                                                    WHERE ALLOCATIONTYPEID = @allocationtypeid;";
    }
}