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

namespace MaintenanceDAL.Query.ActivityType
{
    public static class ActivityTypeQB
    {
        public const string GetSelectListActivityType = @"SELECT
    at.ACTIVITYTYPEID   AS id,
    at.ACTIVITYTYPECODE AS code,
    at.ACTIVITYTYPENAME AS name
    FROM MACTIVITYTYPE at;";

        public const string SAVE_ACTIVITYTYPE = @"
INSERT INTO MACTIVITYTYPE
(
    ACTIVITYTYPEID,
    ACTIVITYTYPECODE,
    ACTIVITYTYPENAME,
    CLASSID,
    SUBCLASSID,
    REMARKS,
    SORTORDER,
    STATUS,
    VERSION,
    CREATEDBYID,
    CREATEDON,
    MODIFIEDBYID,
    MODIFIEDON,
    SOURCETYPE,
    TENANTID
)
VALUES
(
    @ActivityTypeId,
    @ActivityTypeCode,
    @ActivityTypeName,
    @ActivityTypeClassId,
    @ActivityTypeSubClassId,
    @ActivityTypeRemarks,
    @ActivityTypeSortOrder,
    @ActivityTypeStatus,
    @ActivityTypeVersion,
    @ActivityTypeCreatedById,
    @ActivityTypeCreatedOn,
    @ActivityTypeModifiedById,
    @ActivityTypeModifiedOn,
    @ActivityTypeSourceType,
    @ActivityTypeTenantId
);";

        public const string UPDATE_ACTIVITYTYPE = @"
UPDATE MACTIVITYTYPE
SET
    ACTIVITYTYPECODE  = @ActivityTypeCode,
    ACTIVITYTYPENAME  = @ActivityTypeName,
    CLASSID           = @ActivityTypeClassId,
    SUBCLASSID        = @ActivityTypeSubClassId,
    REMARKS           = @ActivityTypeRemarks,
    SORTORDER         = @ActivityTypeSortOrder,
    STATUS            = @ActivityTypeStatus,
    VERSION           = @ActivityTypeVersion + 1,
    MODIFIEDBYID      = @ActivityTypeModifiedById,
    MODIFIEDON        = @ActivityTypeModifiedOn,
    SOURCETYPE        = @ActivityTypeSourceType,
    TENANTID          = @ActivityTypeTenantId
WHERE
    ACTIVITYTYPEID = @ActivityTypeId;";

        public const string GET_ACTIVITYTYPE = @"SELECT
    at.ACTIVITYTYPEID   AS ActivityTypeId,
    at.ACTIVITYTYPECODE AS ActivityTypeCode,
    at.ACTIVITYTYPENAME AS ActivityTypeName,
    at.CLASSID          AS ActivityTypeClassId,
    at.SUBCLASSID       AS ActivityTypeSubClassId,
    at.ISACTIVE         AS ActivityTypeIsActive,
    at.REMARKS          AS ActivityTypeRemarks,
    at.SORTORDER        AS ActivityTypeSortOrder,
    at.STATUS           AS ActivityTypeStatus,
    at.VERSION          AS ActivityTypeVersion,
    at.SOURCETYPE       AS ActivityTypeSourceType,
    at.TENANTID         AS ActivityTypeTenantId,
    at.CREATEDBYID      AS ActivityTypeCreatedById,
    at.CREATEDON        AS ActivityTypeCreatedOn,
    at.MODIFIEDBYID     AS ActivityTypeModifiedById,
    at.MODIFIEDON       AS ActivityTypeModifiedOn
FROM MACTIVITYTYPE at
WHERE at.ACTIVITYTYPEID = @ActivityTypeId";

        public const string DELETE_ACTIVITYTYPE = @"
DELETE FROM MACTIVITYTYPE
WHERE ACTIVITYTYPEID = @ActivityTypeId;";
    }
}