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
));
}
