/// <summary>
/// Updates the download
/// </summary>
/// <param name="DownloadID">The download identifier</param>
/// <param name="UseDownloadURL">The value indicating whether DownloadURL property should be used</param>
/// <param name="DownloadURL">The download URL</param>
/// <param name="DownloadBinary">The download binary</param>
/// <param name="ContentType">The mime-type of the download</param>
/// <param name="Extension">The extension</param>
/// <param name="IsNew">A value indicating whether the download is new</param>
/// <returns>Download</returns>
public override DBDownload UpdateDownload(int DownloadID, bool UseDownloadURL, string DownloadURL,
byte[] DownloadBinary, string ContentType, string Extension, bool IsNew)
{
DBDownload download = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_DownloadUpdate");
db.AddInParameter(dbCommand, "DownloadID", DbType.Int32, DownloadID);
db.AddInParameter(dbCommand, "UseDownloadURL", DbType.Boolean, UseDownloadURL);
db.AddInParameter(dbCommand, "DownloadURL", DbType.String, DownloadURL);
if (DownloadBinary != null)
{
db.AddInParameter(dbCommand, "DownloadBinary", DbType.Binary, DownloadBinary);
}
else
{
db.AddInParameter(dbCommand, "DownloadBinary", DbType.Binary, null);
}
db.AddInParameter(dbCommand, "ContentType", DbType.String, ContentType);
db.AddInParameter(dbCommand, "Extension", DbType.String, Extension);
db.AddInParameter(dbCommand, "IsNew", DbType.Boolean, IsNew);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
download = GetDownloadByID(DownloadID);
}
return(download);
}
/// <summary>
/// Updates the download
/// </summary>
/// <param name="downloadId">The download identifier</param>
/// <param name="useDownloadUrl">The value indicating whether DownloadURL property should be used</param>
/// <param name="downloadUrl">The download URL</param>
/// <param name="downloadBinary">The download binary</param>
/// <param name="contentType">The content type</param>
/// <param name="filename">The filename of the download</param>
/// <param name="extension">The extension</param>
/// <param name="isNew">A value indicating whether the download is new</param>
/// <returns>Download</returns>
public override DBDownload UpdateDownload(int downloadId,
bool useDownloadUrl, string downloadUrl,
byte[] downloadBinary, string contentType, string filename,
string extension, bool isNew)
{
DBDownload item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_DownloadUpdate");
db.AddInParameter(dbCommand, "DownloadID", DbType.Int32, downloadId);
db.AddInParameter(dbCommand, "UseDownloadURL", DbType.Boolean, useDownloadUrl);
db.AddInParameter(dbCommand, "DownloadURL", DbType.String, downloadUrl);
if (downloadBinary != null)
{
db.AddInParameter(dbCommand, "DownloadBinary", DbType.Binary, downloadBinary);
}
else
{
db.AddInParameter(dbCommand, "DownloadBinary", DbType.Binary, null);
}
db.AddInParameter(dbCommand, "ContentType", DbType.String, contentType);
db.AddInParameter(dbCommand, "Filename", DbType.String, filename);
db.AddInParameter(dbCommand, "Extension", DbType.String, extension);
db.AddInParameter(dbCommand, "IsNew", DbType.Boolean, isNew);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
item = GetDownloadById(downloadId);
}
return(item);
}
private DBDownload GetDownloadFromReader(IDataReader dataReader)
{
DBDownload download = new DBDownload();
download.DownloadID = NopSqlDataHelper.GetInt(dataReader, "DownloadID");
download.UseDownloadURL = NopSqlDataHelper.GetBoolean(dataReader, "UseDownloadURL");
download.DownloadURL = NopSqlDataHelper.GetString(dataReader, "DownloadURL");
download.DownloadBinary = NopSqlDataHelper.GetBytes(dataReader, "DownloadBinary");
download.ContentType = NopSqlDataHelper.GetString(dataReader, "ContentType");
download.Extension = NopSqlDataHelper.GetString(dataReader, "Extension");
download.IsNew = NopSqlDataHelper.GetBoolean(dataReader, "IsNew");
return download;
}
private DBDownload GetDownloadFromReader(IDataReader dataReader)
{
DBDownload download = new DBDownload();
download.DownloadID = NopSqlDataHelper.GetInt(dataReader, "DownloadID");
download.UseDownloadURL = NopSqlDataHelper.GetBoolean(dataReader, "UseDownloadURL");
download.DownloadURL = NopSqlDataHelper.GetString(dataReader, "DownloadURL");
download.DownloadBinary = NopSqlDataHelper.GetBytes(dataReader, "DownloadBinary");
download.ContentType = NopSqlDataHelper.GetString(dataReader, "ContentType");
download.Extension = NopSqlDataHelper.GetString(dataReader, "Extension");
download.IsNew = NopSqlDataHelper.GetBoolean(dataReader, "IsNew");
return(download);
}
private DBDownload GetDownloadFromReader(IDataReader dataReader)
{
var item = new DBDownload();
item.DownloadId = NopSqlDataHelper.GetInt(dataReader, "DownloadID");
item.UseDownloadUrl = NopSqlDataHelper.GetBoolean(dataReader, "UseDownloadURL");
item.DownloadUrl = NopSqlDataHelper.GetString(dataReader, "DownloadURL");
item.DownloadBinary = NopSqlDataHelper.GetBytes(dataReader, "DownloadBinary");
item.ContentType = NopSqlDataHelper.GetString(dataReader, "ContentType");
item.Filename = NopSqlDataHelper.GetString(dataReader, "Filename");
item.Extension = NopSqlDataHelper.GetString(dataReader, "Extension");
item.IsNew = NopSqlDataHelper.GetBoolean(dataReader, "IsNew");
return(item);
}
private static Download DBMapping(DBDownload dbItem)
{
if (dbItem == null)
return null;
Download item = new Download();
item.DownloadID = dbItem.DownloadID;
item.UseDownloadURL = dbItem.UseDownloadURL;
item.DownloadURL = dbItem.DownloadURL;
item.DownloadBinary = dbItem.DownloadBinary;
item.ContentType = dbItem.ContentType;
item.Extension = dbItem.Extension;
item.IsNew = dbItem.IsNew;
return item;
}
/// <summary>
/// Gets a download
/// </summary>
/// <param name="DownloadID">Download identifier</param>
/// <returns>Download</returns>
public override DBDownload GetDownloadByID(int DownloadID)
{
DBDownload download = null;
if (DownloadID == 0)
{
return(download);
}
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_DownloadLoadByPrimaryKey");
db.AddInParameter(dbCommand, "DownloadID", DbType.Int32, DownloadID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
download = GetDownloadFromReader(dataReader);
}
}
return(download);
}
