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

namespace PayRollDAL.Query.EmployeeSkill
{
    public static class EmployeeSkillQB
    {
        public const string SAVE_EMPLOYEESKILL = @"INSERT 
                            INTO MEMPLOYEESKILL (
                                 EMPLOYEESKILLID,
                                 EMPLOYEEID,
                                 SLNO,
                                 SKILLID,
                                 SKILLLEVEL,
                                 PARTICULARS
                            ) VALUES (
                                 @EmployeeSkillId,
                                 @EmployeeId,
                                 @EmployeeSkillSlno,
                                 @SkillId,
                                 @EmployeeSkillSkillLevel,
                                 @EmployeeSkillParticulars
                            );
                            ";

        public const string UPDATE_EMPLOYEESKILL = @"UPDATE 
                            MEMPLOYEESKILL SET
                            EMPLOYEEID = @EmployeeId,
                            SLNO = @EmployeeSkillSlno,
                            SKILLID = @SkillId,
                            SKILLLEVEL = @EmployeeSkillSkillLevel,
                            PARTICULARS = @EmployeeSkillParticulars
                            WHERE EMPLOYEESKILLID = @EmployeeSkillId;
                            ";

        public const string DELETE_EMPLOYEESKILL = @"DELETE 
                            FROM MEMPLOYEESKILL
                            WHERE EMPLOYEEID = @employeeid;
                            ";
    }
}