public int InsertVacancyDetails(clsVacancy objclVacancy)
{
Hashtable htparams = new Hashtable
{
{ "invacancyId", objclVacancy.vacancyId },
{ "inJobTitle", objclVacancy.JobTitle },
{ "inVacancyName", objclVacancy.VacancyName },
{ "inHiringManager", objclVacancy.HiringManager },
{ "inNoOfPositions", objclVacancy.NoOfPositions },
{ "inDescription", objclVacancy.Description },
{ "inActive", objclVacancy.Active },
{ "inActiveText", objclVacancy.ActiveText },
{ "inUserDefinedFlag", objclVacancy.UserDefinedFlag },
{ "inUserDefinedText", objclVacancy.UserDefinedText },
{ "inUserDefinedFlag1", objclVacancy.UserDefinedFlag1 },
{ "inUserDefinedText1", objclVacancy.UserDefinedText1 },
{ "inUserDefinedFlag2", objclVacancy.UserDefinedFlag2 },
{ "inUserDefinedText2", objclVacancy.UserDefinedText2 },
{ "inUserDefinedFlag3", objclVacancy.UserDefinedFlag3 },
{ "inUserDefinedText3", objclVacancy.UserDefinedText3 },
{ "in_OpName", objclVacancy.OpName },
};
return(ExecuteNonQuery("vacancy_insert_update", htparams));
}
public DataSet GetVacancyList(clsVacancy objVacancyList)
{
Hashtable htparams = new Hashtable
{
{ "invacancyId", objVacancyList.vacancyId },
{ "inJobTitle", objVacancyList.JobTitle },
{ "inVacancyName", objVacancyList.VacancyName },
{ "inHiringManager", objVacancyList.HiringManager },
{ "inNoOfPositions", objVacancyList.NoOfPositions },
{ "inDescription", objVacancyList.Description },
{ "inActive", objVacancyList.Active },
{ "inActiveText", objVacancyList.ActiveText },
{ "inUserDefinedFlag", objVacancyList.UserDefinedFlag },
{ "inUserDefinedText", objVacancyList.UserDefinedText },
{ "inUserDefinedFlag1", objVacancyList.UserDefinedFlag1 },
{ "inUserDefinedText1", objVacancyList.UserDefinedText1 },
{ "inUserDefinedFlag2", objVacancyList.UserDefinedFlag2 },
{ "inUserDefinedText2", objVacancyList.UserDefinedText2 },
{ "inUserDefinedFlag3", objVacancyList.UserDefinedFlag3 },
{ "inUserDefinedText3", objVacancyList.UserDefinedText3 },
{ "in_OpName", objVacancyList.OpName },
};
return(ExecuteDataSet("vacancy_insert_update", htparams));
}
public DataSet GetVacancy(clsVacancy objclVacancy)
{
Hashtable htparams = new Hashtable
{
{ "invacancyId", objclVacancy.vacancyId },
{ "inVacancyName", objclVacancy.VacancyName },
};
return(ExecuteDataSet("get_vacancy", htparams));
}