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

namespace PayRollDAL.Query.EmployeeReference
{
    public static class EmployeeReferenceQB
    {
        public const string SAVE_EMPLOYEEREFERENCE = @"INSERT 
                            INTO MEMPLOYEEREFERENCE (
                                 EMPLOYEEREFERENCEID,
                                 EMPLOYEEID,
                                 SLNO,
                                 REFERENCE,
                                 REFERENCECOMPANY,
                                 DESIGNATION,
                                 RELATIONSHIP,
                                 TIMEKNOWN,
                                 ISVERIFIED,
                                 VERIFIEDBYID,
                                 VERIFIEDON,
                                 REMARKS
                            ) VALUES (
                                 @EmployeeReferenceId,
                                 @EmployeeId,
                                 @EmployeeReferenceSlNo,
                                 @EmployeeReferenceReference,
                                 @EmployeeReferenceReferenceCompany,
                                 @EmployeeReferenceDesignation,
                                 @EmployeeReferenceRelationship,
                                 @EmployeeReferenceTimeKnown,
                                 @EmployeeReferenceIsVerified,
                                 @VerifiedById,
                                 @EmployeeReferenceVerifiedOn,
                                 @EmployeeReferenceRemarks
                            );
                            ";

        public const string UPDATE_EMPLOYEEREFERENCE = @"UPDATE 
                            MEMPLOYEEREFERENCE SET
                            EMPLOYEEID = @EmployeeId,
                            SLNO = @EmployeeReferenceSlNo,
                            REFERENCE = @EmployeeReferenceReference,
                            REFERENCECOMPANY = @EmployeeReferenceReferenceCompany,
                            DESIGNATION = @EmployeeReferenceDesignation,
                            RELATIONSHIP = @EmployeeReferenceRelationship,
                            TIMEKNOWN = @EmployeeReferenceTimeKnown,
                            ISVERIFIED = @EmployeeReferenceIsVerified,
                            VERIFIEDBYID = @VerifiedById,
                            VERIFIEDON = @EmployeeReferenceVerifiedOn,
                            REMARKS = @EmployeeReferenceRemarks
                            WHERE EMPLOYEEREFERENCEID = @EmployeeReferenceId;
                            ";

        public const string DELETE_EMPLOYEEREFERENCE = @"DELETE 
                            FROM MEMPLOYEEREFERENCE
                            WHERE EMPLOYEEID = @employeeid;
                            ";
    }
}