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