public DataSet DeleteCandidate(CandidateDataBankBOL objCandidateDataBankBOL)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.BigInt);
param[0].Value = objCandidateDataBankBOL.CandidateID;
return(SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_DeleteCandidate", param));
}
public DataSet DeleteCandidate(CandidateDataBankBOL objCandidateDataBankBOL)
{
dsCandidateDetails = objCandidateDataBankDAL.DeleteCandidate(objCandidateDataBankBOL);
return(dsCandidateDetails);
}
public DataSet DeleteCandidateExperienceDetailsByCandidateID(CandidateDataBankBOL objCandidateDataBankBOL)
{
dsCandidateDetails = objCandidateDataBankDAL.DeleteCandidateExperienceDetailsByCandidateID(objCandidateDataBankBOL);
return(dsCandidateDetails);
}
public DataSet DeleteCandidateCertificationDetailsByCandidateID(CandidateDataBankBOL objCandidateDataBankBOL)
{
dsCandidateDetails = objCandidateDataBankDAL.DeleteCandidateCertificationDetailsByCandidateID(objCandidateDataBankBOL);
return(dsCandidateDetails);
}
public DataSet GetCandidateSearchResults(CandidateDataBankBOL objCandidateDataBankBOL)
{
dsCandidateDetails = objCandidateDataBankDAL.GetCandidateSearchResults(objCandidateDataBankBOL);
return(dsCandidateDetails);
}
public DataSet GetCandidateSearchResults(CandidateDataBankBOL objCandidateDataBankBOL)
{
SqlParameter[] param = new SqlParameter[8];
param[0] = new SqlParameter("@name", SqlDbType.VarChar);
if (objCandidateDataBankBOL.FirstName != null)
{
param[0].Value = objCandidateDataBankBOL.FirstName;
}
else
{
param[0].Value = DBNull.Value;
}
//param[1] = new SqlParameter("@work_ex", SqlDbType.VarChar);
//if (candidatemodel.WorkExp!= null)
//param[1].Value = candidatemodel.WorkExp;
//else
//param[1].Value = DBNull.Value;
param[1] = new SqlParameter("@years", SqlDbType.Int);
if (objCandidateDataBankBOL.Years != -1)
{
param[1].Value = objCandidateDataBankBOL.Years;
}
else
{
param[1].Value = DBNull.Value;
}
param[2] = new SqlParameter("@uptoyears", SqlDbType.Int);
if (objCandidateDataBankBOL.UptoYears != -1)
{
param[2].Value = objCandidateDataBankBOL.UptoYears;
}
else
{
param[2].Value = DBNull.Value;
}
param[3] = new SqlParameter("@qualification", SqlDbType.Int);
if (objCandidateDataBankBOL.Qualifications != -1)
{
param[3].Value = objCandidateDataBankBOL.Qualifications;
}
else
{
param[3].Value = DBNull.Value;
}
param[4] = new SqlParameter("@notice", SqlDbType.Int);
if (objCandidateDataBankBOL.NoticePeriod != -1)
{
param[4].Value = objCandidateDataBankBOL.NoticePeriod;
}
else
{
param[4].Value = DBNull.Value;
}
param[5] = new SqlParameter("@status", SqlDbType.Int);
if (objCandidateDataBankBOL.Status != -1)
{
param[5].Value = objCandidateDataBankBOL.Status;
}
else
{
param[5].Value = DBNull.Value;
}
param[6] = new SqlParameter("@SearchMode", SqlDbType.VarChar);
param[6].Value = "SearchForDataBank";
param[7] = new SqlParameter("@RRFID", SqlDbType.Int);
param[7].Value = DBNull.Value;
return(SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_GetCandidateSearchResults", param));
}