public ActionResult ViewHRAllJob(int iJobPostingId)
{
HROfficeBAL objHROfficeBAL = new HROfficeBAL();
AllJobsBO objAllJobsBO = objHROfficeBAL.DisplayHRAllJob(iJobPostingId);
return(PartialView("ViewHRJobs", objAllJobsBO));
}
public List <AllJobsBO> getHOPUpdateGridList()
{
DataSet objDataSet = null;
AllJobsBO objAllJobsBO = null;
List <AllJobsBO> objAllJobsBOList = new List <AllJobsBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDBAccess.execuitDataSet(ProHOPUpdateGrid, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objAllJobsBO = new AllJobsBO();
objAllJobsBO.JobPostingId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objAllJobsBO.JobName = objDataSet.Tables[0].Rows[i][1].ToString();
objAllJobsBO.JobDescription = objDataSet.Tables[0].Rows[i][2].ToString();
objAllJobsBO.JobLocation = objDataSet.Tables[0].Rows[i][3].ToString();
objAllJobsBO.NoOfPositions = objDataSet.Tables[0].Rows[i][4].ToString();
objAllJobsBO.Status = objDataSet.Tables[0].Rows[i][5].ToString();
objAllJobsBO.ApprovedBy = Convert.ToInt32(objDataSet.Tables[0].Rows[i][6].ToString());
objAllJobsBO.RejectedBy = Convert.ToInt32(objDataSet.Tables[0].Rows[i][7].ToString());
objAllJobsBO.HROffice_Comments = objDataSet.Tables[0].Rows[i][8].ToString();
objAllJobsBOList.Add(objAllJobsBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getHOPUpdateGridList");
throw ex;
}
return(objAllJobsBOList);
}
public ActionResult EditHROfficeGrid(AllJobsBO Data, int iJobPostingId)
{
HROfficeBAL objHROfficeBAL = new HROfficeBAL();
AllJobsBO objAllJobsBO = objHROfficeBAL.EditHROfficeGrid(iJobPostingId);
objAllJobsBO.DonorProgrammList = objHROfficeBAL.GetDropDownDonorProgramList(Convert.ToInt32(ViewData["LoginUserId"]));
return(PartialView("EditGrid", objAllJobsBO));
}
public JsonResult SaveOnHoldJob(AllJobsBO Data)
{
AllJobsBAL objAllJobsBAL = new AllJobsBAL();
string strRoleName = ViewData["LoginRoleName"].ToString().ToUpper();
string strResult = objAllJobsBAL.SaveOnHoldJob(Data, Convert.ToInt32(ViewData["LoginUserId"]), strRoleName);
return(Json(strResult, JsonRequestBehavior.AllowGet));
}
public JsonResult SavePMApprovedJob(AllJobsBO Data)
{
PMUpdateBAL objPMUpdateBAL = new PMUpdateBAL();
Data.IsActive = true;
string strResult = objPMUpdateBAL.SavePMApprovedJob(Data, Convert.ToInt32(ViewData["LoginUserId"]));
return(Json(strResult, JsonRequestBehavior.AllowGet));
}
public ActionResult EditPMUpdateGrid(AllJobsBO Data, int iJobPostingId)
{
ApprovedJobsBAL objApprovedJobsBAL = new ApprovedJobsBAL();
AllJobsBAL objAllJobsBAL = new AllJobsBAL();
ApprovedJobsBO objJobsBO = objApprovedJobsBAL.DisplayApprovedJob(iJobPostingId);
objJobsBO.DonorProgramList = objAllJobsBAL.DonorProgramList(Convert.ToInt32(ViewData["LoginUserId"]));
return(PartialView("EditPMGrid", objJobsBO));
}
// GET: HROffice
public ActionResult Index()
{
ViewBag.MainTitle = "All Jobs";
ViewBag.Title = "HR Office";
ViewBag.Icon = "fa fa-graduation";
AllJobsBO objAllJobsBO = new AllJobsBO();
return(View(objAllJobsBO));
}
public JsonResult SaveHRApprovedJob(AllJobsBO Data)
{
HROfficeBAL objHROfficeBAL = new HROfficeBAL();
Data.HRStatus = 1;
Data.IsActive = true;
string strResult = objHROfficeBAL.SaveHRApprovedJob(Data, Convert.ToInt32(ViewData["LoginUserId"]), 1);
return(Json(strResult, JsonRequestBehavior.AllowGet));
}
public JsonResult SaveHRRejectedJob(AllJobsBO Data)
{
HROfficeBAL objHROfficeBAL = new HROfficeBAL();
Data.StatusId = 3;
Data.HRStatus = 2;
Data.IsActive = true;
string strResult = objHROfficeBAL.SaveHRRejectedJob(Data, 1);
return(Json(strResult, JsonRequestBehavior.AllowGet));
}
public AllJobsBO EditPMGrid(int iJobPostingId)
{
DataSet objDataSet = null;
AllJobsBO objAllJobsBO = 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(ProcEditPMJob, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0)
{
objAllJobsBO = new AllJobsBO();
objAllJobsBO.JobPostingId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString());
objAllJobsBO.JobName = objDataSet.Tables[0].Rows[0][1].ToString();
objAllJobsBO.JobCode = objDataSet.Tables[0].Rows[0][2].ToString();
objAllJobsBO.JobDescription = objDataSet.Tables[0].Rows[0][3].ToString();
objAllJobsBO.NoOfPositions = objDataSet.Tables[0].Rows[0][4].ToString();
objAllJobsBO.JobLocation = objDataSet.Tables[0].Rows[0][5].ToString();
objAllJobsBO.JobTimings = objDataSet.Tables[0].Rows[0][6].ToString();
objAllJobsBO.JobDuration = objDataSet.Tables[0].Rows[0][7].ToString();
objAllJobsBO.Qualification = objDataSet.Tables[0].Rows[0][8].ToString();
objAllJobsBO.Experience = objDataSet.Tables[0].Rows[0][9].ToString();
objAllJobsBO.Skills = objDataSet.Tables[0].Rows[0][10].ToString();
objAllJobsBO.Status = objDataSet.Tables[0].Rows[0][11].ToString();
objAllJobsBO.ApprovedById = objDataSet.Tables[0].Rows[0][12].ToString();
objAllJobsBO.ApprovedDate = objDataSet.Tables[0].Rows[0][13].ToString();
objAllJobsBO.RejectedById = objDataSet.Tables[0].Rows[0][14].ToString();
objAllJobsBO.RejectedDate = objDataSet.Tables[0].Rows[0][15].ToString();
objAllJobsBO.MarketedBy = objDataSet.Tables[0].Rows[0][16].ToString();
objAllJobsBO.MarketedDate = objDataSet.Tables[0].Rows[0][17].ToString();
objAllJobsBO.HROffice_Comments = objDataSet.Tables[0].Rows[0][18].ToString();
objAllJobsBO.HOP_Comments = objDataSet.Tables[0].Rows[0][19].ToString();
objAllJobsBO.PM_Comments = objDataSet.Tables[0].Rows[0][20].ToString();
objAllJobsBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[0][21].ToString());
objAllJobsBO.DonorProgramId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][22].ToString());
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "EditPMGrid");
throw ex;
}
return(objAllJobsBO);
}
public AllJobsBO DisplayPMAllJob(int iJobPostingId)
{
DataSet objDataSet = null;
AllJobsBO objAllJobsBO = 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(ProcPMViewAllJob, ref ObjProcParameterBOList);
if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0)
{
objAllJobsBO = new AllJobsBO();
objAllJobsBO.JobName = objDataSet.Tables[0].Rows[0][0].ToString();
objAllJobsBO.JobCode = objDataSet.Tables[0].Rows[0][1].ToString();
objAllJobsBO.JobDescription = objDataSet.Tables[0].Rows[0][2].ToString();
objAllJobsBO.NoOfPositions = objDataSet.Tables[0].Rows[0][3].ToString();
objAllJobsBO.JobLocation = objDataSet.Tables[0].Rows[0][4].ToString();
objAllJobsBO.JobTimings = objDataSet.Tables[0].Rows[0][5].ToString();
objAllJobsBO.JobDuration = objDataSet.Tables[0].Rows[0][6].ToString();
objAllJobsBO.DonorProgramName = objDataSet.Tables[0].Rows[0][7].ToString();
objAllJobsBO.Qualification = objDataSet.Tables[0].Rows[0][8].ToString();
objAllJobsBO.Experience = objDataSet.Tables[0].Rows[0][9].ToString();
objAllJobsBO.Skills = objDataSet.Tables[0].Rows[0][10].ToString();
objAllJobsBO.Status = objDataSet.Tables[0].Rows[0][11].ToString();
objAllJobsBO.HROffice_Comments = objDataSet.Tables[0].Rows[0][12].ToString();
objAllJobsBO.HOP_Comments = objDataSet.Tables[0].Rows[0][13].ToString();
objAllJobsBO.PM_Comments = objDataSet.Tables[0].Rows[0][14].ToString();
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "DisplayPMAllJob");
throw ex;
}
return(objAllJobsBO);
}
public JsonResult SaveApprovedJob(AllJobsBO Data)
{
AllJobsBAL objAllJobsBAL = new AllJobsBAL();
int iRoleId = Convert.ToInt32(ViewData["LoginRoleId"]);
string strResult = objAllJobsBAL.SaveApprovedJob(Data, Convert.ToInt32(ViewData["LoginUserId"]), iRoleId);
if (ViewData["LoginRoleName"].ToString().ToUpper() == "HR OFFICE")
{
List <string> usersList = objAllJobsBAL.GetHOPPMHAFUsersList();
string strEmailBody = "";
if (usersList.Count > 0)
{
strEmailBody = getHROfficeEmailBodyforJobPosted();
CommonUtils.SendEmail(strSenderEmailAddress, usersList, "New Job Approval Request", strEmailBody);
}
}
else if (ViewData["LoginRoleName"].ToString().ToUpper() == "HAF")
{
List <string> usersList = objAllJobsBAL.GetEDUsersList();
string strEmailBody = "";
if (usersList.Count > 0)
{
strEmailBody = getHAFEmailBodyforJobPosted();
CommonUtils.SendEmail(strSenderEmailAddress, usersList, "New Job Approval Request", strEmailBody);
}
}
else if (ViewData["LoginRoleName"].ToString().ToUpper() == "ED")
{
List <string> usersList = objAllJobsBAL.GetMarketerUsersList();
string strEmailBody = "";
if (usersList.Count > 0)
{
strEmailBody = getEDEmailBodyforJobPosted();
CommonUtils.SendEmail(strSenderEmailAddress, usersList, "New Job Approval Request", strEmailBody);
}
}
return(Json(strResult, JsonRequestBehavior.AllowGet));
}
public string SaveHRApprovedJob(AllJobsBO objAllJobsBO, int iUserId, int iStatusId)
{
return(objHROfficeDAL.SaveHRApprovedJob(objAllJobsBO, iUserId, iStatusId));
}
public string SaveApprovedJob(AllJobsBO objAllJobsBO, int iUserId, int iRoleId)
{
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
ProcParameterBO objDBparameter = null;
string strResult = "";
try
{
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iRoleId";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = iRoleId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iJobPostingId";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = objAllJobsBO.JobPostingId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strJobName";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.JobName;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strJobCode";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.JobCode;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strJobDescription";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.JobDescription;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iNoOfPositions";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.NoOfPositions;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strJobLocation";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.JobLocation;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strJobTimings";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.JobTimings;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strJobDuration";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.JobDuration;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strQualification";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.Qualification;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strExperience";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.Experience;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strSkills";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.Skills;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strComments";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.Comments;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iDonorProgrammId";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = objAllJobsBO.DonorProgramId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iRequiredStaffLevel";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.RequiredStaffLevel;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iCurrentStaffLevel";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.CurrentStaffLevel;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iGaps";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.Gaps;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iUserId";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = iUserId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Output;
objDBparameter.ParameterName = "@strResult";
objDBparameter.dbType = DbType.String;
objDBparameter.Size = 100;
objProcParameterBOList.Add(objDBparameter);
objDBAccess.executeNonQuery(ProcSaveApprovedJob, ref objProcParameterBOList);
for (int i = 0; i < objProcParameterBOList.Count; i++)
{
if (objProcParameterBOList[i].Direction == ParameterDirection.Output)
{
strResult = objProcParameterBOList[i].ParameterValue.ToString();
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "SaveApprovedJob");
strResult = "FAILED";
throw ex;
}
return(strResult);
}
public string SaveHRRejectedJob(AllJobsBO objAllJobsBO, int iUserId)
{
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
ProcParameterBO objDBparameter = null;
string strResult = "";
try
{
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iJobPostingId";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = objAllJobsBO.JobPostingId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strJobName";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.JobName;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strJobCode";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.JobCode;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strJobDescription";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.JobDescription;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iNoOfPositions";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.NoOfPositions;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iDonorProgramId";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = objAllJobsBO.DonorProgramId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strJobLocation";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.JobLocation;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strJobTimings";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.JobTimings;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strJobDuration";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.JobDuration;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strQualification";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.Qualification;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strExperience";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.Experience;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strSkills";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.Skills;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strStatusId";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = objAllJobsBO.StatusId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@ApprovedDate";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.ApprovedDate;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iRejectedBy";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = objAllJobsBO.RejectedBy;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@RejectedDate";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.RejectedDate;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iMarketedBy";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = objAllJobsBO.MarketedBy;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@MarketedDate";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.MarketedDate;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strHROffice_Comments";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.HROffice_Comments;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iHRStatus";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = objAllJobsBO.HRStatus;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@bIsActive";
objDBparameter.dbType = DbType.Boolean;
objDBparameter.ParameterValue = objAllJobsBO.IsActive;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iUserId";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = iUserId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Output;
objDBparameter.ParameterName = "@strResult";
objDBparameter.dbType = DbType.String;
objDBparameter.Size = 100;
objProcParameterBOList.Add(objDBparameter);
objDBAccess.executeNonQuery(ProcHRRejectedJob, ref objProcParameterBOList);
for (int i = 0; i < objProcParameterBOList.Count; i++)
{
if (objProcParameterBOList[i].Direction == ParameterDirection.Output)
{
strResult = objProcParameterBOList[i].ParameterValue.ToString();
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "SaveHRRejectedJob");
strResult = "FAILED";
throw ex;
}
return(strResult);
}
public string SavePMApprovedJob(AllJobsBO objAllJobsBO, int iUserId)
{
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
ProcParameterBO objDBparameter = null;
string strResult = "";
try
{
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iJobPostingId";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = objAllJobsBO.JobPostingId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strPM_Comments";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objAllJobsBO.PM_Comments;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@bIsActive";
objDBparameter.dbType = DbType.Boolean;
objDBparameter.ParameterValue = objAllJobsBO.IsActive;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iUserId";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = iUserId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Output;
objDBparameter.ParameterName = "@strResult";
objDBparameter.dbType = DbType.String;
objDBparameter.Size = 100;
objProcParameterBOList.Add(objDBparameter);
objDBAccess.executeNonQuery(ProcSavePMApprovedJob, ref objProcParameterBOList);
for (int i = 0; i < objProcParameterBOList.Count; i++)
{
if (objProcParameterBOList[i].Direction == ParameterDirection.Output)
{
strResult = objProcParameterBOList[i].ParameterValue.ToString();
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "SavePMApprovedJob");
strResult = "FAILED";
throw ex;
}
return(strResult);
}
public string SaveHRRejectedJob(AllJobsBO objAllJobsBO, int iUserId)
{
return(objHROfficeDAL.SaveHRRejectedJob(objAllJobsBO, iUserId));
}
public string SaveOnHoldJob(AllJobsBO objAllJobsBO, int iUserId, string strRoleName)
{
return(objAllJobsDAL.SaveOnHoldJob(objAllJobsBO, iUserId, strRoleName));
}
public string SaveHOPApprovedJob(AllJobsBO objAllJobsBO, int iUserId)
{
return(objHOPUpdateDAL.SaveHOPApprovedJob(objAllJobsBO, iUserId));
}
public string SaveRejectedJob(AllJobsBO objAllJobsBO, int iUserId, int iRoleId)
{
return(objAllJobsDAL.SaveRejectedJob(objAllJobsBO, iUserId, iRoleId));
}
