//------------------------------------------------------------------------------------------------------
#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));
}
