public ReviewerMgmt GetReviewers() { ReviewerMgmt objRm = new ReviewerMgmt("", false); List <Reviewer> reviewers = new List <Reviewer>(); try { using (con = new SqlConnection(conStr)) { con.Open(); using (SqlCommand cmd = new SqlCommand(StaticData.GET_REVIEWERS, con)) { SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { reviewers.Add(new Reviewer() { ReviewerName = Convert.ToString(rdr["ReviewerName"]), IsPrimary = Convert.ToBoolean(rdr["isprimary"]), ReviewerId = Convert.ToString(rdr["reviewerid"]) }); } } } objRm._success = true; objRm.lst = reviewers; } catch (Exception ex) { objRm._message = FinTrackRes.REV_LOAD_ERR; Logger.Log(Logger.LogType.Error, ex.ToString()); } return(objRm); }
public JsonResult GetReviewers() { repository getdata = new repository(); ReviewerMgmt rmgmt = new ReviewerMgmt(); UserViewModel uModel = new UserViewModel(); uModel = getdata.GetUsers(); rmgmt = getdata.GetReviewers(); //remove the users who already have the reviewer role foreach (var p in rmgmt.lst) { if (uModel.lst.Exists(s => s.UserId == p.ReviewerId)) { uModel.lst.Remove(uModel.lst.Single(s => s.UserId == p.ReviewerId)); } } rmgmt.AvailableUsers = uModel.lst; return(Json(rmgmt, JsonRequestBehavior.AllowGet)); }