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

namespace PayRollDAL.Query.PayProduction
{
    public static class PayProductionQB
    {
        public const string SAVE_PAY_PRODUCTION = @"INSERT INTO TPAYPRODUCTION (
                                            PAYPRODUCTIONID,              
                                            OUID,                          
                                            PERIODID,                     
                                            BIZTRANSACTIONTYPEID,        
                                            PAYPRODUCTIONNUMBER,        
                                            PAYPRODUCTIONDATE,            
                                            REFERENCENUMBER,              
                                            SHIFTID,                    
                                            PARTICULARS,                  
                                            STATUS,                       
                                            VERSION,                      
                                            CREATEDBYID,                   
                                            CREATEDON,                    
                                            MODIFIEDBYID,                 
                                            MODIFIEDON                     
                                        )
                                        VALUES (
                                            @PayProductionId,                                       -- PayProductionId
                                            @OUId,                                                  -- OUId
                                            @PeriodId,                                              -- PeriodId
                                            @BizTransactionTypeId,                                  -- BizTransactionTypeId
                                            @PayProductionNumber,                                   -- PayProductionNumber
                                            @PayProductionDate,                                     -- PayProductionDate
                                            @PayProductionReferenceNumber,                          -- PayProductionReferenceNumber
                                            @ShiftId,                                               -- ShiftId
                                            @PayProductionParticulars,                              -- PayProductionParticulars
                                            @PayProductionStatus,                                   -- PayProductionStatus
                                            @PayProductionVersion,                                  -- PayProductionVersion
                                            @PayProductionCreatedById,                              -- PayProductionCreatedById
                                            @PayProductionCreatedOn,                                -- PayProductionCreatedOn
                                            @PayProductionModifiedById,                             -- PayProductionModifiedById
                                            @PayProductionModifiedOn                                -- PayProductionModifiedOn
                                        );";

        public const string SAVE_PAY_PRODUCTION_DETAIL = @"INSERT INTO TPAYPRODUCTIONDETAIL (
                                                PAYPRODUCTIONDETAILID,
                                                PAYPRODUCTIONID,
                                                SLNO,
                                                EMPLOYEEID,
                                                PROCESSID,
                                                ITEMID,
                                                SKUID,
                                                MACHINEID,
                                                QUANTITY,
                                                RATE,
                                                RATEPER,
                                                AMOUNT,
                                                REMARKS
                                            )
                                            VALUES (
                                                @PayProductionDetailId,
                                                @PayProductionId,
                                                @PayProductionDetailSlNo,
                                                @EmployeeId,
                                                @ProcessId,
                                                @ItemId,
                                                @SKUId,
                                                @MachineId,
                                                @PayProductionDetailQuantity,
                                                @PayProductionDetailRate,
                                                @PayProductionDetailRatePer,
                                                @PayProductionDetailAmount,
                                                @PayProductionDetailRemarks
                                            ); ";
    }
}