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

namespace AdminDAL.Query.Company
{
    public static class CompanyQB
    {
        public const string GET_COMPANY = @"SELECT
                                            A.COMPANYID AS CompanyId,
                                            A.COMPANYCODE AS CompanyCode,
                                            A.COMPANYNAME AS CompanyName,
                                            A.COMPANYSHORTNAME AS CompanyShortName,
                                            A.SORTORDER AS CompanySortOrder,
                                            A.STATUS AS CompanyStatus,
                                            A.VERSION AS CompanyVersion,
                                            A.CREATEDBYID AS CompanyCreatedById,
                                            A.CREATEDON AS CompanyCreatedOn,
                                            A.MODIFIEDBYID AS CompanyModifiedById,
                                            A.MODIFIEDON AS CompanyModifiedOn,
                                            A.COMPANYLOGO AS CompanyLogo,
                                            A.COMPANYLOGO2 AS CompanyLogo2,
                                            A.SOURCETYPE AS SourceType,
                                            A.CINNUMBER AS CompanyCINNumber,
                                            A.IMPORTEXPORTCODE AS ImportExportCode,
                                            A.IECDATE AS IECDate,
                                            A.TENANTID AS TenantId,
                                            A.MSMEREGNO AS CompanyMSMERegNo
                                        FROM MCOMPANY A
                                        WHERE
                                        A.COMPANYID = @companyid;";

        public const string GET_SELECTLIST_COMPANY = @"SELECT
                                                        COMPANYID AS Id,
                                                        COMPANYCODE AS Code,
                                                        COMPANYNAME AS Name,
                                                        COMPANYSHORTNAME AS ShortName 
                                                        FROM MCOMPANY";
        public const string SAVE_COMPANY = @"
INSERT INTO MCOMPANY
(
    COMPANYID,
    COMPANYCODE,
    COMPANYNAME,
    COMPANYSHORTNAME,
    SORTORDER,
    STATUS,
    VERSION,
    CREATEDBYID,
    CREATEDON,
    MODIFIEDBYID,
    MODIFIEDON,
    COMPANYLOGO,
    COMPANYLOGO2,
    SOURCETYPE,
    CINNUMBER,
    IMPORTEXPORTCODE,
    IECDATE,
    TENANTID,
    MSMEREGNO
)
VALUES
(
    @CompanyId,
    @CompanyCode,
    @CompanyName,
    @CompanyShortName,
    @CompanySortOrder,
    @CompanyStatus,
    @CompanyVersion,
    @CompanyCreatedById,
    @CompanyCreatedOn,
    @CompanyModifiedById,
    @CompanyModifiedOn,
    @CompanyLogo,
    @CompanyLogo2,
    @SourceType,
    @CompanyCINNumber,
    @ImportExportCode,
    @IECDate,
    @TenantId,
    @CompanyMSMERegNo
);
";

        public const string UPDATE_COMPANY = @"
UPDATE MCOMPANY
SET
    COMPANYCODE = @CompanyCode,
    COMPANYNAME = @CompanyName,
    COMPANYSHORTNAME = @CompanyShortName,
    SORTORDER = @CompanySortOrder,
    STATUS = @CompanyStatus,
    VERSION = @CompanyVersion,
    MODIFIEDBYID = @CompanyModifiedById,
    MODIFIEDON = @CompanyModifiedOn,
    COMPANYLOGO = @CompanyLogo,
    COMPANYLOGO2 = @CompanyLogo2,
    SOURCETYPE = @SourceType,
    CINNUMBER = @CompanyCINNumber,
    IMPORTEXPORTCODE = @ImportExportCode,
    IECDATE = @IECDate,
    TENANTID = @TenantId,
    MSMEREGNO = @CompanyMSMERegNo
WHERE COMPANYID = @CompanyId;
";

        public const string DELETE_COMPANY = @"
DELETE FROM MCOMPANY
WHERE COMPANYID = @companyid;
";


    }
}