//public DataSet OperationInstituteSearch(InstituteSearch _obj) //{ // try // { // _cn.Open(); // SqlCommand _cmd = new SqlCommand("Institute_Search", _cn); // _cmd.Parameters.AddWithValue("@Created_IP", _obj.CreatedIP); // _cmd.Parameters.AddWithValue("@Type", _obj.Type); // _cmd.Parameters.AddWithValue("@Control", _obj.Control); // _cmd.Parameters.AddWithValue("@InstituteID", _obj.InstituteID); // _cmd.CommandType = CommandType.StoredProcedure; // SqlDataAdapter _adp = new SqlDataAdapter(_cmd); // DataSet _ds = new DataSet(); // _adp.Fill(_ds); // _adp.Dispose(); // _cmd.Dispose(); // return _ds; // } // catch (Exception) // { // throw; // } // finally // { // _cn.Close(); // } //} public DataSet OperationInstituteSearch(InstituteSearch _obj) { try { _cn.Open(); SqlCommand _cmd = new SqlCommand("Institute_Search", _cn); _cmd.Parameters.AddWithValue("@Created_IP", _obj.CreatedIP); _cmd.Parameters.AddWithValue("@Type", _obj.Type); _cmd.Parameters.AddWithValue("@Control", _obj.Control); _cmd.Parameters.AddWithValue("@State", _obj.State); _cmd.Parameters.AddWithValue("@ProgramLevel", _obj.ProgramLevel); _cmd.Parameters.AddWithValue("@NatureOfCourse", _obj.NatureOfCourse); _cmd.Parameters.AddWithValue("@BranchID", _obj.BranchID); _cmd.Parameters.AddWithValue("@InstituteType", _obj.InstituteType); _cmd.CommandType = CommandType.StoredProcedure; _cmd.CommandTimeout = 180; SqlDataAdapter _adp = new SqlDataAdapter(_cmd); DataSet _ds = new DataSet(); _adp.Fill(_ds); _adp.Dispose(); _cmd.Dispose(); return(_ds); } catch (Exception) { throw; } finally { _cn.Close(); } }
public List <InstituteSearch> GetList_InstituteSearchByCareerCourse(int career, int course) { try { List <InstituteSearch> li = new List <InstituteSearch>(); using (SqlConnection con = new SqlConnection(ConnectionStringDheya)) { SqlCommand cmd = new SqlCommand("SP_InstituteSearchAndDetails", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Type", "InstituteSearchByCareerCourse"); cmd.Parameters.AddWithValue("@Career", career); cmd.Parameters.AddWithValue("@Course", course); cmd.Parameters.AddWithValue("@Inst", ""); cmd.Parameters.AddWithValue("@Subco", ""); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { InstituteSearch obj = new InstituteSearch(); obj.Inst_ID = Convert.ToInt32(dr["inst_id"]); obj.InstName = dr["inst_name"].ToString(); obj.CityName = dr["city"].ToString(); obj.Subco_id = Convert.ToInt32(dr["subco_id"]); obj.Subco_name = dr["subco_name"].ToString(); obj.SpecializationName = dr["specialization"].ToString(); li.Add(obj); } con.Close(); return(li); } else { return(null); } } } catch (Exception ex) { Log.Error(ex); return(null); } }
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 ActionResult LoadInstitute(InstituteSearch search_obj) { var institute_list = db.SET_INSTITUTE_SEARCH(search_obj.INSTITUTE_NO, search_obj.INSTITUTE_NAME, search_obj.INSTITUTE_NAME_BNG, search_obj.INST_TYPE_NO, search_obj.THANA_NO, search_obj.F_INSTITUTION_DB_ID, search_obj.EIIN_NUMBER, search_obj.USER_NO).ToList(); return(View(institute_list)); }