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