private DBPicture GetPictureFromReader(IDataReader dataReader) { var item = new DBPicture(); item.PictureId = NopSqlDataHelper.GetInt(dataReader, "PictureID"); item.PictureBinary = NopSqlDataHelper.GetBytes(dataReader, "PictureBinary"); item.Extension = NopSqlDataHelper.GetString(dataReader, "Extension"); item.IsNew = NopSqlDataHelper.GetBoolean(dataReader, "IsNew"); return(item); }
private DBPicture GetPictureFromReader(IDataReader dataReader) { DBPicture picture = new DBPicture(); picture.PictureID = NopSqlDataHelper.GetInt(dataReader, "PictureID"); picture.PictureBinary = NopSqlDataHelper.GetBytes(dataReader, "PictureBinary"); picture.Extension = NopSqlDataHelper.GetString(dataReader, "Extension"); picture.IsNew = NopSqlDataHelper.GetBoolean(dataReader, "IsNew"); return(picture); }
/// <summary> /// Updates the picture /// </summary> /// <param name="PictureID">The picture identifier</param> /// <param name="PictureBinary">The picture binary</param> /// <param name="Extension">The picture extension</param> /// <param name="IsNew">A value indicating whether the picture is new</param> /// <returns>Picture</returns> public override DBPicture UpdatePicture(int PictureID, byte[] PictureBinary, string Extension, bool IsNew) { DBPicture picture = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_PictureUpdate"); db.AddInParameter(dbCommand, "PictureID", DbType.Int32, PictureID); db.AddInParameter(dbCommand, "PictureBinary", DbType.Binary, PictureBinary); db.AddInParameter(dbCommand, "Extension", DbType.String, Extension); db.AddInParameter(dbCommand, "IsNew", DbType.Boolean, IsNew); if (db.ExecuteNonQuery(dbCommand) > 0) { picture = GetPictureByID(PictureID); } return(picture); }
/// <summary> /// Updates the picture /// </summary> /// <param name="pictureId">The picture identifier</param> /// <param name="pictureBinary">The picture binary</param> /// <param name="extension">The picture extension</param> /// <param name="isNew">A value indicating whether the picture is new</param> /// <returns>Picture</returns> public override DBPicture UpdatePicture(int pictureId, byte[] pictureBinary, string extension, bool isNew) { DBPicture item = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_PictureUpdate"); db.AddInParameter(dbCommand, "PictureID", DbType.Int32, pictureId); db.AddInParameter(dbCommand, "PictureBinary", DbType.Binary, pictureBinary); db.AddInParameter(dbCommand, "Extension", DbType.String, extension); db.AddInParameter(dbCommand, "IsNew", DbType.Boolean, isNew); if (db.ExecuteNonQuery(dbCommand) > 0) { item = GetPictureById(pictureId); } return(item); }
/// <summary> /// Gets a picture /// </summary> /// <param name="pictureId">Picture identifier</param> /// <returns>Picture</returns> public override DBPicture GetPictureById(int pictureId) { DBPicture item = null; if (pictureId == 0) { return(item); } Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_PictureLoadByPrimaryKey"); db.AddInParameter(dbCommand, "PictureID", DbType.Int32, pictureId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { item = GetPictureFromReader(dataReader); } } return(item); }