public JsonResult saveAssociateJob_To_Candidate(List <int> listCandidateIds, List <int> listJoiIds, string comments, int csSubCatId)
{
string msg = null;
int status = 0;
try
{
foreach (var cId in listCandidateIds)
{
AssociateJob_To_Candidate ajc = new AssociateJob_To_Candidate();
ajc.candidateId = Convert.ToInt32(cId);
ajc.crtUserId = MySession.userId;
ajc.comments = comments;
ajc.csSubCatId = csSubCatId;
foreach (var joiId in listJoiIds)
{
ajc.joiId = Convert.ToInt32(joiId);
status += _ajcServ.saveAssociateJob_To_Candidate(ajc);
}
//ajc.joiId
}
msg = status > 0 ? "s" : "f";
}
catch (Exception ex)
{
msg = "Error:" + ex.Message;
}
return(Json(new { msg = msg }, JsonRequestBehavior.AllowGet));
}
public List <AssociateJob_To_Candidate> getAssociateJob_To_Candidate_byCandidateId(int candidateId)
{
_param = new SqlParameter[] { new SqlParameter("@candidateId", candidateId) };
_dt = _sf.returnDTWithProc_executeReader("p_tblAssociateJob_To_Candidate_get_byCandidateId", _param);
List <AssociateJob_To_Candidate> listAJC = new List <AssociateJob_To_Candidate>();
if (_dt.Rows.Count > 0)
{
foreach (DataRow row in _dt.Rows)
{
AssociateJob_To_Candidate ajc = new AssociateJob_To_Candidate();
ajc.clientName = Convert.ToString(row["clientName"]);
ajc.recruitmetLeadName = Convert.ToString(row["recruitmetLeadName"]);
ajc.recruiterName = Convert.ToString(row["recruiterName"]);
ajc.csSubCat = Convert.ToString(row["csSubCat"]);
ajc.currentJobTitle = Convert.ToString(row["currentJobTitle"]);
ajc.positionTile = Convert.ToString(row["positionTile"]);
listAJC.Add(ajc);
}
}
return(listAJC);
}
public int saveAssociateJob_To_Candidate(AssociateJob_To_Candidate ajc)
{
_param = new SqlParameter[] { new SqlParameter("@associateJCId", ajc.associateJCId), new SqlParameter("@joiId", ajc.joiId), new SqlParameter("@candidateId", ajc.candidateId), new SqlParameter("@comments", ajc.comments), new SqlParameter("@crtUserId", ajc.crtUserId), new SqlParameter("@csSubCatId", ajc.csSubCatId) };
return(_sf.executeNonQueryWithProc("p_tblAssociateJob_To_Candidate_save", _param));
}
