//------------------------------------------------------------------------------------------------------ #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="JournalsObj">Model object.</param> /// <returns>The result of create query.</returns> //-------------------------------------------------------------------- public bool Create(JournalsModel JournalsObj) { bool result = false; using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("[dbo].[Journals_Create]", myConnection); myCommand.CommandType = CommandType.StoredProcedure; //---------------------------------------------------------------------------------------------- // Set the parameters //---------------------------------------------------------------------------------------------- myCommand.Parameters.Add("@JournalCode", SqlDbType.VarChar).Value = JournalsObj.JournalCode; myCommand.Parameters.Add("@FullTitle", SqlDbType.VarChar).Value = JournalsObj.FullTitle; myCommand.Parameters.Add("@ShortTitle", SqlDbType.VarChar).Value = JournalsObj.ShortTitle; myCommand.Parameters.Add("@JournalSubCode", SqlDbType.VarChar).Value = JournalsObj.JournalSubCode; myCommand.Parameters.Add("@JournalOwner", SqlDbType.Int).Value = JournalsObj.JournalOwner; myCommand.Parameters.Add("@Note", SqlDbType.VarChar).Value = JournalsObj.Note; //---------------------------------------------------------------------------------------------- // 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; //---------------------------------------------------------------------------------------------- } }
public ActionResult Update(JournalsModel JournalsObj) { //------------------------------------------ //Check ModelState //------------------------------------------ if (!ModelState.IsValid) { return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError, "Invalid data")); } //------------------------------------------ try { bool result = JournalsFactor.Update(JournalsObj); 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 JournalsModel GetObject(string JournalCode) { JournalsModel JournalsObj = null; List <JournalsModel> list = JournalsSqlDataPrvider.Instance.Get(JournalCode); if (list != null && list.Count > 0) { JournalsObj = list[0]; } return(JournalsObj); }
public ActionResult GetObject(string id) { try { JournalsModel JournalsObj = JournalsFactor.GetObject(id); if (JournalsObj == null) { JournalsObj = new JournalsModel(); } return(Json(JournalsObj, 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 JournalsModel PopulateModelFromIDataReader(IDataReader reader) { //Create a new object JournalsModel JournalsObj = new JournalsModel(); //Fill the object with data //------------------------------------------------ //[JournalCode] //------------------------------------------------ if (reader["JournalCode"] != DBNull.Value) JournalsObj.JournalCode = (string)reader["JournalCode"]; //------------------------------------------------ //------------------------------------------------ //[FullTitle] //------------------------------------------------ if (reader["FullTitle"] != DBNull.Value) JournalsObj.FullTitle = (string)reader["FullTitle"]; //------------------------------------------------ //------------------------------------------------ //[ShortTitle] //------------------------------------------------ if (reader["ShortTitle"] != DBNull.Value) JournalsObj.ShortTitle = (string)reader["ShortTitle"]; //------------------------------------------------ //------------------------------------------------ //[JournalSubCode] //------------------------------------------------ if (reader["JournalSubCode"] != DBNull.Value) JournalsObj.JournalSubCode = (string)reader["JournalSubCode"]; //------------------------------------------------ //------------------------------------------------ //[JournalOwner] //------------------------------------------------ if (reader["JournalOwner"] != DBNull.Value) JournalsObj.JournalOwner = (int)reader["JournalOwner"]; //------------------------------------------------ //------------------------------------------------ //[Note] //------------------------------------------------ if (reader["Note"] != DBNull.Value) JournalsObj.Note = (string)reader["Note"]; //------------------------------------------------ //Return the populated object return JournalsObj; }
//------------------------------------------------------------------------------------------------------ #endregion #region --------------Update-------------- //------------------------------------------------------------------------------------------------------ /// <summary> /// Updates model object by calling sql data provider update method. /// </summary> /// <param name="JournalsObj">The model object.</param> /// <returns>The result of update operation.</returns> //-------------------------------------------------------------------- public static bool Update(JournalsModel JournalsObj) { return(JournalsSqlDataPrvider.Instance.Update(JournalsObj)); }