//------------------------------------------------------------------------------------------------------ #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="IndexersObj">Model object.</param> /// <returns>The result of create query.</returns> //-------------------------------------------------------------------- public bool Create(IndexersModel IndexersObj) { bool result = false; using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("[dbo].[Indexers_Create]", myConnection); myCommand.CommandType = CommandType.StoredProcedure; //---------------------------------------------------------------------------------------------- // Set the parameters //---------------------------------------------------------------------------------------------- myCommand.Parameters.Add("@IndexerID", SqlDbType.Int).Direction = ParameterDirection.Output; myCommand.Parameters.Add("@Name", SqlDbType.VarChar).Value = IndexersObj.Name; myCommand.Parameters.Add("@OwnerID", SqlDbType.Int).Value = IndexersObj.OwnerID; //---------------------------------------------------------------------------------------------- // Execute the command //---------------------------------------------------------------------------------------------- myConnection.Open(); if (myCommand.ExecuteNonQuery() > 0) { result = true; //Get ID value from database and set it in object IndexersObj.IndexerID = (int)myCommand.Parameters["@IndexerID"].Value; } myConnection.Close(); return result; //---------------------------------------------------------------------------------------------- } }
//------------------------------------------------------------------------------------------------------ #endregion #region /*--------- PopulateModelFromIDataReader ---------*\ //------------------------------------------------------------------------------------------------------ /// <summary> /// Populates model from IDataReader . /// </summary> /// <param name="reader"></param> /// <returns>Model object.</returns> //-------------------------------------------------------------------- private IndexersModel PopulateModelFromIDataReader(IDataReader reader) { //Create a new object IndexersModel IndexersObj = new IndexersModel(); //Fill the object with data //------------------------------------------------ //[IndexerID] //------------------------------------------------ if (reader["IndexerID"] != DBNull.Value) IndexersObj.IndexerID = (int)reader["IndexerID"]; //------------------------------------------------ //------------------------------------------------ //[Name] //------------------------------------------------ if (reader["Name"] != DBNull.Value) IndexersObj.Name = (string)reader["Name"]; //------------------------------------------------ //------------------------------------------------ //[OwnerID] //------------------------------------------------ if (reader["OwnerID"] != DBNull.Value) IndexersObj.OwnerID = (int)reader["OwnerID"]; //------------------------------------------------ //Return the populated object return IndexersObj; }
//------------------------------------------------------------------------------------------------------ #endregion #region /*--------- Update ---------*\ //------------------------------------------------------------------------------------------------------ /// <summary> /// Converts the object properties to SQL paramters and executes the update procedure. /// </summary> /// <param name="IndexersObj">Model object.</param> /// <returns>The result of update query.</returns> //-------------------------------------------------------------------- public bool Update(IndexersModel IndexersObj) { bool result = false; using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("[dbo].[Indexers_Update]", myConnection); myCommand.CommandType = CommandType.StoredProcedure; //---------------------------------------------------------------------------------------------- // Set the parameters //---------------------------------------------------------------------------------------------- myCommand.Parameters.Add("@IndexerID", SqlDbType.Int).Value = IndexersObj.IndexerID; myCommand.Parameters.Add("@Name", SqlDbType.VarChar).Value = IndexersObj.Name; myCommand.Parameters.Add("@OwnerID", SqlDbType.Int).Value = IndexersObj.OwnerID; //---------------------------------------------------------------------------------------------- // Execute the command //---------------------------------------------------------------------------------------------- myConnection.Open(); if (myCommand.ExecuteNonQuery() > 0) { result = true; } myConnection.Close(); return result; //---------------------------------------------------------------------------------------------- } }
public ActionResult Update(IndexersModel IndexersObj) { //------------------------------------------ //Check ModelState //------------------------------------------ if (!ModelState.IsValid) { return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError, "Invalid data")); } //------------------------------------------ try { bool result = IndexersFactor.Update(IndexersObj); 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 --------------GetObject-------------- //------------------------------------------------------------------------------------------------------ /// <summary> /// Gets the spesific record. /// </summary> /// <param name="ID">The model id.</param> /// <returns>Model object.</returns> //-------------------------------------------------------------------- public static IndexersModel GetObject(int IndexerID) { IndexersModel IndexersObj = null; List <IndexersModel> list = IndexersSqlDataPrvider.Instance.Get(IndexerID); if (list != null && list.Count > 0) { IndexersObj = list[0]; } return(IndexersObj); }
public ActionResult GetObject(int id) { try { IndexersModel IndexersObj = IndexersFactor.GetObject(id); if (IndexersObj == null) { IndexersObj = new IndexersModel(); } return(Json(IndexersObj, 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="IndexersObj">The model object.</param> /// <returns>The result of update operation.</returns> //-------------------------------------------------------------------- public static bool Update(IndexersModel IndexersObj) { return(IndexersSqlDataPrvider.Instance.Update(IndexersObj)); }