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

namespace MMDAL.Query.Color
{
    public class ColorQB
    {
        public const string GET_COLOR = @"SELECT
                                            COLORID             AS ColorId,
                                            COLORCODE           AS ColorCode,
                                            COLORNAME           AS ColorName,
                                            COLORNAMEINNATIVE   AS ColorNameInNative,
                                            COLORTYPE           AS ColorType,
                                            ISTWISTCOLOR        AS ColorIsTwistColor,
                                            FIRSTCOLORID        AS FirstColorId,
                                            SECONDCOLORID       AS SecondColorId,
                                            THIRDCOLORID        AS ThirdColorId,
                                            RGBVALUE1           AS ColorRGBValue1,
                                            RGBVALUE2           AS ColorRGBValue2,
                                            RGBVALUE3           AS ColorRGBValue3,
                                            SHADETYPE           AS ColorShadeType,
                                            DYEINGLOSSPERCENTAGE AS ColorDyeingLossPercentage,
                                            DYEINGRATE          AS ColorDyeingRate,
                                            SORTORDER           AS ColorSortOrder,
                                            STATUS              AS ColorStatus,
                                            VERSION             AS ColorVersion,
                                            CREATEDBYID         AS ColorCreatedById,
                                            CREATEDON           AS ColorCreatedOn,
                                            MODIFIEDBYID        AS ColorModifiedById,
                                            MODIFIEDON          AS ColorModifiedOn,
                                            SOURCETYPE          AS SourceType,
                                            TENANTID            AS TenantId
                                        FROM MCOLOR 
                                        WHERE COLORID = @colorid;";

        public const string SAVE_COLOR = @"INSERT INTO MCOLOR
                                            (
                                                COLORID,
                                                COLORCODE,
                                                COLORNAME,
                                                COLORNAMEINNATIVE,
                                                COLORTYPE,
                                                ISTWISTCOLOR,
                                                FIRSTCOLORID,
                                                SECONDCOLORID,
                                                THIRDCOLORID,
                                                RGBVALUE1,
                                                RGBVALUE2,
                                                RGBVALUE3,
                                                SHADETYPE,
                                                DYEINGLOSSPERCENTAGE,
                                                DYEINGRATE,
                                                SORTORDER,
                                                STATUS,
                                                VERSION,
                                                CREATEDBYID,
                                                CREATEDON,
                                                MODIFIEDBYID,
                                                MODIFIEDON, 
                                                SOURCETYPE,
                                                TENANTID
                                            )
                                            VALUES
                                            (
                                                @ColorId,
                                                @ColorCode,
                                                @ColorName,
                                                @ColorNameInNative,
                                                @ColorType,
                                                @ColorIsTwistColor,
                                                @FirstColorId,
                                                @SecondColorId,
                                                @ThirdColorId,
                                                @ColorRGBValue1,
                                                @ColorRGBValue2,
                                                @ColorRGBValue3,
                                                @ColorShadeType,
                                                @ColorDyeingLossPercentage,
                                                @ColorDyeingRate,
                                                @ColorSortOrder,
                                                @ColorStatus,
                                                @ColorVersion,
                                                @ColorCreatedById,
                                                @ColorCreatedOn,
                                                @ColorModifiedById,
                                                @ColorModifiedOn,
                                                @SourceType,
                                                @TenantId
                                            );";

        public const string UPDATE_COLOR = @"UPDATE MCOLOR
                                            SET
                                                COLORCODE = @ColorCode,
                                                COLORNAME = @ColorName,
                                                COLORNAMEINNATIVE = @ColorNameInNative,
                                                COLORTYPE = @ColorType,
                                                ISTWISTCOLOR = @ColorIsTwistColor,
                                                FIRSTCOLORID = @FirstColorId,
                                                SECONDCOLORID = @SecondColorId,
                                                THIRDCOLORID = @ThirdColorId,
                                                RGBVALUE1 = @ColorRGBValue1,
                                                RGBVALUE2 = @ColorRGBValue2,
                                                RGBVALUE3 = @ColorRGBValue3,
                                                SHADETYPE = @ColorShadeType,
                                                DYEINGLOSSPERCENTAGE = @ColorDyeingLossPercentage,
                                                DYEINGRATE = @ColorDyeingRate,
                                                SORTORDER = @ColorSortOrder,
                                                STATUS = @ColorStatus,
                                                VERSION = @ColorVersion,
                                                MODIFIEDBYID = @ColorModifiedById,
                                                MODIFIEDON = @ColorModifiedOn,
                                                SOURCETYPE = @SourceType,
                                                TENANTID = @TenantId
                                            WHERE
                                                COLORID = @ColorId;";

        public const string DELETE_COLOR = @"DELETE FROM MCOLOR
                                            WHERE COLORID = @colorid;";

        public const string GET_SELECTLIST_COLOR = @"SELECT 
                            COLORID AS Id,
                            COLORNAME AS Name,
                            COLORCODE AS Code
                            FROM MCOLOR";
    }
}