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);
}
