public ActionResult Update(SchoolsToNewsModel SchoolsToNewsObj) { //------------------------------------------ //Check ModelState //------------------------------------------ if (!ModelState.IsValid) { return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError, "Invalid data")); } //------------------------------------------ try { bool result = SchoolsToNewsFactor.Update(SchoolsToNewsObj); if (result == true) { return(List(1, 25, null, null, null, null)); } else { return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError, "Saving operation faild")); } } catch (Exception ex) { return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError, ex.Message)); } }
//------------------------------------------------------------------------------------------------------ #endregion #region /*--------- Create ---------*\ //------------------------------------------------------------------------------------------------------ /// <summary> /// Converts the object properties to SQL paramters and executes the create procedure /// and updates the object with the SQL data by reference. /// </summary> /// <param name="SchoolsToNewsObj">Model object.</param> /// <returns>The result of create query.</returns> //-------------------------------------------------------------------- public bool Create(SchoolsToNewsModel SchoolsToNewsObj) { bool result = false; using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("[dbo].[SchoolsToNews_Create]", myConnection); myCommand.CommandType = CommandType.StoredProcedure; //---------------------------------------------------------------------------------------------- // Set the parameters //---------------------------------------------------------------------------------------------- myCommand.Parameters.Add("@ShoolsToNewsID", SqlDbType.Int).Value = SchoolsToNewsObj.ShoolsToNewsID; myCommand.Parameters.Add("@SchoolID", SqlDbType.Int).Value = SchoolsToNewsObj.SchoolID; myCommand.Parameters.Add("@NewsID", SqlDbType.Int).Value = SchoolsToNewsObj.NewsID; //---------------------------------------------------------------------------------------------- // Execute the command //---------------------------------------------------------------------------------------------- myConnection.Open(); if (myCommand.ExecuteNonQuery() > 0) { result = true; //Get ID value from database and set it in object } myConnection.Close(); return result; //---------------------------------------------------------------------------------------------- } }
//------------------------------------------------------------------------------------------------------ #endregion #region /*--------- PopulateModelFromIDataReader ---------*\ //------------------------------------------------------------------------------------------------------ /// <summary> /// Populates model from IDataReader . /// </summary> /// <param name="reader"></param> /// <returns>Model object.</returns> //-------------------------------------------------------------------- private SchoolsToNewsModel PopulateModelFromIDataReader(IDataReader reader) { //Create a new object SchoolsToNewsModel SchoolsToNewsObj = new SchoolsToNewsModel(); //Fill the object with data //------------------------------------------------ //[ShoolsToNewsID] //------------------------------------------------ if (reader["ShoolsToNewsID"] != DBNull.Value) SchoolsToNewsObj.ShoolsToNewsID = (int)reader["ShoolsToNewsID"]; //------------------------------------------------ //------------------------------------------------ //[SchoolID] //------------------------------------------------ if (reader["SchoolID"] != DBNull.Value) SchoolsToNewsObj.SchoolID = (int)reader["SchoolID"]; //------------------------------------------------ //------------------------------------------------ //[NewsID] //------------------------------------------------ if (reader["NewsID"] != DBNull.Value) SchoolsToNewsObj.NewsID = (int)reader["NewsID"]; //------------------------------------------------ //Return the populated object return SchoolsToNewsObj; }
//------------------------------------------------------------------------------------------------------ #endregion #region --------------GetObject-------------- //------------------------------------------------------------------------------------------------------ /// <summary> /// Gets the spesific record. /// </summary> /// <param name="ID">The model id.</param> /// <returns>Model object.</returns> //-------------------------------------------------------------------- public static SchoolsToNewsModel GetObject(int ShoolsToNewsID) { SchoolsToNewsModel SchoolsToNewsObj = null; List <SchoolsToNewsModel> list = SchoolsToNewsSqlDataPrvider.Instance.Get(ShoolsToNewsID); if (list != null && list.Count > 0) { SchoolsToNewsObj = list[0]; } return(SchoolsToNewsObj); }
public ActionResult GetObject(int id) { try { SchoolsToNewsModel SchoolsToNewsObj = SchoolsToNewsFactor.GetObject(id); if (SchoolsToNewsObj == null) { SchoolsToNewsObj = new SchoolsToNewsModel(); } return(Json(SchoolsToNewsObj, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError, ex.Message)); } }
//------------------------------------------------------------------------------------------------------ #endregion #region --------------Update-------------- //------------------------------------------------------------------------------------------------------ /// <summary> /// Updates model object by calling sql data provider update method. /// </summary> /// <param name="SchoolsToNewsObj">The model object.</param> /// <returns>The result of update operation.</returns> //-------------------------------------------------------------------- public static bool Update(SchoolsToNewsModel SchoolsToNewsObj) { return(SchoolsToNewsSqlDataPrvider.Instance.Update(SchoolsToNewsObj)); }