public List <HRInteractionBO> getHRInteractionList() { DataSet objDataSet = null; HRInteractionBO objHRInteractionBO = null; List <HRInteractionBO> objHRInteractionBOList = new List <HRInteractionBO>(); List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>(); try { objDataSet = objDBAccess.execuitDataSet(ProcHRInteractionList, ref objProcParameterBOList); if (objDataSet != null && objDataSet.Tables.Count > 0) { for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++) { objHRInteractionBO = new HRInteractionBO(); objHRInteractionBO.RequestId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString()); objHRInteractionBO.ApplicantName = objDataSet.Tables[0].Rows[i][1].ToString(); objHRInteractionBO.Subject = objDataSet.Tables[0].Rows[i][2].ToString(); objHRInteractionBO.RequestDate = objDataSet.Tables[0].Rows[i][3].ToString(); objHRInteractionBO.ResponseDate = objDataSet.Tables[0].Rows[i][4].ToString(); objHRInteractionBO.Status = objDataSet.Tables[0].Rows[i][5].ToString(); objHRInteractionBO.Comments = objDataSet.Tables[0].Rows[i][6].ToString(); objHRInteractionBOList.Add(objHRInteractionBO); } } } catch (Exception ex) { ExceptionError.Error_Log(ex, "getHRInteractionList"); throw ex; } return(objHRInteractionBOList); }
public ActionResult ViewHRInteractionList(int iRequestId) { HRInteractionBAL objHRInteractionBAL = new HRInteractionBAL(); HRInteractionBO objHRInteractionBO = objHRInteractionBAL.DisplayHRDetails(iRequestId); return(PartialView("ViewHRInteraction", objHRInteractionBO)); }
public ActionResult EditHRInteraction(int iRequestId) { HRInteractionBAL objHRInteractionBAL = new HRInteractionBAL(); HRInteractionBO objHRInteractionBO = objHRInteractionBAL.EditHRInteraction(iRequestId); return(View("EditHRInteraction", objHRInteractionBO)); }
public ActionResult Index() { ViewBag.Title = "Applicants"; ViewBag.MainTitle = "HR Interaction"; ViewBag.Icon = "fa fa-user"; HRInteractionBO objHRInteractionBO = new HRInteractionBO(); return(View(objHRInteractionBO)); }
public JsonResult SaveHRReply(HRInteractionBO Data) { HRInteractionBAL objHRInteractionBAL = new HRInteractionBAL(); Data.IsActive = true; Data.StatusId = 2; string strResult = objHRInteractionBAL.SaveHRReply(Data, Convert.ToInt32(ViewData["LoginUserId"])); return(Json(strResult, JsonRequestBehavior.AllowGet)); }
public ActionResult CreateHRInteraction() { ViewBag.Title = "Applicants"; ViewBag.MainTitle = "HR Interaction"; ViewBag.Icon = "fa fa-user"; HRInteractionBAL objHRInteractionBAL = new HRInteractionBAL(); HRInteractionBO objHRInteractionBO = new HRInteractionBO(); return(View("AddHRInteraction", objHRInteractionBO)); }
public HRInteractionBO EditHRInteraction(int iRequestId) { DataSet objDataSet = null; HRInteractionBO objHRInteractionBO = null; List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>(); try { ProcParameterBO objDbParameter = new ProcParameterBO(); objDbParameter.Direction = ParameterDirection.Input; objDbParameter.ParameterName = "@iRequestId"; objDbParameter.dbType = DbType.Int32; objDbParameter.ParameterValue = iRequestId; objProcParameterBOList.Add(objDbParameter); objDataSet = objDBAccess.execuitDataSet(ProcEditHRInteraction, ref objProcParameterBOList); if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0) { objHRInteractionBO = new HRInteractionBO(); objHRInteractionBO.RequestId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString()); objHRInteractionBO.ApplicantName = objDataSet.Tables[0].Rows[0][1].ToString(); objHRInteractionBO.EmailId = objDataSet.Tables[0].Rows[0][2].ToString(); objHRInteractionBO.Subject = objDataSet.Tables[0].Rows[0][3].ToString(); objHRInteractionBO.Description = objDataSet.Tables[0].Rows[0][4].ToString(); objHRInteractionBO.RequestDate = objDataSet.Tables[0].Rows[0][5].ToString(); objHRInteractionBO.ResponseDate = objDataSet.Tables[0].Rows[0][6].ToString(); objHRInteractionBO.Comments = objDataSet.Tables[0].Rows[0][7].ToString(); objHRInteractionBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[0][8].ToString()); } } catch (Exception ex) { ExceptionError.Error_Log(ex, "EditHRInteraction"); throw ex; } return(objHRInteractionBO); }
public string SaveHRReply(HRInteractionBO objHRInteractionBO, int iUserId) { return(objHRInteractionDAL.SaveHRReply(objHRInteractionBO, iUserId)); }
public string SaveHRInteraction(HRInteractionBO objHRInteractionBO, int iUserId) { List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>(); ProcParameterBO objDBparameter = null; string strResult = ""; try { objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iRequestId"; objDBparameter.dbType = DbType.Int32; objDBparameter.ParameterValue = objHRInteractionBO.RequestId; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strApplicantName"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objHRInteractionBO.ApplicantName; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strEmailId"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objHRInteractionBO.EmailId; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strSubject"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objHRInteractionBO.Subject; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strDescription"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objHRInteractionBO.Description; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strRequestDate"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objHRInteractionBO.RequestDate; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iStatusId"; objDBparameter.dbType = DbType.Int32; objDBparameter.ParameterValue = objHRInteractionBO.StatusId; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@bIsActive"; objDBparameter.dbType = DbType.Boolean; objDBparameter.ParameterValue = objHRInteractionBO.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(ProcSaveHRInteraction, 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, "SaveHRInteraction"); strResult = "FAILED"; throw ex; } return(strResult); }