public JsonResult Save_Campus_Infrastructure(InstituteInfrascuture _obj) { InstituteInfrascutureRepository objRepository = new InstituteInfrascutureRepository(); _obj.InstituteID = Session["InstituteID"].ToString(); _obj.CreatedIP = Session["localIP"].ToString(); _obj.Edited_by = Session["User_id"].ToString(); DataSet _ds = objRepository.Save_Campus_Infrastructure(_obj); bool flag = true; if (_ds != null) { if (_ds.Tables[0].Rows.Count > 0) { if (_ds.Tables[0].Rows[0]["FLAG"].ToString() == "0") { flag = false; } } } return(Json(new { flag = flag }, JsonRequestBehavior.AllowGet )); }
public DataSet Save_Campus_Infrastructure(InstituteInfrascuture _obj) { try { _cn.Open(); SqlCommand _cmd = new SqlCommand("sp_Insert_Update_Institute_Campus_Infrastructure", _cn); _cmd.Parameters.AddWithValue("@InstituteID", _obj.InstituteID); _cmd.Parameters.AddWithValue("@Area", _obj.Area); _cmd.Parameters.AddWithValue("@ITInfrastructure", _obj.ITInfrastructure); _cmd.Parameters.AddWithValue("@ITInfrastructureWifiFacility", _obj.ITInfrastructureWifiFacility); _cmd.Parameters.AddWithValue("@AcademicFacilities", _obj.AcademicFacilities); _cmd.Parameters.AddWithValue("@Database", _obj.Database); _cmd.Parameters.AddWithValue("@elibrary", _obj.elibrary); _cmd.Parameters.AddWithValue("@ResearchFacilitiesLabs", _obj.ResearchFacilitiesLabs); _cmd.Parameters.AddWithValue("@Accommodation", _obj.Accommodation); _cmd.Parameters.AddWithValue("@AccommodationWifi", _obj.AccommodationWifi); _cmd.Parameters.AddWithValue("@CuisineServedInMess", _obj.CuisineServedInMess); _cmd.Parameters.AddWithValue("@CuisinesOfFoodServed", _obj.CuisinesOfFoodServed); _cmd.Parameters.AddWithValue("@Doctors", _obj.Doctors); _cmd.Parameters.AddWithValue("@Pharmacy", _obj.Pharmacy); _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_Campus_Infrastructure() { InstituteInfrascutureRepository objRep = new InstituteInfrascutureRepository(); DataSet ds = objRep.Select_Campus_Infrastructure(Session["InstituteID"].ToString()); List <InstituteInfrascuture> _list = new List <InstituteInfrascuture>(); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { InstituteInfrascuture objCourse = new InstituteInfrascuture(); objCourse.ID = row["ID"].ToString(); objCourse.InstituteID = row["InstituteId"].ToString(); objCourse.Area = row["Area"].ToString(); objCourse.ITInfrastructure = row["ITInfrastructure"].ToString(); objCourse.ITInfrastructureWifiFacility = row["ITInfrastructureWifiFacility"].ToString(); objCourse.AcademicFacilities = row["AcademicFacilities"].ToString(); objCourse.Database = row["Database"].ToString(); objCourse.elibrary = row["elibrary"].ToString(); objCourse.ResearchFacilitiesLabs = row["ResearchFacilitiesLabs"].ToString(); objCourse.Accommodation = row["Accommodation"].ToString(); objCourse.AccommodationWifi = row["AccommodationWifi"].ToString(); objCourse.CuisineServedInMess = row["CuisineServedInMess"].ToString(); objCourse.CuisinesOfFoodServed = row["CuisinesOfFoodServed"].ToString(); objCourse.Doctors = row["Doctors"].ToString(); objCourse.Pharmacy = row["Pharmacy"].ToString(); _list.Add(objCourse); } } } return(Json(new { List = _list }, JsonRequestBehavior.AllowGet )); }