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

namespace FrameworkDAL.Query.Developer
{
    public static class DeveloperQB
    {
        public const string GET_DEVELOPER = @"SELECT
                            D.DEVELOPERID AS DeveloperId,
                            D.DEVELOPERNAME AS DeveloperName,
                            D.ACCESSKEYID AS DeveloperAccessKeyId,
                            D.SECRETKEY AS DeveloperSecretKey,
                            D.DIGEST AS DeveloperDigest,
                            D.SORTORDER AS DeveloperSortOrder,
                            D.STATUS AS DeveloperStatus,
                            D.VERSION AS DeveloperVersion,
                            D.SOURCETYPE AS DeveloperSourceType,
                            D.CREATEDBYID AS DeveloperCreatedById,
                            D.CREATEDON AS DeveloperCreatedOn,
                            D.MODIFIEDBYID AS DeveloperModifiedById,
                            D.MODIFIEDON AS DeveloperModifiedOn,
                            D.ISENCRYPTIONREQUIRED AS DeveloperIsEncryptionRequired
                            FROM MDEVELOPER D
                            WHERE D.DEVELOPERID = @developerid;
                            ";

        public const string SAVE_DEVELOPER = @"INSERT 
                            INTO MDEVELOPER (
                                 DEVELOPERNAME,
                                 ACCESSKEYID,
                                 SECRETKEY,
                                 DIGEST,
                                 SORTORDER,
                                 STATUS,
                                 VERSION,
                                 SOURCETYPE,
                                 CREATEDBYID,
                                 CREATEDON,
                                 MODIFIEDBYID,
                                 MODIFIEDON,
                                 ISENCRYPTIONREQUIRED
                            ) VALUES (
                                 @DeveloperName,
                                 @DeveloperAccessKeyId,
                                 @DeveloperSecretKey,
                                 @DeveloperDigest,
                                 @DeveloperSortOrder,
                                 @DeveloperStatus,
                                 @DeveloperVersion,
                                 @DeveloperSourceType,
                                 @DeveloperCreatedById,
                                 @DeveloperCreatedOn,
                                 @DeveloperModifiedById,
                                 @DeveloperModifiedOn,
                                 @DeveloperIsEncryptionRequired
                            );
                            SELECT CAST(SCOPE_IDENTITY() AS INT);
                            ";

        public const string UPDATE_DEVELOPER = @"UPDATE 
                            MDEVELOPER SET
                            DEVELOPERNAME = @DeveloperName,
                            ACCESSKEYID = @DeveloperAccessKeyId,
                            SECRETKEY = @DeveloperSecretKey,
                            DIGEST = @DeveloperDigest,
                            SORTORDER = @DeveloperSortOrder,
                            STATUS = @DeveloperStatus,
                            VERSION = @DeveloperVersion,
                            SOURCETYPE = @DeveloperSourceType,
                            MODIFIEDBYID = @DeveloperModifiedById,
                            MODIFIEDON = @DeveloperModifiedOn,
                            ISENCRYPTIONREQUIRED = @DeveloperIsEncryptionRequired
                            WHERE DEVELOPERID = @DeveloperId;
                            ";

        public const string DELETE_DEVELOPER = @"DELETE 
                            FROM MDEVELOPER
                            WHERE DEVELOPERID = @developerid;
                            ";

        public const string GET_SELECTLIST_DEVELOPER = @"SELECT
                            DEVELOPERID AS Id,
                            DEVELOPERNAME AS Name
                            FROM MDEVELOPER
                            ";
    }
}