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 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 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 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 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 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 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);
}
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 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 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 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 void InsertActivation(int aid, int code, int vid)
{
SqlParameter[] pam = new SqlParameter[3];
pam[0] = ClsDll.AddParameter("@AppId", aid, SqlDbType.Int, 10);
pam[1] = ClsDll.AddParameter("@Code", code, SqlDbType.Int, 50);
pam[2] = ClsDll.AddParameter("@vid", vid, SqlDbType.Int, 10);
ClsDll.ExecuteDTByProcedure("spActivateCode", pam);
}
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);
}
//Recruitment model insert event start
public void InsertAppRec()
{
//to insert the gridview data from vacancyReceived into vacRec table
SqlParameter[] pam = new SqlParameter[2];
pam[0] = ClsDll.AddParameter("@ReceivalId", ReceivalId, SqlDbType.Int, 100);
pam[1] = ClsDll.AddParameter("@IsShortListed", IsShortListed, SqlDbType.Bit, 10);
ClsDll.ExecuteDTByProcedure("spUpdateVacSl", pam);
}
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 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 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);
}
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 GetEmp()
{
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = ClsDll.AddParameter("@DeptId", DeptId, SqlDbType.Int, 20);
DataTable dt = ClsDll.ExecuteDTByProcedure("spGetEmp", parameters);
return(dt);
}
//search the applications
public DataTable SearchResult()
{
SqlParameter[] pam = new SqlParameter[2];
pam[0] = ClsDll.AddParameter("@Key", Key, SqlDbType.VarChar, 100);
pam[1] = ClsDll.AddParameter("@Index", Index, SqlDbType.VarChar, 100);
DataTable dt = ClsDll.ExecuteDTByProcedure("spGetSearchData", pam);
return(dt);
}
public void AddHoliday(int yr, int mn, int dy, string det)
{
SqlParameter[] parameters = new SqlParameter[4];
parameters[0] = ClsDll.AddParameter("@yr", yr, SqlDbType.Int, 100);
parameters[1] = ClsDll.AddParameter("@mn", mn, SqlDbType.Int, 10);
parameters[2] = ClsDll.AddParameter("@dy", dy, SqlDbType.Int, 10);
parameters[3] = ClsDll.AddParameter("@Details", det, SqlDbType.NVarChar, 500);
ClsDll.ExecuteDTByProcedure("spAddHoliday", parameters);
}
//complain sp
public DataTable GetComplain(int eid)
{
//populate complain
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = ClsDll.AddParameter("@eid", eid, SqlDbType.Int, 10);
DataTable dt = ClsDll.ExecuteDTByProcedure("spGetComplain", parameters);
return(dt);
}
public void InsertComplain(int eid, string sub, string msg, DateTime dt)
{
SqlParameter[] parameters = new SqlParameter[4];
parameters[0] = ClsDll.AddParameter("@eid", eid, SqlDbType.Int, 100);
parameters[1] = ClsDll.AddParameter("@sub", sub, SqlDbType.NVarChar, 10);
parameters[2] = ClsDll.AddParameter("@date", dt, SqlDbType.Date, 10);
parameters[3] = ClsDll.AddParameter("@msg", msg, SqlDbType.NVarChar, 500);
ClsDll.ExecuteDTByProcedure("spInsertComplain", parameters);
}
public int GetEmpByEmail(string em)
{
SqlParameter[] pam = new SqlParameter[1];
pam[0] = ClsDll.AddParameter("@em", em, SqlDbType.VarChar, 100);
DataTable dt = ClsDll.ExecuteDTByProcedure("spGetEmpByEmail", pam);
int str = Convert.ToInt32(dt.Rows[0][0]);
return(str);
}
public void UpdateEmp2()
{
SqlParameter[] pam = new SqlParameter[5];
pam[0] = ClsDll.AddParameter("@pf", Address, SqlDbType.VarChar, 100);
pam[1] = ClsDll.AddParameter("@citp", BankAcN, SqlDbType.VarChar, 100);
pam[2] = ClsDll.AddParameter("@cit", BankName, SqlDbType.VarChar, 100);
pam[3] = ClsDll.AddParameter("@eid", EmpId, SqlDbType.Int, 20);
pam[4] = ClsDll.AddParameter("@rl", Degree, SqlDbType.VarChar, 100);
ClsDll.ExecuteDTByProcedure("spUpdateEmp2", pam);
}
//leave sp
public DataTable GetLeave(String stat)
{
SqlParameter[] parameters = new SqlParameter[3];
parameters[0] = ClsDll.AddParameter("@DeptId", DeptId, SqlDbType.Int, 20);
parameters[1] = ClsDll.AddParameter("@EmpId", EmpId, SqlDbType.Int, 20);
parameters[2] = ClsDll.AddParameter("@Status", stat, SqlDbType.NVarChar, 20);
DataTable dt = ClsDll.ExecuteDTByProcedure("spGetLeave", parameters);
return(dt);
}
