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

namespace MMDAL.Query.LotType
{
    public static class LotTypeQB
    {
        public const string GET_LOTTYPE = @"SELECT
                            L.LOTTYPEID AS LotTypeId,
                            L.OUID AS OUId,
                            O.ORGANIZATIONUNITCODE AS OUCode,
                            O.ORGANIZATIONUNITNAME AS OUName,
                            L.LOTTYPE AS LotTypeType,
                            L.LOTNUMBERINGTYPE AS LotTypeLotNumberingType,
                            L.PROCESSID AS ProcessId,
                            P.PROCESSCODE AS ProcessCode,
                            P.PROCESSNAME AS ProcessName,
                            L.ITEMID AS ItemId,
                            I.ITEMCODE AS ItemCode,
                            I.ITEMNAME AS ItemName,
                            L.SKUID AS SKUId,
                            S.SKUCODE AS SKUCode,
                            S.SKUNAME AS SKUName,
                            L.LOTNUMBERSIZE AS LotTypeLotNumberSize,
                            L.PREFIX AS LotTypePrefix,
                            L.SUFFIX AS LotTypeSuffix,
                            L.FROMNUMBER AS LotTypeFromNumber,
                            L.REMARKS AS LotTypeRemarks,
                            L.SORTORDER AS LotTypeSortOrder,
                            L.STATUS AS LotTypeStatus,
                            L.VERSION AS LotTypeVersion,
                            L.CREATEDBYID AS LotTypeCreatedById,
                            L.CREATEDON AS LotTypeCreatedOn,
                            L.MODIFIEDBYID AS LotTypeModifiedById,
                            L.MODIFIEDON AS LotTypeModifiedOn,
                            L.LOTTYPENAME AS LotTypeName,
                            L.SOURCETYPE AS LotTypeSourceType,
                            L.TENANTID AS LotTypeTenantId
                            FROM MLOTTYPE L
                            LEFT JOIN MORGANIZATIONUNIT O ON L.OUID = O.OUID
                            LEFT JOIN MPROCESS P ON L.PROCESSID = P.PROCESSID
                            LEFT JOIN MITEM I ON L.ITEMID = I.ITEMID
                            LEFT JOIN MSKU S ON L.SKUID = S.SKUID
                            WHERE L.LOTTYPEID = @lottypeid;
                            ";

        public const string GET_SELECTLIST_LOTTYPE = @"SELECT
                            LOTTYPEID AS Id,
                            LOTTYPENAME AS Name
                            FROM MLOTTYPE
                            ";

        public const string SAVE_LOTTYPE = @"INSERT 
                            INTO MLOTTYPE (
                                 LOTTYPEID,
                                 OUID,
                                 LOTTYPE,
                                 LOTNUMBERINGTYPE,
                                 PROCESSID,
                                 ITEMID,
                                 SKUID,
                                 LOTNUMBERSIZE,
                                 PREFIX,
                                 SUFFIX,
                                 FROMNUMBER,
                                 REMARKS,
                                 STATUS,
                                 VERSION,
                                 CREATEDBYID,
                                 CREATEDON,
                                 MODIFIEDBYID,
                                 MODIFIEDON,
                                 LOTTYPENAME
                            ) VALUES (
                                 @LotTypeId,
                                 @OUId,
                                 @LotTypeType,
                                 @LotTypeLotNumberingType,
                                 @ProcessId,
                                 @ItemId,
                                 @SKUId,
                                 @LotTypeLotNumberSize,
                                 @LotTypePrefix,
                                 @LotTypeSuffix,
                                 @LotTypeFromNumber,
                                 @LotTypeRemarks,
                                 @LotTypeStatus,
                                 @LotTypeVersion,
                                 @LotTypeCreatedById,
                                 @LotTypeCreatedOn,
                                 @LotTypeModifiedById,
                                 @LotTypeModifiedOn,
                                 @LotTypeName
                            );
                            ";

        public const string UPDATE_LOTTYPE = @"UPDATE 
                            MLOTTYPE SET
                            OUID = @OUId,
                            LOTTYPE = @LotTypeType,
                            LOTNUMBERINGTYPE = @LotTypeLotNumberingType,
                            PROCESSID = @ProcessId,
                            ITEMID = @ItemId,
                            SKUID = @SKUId,
                            LOTNUMBERSIZE = @LotTypeLotNumberSize,
                            PREFIX = @LotTypePrefix,
                            SUFFIX = @LotTypeSuffix,
                            FROMNUMBER = @LotTypeFromNumber,
                            REMARKS = @LotTypeRemarks,
                            STATUS = @LotTypeStatus,
                            VERSION = @LotTypeVersion,
                            MODIFIEDBYID = @LotTypeModifiedById,
                            MODIFIEDON = @LotTypeModifiedOn,
                            LOTTYPENAME = @LotTypeName
                            WHERE LOTTYPEID = @LotTypeId;
                            ";

        public const string DELETE_LOTTYPE = @"DELETE 
                            FROM MLOTTYPE
                            WHERE LOTTYPEID = @lottypeid;
                            ";
    }
}