public DataSet SetSelectedCandidateDetails(SelectedCandidateBOL objSelectedCandidate)
{
SqlParameter[] param = new SqlParameter[13];
param[0] = new SqlParameter("@CandidateID", SqlDbType.Int);
param[0].Value = objSelectedCandidate.CandidateID;
param[1] = new SqlParameter("@RRFNo", SqlDbType.Int);
param[1].Value = objSelectedCandidate.RRFNo;
param[2] = new SqlParameter("@StageID", SqlDbType.Int);
param[2].Value = objSelectedCandidate.StageID;
param[3] = new SqlParameter("@Action", SqlDbType.Int);
param[3].Value = objSelectedCandidate.Action;
param[4] = new SqlParameter("@CTC", SqlDbType.Decimal);
param[4].Value = objSelectedCandidate.CTC;
//param[5] = new SqlParameter("@other1", SqlDbType.VarChar);
//param[5].Value = objSelectedCandidate.Other1;
//param[6] = new SqlParameter("@other2", SqlDbType.VarChar);
//param[6].Value = objSelectedCandidate.Other2;
param[5] = new SqlParameter("@JoiningDate", SqlDbType.DateTime);
param[5].Value = objSelectedCandidate.JoiningDate;
param[6] = new SqlParameter("@ProbationPeriod", SqlDbType.Int);
param[6].Value = objSelectedCandidate.ProbationPeriod;
param[7] = new SqlParameter("@SelectedComment", SqlDbType.VarChar);
param[7].Value = objSelectedCandidate.SelectedComment;
param[8] = new SqlParameter("@Grade", SqlDbType.VarChar);
param[8].Value = objSelectedCandidate.Grade;
param[9] = new SqlParameter("@OfferedPosition", SqlDbType.Int);
param[9].Value = objSelectedCandidate.OfferedPosition;
param[10] = new SqlParameter("@OfferedEmployementType", SqlDbType.Int);
param[10].Value = objSelectedCandidate.OfferedEmployementType;
param[11] = new SqlParameter("@FeedBackBy", SqlDbType.Int);
param[11].Value = objSelectedCandidate.FeedBackBy;
param[12] = new SqlParameter("@ScheduleId", SqlDbType.Int);
param[12].Value = objSelectedCandidate.ScheduleId;
return(dsGetSelectedCandidateRoundDetails = SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_setSelectedCandidate", param));
}
public DataSet GetDetailsformail(SelectedCandidateBOL objSelectedCandidateBOL)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@RRFID", SqlDbType.Int);
param[0].Value = objSelectedCandidateBOL.RRFNo;
param[1] = new SqlParameter("@ScheduleID", SqlDbType.Int);
param[1].Value = objSelectedCandidateBOL.ScheduleId;
return(dsGetSelectedCandidateRoundDetails = SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_getdetailsformailForFeedbackPage", param));
}
public DataSet GetCandidateScore(SelectedCandidateBOL objSelectedCandidate)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@CandidateID", SqlDbType.Int);
param[0].Value = objSelectedCandidate.CandidateID;
param[1] = new SqlParameter("@RRFNo", SqlDbType.Int);
param[1].Value = objSelectedCandidate.RRFNo;
DataSet dscandidateScore = new DataSet();
return(dscandidateScore = SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_GetCandidateScore", param));
}
public DataSet GetSelectedCandidateRoundDetails(SelectedCandidateBOL objSelectedCandidate)
{
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@CandidateID", SqlDbType.Int);
param[0].Value = objSelectedCandidate.CandidateID;
param[1] = new SqlParameter("@RRFNo", SqlDbType.Int);
param[1].Value = objSelectedCandidate.RRFNo;
param[2] = new SqlParameter("@FeedBackBy", SqlDbType.Int);
param[2].Value = objSelectedCandidate.FeedBackBy;
param[3] = new SqlParameter("@ScheduleId", SqlDbType.Int);
param[3].Value = objSelectedCandidate.ScheduleId;
return(dsGetSelectedCandidateRoundDetails = SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_GetSelectedCandidateRoundDetails", param));
}
public DataSet GetDetailsformail(SelectedCandidateBOL objSelectedCandidateBOL)
{
dsSelectedCandidate = objSelectedCandidateDAL.GetDetailsformail(objSelectedCandidateBOL);
return(dsSelectedCandidate);
}
public DataSet GetCandidateScore(SelectedCandidateBOL objSelectedCandidateBOL)
{
dsSelectedCandidate = objSelectedCandidateDAL.GetCandidateScore(objSelectedCandidateBOL);
return(dsSelectedCandidate);
}
public DataSet SetSelectedCandidate(SelectedCandidateBOL objSelectedCandidateBOL)
{
dsSelectedCandidate = objSelectedCandidateDAL.SetSelectedCandidateDetails(objSelectedCandidateBOL);
return(dsSelectedCandidate);
}
