public void InsertInterview()
{
SqlParameter[] pam = new SqlParameter[2];
pam[0] = ClsDll.AddParameter("@ReceivalId", ReceivalId, SqlDbType.Int, 100);
pam[1] = ClsDll.AddParameter("@IsInterviewPss", IsInterviewPss, SqlDbType.Bit, 10);
ClsDll.ExecuteDTByProcedure("spUpdateVacInt", pam);
}
public void InsertWritten()
{
SqlParameter[] pam = new SqlParameter[2];
pam[0] = ClsDll.AddParameter("@ReceivalId", ReceivalId, SqlDbType.Int, 100);
pam[1] = ClsDll.AddParameter("@IsWrTestPass", IsWrTestPass, SqlDbType.Bit, 10);
ClsDll.ExecuteDTByProcedure("spUpdateVacWt", pam);
}
public void InsertStatus()
{
SqlParameter[] pam = new SqlParameter[2];
pam[0] = ClsDll.AddParameter("@ReceivalId", ReceivalId, SqlDbType.Int, 100);
pam[1] = ClsDll.AddParameter("@IsEmployee", IsEmployee, SqlDbType.Bit, 10);
ClsDll.ExecuteDTByProcedure("spUpdateVacSts", pam);
}
public void InsertShortList()
{
SqlParameter[] pam = new SqlParameter[2];
pam[0] = ClsDll.AddParameter("@ReceivalId", ReceivalId, SqlDbType.Int, 100);
pam[1] = ClsDll.AddParameter("@IsWrTestCall", IsWrTestCall, SqlDbType.Bit, 10);
DataTable dt = ClsDll.ExecuteDTByProcedure("spUpdateVacWtCl", pam);
}
public DataTable GetAvlPost()
{
SqlParameter[] parameters = new SqlParameter[0];
DataTable dt = ClsDll.ExecuteDTByProcedure("spGetAvlPost", parameters);
return(dt);
}
public void AddJobDetails(string jd)
{
SqlParameter[] pam = new SqlParameter[2];
pam[0] = ClsDll.AddParameter("@PostId", PostId, SqlDbType.Int, 100);
pam[1] = ClsDll.AddParameter("@JobDesc", jd, SqlDbType.NVarChar, 500);
ClsDll.ExecuteDTByProcedure("spInsertJobDetails", pam);
}
public DataTable GetEmp(int did, int eid)
{
SqlParameter[] pam = new SqlParameter[2];
pam[0] = ClsDll.AddParameter("@did", did, SqlDbType.Int, 100);
pam[1] = ClsDll.AddParameter("@eid", eid, SqlDbType.Int, 500);
return(ClsDll.ExecuteDTByProcedure("GetEmp", pam));
}
public DataTable TotWD(int yr, int mn)
{
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = ClsDll.AddParameter("@FullYear", yr, SqlDbType.Int, 10);
parameters[1] = ClsDll.AddParameter("@mn", mn, SqlDbType.Int, 10);
return(ClsDll.ExecuteDTByProcedure("spGetTotWorkDays", parameters));
}
public void UpdateDept(string dn, int did)
{
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = ClsDll.AddParameter("@dn", dn, SqlDbType.NVarChar, 50);
parameters[1] = ClsDll.AddParameter("@did", did, SqlDbType.Int, 20);
ClsDll.ExecuteDTByProcedure("spUpdateDept", parameters);
}
public void UpdateLeave(int lid, string stat)
{
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = ClsDll.AddParameter("@LeaveId", lid, SqlDbType.Int, 20);
parameters[1] = ClsDll.AddParameter("@Status", stat, SqlDbType.NVarChar, 20);
ClsDll.ExecuteDTByProcedure("spUpdateLeaveStatus", parameters);
}
public void UpdateEmpResignation(DateTime dt, int eid)
{
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = ClsDll.AddParameter("@ResDate", dt, SqlDbType.DateTime, 10);
parameters[1] = ClsDll.AddParameter("@EmpId", eid, SqlDbType.Int, 10);
ClsDll.ExecuteDTByProcedure("spUpdateEmpResDate", parameters);
}
public void DeleteLeave(int lid)
{
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = ClsDll.AddParameter("@LeaveId", lid, SqlDbType.Int, 20);
parameters[1] = ClsDll.AddParameter("@LveStatus", 0, SqlDbType.Bit, 20);
ClsDll.ExecuteDTByProcedure("spUpdateLeaveStatus", parameters);
}
public DataTable AbsDays(DateTime dt, int eid)
{
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = ClsDll.AddParameter("@Fd", dt, SqlDbType.Date, 10);
parameters[1] = ClsDll.AddParameter("@EmpId", eid, SqlDbType.Int, 10);
return(ClsDll.ExecuteDTByProcedure("spGetAbsDays", parameters));
}
public void UpdateCmpReply()
{
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = ClsDll.AddParameter("@CmpId", CmpId, SqlDbType.Int, 20);
parameters[1] = ClsDll.AddParameter("@Reply", Reply, SqlDbType.NVarChar, 500);
ClsDll.ExecuteDTByProcedure("spUpdateCmpRply", parameters);
}
public DataTable ApplicantDet(int code, string em)
{
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = ClsDll.AddParameter("@em", em, SqlDbType.NVarChar, 100);
parameters[1] = ClsDll.AddParameter("@code", code, SqlDbType.Int, 10);
return(ClsDll.ExecuteDTByProcedure("spActEmp", parameters));
}
public DataTable GetRecApp()
{
SqlParameter[] parameters = new SqlParameter[0];
DataTable dt = ClsDll.ExecuteDTByProcedure("spGetAllAppRec", parameters);
return(dt);
}
public void InsertCV()
{
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = ClsDll.AddParameter("@uid", EmpId, SqlDbType.Int, 20);
parameters[1] = ClsDll.AddParameter("@path", Path, SqlDbType.VarChar, 100);
ClsDll.ExecuteDTByProcedure("spInsertCv", parameters);
}
//Recruitment model load event end
public DataTable GetJobDetails()
{
SqlParameter[] parameters = new SqlParameter[0];
DataTable dt = ClsDll.ExecuteDTByProcedure("spGetAllVacancyDetails", parameters);
return(dt);
}
public void UpdateEmpSts(string sts, int eid)
{
SqlParameter[] parameters = new SqlParameter[3];
parameters[0] = ClsDll.AddParameter("@EmpId", eid, SqlDbType.Int, 10);
parameters[1] = ClsDll.AddParameter("@EmpSts", sts, SqlDbType.NVarChar, 20);
parameters[2] = ClsDll.AddParameter("@Path", Path, SqlDbType.NVarChar, 200);
ClsDll.ExecuteDTByProcedure("spUpdateEmpSts", parameters);
}
public DataTable GetShortListed()
{
//populate the ShortList.aspx
SqlParameter[] parameters = new SqlParameter[0];
DataTable dt = ClsDll.ExecuteDTByProcedure("spGetShortListedApp", parameters);
return(dt);
}
public DataTable GetAllVac(int VacancyId)
{
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = ClsDll.AddParameter("@VacancyId", VacancyId, SqlDbType.Int, 100);
DataTable dt = ClsDll.ExecuteDTByProcedure("spGetAllVac", parameters);
return(dt);
}
public DataTable GetStatus()
{
//populate status
SqlParameter[] parameters = new SqlParameter[0];
DataTable dt = ClsDll.ExecuteDTByProcedure("spGetStatus", parameters);
return(dt);
}
public DataTable GetInterviewed()
{
//populate interview
SqlParameter[] parameters = new SqlParameter[0];
DataTable dt = ClsDll.ExecuteDTByProcedure("spGetInterviewed", parameters);
return(dt);
}
public DataTable GetWritten()
{
//populate writtentest.aspx
SqlParameter[] parameters = new SqlParameter[0];
DataTable dt = ClsDll.ExecuteDTByProcedure("spGetWrittenTest", parameters);
return(dt);
}
public DataTable SalDet(int eid, int yr, int mn)
{
SqlParameter[] parameters = new SqlParameter[3];
parameters[0] = ClsDll.AddParameter("@eid", eid, SqlDbType.Int, 10);
parameters[1] = ClsDll.AddParameter("@yr", yr, SqlDbType.Int, 10);
parameters[2] = ClsDll.AddParameter("@mn", mn, SqlDbType.Int, 10);
return(ClsDll.ExecuteDTByProcedure("spGetSalaryDet", parameters));
}
public DataTable GetCmpById()
{
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = ClsDll.AddParameter("@CmpId", CmpId, SqlDbType.Int, 20);
DataTable dt = ClsDll.ExecuteDTByProcedure("spGetComplainById", parameters);
return(dt);
}
public DataTable GetEmp()
{
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = ClsDll.AddParameter("@DeptId", DeptId, SqlDbType.Int, 20);
DataTable dt = ClsDll.ExecuteDTByProcedure("spGetEmp", parameters);
return(dt);
}
//Recruitment model insert event end
//Recruitment model load event start
public DataTable GetRecAppDet()
{
//populate the vacancyReceived.aspx
SqlParameter[] parameters = new SqlParameter[0];
DataTable dt = ClsDll.ExecuteDTByProcedure("spGetAllAppRecDet", parameters);
return(dt);
}
public DataTable GetEmpByEid(int eid)
{
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = ClsDll.AddParameter("@EmpId", eid, SqlDbType.Int, 20);
DataTable dt = ClsDll.ExecuteDTByProcedure("spGetEmpByEid", parameters);
return(dt);
}
//Attendance model database
public DataTable GetEmpAttPart()
{
//get Eid and date from Attendance
SqlParameter[] parameters = new SqlParameter[0];
DataTable dt = ClsDll.ExecuteDTByProcedure("spGetAttPart", parameters);
return(dt);
}