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

namespace FrameworkDAL.Query.Operation
{
    public class OperationQB
    {
        public const string GET_OPERATION = @"SELECT 
                                            O.OPERATIONID     AS OperationId,
                                            O.OPERATIONCODE   AS OperationCode,
                                            O.OPERATIONNAME   AS OperationName,
                                            O.REMARKS         AS OperationRemarks,
                                            O.SORTORDER       AS OperationSortOrder,
                                            O.STATUS          AS OperationStatus,
                                            O.VERSION         AS OperationVersion,
                                            O.SOURCETYPE      AS OperationSourceType,
                                            O.CREATEDBYID     AS OperationCreatedById,
                                            O.CREATEDON       AS OperationCreatedOn,
                                            O.MODIFIEDBYID    AS OperationModifiedById,
                                            O.MODIFIEDON      AS OperationModifiedOn
                                        FROM MOPERATION O
                                         WHERE OPERATIONID = @OperationId;
                                        ";


        public const string GET_SELECTLIST_OPERATION = @"SELECT
                                                        OPERATIONID   AS Id,
                                                        OPERATIONCODE AS Code,
                                                        OPERATIONNAME AS Name
                                                    FROM MOPERATION;";

        public const string SAVE_OPERATION = @"INSERT INTO MOPERATION
                                            (
                                                OPERATIONID,
                                                OPERATIONCODE,
                                                OPERATIONNAME,
                                                REMARKS,
                                                SORTORDER,
                                                STATUS,
                                                VERSION,
                                                SOURCETYPE,
                                                CREATEDBYID,
                                                CREATEDON,
                                                MODIFIEDBYID,
                                                MODIFIEDON
                                            )
                                            VALUES
                                            (
                                                @OperationId,   
                                                @OperationCode,
                                                @OperationName,
                                                @OperationRemarks,
                                                @OperationSortOrder,
                                                @OperationStatus,
                                                @OperationVersion,
                                                @OperationSourceType,
                                                @OperationCreatedById,
                                                @OperationCreatedOn,
                                                @OperationModifiedById,
                                                @OperationModifiedOn
                                            );";

        public const string UPDATE_OPERATION = @"UPDATE MOPERATION
                                                SET 
                                                    OPERATIONCODE   = @OperationCode,
                                                    OPERATIONNAME   = @OperationName,
                                                    REMARKS         = @OperationRemarks,
                                                    SORTORDER       = @OperationSortOrder,
                                                    STATUS          = @OperationStatus,
                                                    VERSION         = @OperationVersion,
                                                    SOURCETYPE      = @OperationSourceType,
                                                    CREATEDBYID     = @OperationCreatedById,
                                                    CREATEDON       = @OperationCreatedOn,
                                                    MODIFIEDBYID    = @OperationModifiedById,
                                                    MODIFIEDON      = @OperationModifiedOn
                                                WHERE OPERATIONID = @OperationId;";

        public const string DELETE_OPERATION = @"DELETE FROM MOPERATION
                                                WHERE OPERATIONID = @OperationId;";
    }
}