public override long SaveAlbumImage(AlbumImageInfo image, IDbTransaction transaction)
{
var sqlParam = new DynamicParameters();
sqlParam.Add("@AlbumId", image.AlbumID);
sqlParam.Add("@AlbumImagePath", image.AlbumImagePath);
sqlParam.Add("@ImageName", image.AlbumImageName);
sqlParam.Add("@ImageDescription", image.AlbumImageDescription);
sqlParam.Add("@ImageTypeId", image.ImageTypeId);
sqlParam.Add("@UploadedBy", image.UploadedBy);
sqlParam.Add("@IsActive", image.IsActive);
sqlParam.Add("@StatusId", image.StatusId);
sqlParam.Add("@IdentityReturn", dbType: DbType.Int64, direction: ParameterDirection.Output);
if (transaction != null)
{
transaction.Connection.Execute("[dbo].[AlbumImageInsert]", sqlParam, transaction, null,
CommandType.StoredProcedure);
}
else
{
using (IDbConnection connection = NewDataConnection) {
connection.Execute("[dbo].[AlbumImageInsert]", sqlParam, null, null, CommandType.StoredProcedure);
}
}
return(sqlParam.Get <long>("IdentityReturn"));
}
public ResultModel UpdateImageDestinationUrl(int albumId, string imageId, AlbumImageInfo image)
{
try
{
_albumService.UpdateImageDestinationUrl(albumId, imageId, image.DestinationUrl);
return(ResultModel.Success);
}
catch (Exception e)
{
_logService.LogError(e);
return(new ResultModel(e));
}
}
/// <summary>
/// Saves the object in the database by either inserting it if it was a newly created object or updating it if it has an exisiting record
/// </summary>
/// <param name="album"></param>
public static long Save(AlbumImageInfo album)
{
var transaction = DataProviderManager.Provider.NewDataTransaction;
var connection = transaction.Connection;
try {
var albumId = DataProviderManager.Provider.SaveAlbumImage(album, transaction);
transaction.Commit();
return(albumId);
} catch (Exception ex) {
transaction.Rollback();
throw;
} finally {
connection.Close();
}
}
public abstract long SaveAlbumImage(AlbumImageInfo image, IDbTransaction transation);
