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); }