public SummaryDashboardDTO GetSummaryDashboardPM(string team, string Deartment)
{
SummaryDashboardDTO getSummary = new SummaryDashboardDTO();
var countNewByDepartment = Context.ApplicantProfile.Where(x => x.Position == Deartment).GroupBy(i => i.StatusApplicant).Select(i => new { Word = i.Key, Count = i.Count() });
foreach (var item in countNewByDepartment)
{
if (item.Word == "Pass_HR") // ผู้สมัครใหม่
{
getSummary.Total_NewApplicantPM = item.Count;
}
}
var grouped = Context.ApplicantProfile.Where(x => x.Team == team).GroupBy(i => i.StatusApplicant).Select(i => new { Word = i.Key, Count = i.Count() });
foreach (var item in grouped)
{
if (item.Word == "Contact_Inte") //รอประเมิณการสัมภาษณ์
{
getSummary.Total_waitInterview += item.Count;
}
if (item.Word == "Interview_P") //รอกำหนดข้อตกลง
{
getSummary.Total_WaitaAgreement = item.Count;
}
}
return(getSummary);
}
public SummaryDashboardDTO GetSummaryDashboard()
{
SummaryDashboardDTO getSummary = new SummaryDashboardDTO();
var grouped = Context.ApplicantProfile.GroupBy(i => i.StatusApplicant).Select(i => new { Word = i.Key, Count = i.Count() });
foreach (var item in grouped)
{
if (item.Word == "New") // ผู้สมัครใหม่
{
getSummary.Total_NewApplicant = item.Count;
}
if (item.Word == "Contact_Cnot" || item.Word == "Pass_PM") //ยังไม่ได้ติดต่อ
{
getSummary.Total_WaitContact += item.Count;
}
if (item.Word == "Contact_Inte") //รอผลสัมภาษณ์
{
getSummary.Total_WaitInterviewResult = item.Count;
}
if (item.Word == "Agreemented" || item.Word == "Interview_C" || item.Word == "Interview_N") //รอการแจ้งผล
{
getSummary.Total_WaitResult += item.Count;
}
}
return(getSummary);
}
