public JsonResult SearchInstitutes(InstituteSearchPara _obj) { string localIP = "?"; localIP = Request.ServerVariables["REMOTE_ADDR"].ToString(); _obj.Created_Ip = localIP; _obj.ParticipatedYear = ConfigurationManager.AppSettings["ParticipatedYear"].ToString(); InstituteSearchRepository _objRepository = new InstituteSearchRepository(); DataSet _ds = _objRepository.InstituteSearchForWebsite(_obj); List <InstituteSearchVM> _list = new List <InstituteSearchVM>(); if (_ds != null) { if (_ds.Tables[0].Rows.Count > 0) { foreach (DataRow _dr in _ds.Tables[0].Rows) { InstituteSearchVM _objResult = new InstituteSearchVM(); _objResult.InstituteID = _dr["InstituteID"].ToString(); _objResult.InstituteName = _dr["InstituteName"].ToString(); _objResult.Website = _dr["Website"].ToString(); _objResult.StateName = _dr["StateName"].ToString(); _objResult.City = _dr["City"].ToString(); _objResult.TotalCourse = _dr["TotalCourse"].ToString(); _objResult.TotalSeats = _dr["TotalSeats"].ToString(); _objResult.Photo = _dr["Photo"].ToString(); _objResult.Discipline = _dr["Discipline"].ToString(); _objResult.ProgramLevel = _dr["ProgramLevel"].ToString(); _objResult.Qualification = _dr["Qualification"].ToString(); _objResult.CourseOfStudy = _dr["CourseOfStudy"].ToString(); _list.Add(_objResult); } } } return(Json(new { List = _list }, JsonRequestBehavior.AllowGet )); }
public JsonResult FilterData(InstituteSearch _obj) { _obj.Type = "GridDetails"; string localIP = "?"; localIP = Request.ServerVariables["REMOTE_ADDR"].ToString(); _obj.CreatedIP = localIP; InstituteSearchRepository _objRepository = new InstituteSearchRepository(); DataSet _ds = _objRepository.OperationInstituteSearch(_obj); List <InstituteSearchResult> _list = new List <InstituteSearchResult>(); if (_ds != null) { if (_ds.Tables[0].Rows.Count > 0) { foreach (DataRow _dr in _ds.Tables[0].Rows) { InstituteSearchResult _objResult = new InstituteSearchResult(); _objResult.InstituteID = _dr["InstituteID"].ToString(); _objResult.InstituteName = _dr["InstituteName"].ToString(); _objResult.instituteweburl = _dr["instituteweburl"].ToString(); _objResult.state_name = _dr["state_name"].ToString(); _objResult.City = _dr["City"].ToString(); _objResult.Pin = _dr["Pin"].ToString(); _objResult.Address = _dr["Address"].ToString(); _objResult.YOE = _dr["YOE"].ToString(); _objResult.description = _dr["description"].ToString(); _objResult.NoOfStudentDegreeAward = _dr["NoOfStudentDegreeAward"].ToString(); _objResult.NoOfStudentStrength = _dr["NoOfStudentStrength"].ToString(); _objResult.NoOfInterStudentIntake = _dr["NoOfInterStudentIntake"].ToString(); _objResult.NoOfResearch = _dr["NoOfResearch"].ToString(); _objResult.NoOfPatents = _dr["NoOfPatents"].ToString(); _objResult.NoOfFullTimeStafStrength = _dr["NoOfFullTimeStafStrength"].ToString(); _objResult.NoOfPartTimeStafStrength = _dr["NoOfPartTimeStafStrength"].ToString(); _objResult.CourseCount = _dr["CourseCount"].ToString(); _objResult.Photo = _dr["Photo"].ToString(); _objResult.SheetCount = _dr["SheetCount"].ToString(); _objResult.FilttredCourseCount = _dr["FilttredCourseCount"].ToString(); _objResult.FiltteredSheetCount = _dr["FiltteredSheetCount"].ToString(); _list.Add(_objResult); } } } _obj.Type = "Load"; DataSet _dsLoad = _objRepository.OperationInstituteSearch(_obj); List <InstituteSearchFilter> _listProgramLevel = new List <InstituteSearchFilter>(); List <InstituteSearchFilter> _listState = new List <InstituteSearchFilter>(); List <InstituteSearchFilter> _listNatureOfCourse = new List <InstituteSearchFilter>(); List <InstituteSearchFilter> _listBranch = new List <InstituteSearchFilter>(); List <InstituteSearchFilter> _listType = new List <InstituteSearchFilter>(); string StatePara = "", ProgramLevelPara = "", NatureOfCoursePara = "", BranchIDPara = "", InstituteTypePara = ""; if (_dsLoad != null) { if (_dsLoad.Tables[0].Rows.Count > 0) { foreach (DataRow _dr in _dsLoad.Tables[0].Rows) { InstituteSearchFilter _objResult = new InstituteSearchFilter(); _objResult.Id = _dr["Id"].ToString(); _objResult.Value = _dr["Value"].ToString(); _objResult.Help = _dr["Help"].ToString(); _listState.Add(_objResult); } } if (_dsLoad.Tables[1].Rows.Count > 0) { foreach (DataRow _dr in _dsLoad.Tables[1].Rows) { InstituteSearchFilter _objResult = new InstituteSearchFilter(); _objResult.Id = _dr["Id"].ToString(); _objResult.Value = _dr["Value"].ToString(); _objResult.Help = _dr["Help"].ToString(); _listProgramLevel.Add(_objResult); } } if (_dsLoad.Tables[2].Rows.Count > 0) { foreach (DataRow _dr in _dsLoad.Tables[2].Rows) { InstituteSearchFilter _objResult = new InstituteSearchFilter(); _objResult.Id = _dr["Id"].ToString(); _objResult.Value = _dr["Value"].ToString(); _objResult.Help = _dr["Help"].ToString(); _listNatureOfCourse.Add(_objResult); } } if (_dsLoad.Tables[3].Rows.Count > 0) { foreach (DataRow _dr in _dsLoad.Tables[3].Rows) { StatePara = _dr["StatePara"].ToString(); ProgramLevelPara = _dr["ProgramLevelPara"].ToString(); NatureOfCoursePara = _dr["NatureOfCoursePara"].ToString(); BranchIDPara = _dr["BranchIDPara"].ToString(); InstituteTypePara = _dr["InstituteTypePara"].ToString(); } } if (_dsLoad.Tables[4].Rows.Count > 0) { foreach (DataRow _dr in _dsLoad.Tables[4].Rows) { InstituteSearchFilter _objResult = new InstituteSearchFilter(); _objResult.Id = _dr["Id"].ToString(); _objResult.Value = _dr["Value"].ToString(); _objResult.Help = _dr["Help"].ToString(); _listBranch.Add(_objResult); } } if (_dsLoad.Tables[5].Rows.Count > 0) { foreach (DataRow _dr in _dsLoad.Tables[5].Rows) { InstituteSearchFilter _objResult = new InstituteSearchFilter(); _objResult.Id = _dr["Id"].ToString(); _objResult.Value = _dr["Value"].ToString(); _objResult.Help = _dr["Help"].ToString(); _listType.Add(_objResult); } } } return(Json(new { List = _list, FilterListState = _listState, FilterListProgramLevel = _listProgramLevel, FilterListNatureOfCourse = _listNatureOfCourse, FilterListBranch = _listBranch, FilterListType = _listType, StatePara = StatePara, ProgramLevelPara = ProgramLevelPara, NatureOfCoursePara = NatureOfCoursePara, BranchIDPara = BranchIDPara, InstituteTypePara = InstituteTypePara }, JsonRequestBehavior.AllowGet )); }
public JsonResult SearchCourseList(InstituteSearchPara _obj) { string localIP = "?"; localIP = Request.ServerVariables["REMOTE_ADDR"].ToString(); _obj.Created_Ip = localIP; _obj.ParticipatedYear = ConfigurationManager.AppSettings["ParticipatedYear"].ToString(); InstituteSearchRepository _objRepository = new InstituteSearchRepository(); DataSet _ds = _objRepository.InstituteSearchForWebsite_New(_obj); List <InstituteSearchVM> _list = new List <InstituteSearchVM>(); List <InstituteSearchDropdowns> _listCity = new List <InstituteSearchDropdowns>(); List <InstituteSearchDropdowns> _listDiscipline = new List <InstituteSearchDropdowns>(); List <InstituteSearchDropdowns> _listCourseOfStudy = new List <InstituteSearchDropdowns>(); if (_ds != null) { if (_ds.Tables[0].Rows.Count > 0) { foreach (DataRow _dr in _ds.Tables[0].Rows) { InstituteSearchVM _objResult = new InstituteSearchVM(); _objResult.ID = _dr["ID"].ToString(); _objResult.InstituteID = _dr["InstituteID"].ToString(); _objResult.InstituteName = _dr["InstituteName"].ToString(); _objResult.Website = _dr["Website"].ToString(); _objResult.StateName = _dr["StateName"].ToString(); _objResult.City = _dr["City"].ToString(); _objResult.TotalCourse = _dr["TotalCourse"].ToString(); _objResult.TotalSeats = _dr["TotalSeats"].ToString(); _objResult.Photo = _dr["Photo"].ToString(); _objResult.Discipline = _dr["Discipline"].ToString(); _objResult.ProgramLevel = _dr["ProgramLevel"].ToString(); _objResult.Qualification = _dr["Qualification"].ToString(); _objResult.CourseOfStudy = _dr["CourseOfStudy"].ToString(); _objResult.StartDate = Convert.ToDateTime(_dr["StartDate"].ToString()).ToString("dd-MM-yyyy"); _objResult.EndDate = Convert.ToDateTime(_dr["EndDate"].ToString()).ToString("dd-MM-yyyy"); _objResult.TotalFees = _dr["TotalFees"].ToString(); _objResult.TotalFeesCurrency = _dr["TotalFeesCurrency"].ToString(); _objResult.Photo = _dr["Photo"].ToString(); _list.Add(_objResult); } } if (_ds.Tables[1].Rows.Count > 0) { foreach (DataRow _dr in _ds.Tables[1].Rows) { _listCity.Add(new InstituteSearchDropdowns { Id = _dr["City"].ToString(), Value = _dr["City"].ToString() }); } } if (_ds.Tables[2].Rows.Count > 0) { foreach (DataRow _dr in _ds.Tables[2].Rows) { _listDiscipline.Add(new InstituteSearchDropdowns { Id = _dr["Discipline_ID"].ToString(), Value = _dr["Discipline"].ToString() }); } } if (_ds.Tables[3].Rows.Count > 0) { foreach (DataRow _dr in _ds.Tables[3].Rows) { _listCourseOfStudy.Add(new InstituteSearchDropdowns { Id = _dr["CourseOfStudy_ID"].ToString(), Value = _dr["CourseOfStudy"].ToString() }); } } } return(Json(new { List = _list, ListCity = _listCity, ListDiscipline = _listDiscipline, ListCourseOfStudy = _listCourseOfStudy }, JsonRequestBehavior.AllowGet )); }