public DataSet InstituteStudentsFacility_Select(InstituteStudentsFacility _obj) { try { _cn.Open(); SqlCommand _cmd = new SqlCommand("sp_Select_tbl_InstituteStudentsFacility", _cn); _cmd.Parameters.AddWithValue("@ID", _obj.ID); _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 JsonResult Save_StudentFacility(InstituteStudentsFacility _obj) { bool flag = false; try { InstituteStudentsFacilityRepository _objRepository = new InstituteStudentsFacilityRepository(); _obj.InstituteID = Session["InstituteID"].ToString(); _obj.CreatedIP = Session["localIP"].ToString(); DataSet _ds = _objRepository.InstituteStudentsFacility_Insert(_obj); if (_ds != null) { if (_ds.Tables[0].Rows.Count > 0) { if (_ds.Tables[0].Rows[0]["FLAG"].ToString() == "1") { flag = true; } } } } catch (System.Exception) { throw; } return(Json(new { flag = flag }, JsonRequestBehavior.AllowGet )); }
public DataSet InstituteStudentsFacility_Insert(InstituteStudentsFacility _obj) { try { _cn.Open(); SqlCommand _cmd = new SqlCommand("sp_Insert_tbl_InstituteStudentsFacility", _cn); _cmd.Parameters.AddWithValue("@ID", _obj.ID); _cmd.Parameters.AddWithValue("@InstituteID", _obj.InstituteID); _cmd.Parameters.AddWithValue("@HasCellOffice", _obj.HasCellOffice); _cmd.Parameters.AddWithValue("@CellOfficeDesc", _obj.CellOfficeDesc); _cmd.Parameters.AddWithValue("@HasVisaAssistance", _obj.HasVisaAssistance); _cmd.Parameters.AddWithValue("@VisaAssistanceDesc", _obj.VisaAssistanceDesc); _cmd.Parameters.AddWithValue("@OtherFacility", _obj.OtherFacility); _cmd.Parameters.AddWithValue("@HasCulturalEngagement", _obj.HasCulturalEngagement); _cmd.Parameters.AddWithValue("@HasStudentBoarding", _obj.HasStudentBoarding); _cmd.Parameters.AddWithValue("@HasArrival", _obj.HasArrival); _cmd.Parameters.AddWithValue("@HasMentor", _obj.HasMentor); _cmd.Parameters.AddWithValue("@IntroProgram", _obj.IntroProgram); _cmd.Parameters.AddWithValue("@ContactPersonName", _obj.ContactPersonName); _cmd.Parameters.AddWithValue("@ContactPersonEmail", _obj.ContactPersonEmail); _cmd.Parameters.AddWithValue("@ContactPersonMobile", _obj.ContactPersonMobile); _cmd.Parameters.AddWithValue("@ContactPersonPhone", _obj.ContactPersonPhone); _cmd.Parameters.AddWithValue("@CreatedIP", _obj.CreatedIP); _cmd.Parameters.AddWithValue("@Edited_by", _obj.Edited_by); _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 JsonResult Select_InternationalSchool(InstituteStudentsFacility obj) { List <InstituteStudentsFacility> _list = new List <InstituteStudentsFacility>(); obj.InstituteID = Session["InstituteID"].ToString(); InstituteStudentsFacilityRepository _objRepository = new InstituteStudentsFacilityRepository(); DataSet ds = _objRepository.InstituteStudentsFacility_Select(obj); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { InstituteStudentsFacility _objList = new InstituteStudentsFacility(); _objList.ID = row["ID"].ToString(); _objList.InstituteID = row["InstituteID"].ToString(); _objList.HasCellOffice = row["HasCellOffice"].ToString(); _objList.CellOfficeDesc = row["CellOfficeDesc"].ToString(); _objList.HasVisaAssistance = row["HasVisaAssistance"].ToString(); _objList.VisaAssistanceDesc = row["VisaAssistanceDesc"].ToString(); _objList.HasCulturalEngagement = row["HasCulturalEngagement"].ToString(); _objList.HasStudentBoarding = row["HasStudentBoarding"].ToString(); _objList.HasArrival = row["HasArrival"].ToString(); _objList.IntroProgram = row["IntroProgram"].ToString(); _objList.ContactPersonName = row["ContactPersonName"].ToString(); _objList.ContactPersonEmail = row["ContactPersonEmail"].ToString(); _objList.ContactPersonMobile = row["ContactPersonMobile"].ToString(); _objList.ContactPersonPhone = row["ContactPersonPhone"].ToString(); _list.Add(_objList); } } } return(Json(new { List = _list }, JsonRequestBehavior.AllowGet )); }