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