//------------------------------------------------------------------------------------------------------ #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="ImagesCategoriesObj">Model object.</param> /// <returns>The result of create query.</returns> //-------------------------------------------------------------------- public bool Create(ImagesCategoriesModel ImagesCategoriesObj) { bool result = false; using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("[dbo].[ImagesCategories_Create]", myConnection); myCommand.CommandType = CommandType.StoredProcedure; //---------------------------------------------------------------------------------------------- // Set the parameters //---------------------------------------------------------------------------------------------- myCommand.Parameters.Add("@CategoryID", SqlDbType.Int, 4).Direction = ParameterDirection.Output; myCommand.Parameters.Add("@Identifire", SqlDbType.VarChar, 128).Value = ImagesCategoriesObj.Identifire; myCommand.Parameters.Add("@NameEn", SqlDbType.VarChar, 128).Value = ImagesCategoriesObj.NameEn; myCommand.Parameters.Add("@NameAr", SqlDbType.NVarChar, 128).Value = ImagesCategoriesObj.NameAr; //---------------------------------------------------------------------------------------------- // Execute the command //---------------------------------------------------------------------------------------------- myConnection.Open(); if (myCommand.ExecuteNonQuery() > 0) { result = true; //Get ID value from database and set it in object ImagesCategoriesObj.CategoryID = (int)myCommand.Parameters["@CategoryID"].Value; } myConnection.Close(); return result; //---------------------------------------------------------------------------------------------- } }
//------------------------------------------------------------------------------------------------------ #endregion #region /*--------- PopulateModelFromIDataReader ---------*\ //------------------------------------------------------------------------------------------------------ /// <summary> /// Populates model from IDataReader . /// </summary> /// <param name="reader"></param> /// <returns>Model object.</returns> //-------------------------------------------------------------------- private ImagesCategoriesModel PopulateModelFromIDataReader(IDataReader reader) { //Create a new object ImagesCategoriesModel ImagesCategoriesObj = new ImagesCategoriesModel(); //Fill the object with data //------------------------------------------------ //[CategoryID] //------------------------------------------------ if (reader["CategoryID"] != DBNull.Value) ImagesCategoriesObj.CategoryID = (int)reader["CategoryID"]; //------------------------------------------------ //------------------------------------------------ //[Identifire] //------------------------------------------------ if (reader["Identifire"] != DBNull.Value) ImagesCategoriesObj.Identifire = (string)reader["Identifire"]; //------------------------------------------------ //------------------------------------------------ //[NameEn] //------------------------------------------------ if (reader["NameEn"] != DBNull.Value) ImagesCategoriesObj.NameEn = (string)reader["NameEn"]; //------------------------------------------------ //------------------------------------------------ //[NameAr] //------------------------------------------------ if (reader["NameAr"] != DBNull.Value) ImagesCategoriesObj.NameAr = (string)reader["NameAr"]; //------------------------------------------------ //Return the populated object return ImagesCategoriesObj; }
//------------------------------------------------------------------------------------------------------ #endregion #region --------------GetObject-------------- //------------------------------------------------------------------------------------------------------ /// <summary> /// Gets the spesific record. /// </summary> /// <param name="ID">The model id.</param> /// <returns>Model object.</returns> //-------------------------------------------------------------------- public static ImagesCategoriesModel GetObject(int CategoryID) { ImagesCategoriesModel ImagesCategoriesObj = null; List <ImagesCategoriesModel> list = ImagesCategoriesSqlDataPrvider.Instance.Get(CategoryID); if (list != null && list.Count > 0) { ImagesCategoriesObj = list[0]; } return(ImagesCategoriesObj); }
//------------------------------------------------------------------------------------------------------ #endregion #region --------------Update-------------- //------------------------------------------------------------------------------------------------------ /// <summary> /// Updates model object by calling sql data provider update method. /// </summary> /// <param name="ImagesCategoriesObj">The model object.</param> /// <returns>The result of update operation.</returns> //-------------------------------------------------------------------- public static bool Update(ImagesCategoriesModel ImagesCategoriesObj) { return(ImagesCategoriesSqlDataPrvider.Instance.Update(ImagesCategoriesObj)); }