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