public DataSet GetDetailsformail(RescheduledBOL objRescheduledBOL)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@RRFID", SqlDbType.Int);
param[0].Value = objRescheduledBOL.RRFNo;
return(ds = SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_getdetailsformail", param));
}
public DataSet SetCandidateSchecule(RescheduledBOL mod, int RoundNumber)
{
SqlParameter[] param = new SqlParameter[9];
param[0] = new SqlParameter("@CandidateId", SqlDbType.VarChar);
param[0].Value = mod.CandidateID;
param[1] = new SqlParameter("@RRFNo", SqlDbType.Int);
param[1].Value = mod.RRFNo;
param[2] = new SqlParameter("@Stage", SqlDbType.VarChar);
param[2].Value = mod.Stage;
param[3] = new SqlParameter("@ScheduledDateTime", SqlDbType.DateTime);
param[3].Value = mod.ScheduledDateTime;
//param[4] = new SqlParameter("@Position", SqlDbType.VarChar);
//param[4].Value = mod.Position;
//param[5] = new SqlParameter("@PostedDate", SqlDbType.DateTime);
//param[5].Value = mod.PostedDate;
//param[5] = new SqlParameter("@Requestor", SqlDbType.VarChar);
//param[5].Value = mod.Requestor;
param[4] = new SqlParameter("@InterviewerName", SqlDbType.VarChar);
param[4].Value = mod.InterviewerName;
param[5] = new SqlParameter("@ScheduledBy", SqlDbType.Int);
param[5].Value = mod.ScheduledBy;
param[6] = new SqlParameter("@Reschedule", SqlDbType.VarChar);
param[6].Value = mod.RescheduledBy;
param[7] = new SqlParameter("@RescheduleReason", SqlDbType.VarChar);
param[7].Value = mod.RescheduledReason;
param[8] = new SqlParameter("@RowNumberForReschedule", SqlDbType.Int);
param[8].Value = RoundNumber;
return(ds = SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_SetCandidateSchedule", param));
}
public DataSet GetDetailsformail(RescheduledBOL objRescheduledBOL)
{
dsRBOLDataset = dal.GetDetailsformail(objRescheduledBOL);
return(dsRBOLDataset);
}
public DataSet SetCandidateSchecule(RescheduledBOL mod, int Roundnumber)
{
dsRBOLDataset = dal.SetCandidateSchecule(mod, Roundnumber);
return(dsRBOLDataset);
}