// GET: StudentReport public ActionResult StudentReport(string str, string StrMain) { string UsertypeId = Session["UserTypeId"].ToString(); //if (StrMain == null || StrMain == "") //{ // TempData["Message"] = ""; //} //else //{ // TempData["Message"] = StrMain; //} TempData["PageName"] = str; if (str == "Accepted") { StrMain = StrMain + "And Status='Approved'"; } if (str == "Rejected") { StrMain = StrMain + "And Status='Rejected'"; } DataTable dtStudentList = new DataTable(); dtStudentList = StudentCon.StudentList(UsertypeId); ViewBag.StudentList = ToSelectList(dtStudentList, "Id", "Name"); DataTable dtCounsellor = new DataTable(); dtCounsellor = StudentCon.CounsellorList(); ViewBag.CounsellorList = ToSelectList(dtCounsellor, "Id", "Name"); DataTable dtProductList = new DataTable(); dtProductList = StudentCon.ProductList(); ViewBag.ProductList = ToSelectList(dtProductList, "Id", "Name"); DataTable dtApplicationYear = new DataTable(); dtApplicationYear = StudentCon.ApplicationYearList(); ViewBag.ApplicationYear = ToSelectListOnlyValue(dtApplicationYear, "Name"); DataTable dtCountryList = new DataTable(); dtCountryList = StudentCon.CountryList(); ViewBag.CountryList = ToSelectList(dtCountryList, "Id", "Name"); DataTable dtSchoolList = new DataTable(); dtSchoolList = StudentCon.SchoolList(); ViewBag.SchoolList = ToSelectList(dtSchoolList, "Name"); DataTable objStudent = new DataTable(); objStudent = DashboardCon.GetDashboardStudentReport(StrMain, UsertypeId); return(View(objStudent)); }
public ActionResult CounsellorDashboard(string str, string StrMain) { if (StrMain == null || StrMain == "") { TempData["Message"] = ""; } else { TempData["Message"] = StrMain; } string UsertypeId = Session["UserTypeId"].ToString(); DataTable dtStudentList = new DataTable(); dtStudentList = StudentCon.StudentList(UsertypeId); ViewBag.StudentList = ToSelectList(dtStudentList, "Id", "Name"); DataTable dtCounsellor = new DataTable(); dtCounsellor = StudentCon.CounsellorList(); ViewBag.CounsellorList = ToSelectList(dtCounsellor, "Id", "Name"); DataTable dtProductList = new DataTable(); dtProductList = StudentCon.ProductList(); ViewBag.ProductList = ToSelectList(dtProductList, "Id", "Name"); DataTable dtApplicationYear = new DataTable(); dtApplicationYear = StudentCon.ApplicationYearList(); ViewBag.ApplicationYear = ToSelectListOnlyValue(dtApplicationYear, "Name"); DataTable dtCountryList = new DataTable(); dtCountryList = StudentCon.CountryList(); ViewBag.CountryList = ToSelectList(dtCountryList, "Id", "Name"); DataTable dtSchoolList = new DataTable(); dtSchoolList = StudentCon.SchoolList(); ViewBag.SchoolList = ToSelectList(dtSchoolList, "Name"); DataTable objStudent = new DataTable(); objStudent = DashboardCon.GetCounsellorDashboardStudentReport(str, UsertypeId); return(View(objStudent)); }