/// <summary>
/// Builds the media draft from reader.
/// </summary>
/// <param name="data">The data.</param>
/// <returns>MediaDraft entity</returns>
private MediaDraft BuildMediaDraftFromReader(SqlDataReader data)
{
var item = new MediaDraft();
try
{
item.Id = Convert.ToInt32(data["Id"]);
item.GroupId = data["GroupId"] is DBNull ? 0 : Convert.ToInt32(data["GroupId"]);
item.FileSize = data["FileSize"] is DBNull ? 0 : Convert.ToInt32(data["FileSize"]);
item.FileDateTime = data["FileDateTime"] is DBNull ? DateTime.MinValue : Convert.ToDateTime(data["FileDateTime"]);
item.ServerFilePath = data["ServerFilePath"] is DBNull ? string.Empty : Convert.ToString(data["ServerFilePath"]);
item.Media = (byte[])data["Media"];
}
catch (Exception ex)
{
this.logger.Error(
string.Format(
"Error while reading Media of {0} row. Message: {1}", item.Id, ex.Message));
}
return(item);
}
/// <summary>
/// Loads the media file.
/// </summary>
/// <param name="id">The id.</param>
/// <returns>
/// MediaDraft entity
/// </returns>
public MediaDraft LoadMediaFile(int id)
{
this.logger.Info("Loading single Media file from old MySQL database...");
try
{
MediaDraft media = null;
using (var conn = new SqlConnection(this.connStr))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
var commandBuilder = new StringBuilder();
commandBuilder.AppendFormat("LoadSingleMedia");
cmd.CommandText = commandBuilder.ToString();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Id", id));
using (SqlDataReader data = cmd.ExecuteReader())
{
if (data.Read())
{
media = this.BuildMediaDraftFromReader(data);
}
else
{
this.logger.Info(string.Format("Image not found using id={0}", id));
}
}
}
conn.Close();
}
this.logger.Info(string.Format("Successfully loaded single image from the database."));
return(media);
}
catch (Exception ex)
{
this.logger.Error(string.Format("Error while loading single image. Message: {0}", ex.Message));
throw;
}
finally
{
this.logger.Info("Loading single Media file from old MySQL database completed.");
}
}
/// <summary>
/// Saves the media.
/// </summary>
/// <param name="draft">The draft.</param>
/// <returns>
/// upload result
/// </returns>
public bool SaveMedia(MediaDraft draft)
{
this.logger.Info("Saving media draft...");
try
{
using (var conn = new SqlConnection(this.connStr))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
var commandBuilder = new StringBuilder();
commandBuilder.AppendFormat("SaveMedia");
cmd.CommandText = commandBuilder.ToString();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Media", draft.Media);
cmd.Parameters.AddWithValue("@ServerFilePath", draft.ServerFilePath);
cmd.Parameters.AddWithValue("@FileSize", draft.FileSize);
cmd.ExecuteNonQuery();
}
conn.Close();
}
this.logger.Info(string.Format("Successfully savedmedia to the database"));
return(true);
}
catch (Exception ex)
{
this.logger.Error(string.Format("Error while saving media. Message: {0}", ex.Message));
throw;
}
finally
{
this.logger.Info("Saving media draft completed.");
}
}
/// <summary>
/// Updates the media.
/// </summary>
/// <param name="item">The item.</param>
/// <returns>
/// Updates existing media item
/// </returns>
public bool UpdateMedia(MediaDraft item)
{
this.logger.Info("Updating media draft...");
try
{
using (var conn = new SqlConnection(this.connStr))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
var commandBuilder = new StringBuilder();
commandBuilder.AppendFormat("UpdateMedia");
cmd.CommandText = commandBuilder.ToString();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", item.Id);
cmd.Parameters.AddWithValue("@GroupId", item.GroupId);
cmd.ExecuteNonQuery();
}
conn.Close();
}
this.logger.Info(string.Format("Successfully updated image"));
return(true);
}
catch (Exception ex)
{
this.logger.Error(string.Format("Error while updating media. Message: {0}", ex.Message));
throw;
}
finally
{
this.logger.Info("Update media draft completed.");
}
}
