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

namespace CostingDAL.Query.CostAnalysis
{
    public static class CostAnalysisQB
    {
        public const string GET_COST_ANALYSIS = @"SELECT
                                                A.COSTANALYSISID AS CostAnalysisId,
                                                A.COSTANALYSISCODE AS CostAnalysisCode,
                                                A.COSTANALYSISNAME AS CostAnalysisName,
                                                A.COSTINGTYPE AS CostAnalysisCostingType,
                                                A.PERIODFROM AS CostAnalysisPeriodFrom,
                                                A.PERIODTO AS CostAnalysisPeriodTo,
                                                A.BASICRATETYPE AS CostAnalysisBasicRateType,
                                                A.MATERIALCOSTTYPE AS CostAnalysisMaterialCostType,
                                                A.PROCESSCOSTTYPE AS CostAnalysisProcessCostType,
                                                A.RESOURCECOSTTYPE AS CostAnalysisResourceCostType,
                                                A.ISCOSTPOSTTOSTOCK AS CostAnalysisIsCostpostToStock,
                                                A.SORTORDER AS CostAnalysisSortOrder,
                                                A.VERSION AS CostAnalysisVersion,
                                                A.STATUS AS CostAnalysisStatus,
                                                A.CREATEDBYID AS CostAnalysisCreatedById,
                                                A.CREATEDON AS CostAnalysisCreatedOn,
                                                A.MODIFIEDBYID AS CostAnalysisModifiedById,
                                                A.MODIFIEDON AS CostAnalysisModifiedOn,
                                                A.SOURCETYPE AS CostAnalysisSourceType,
                                                A.TENANTID AS TenantId
                                            FROM MCOSTANALYSIS A
                                            WHERE
                                            A.COSTANALYSISID = @costanalysisid;";

        public const string SAVE_COSTANALYSIS = @"INSERT INTO MCOSTANALYSIS
                                                    (
                                                        COSTANALYSISID,
                                                        COSTANALYSISCODE,
                                                        COSTANALYSISNAME,
                                                        COSTINGTYPE,
                                                        PERIODFROM,
                                                        PERIODTO,
                                                        BASICRATETYPE,
                                                        MATERIALCOSTTYPE,
                                                        PROCESSCOSTTYPE,
                                                        RESOURCECOSTTYPE,
                                                        ISCOSTPOSTTOSTOCK,
                                                        VERSION,
                                                        STATUS,
                                                        CREATEDBYID,
                                                        CREATEDON,
                                                        MODIFIEDBYID,
                                                        MODIFIEDON
                                                    )
                                                    VALUES
                                                    (
                                                        @CostAnalysisId,
                                                        @CostAnalysisCode,
                                                        @CostAnalysisName,
                                                        @CostAnalysisCostingType,
                                                        @CostAnalysisPeriodFrom,
                                                        @CostAnalysisPeriodTo,
                                                        @CostAnalysisBasicRateType,
                                                        @CostAnalysisMaterialCostType,
                                                        @CostAnalysisProcessCostType,
                                                        @CostAnalysisResourceCostType,
                                                        @CostAnalysisIsCostpostToStock,
                                                        @CostAnalysisVersion,
                                                        @CostAnalysisStatus,
                                                        @CostAnalysisCreatedById,
                                                        @CostAnalysisCreatedOn,
                                                        @CostAnalysisModifiedById,
                                                        @CostAnalysisModifiedOn
                                                    );";

        public const string UPDATE_COSTANALYSIS = @"UPDATE MCOSTANALYSIS
                                                    SET
                                                        COSTANALYSISCODE        = @CostAnalysisCode,
                                                        COSTANALYSISNAME        = @CostAnalysisName,
                                                        COSTINGTYPE             = @CostAnalysisCostingType,
                                                        PERIODFROM              = @CostAnalysisPeriodFrom,
                                                        PERIODTO                = @CostAnalysisPeriodTo,
                                                        BASICRATETYPE           = @CostAnalysisBasicRateType,
                                                        MATERIALCOSTTYPE        = @CostAnalysisMaterialCostType,
                                                        PROCESSCOSTTYPE         = @CostAnalysisProcessCostType,
                                                        RESOURCECOSTTYPE        = @CostAnalysisResourceCostType,
                                                        ISCOSTPOSTTOSTOCK       = @CostAnalysisIsCostpostToStock,
                                                        VERSION                 = @CostAnalysisVersion,
                                                        STATUS                  = @CostAnalysisStatus,
                                                        MODIFIEDBYID            = @CostAnalysisModifiedById,
                                                        MODIFIEDON              = @CostAnalysisModifiedOn
                                                    WHERE
                                                        COSTANALYSISID = @CostAnalysisId;";


        public const string DELETE_COSTANALYSIS = @"DELETE FROM MCOSTANALYSIS
                                                    WHERE COSTANALYSISID=@costanalysisid;";

        public const string GET_SELECTLIST_COSTANALYSIS = @"SELECT
                                            COSTANALYSISID AS Id,
                                            COSTANALYSISCODE AS Code,
                                            COSTANALYSISNAME AS Name
                                            FROM MCOSTANALYSIS;";

    }
}