public ActionResult Index()
{
ViewBag.Title = "Jobs";
ViewBag.MainTitle = "Job Postings";
JobPostingsBO objJobPostingsBO = new JobPostingsBO();
return(View(objJobPostingsBO));
}
public JobPostingsBO ViewJobPosting(int iJobPostingId)
{
DataSet objDataSet = null;
JobPostingsBO objJobPostingsBO = null;
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
ProcParameterBO objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iJobPostingId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iJobPostingId;
objProcParameterBOList.Add(objDbParameter);
objDataSet = objDBAccess.execuitDataSet(ProcViewJobPosting, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0)
{
objJobPostingsBO = new JobPostingsBO();
objJobPostingsBO.JobPostingId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString());
objJobPostingsBO.JobName = objDataSet.Tables[0].Rows[0][1].ToString();
objJobPostingsBO.JobCode = objDataSet.Tables[0].Rows[0][2].ToString();
objJobPostingsBO.JobDescription = objDataSet.Tables[0].Rows[0][3].ToString();
objJobPostingsBO.NoOfPositions = objDataSet.Tables[0].Rows[0][4].ToString();
objJobPostingsBO.JobLocation = objDataSet.Tables[0].Rows[0][5].ToString();
objJobPostingsBO.JobTimings = objDataSet.Tables[0].Rows[0][6].ToString();
objJobPostingsBO.JobDuration = objDataSet.Tables[0].Rows[0][7].ToString();
objJobPostingsBO.Qualification = objDataSet.Tables[0].Rows[0][8].ToString();
objJobPostingsBO.Experience = objDataSet.Tables[0].Rows[0][9].ToString();
objJobPostingsBO.Skills = objDataSet.Tables[0].Rows[0][10].ToString();
objJobPostingsBO.Status = objDataSet.Tables[0].Rows[0][11].ToString();
objJobPostingsBO.ApprovedById = objDataSet.Tables[0].Rows[0][12].ToString();
objJobPostingsBO.ApprovedDate = objDataSet.Tables[0].Rows[0][13].ToString();
objJobPostingsBO.RejectedById = objDataSet.Tables[0].Rows[0][14].ToString();
objJobPostingsBO.RejectedDate = objDataSet.Tables[0].Rows[0][15].ToString();
objJobPostingsBO.MarketedById = Convert.ToInt32(objDataSet.Tables[0].Rows[0][16].ToString());
objJobPostingsBO.MarketedDate = objDataSet.Tables[0].Rows[0][17].ToString();
objJobPostingsBO.Comments = objDataSet.Tables[0].Rows[0][18].ToString();
objJobPostingsBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[0][19].ToString());
objJobPostingsBO.DonorProgramName = objDataSet.Tables[0].Rows[0][20].ToString();
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "ViewJobPosting");
throw ex;
}
return(objJobPostingsBO);
}