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