public List <DashboardModel> RecruitmentSummaryCollegeWise(int recruitmentId) { List <DashboardModel> list = new List <DashboardModel>(); var parameters = new SqlParameter[1]; parameters[0] = new SqlParameter("@Recruitmentid", 1); DataSet ds = SqlHelper.FillDataSet(ConfigurationManager.RdConnectionString, "Get_RecruitmentSummary_CollegeWise", parameters); foreach (DataRow dr in ds.Tables[0].Rows) { DashboardModel model = new DashboardModel(); model.CollegeName = dr["GraduationCollegeName"].ToString(); model.Count = Convert.ToInt32(dr["Count"]); list.Add(model); } return(list.OrderByDescending(x => x.Count).ToList()); }
public List <DashboardModel> InterviewPanelwiseSummaryList(int recruitmentId, string role) { List <DashboardModel> list = new List <DashboardModel>(); var parameters = new SqlParameter[2]; parameters[0] = new SqlParameter("@Recruitmentid", recruitmentId); parameters[1] = new SqlParameter("@Role", role); DataSet ds = SqlHelper.FillDataSet(ConfigurationManager.RdConnectionString, "Get_TechnicalInterviewsPanelwise", parameters); foreach (DataRow dr in ds.Tables[0].Rows) { DashboardModel model = new DashboardModel(); model.InterviewerName = dr["InterviewerName"].ToString(); model.InterviewesTaken = dr["InterviewesTaken"].ToString(); model.Accepted = dr["Accepted"].ToString(); model.Rejected = dr["Rejected"].ToString(); list.Add(model); } return(list); }