public ActionResult Reports()
{
#region Registered Students
ReportsRepository _objRepo = new ReportsRepository();
DataSet _ds = _objRepo.SELECT_PHASE2_KPI_REGISTERED_STUDENTS("Count");
ViewBag.RegisteredStudents = 0;
ViewBag.ParticipatedCountries = 0;
ViewBag.ConsideredStudents = 0;
ViewBag.AllottedStudents = 0;
if (_ds != null)
{
DataRow _dr = _ds.Tables[0].Rows[0];
ViewBag.RegisteredStudents = _dr["Counts"].ToString();
ViewBag.ParticipatedCountries = _dr["Country"].ToString();
ViewBag.ConsideredStudents = _dr["Considered"].ToString();
ViewBag.AllottedStudents = _dr["Allotted"].ToString();
}
#endregion
#region Counselling_Overview
ReportsRepository _objRepoC = new ReportsRepository();
DataSet _dsC = _objRepo.SELECT_PHASE2_KPI_Counselling_Overview("Count");
ViewBag.UG_SeatAlloted = 0;
ViewBag.PG_SeatAlloted = 0;
ViewBag.PHD_SeatAlloted = 0;
ViewBag.UG_NoSeatAlloted = 0;
ViewBag.PG_NoSeatAlloted = 0;
ViewBag.PHD_NoSeatAlloted = 0;
ViewBag.UG_NoSeatAlloted_Common = 0;
ViewBag.PG_NoSeatAlloted_Common = 0;
ViewBag.PHD_NoSeatAlloted_Common = 0;
ViewBag.UG_ConsiderStudent = 0;
ViewBag.PG_ConsiderStudent = 0;
ViewBag.PHD_ConsiderStudent = 0;
ViewBag.TotalSc = 0;
ViewBag.TotalSIISc_PG = 0;
ViewBag.TotalSIISc_UG = 0;
ViewBag.TotalAfricaSc_PG = 0;
ViewBag.TotalAfricaSc_UG = 0;
ViewBag.TotalCountrySc_UG = 0;
ViewBag.TotalCountrySc_PG = 0;
ViewBag.TotalCountrySc = 0;
ViewBag.UG2_SeatAlloted = 0;
ViewBag.UG2_ConsiderStudent = 0;
ViewBag.UG2_NoSeatAlloted = 0;
ViewBag.UG2_NoSeatAlloted_Common = 0;
if (_dsC != null)
{
DataRow _drC = _dsC.Tables[0].Rows[0];
ViewBag.UG_SeatAlloted = _drC["UG_SeatAlloted"].ToString();
ViewBag.PG_SeatAlloted = _drC["PG_SeatAlloted"].ToString();
ViewBag.PHD_SeatAlloted = _drC["PHD_SeatAlloted"].ToString();
ViewBag.UG_NoSeatAlloted = _drC["UG_NoSeatAlloted"].ToString();
ViewBag.PG_NoSeatAlloted = _drC["PG_NoSeatAlloted"].ToString();
ViewBag.PHD_NoSeatAlloted = _drC["PHD_NoSeatAlloted"].ToString();
ViewBag.UG_NoSeatAlloted_Common = _drC["UG_NoSeatAlloted_Common"].ToString();
ViewBag.PG_NoSeatAlloted_Common = _drC["PG_NoSeatAlloted_Common"].ToString();
ViewBag.PHD_NoSeatAlloted_Common = _drC["PHD_NoSeatAlloted_Common"].ToString();
ViewBag.UG_ConsiderStudent = _drC["UG_ConsiderStudent"].ToString();
ViewBag.PG_ConsiderStudent = _drC["PG_ConsiderStudent"].ToString();
ViewBag.PHD_ConsiderStudent = _drC["PHD_ConsiderStudent"].ToString();
ViewBag.TotalSc = _drC["TotalSc"].ToString();;
ViewBag.TotalSIISc_PG = _drC["TotalSIISc_PG"].ToString();;
ViewBag.TotalSIISc_UG = _drC["TotalSIISc_UG"].ToString();;
ViewBag.TotalAfricaSc_PG = _drC["TotalAfricaSc_PG"].ToString();;
ViewBag.TotalAfricaSc_UG = _drC["TotalAfricaSc_UG"].ToString();;
ViewBag.TotalCountrySc_UG = _drC["TotalCountrySc_UG"].ToString();;
ViewBag.TotalCountrySc_PG = _drC["TotalCountrySc_PG"].ToString();;
ViewBag.TotalCountrySc = _drC["TotalCountrySc"].ToString();;
ViewBag.UG2_SeatAlloted = _drC["UG2_SeatAlloted"].ToString();;
ViewBag.UG2_ConsiderStudent = _drC["UG2_ConsiderStudent"].ToString();;
ViewBag.UG2_NoSeatAlloted = _drC["UG2_NoSeatAlloted"].ToString();;
ViewBag.UG2_NoSeatAlloted_Common = _drC["UG2_NoSeatAlloted_Common"].ToString();;
}
#endregion
#region INSTITUTE OVERVIEW
ReportsRepository _objRepo_ = new ReportsRepository();
DataSet _ds_ = _objRepo.SELECT_PHASE2_KPI_Institute_Overview_("Count");
ViewBag.Regint = 0;
ViewBag.Allotedint = 0;
ViewBag.AproveStudent = 0;
ViewBag.OfferAcept = 0;
ViewBag.AdmittedStudents = 0;
ViewBag.TotalCourse = 0;
ViewBag.TotalSeat = 0;
ViewBag.InsRejectTotal = 0;
ViewBag.InsRejectUG = 0;
ViewBag.InsRejectPG = 0;
ViewBag.InsRejectPHD = 0;
if (_ds_ != null)
{
DataRow _dr_ = _ds_.Tables[0].Rows[0];
ViewBag.Regint = _dr_["Regint"].ToString();
ViewBag.TotalCourse = _dr_["TotalCourse"].ToString();
ViewBag.TotalSeat = _dr_["TotalSeat"].ToString();
ViewBag.Allotedint = _dr_["AllotedintTotal"].ToString();
ViewBag.AllotedintUG = _dr_["AllotedintUG"].ToString();
ViewBag.AllotedintPG = _dr_["AllotedintPG"].ToString();
ViewBag.AllotedintPHD = _dr_["AllotedintPHD"].ToString();
ViewBag.InsApproveTotal = _dr_["InsApproveTotal"].ToString();
ViewBag.InsApproveUG = _dr_["InsApproveUG"].ToString();
ViewBag.InsApprovePG = _dr_["InsApprovePG"].ToString();
ViewBag.InsApprovePHD = _dr_["InsApprovePHD"].ToString();
ViewBag.StdApproveTotal = _dr_["StdApproveTotal"].ToString();
ViewBag.StdApproveUG = _dr_["StdApproveUG"].ToString();
ViewBag.StdApprovePG = _dr_["StdApprovePG"].ToString();
ViewBag.StdApprovePHD = _dr_["StdApprovePHD"].ToString();
ViewBag.StdRejectTotal = _dr_["StdRejectTotal"].ToString();
ViewBag.StdRejectUG = _dr_["StdRejectUG"].ToString();
ViewBag.StdRejectPG = _dr_["StdRejectPG"].ToString();
ViewBag.StdRejectPHD = _dr_["StdRejectPHD"].ToString();
ViewBag.StdjoinTotal = _dr_["StdjoinTotal"].ToString();
ViewBag.StdjoinUG = _dr_["StdjoinUG"].ToString();
ViewBag.StdjoinPG = _dr_["StdjoinPG"].ToString();
ViewBag.StdjoinPHD = _dr_["StdjoinPHD"].ToString();
ViewBag.InsRejectTotal = _dr_["InsRejectTotal"].ToString();
ViewBag.InsRejectUG = _dr_["InsRejectUG"].ToString();
ViewBag.InsRejectPG = _dr_["InsRejectPG"].ToString();
ViewBag.InsRejectPHD = _dr_["InsRejectPHD"].ToString();
}
#endregion
#region AdmittedLanded Overview
ReportsRepository _objRepo_ALO = new ReportsRepository();
DataSet _ds_ALO = _objRepo.SELECT_PHASE2_KPI_AdmittedLanded_Overview("Count");
ViewBag.HavePassport = 0;
ViewBag.ApplyForPassport = 0;
ViewBag.NepalPassport = 0;
ViewBag.NoPassport = 0;
ViewBag.BookedTicket = 0;
ViewBag.NoBookedTicket = 0;
ViewBag.SoonBookedTicket = 0;
ViewBag.HaveVisa = 0;
ViewBag.ApplyForVisa = 0;
ViewBag.RejectedVisa = 0;
ViewBag.StudentsRefusedToCome = 0;
ViewBag.OnBoardingCompleted = 0;
ViewBag.TravelFormalitiesInProcess = 0;
if (_ds_ALO != null)
{
DataRow _dr_ALO = _ds_ALO.Tables[0].Rows[0];
ViewBag.HavePassport = _dr_ALO["HavePassport"].ToString();
ViewBag.ApplyForPassport = _dr_ALO["ApplyForPassport"].ToString();
ViewBag.NepalPassport = _dr_ALO["NepalPassport"].ToString();
ViewBag.NoPassport = _dr_ALO["NoPassport"].ToString();
ViewBag.BookedTicket = _dr_ALO["BookedTicket"].ToString();
ViewBag.NoBookedTicket = _dr_ALO["NoBookedTicket"].ToString();
ViewBag.SoonBookedTicket = _dr_ALO["SoonBookedTicket"].ToString();
ViewBag.HaveVisa = _dr_ALO["HaveVisa"].ToString();
ViewBag.ApplyForVisa = _dr_ALO["ApplyForVisa"].ToString();
ViewBag.RejectedVisa = _dr_ALO["RejectedVisa"].ToString();
ViewBag.StudentsRefusedToCome = _dr_ALO["StudentsRefusedToCome"].ToString();
ViewBag.OnBoardingCompleted = _dr_ALO["OnBoardingCompleted"].ToString();
ViewBag.TravelFormalitiesInProcess = _dr_ALO["TravelFormalitiesInProcess"].ToString();
}
#endregion
#region Round 2
ReportsRepository _objRepo_R2 = new ReportsRepository();
DataSet _ds_R2 = _objRepo_R2.SELECT_PHASE2_KPI_SecondRound_OverView("Count");
ViewBag.PGStdParticapte_ = 0;
ViewBag.PGStdStartFillingChoice = 0;
ViewBag.PGStdSubmittedChoice = 0;
ViewBag.PGStdSeatAlloted = 0;
ViewBag.PGStdSeatNotAlloted = 0;
if (_ds_R2 != null)
{
DataRow _dr_R2 = _ds_R2.Tables[0].Rows[0];
ViewBag.PGStdParticapte_ = _dr_R2["PGStdParticapte_"].ToString();
ViewBag.PGStdStartFillingChoice = _dr_R2["PGStdStartFillingChoice"].ToString();
ViewBag.PGStdSubmittedChoice = _dr_R2["PGStdSubmittedChoice"].ToString();
ViewBag.PGStdSeatAlloted = _dr_R2["PGStdSeatAlloted"].ToString();
ViewBag.PGStdSeatNotAlloted = _dr_R2["PGStdSeatNotAlloted"].ToString();
}
#endregion
#region Round 3
ReportsRepository _objRepo_R3 = new ReportsRepository();
DataSet _ds_R3 = _objRepo_R2.SELECT_PHASE2_KPI_ThirdRound_OverView("Count");
ViewBag.UGStdR3Particapte_ = 0;
ViewBag.UGStdR3StartFillingChoice = 0;
ViewBag.UGStdR3SubmittedChoice = 0;
ViewBag.UGStdR3SeatAlloted = 0;
ViewBag.UGStdR3SeatNotAlloted = 0;
if (_ds_R3 != null)
{
DataRow _dr_R3 = _ds_R3.Tables[0].Rows[0];
ViewBag.UGStdR3Particapte_ = _dr_R3["UGStdR3Particapte_"].ToString();
ViewBag.UGStdR3StartFillingChoice = _dr_R3["UGStdR3StartFillingChoice"].ToString();
ViewBag.UGStdR3SubmittedChoice = _dr_R3["UGStdR3SubmittedChoice"].ToString();
ViewBag.UGStdR3SeatAlloted = _dr_R3["UGStdR3SeatAlloted"].ToString();
ViewBag.UGStdR3SeatNotAlloted = _dr_R3["UGStdR3SeatNotAlloted"].ToString();
}
#endregion
return(View());
}
