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