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

namespace FrameworkDAL.Query.UOM
{
    public static class UOMQB
    {
        public const string GET_UOM = @"SELECT
                                        U.UOMID AS UOMId,
                                        U.UOMCODE AS UOMCode,
                                        U.UOMNAME AS UOMName,
                                        U.UOMTYPE AS UOMType,
                                         CASE U.UOMTYPE
                                                    WHEN 0 THEN 'Length'
                                                    WHEN 1 THEN 'Weight'
                                                    WHEN 2 THEN 'Time'
                                                    WHEN 3 THEN 'Yarn Count'
                                                    WHEN 4 THEN 'Capacity'
                                                    WHEN 5 THEN 'Production Entry'
                                                    WHEN 6 THEN 'Others'
                                                    ELSE 'Unknown'
                                                END AS UOMTypeName,
                                        U.NOOFDECIMALS AS UOMNoOfDecimals,

                                        U.CREATEDBYID AS UOMCreatedById,
                                        U.CREATEDON AS UOMCreatedOn,
                                        CU.USERNAME AS UOMCreatedByName,
                                        U.MODIFIEDBYID AS UOMModifiedById,
                                        U.MODIFIEDON AS UOMModifiedOn,
                                        MU.USERNAME AS UOMModifiedByName,

                                        U.SORTORDER AS UOMSortOrder,
                                        U.STATUS AS UOMStatus,
                                        U.VERSION AS UOMVersion,
                                        U.SOURCETYPE AS UOMSourceType,
                                        U.GSTUOMCODE AS UOMGstUOMCode

                                    FROM MUOM U
                                     LEFT JOIN MUSER CU
                                            ON CU.USERID = U.CREATEDBYID

                                        LEFT JOIN MUSER MU
                                            ON MU.USERID = U.MODIFIEDBYID
                                    WHERE U.UOMID = @uomid;";

       
        public const string GetSelectListUOM = @"SELECT
                                                mu.UOMID   AS id,
                                                mu.UOMCODE AS code,
                                                mu.UOMNAME AS name
                                                FROM MUOM mu;";

        public const string SAVE_UOM = @"INSERT INTO MUOM
                                        (
                                            UOMID,
                                            UOMCODE,
                                            UOMNAME,
                                            UOMTYPE,
                                            NOOFDECIMALS,
                                            SORTORDER,
                                            STATUS,
                                            VERSION,
                                            SOURCETYPE,
                                            CREATEDBYID,
                                            CREATEDON,
                                            MODIFIEDBYID,
                                            MODIFIEDON,
                                            GSTUOMCODE
                                        )
                                        VALUES
                                        (
                                            @UOMId,
                                            @UOMCode,
                                            @UOMName,
                                            @UOMType,
                                            @UOMNoOfDecimals,
                                            @UOMSortOrder,
                                            @UOMStatus,
                                            @UOMVersion,
                                            @UOMSourceType,
                                            @UOMCreatedById,
                                            @UOMCreatedOn,
                                            @UOMModifiedById,
                                            @UOMModifiedOn,
                                            @UOMGstUOMCode);";

        public const string UPDATE_UOM = @"UPDATE MUOM
                                            SET
                                                UOMCODE = @UOMCode,
                                                UOMNAME = @UOMName,
                                                UOMTYPE = @UOMType,
                                                NOOFDECIMALS = @UOMNoOfDecimals,
                                                SORTORDER = @UOMSortOrder,
                                                STATUS = @UOMStatus,
                                                VERSION = @UOMVersion,
                                                SOURCETYPE = @UOMSourceType,
                                                MODIFIEDBYID = @UOMModifiedById,
                                                MODIFIEDON = @UOMModifiedOn,
                                                GSTUOMCODE = @UOMGstUOMCode
                                            WHERE
                                                UOMID = @UOMId;";

        public const string DELETE_UOM = @"DELETE FROM MUOM
                                        WHERE UOMID = @uomid;";
    }
}