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