public async Task <TagBaseContract> Create(string name)
{
ParamIs.NotNullOrWhiteSpace(() => name);
PermissionContext.VerifyManageDatabase();
return(await _repository.HandleTransactionAsync(async ctx =>
{
var duplicateName = await ctx.Query <TagName>()
.Select(t => t.Value)
.Where(t => t == name)
.VdbFirstOrDefaultAsync();
if (duplicateName != null)
{
throw new DuplicateTagNameException(duplicateName);
}
var factory = new TagFactoryRepository(ctx, ctx.CreateAgentLoginData(PermissionContext));
var tag = await factory.CreateTagAsync(name);
await ctx.AuditLogger.AuditLogAsync($"created tag {_entryLinkFactory.CreateEntryLink(tag)}");
return new TagBaseContract(tag, PermissionContext.LanguagePreference);
}));
}
public void Delete(int id, string notes)
{
PermissionContext.VerifyManageDatabase();
repository.HandleTransaction(ctx => {
var tag = LoadTagById(ctx, id);
permissionContext.VerifyEntryDelete(tag);
tag.Deleted = true;
ctx.AuditLogger.AuditLog(string.Format("deleted {0}", entryLinkFactory.CreateEntryLink(tag)));
Archive(ctx, tag, new TagDiff(false), EntryEditEvent.Deleted, notes);
ctx.Update(tag);
});
}
/// <summary>
/// Creates a new tag.
/// </summary>
/// <param name="name">Tag English name. Cannot be null or empty. Must be unique.</param>
/// <returns>The created tag. Cannot be null.</returns>
/// <exception cref="DuplicateTagNameException">If a tag with the specified name already exists.</exception>
public TagBaseContract Create(string name)
{
ParamIs.NotNullOrWhiteSpace(() => name);
PermissionContext.VerifyManageDatabase();
return(repository.HandleTransaction(ctx => {
var duplicateName = ctx.Query <TagName>()
.Select(t => t.Value)
.FirstOrDefault(t => t == name);
if (duplicateName != null)
{
throw new DuplicateTagNameException(duplicateName);
}
var factory = new TagFactoryRepository(ctx, ctx.CreateAgentLoginData(PermissionContext));
var tag = factory.CreateTag(name);
ctx.AuditLogger.AuditLog(string.Format("created tag {0}", entryLinkFactory.CreateEntryLink(tag)));
return new TagBaseContract(tag, PermissionContext.LanguagePreference);
}));
}
public int UpdateSeries(ReleaseEventSeriesForEditContract contract, EntryPictureFileContract pictureData)
{
ParamIs.NotNull(() => contract);
PermissionContext.VerifyManageDatabase();
return(HandleTransaction(session => {
ReleaseEventSeries series;
if (contract.Id == 0)
{
series = new ReleaseEventSeries(contract.DefaultNameLanguage, contract.Names, contract.Description)
{
Category = contract.Category,
Status = contract.Status
};
session.Save(series);
var diff = new ReleaseEventSeriesDiff(ReleaseEventSeriesEditableFields.OriginalName | ReleaseEventSeriesEditableFields.Names);
diff.Description.Set(!string.IsNullOrEmpty(contract.Description));
var weblinksDiff = WebLink.Sync(series.WebLinks, contract.WebLinks, series);
if (weblinksDiff.Changed)
{
diff.WebLinks.Set();
session.OfType <ReleaseEventWebLink>().Sync(weblinksDiff);
}
if (pictureData != null)
{
diff.Picture.Set();
SaveImage(series, pictureData);
session.Update(series);
}
session.Update(series);
Archive(session, series, diff, EntryEditEvent.Created, string.Empty);
AuditLog(string.Format("created {0}", entryLinkFactory.CreateEntryLink(series)), session);
}
else
{
series = session.Load <ReleaseEventSeries>(contract.Id);
permissionContext.VerifyEntryEdit(series);
var diff = new ReleaseEventSeriesDiff(ReleaseEventSeriesEditableFields.Nothing);
if (series.TranslatedName.DefaultLanguage != contract.DefaultNameLanguage)
{
series.TranslatedName.DefaultLanguage = contract.DefaultNameLanguage;
diff.OriginalName.Set();
}
var nameDiff = series.Names.Sync(contract.Names, series);
session.Sync(nameDiff);
if (nameDiff.Changed)
{
diff.Names.Set();
}
if (series.Category != contract.Category)
{
diff.Category.Set();
series.Category = contract.Category;
}
if (series.Description != contract.Description)
{
diff.Description.Set();
series.Description = contract.Description;
}
if (series.Status != contract.Status)
{
diff.Status.Set();
series.Status = contract.Status;
}
if (pictureData != null)
{
diff.Picture.Set();
SaveImage(series, pictureData);
}
var weblinksDiff = WebLink.Sync(series.WebLinks, contract.WebLinks, series);
if (weblinksDiff.Changed)
{
diff.WebLinks.Set();
session.OfType <ReleaseEventWebLink>().Sync(weblinksDiff);
}
session.Update(series);
if (diff.Names.IsChanged || diff.OriginalName.IsChanged)
{
var eventNamesQuery = new UpdateEventNamesQuery();
foreach (var ev in series.Events.Where(e => !e.CustomName))
{
eventNamesQuery.UpdateNames(session, ev, series, ev.CustomName, ev.SeriesNumber, ev.SeriesSuffix, ev.Names);
session.Update(ev);
}
}
Archive(session, series, diff, EntryEditEvent.Updated, string.Empty);
AuditLog(string.Format("updated {0}", entryLinkFactory.CreateEntryLink(series)), session);
}
return series.Id;
}));
}
/// <summary>
/// Updates or creates release event.
///
/// Album release event names will be updated as well if the name changed.
/// </summary>
/// <param name="contract">Updated contract. Cannot be null.</param>
/// <returns>Updated release event data. Cannot be null.</returns>
/// <exception cref="DuplicateEventNameException">If the event name is already in use.</exception>
public ReleaseEventContract Update(ReleaseEventForEditContract contract, EntryPictureFileContract pictureData)
{
ParamIs.NotNull(() => contract);
PermissionContext.VerifyManageDatabase();
return(repository.HandleTransaction(session => {
ReleaseEvent ev;
if (contract.Id == 0)
{
var diff = new ReleaseEventDiff();
if (!contract.Series.IsNullOrDefault())
{
var series = session.OfType <ReleaseEventSeries>().Load(contract.Series.Id);
ev = new ReleaseEvent(contract.Description, contract.Date, series, contract.SeriesNumber, contract.SeriesSuffix,
contract.DefaultNameLanguage, contract.CustomName);
series.AllEvents.Add(ev);
}
else
{
ev = new ReleaseEvent(contract.Description, contract.Date, contract.DefaultNameLanguage);
}
ev.Category = contract.Category;
ev.EndDate = contract.EndDate;
ev.SongList = session.NullSafeLoad <SongList>(contract.SongList);
ev.Status = contract.Status;
ev.VenueName = contract.VenueName;
if (contract.SongList != null)
{
diff.SongList.Set();
}
if (!string.IsNullOrEmpty(contract.VenueName))
{
diff.Venue.Set();
}
var weblinksDiff = WebLink.Sync(ev.WebLinks, contract.WebLinks, ev);
if (weblinksDiff.Changed)
{
diff.WebLinks.Set();
}
var pvDiff = ev.PVs.Sync(contract.PVs, ev.CreatePV);
session.OfType <PVForAlbum>().Sync(pvDiff);
if (pvDiff.Changed)
{
diff.PVs.Set();
}
var artistDiff = ev.SyncArtists(contract.Artists, artistId => session.Load <Artist>(artistId));
if (artistDiff.Changed)
{
diff.Artists.Set();
}
session.Save(ev);
var namesChanged = new UpdateEventNamesQuery().UpdateNames(session, ev, contract.Series, contract.CustomName, contract.SeriesNumber, contract.SeriesSuffix, contract.Names);
if (namesChanged)
{
session.Update(ev);
}
if (pictureData != null)
{
diff.MainPicture.Set();
SaveImage(ev, pictureData);
session.Update(ev);
}
var archived = Archive(session, ev, diff, EntryEditEvent.Created, string.Empty);
AddEntryEditedEntry(session.OfType <ActivityEntry>(), archived);
session.AuditLogger.AuditLog(string.Format("created {0}", entryLinkFactory.CreateEntryLink(ev)));
new FollowedArtistNotifier().SendNotifications(session, ev, ev.Artists.Where(a => a?.Artist != null).Select(a => a.Artist), PermissionContext.LoggedUser, entryLinkFactory, mailer, enumTranslations);
}
else
{
ev = session.Load(contract.Id);
permissionContext.VerifyEntryEdit(ev);
var diff = new ReleaseEventDiff(DoSnapshot(ev, session));
if (ev.Category != contract.Category)
{
diff.Category.Set();
}
if (!ev.Date.Equals(contract.Date) || !ev.EndDate.Equals(contract.EndDate))
{
diff.Date.Set();
}
if (ev.Description != contract.Description)
{
diff.Description.Set();
}
var inheritedLanguage = ev.Series == null || contract.CustomName ? contract.DefaultNameLanguage : ev.Series.TranslatedName.DefaultLanguage;
if (ev.TranslatedName.DefaultLanguage != inheritedLanguage)
{
diff.OriginalName.Set();
}
var namesChanged = new UpdateEventNamesQuery().UpdateNames(session, ev, contract.Series, contract.CustomName, contract.SeriesNumber, contract.SeriesSuffix, contract.Names);
if (namesChanged)
{
diff.Names.Set();
}
if (!ev.Series.NullSafeIdEquals(contract.Series))
{
diff.Series.Set();
}
if (ev.SeriesNumber != contract.SeriesNumber)
{
diff.SeriesNumber.Set();
}
if (ev.SeriesSuffix != contract.SeriesSuffix)
{
diff.SeriesSuffix.Set();
}
if (!ev.SongList.NullSafeIdEquals(contract.SongList))
{
diff.SongList.Set();
}
if (ev.Status != contract.Status)
{
diff.Status.Set();
}
if (!string.Equals(ev.VenueName, contract.VenueName))
{
diff.Venue.Set();
}
ev.SetSeries(session.NullSafeLoad <ReleaseEventSeries>(contract.Series));
ev.Category = contract.Category;
ev.CustomName = contract.CustomName;
ev.Date = contract.Date;
ev.Description = contract.Description;
ev.EndDate = contract.EndDate > contract.Date ? contract.EndDate : null;
ev.SeriesNumber = contract.SeriesNumber;
ev.SeriesSuffix = contract.SeriesSuffix;
ev.SongList = session.NullSafeLoad <SongList>(contract.SongList);
ev.Status = contract.Status;
ev.TranslatedName.DefaultLanguage = inheritedLanguage;
ev.VenueName = contract.VenueName;
var weblinksDiff = WebLink.Sync(ev.WebLinks, contract.WebLinks, ev);
if (weblinksDiff.Changed)
{
diff.WebLinks.Set();
session.OfType <ReleaseEventWebLink>().Sync(weblinksDiff);
}
var pvDiff = ev.PVs.Sync(contract.PVs, ev.CreatePV);
session.OfType <PVForAlbum>().Sync(pvDiff);
if (pvDiff.Changed)
{
diff.PVs.Set();
}
var artistDiff = ev.SyncArtists(contract.Artists, artistId => session.Load <Artist>(artistId));
if (artistDiff.Changed)
{
diff.Artists.Set();
}
if (pictureData != null)
{
diff.MainPicture.Set();
SaveImage(ev, pictureData);
}
session.Update(ev);
var archived = Archive(session, ev, diff, EntryEditEvent.Updated, string.Empty);
AddEntryEditedEntry(session.OfType <ActivityEntry>(), archived);
var logStr = string.Format("updated properties for {0} ({1})", entryLinkFactory.CreateEntryLink(ev), diff.ChangedFieldsString);
session.AuditLogger.AuditLog(logStr);
var newSongCutoff = TimeSpan.FromHours(1);
if (artistDiff.Added.Any() && ev.CreateDate >= DateTime.Now - newSongCutoff)
{
var addedArtists = artistDiff.Added.Where(a => a.Artist != null).Select(a => a.Artist).Distinct().ToArray();
if (addedArtists.Any())
{
new FollowedArtistNotifier().SendNotifications(session, ev, addedArtists, PermissionContext.LoggedUser, entryLinkFactory, mailer, enumTranslations);
}
}
}
return new ReleaseEventContract(ev, LanguagePreference);
}));
}
/// <summary>
/// Updates or creates release event.
///
/// Album release event names will be updated as well if the name changed.
/// </summary>
/// <param name="contract">Updated contract. Cannot be null.</param>
/// <returns>Updated release event data. Cannot be null.</returns>
public ReleaseEventContract Update(ReleaseEventDetailsContract contract)
{
ParamIs.NotNull(() => contract);
PermissionContext.VerifyManageDatabase();
return(repository.HandleTransaction(session => {
ReleaseEvent ev;
if (contract.Id == 0)
{
var diff = new ReleaseEventDiff();
if (!contract.Series.IsNullOrDefault())
{
var series = session.OfType <ReleaseEventSeries>().Load(contract.Series.Id);
ev = new ReleaseEvent(contract.Description, contract.Date, series, contract.SeriesNumber, contract.SeriesSuffix,
contract.Name, contract.CustomName);
series.Events.Add(ev);
}
else
{
ev = new ReleaseEvent(contract.Description, contract.Date, contract.Name);
}
var weblinksDiff = WebLink.Sync(ev.WebLinks, contract.WebLinks, ev);
if (weblinksDiff.Changed)
{
diff.WebLinks.Set();
}
CheckDuplicateName(session, ev);
session.Save(ev);
var archived = Archive(session, ev, diff, EntryEditEvent.Created, string.Empty);
AddEntryEditedEntry(session.OfType <ActivityEntry>(), archived);
session.AuditLogger.AuditLog(string.Format("created {0}", entryLinkFactory.CreateEntryLink(ev)));
}
else
{
ev = session.Load(contract.Id);
var diff = new ReleaseEventDiff(DoSnapshot(ev, session));
if (!ev.Date.Equals(contract.Date))
{
diff.Date.Set();
}
if (ev.Description != contract.Description)
{
diff.Description.Set();
}
if (ev.Name != contract.Name && (contract.Series == null || contract.CustomName))
{
diff.Name.Set();
}
if (!ev.Series.NullSafeIdEquals(contract.Series))
{
diff.Series.Set();
}
if (ev.SeriesNumber != contract.SeriesNumber)
{
diff.SeriesNumber.Set();
}
if (ev.SeriesSuffix != contract.SeriesSuffix)
{
diff.SeriesSuffix.Set();
}
var oldName = ev.Name;
ev.Series = session.OfType <ReleaseEventSeries>().NullSafeLoad(contract.Series);
ev.CustomName = contract.CustomName;
ev.Date = contract.Date;
ev.Description = contract.Description;
ev.Name = contract.Name;
ev.SeriesNumber = contract.SeriesNumber;
ev.SeriesSuffix = contract.SeriesSuffix;
ev.UpdateNameFromSeries();
var weblinksDiff = WebLink.Sync(ev.WebLinks, contract.WebLinks, ev);
if (weblinksDiff.Changed)
{
diff.WebLinks.Set();
session.OfType <ReleaseEventWebLink>().Sync(weblinksDiff);
}
CheckDuplicateName(session, ev);
session.Update(ev);
var archived = Archive(session, ev, diff, EntryEditEvent.Updated, string.Empty);
AddEntryEditedEntry(session.OfType <ActivityEntry>(), archived);
var logStr = string.Format("updated properties for {0} ({1})", entryLinkFactory.CreateEntryLink(ev), diff.ChangedFieldsString);
session.AuditLogger.AuditLog(logStr);
}
return new ReleaseEventContract(ev);
}));
}
public int Update(VenueForEditContract contract)
{
ParamIs.NotNull(() => contract);
PermissionContext.VerifyManageDatabase();
return(HandleTransaction(ctx =>
{
Venue venue;
if (contract.Id == 0)
{
venue = new Venue(contract.DefaultNameLanguage, contract.Names, contract.Description)
{
Address = contract.Address,
AddressCountryCode = contract.AddressCountryCode,
Coordinates = (contract.Coordinates != null) ? new OptionalGeoPoint(contract.Coordinates) : new OptionalGeoPoint(),
Status = contract.Status
};
ctx.Save(venue);
var diff = new VenueDiff(VenueEditableFields.OriginalName | VenueEditableFields.Names);
diff.Address.Set(!string.IsNullOrEmpty(contract.Address));
diff.AddressCountryCode.Set(!string.IsNullOrEmpty(contract.AddressCountryCode));
diff.Description.Set(!string.IsNullOrEmpty(contract.Description));
if (contract.Coordinates != null)
{
diff.Coordinates.Set();
}
var webLinkDiff = venue.WebLinks.Sync(contract.WebLinks, venue);
ctx.OfType <VenueWebLink>().Sync(webLinkDiff);
if (webLinkDiff.Changed)
{
diff.WebLinks.Set();
}
ctx.Update(venue);
var archived = Archive(ctx, venue, diff, EntryEditEvent.Created, string.Empty);
AddEntryEditedEntry(ctx.OfType <ActivityEntry>(), venue, EntryEditEvent.Created, archived);
AuditLog($"created {_entryLinkFactory.CreateEntryLink(venue)}", ctx);
}
else
{
venue = ctx.Load <Venue>(contract.Id);
_permissionContext.VerifyEntryEdit(venue);
var diff = new VenueDiff(DoSnapshot(venue, ctx));
if (venue.TranslatedName.DefaultLanguage != contract.DefaultNameLanguage)
{
venue.TranslatedName.DefaultLanguage = contract.DefaultNameLanguage;
diff.OriginalName.Set();
}
var nameDiff = venue.Names.Sync(contract.Names, venue);
ctx.Sync(nameDiff);
if (nameDiff.Changed)
{
diff.Names.Set();
}
if (venue.Address != contract.Address)
{
diff.Address.Set();
venue.Address = contract.Address;
}
if (venue.AddressCountryCode != contract.AddressCountryCode)
{
diff.AddressCountryCode.Set();
venue.AddressCountryCode = contract.AddressCountryCode;
}
if (venue.Description != contract.Description)
{
diff.Description.Set();
venue.Description = contract.Description;
}
if (!venue.Coordinates.Equals(contract.Coordinates))
{
diff.Coordinates.Set();
venue.Coordinates = (contract.Coordinates != null) ? new OptionalGeoPoint(contract.Coordinates) : new OptionalGeoPoint();
}
if (venue.Status != contract.Status)
{
diff.Status.Set();
venue.Status = contract.Status;
}
var webLinkDiff = venue.WebLinks.Sync(contract.WebLinks, venue);
ctx.OfType <VenueWebLink>().Sync(webLinkDiff);
if (webLinkDiff.Changed)
{
diff.WebLinks.Set();
}
ctx.Update(venue);
var archived = Archive(ctx, venue, diff, EntryEditEvent.Updated, string.Empty);
AddEntryEditedEntry(ctx.OfType <ActivityEntry>(), venue, EntryEditEvent.Updated, archived);
AuditLog($"updated {_entryLinkFactory.CreateEntryLink(venue)}", ctx);
}
return venue.Id;
}));
}
/// <summary>
/// Updates or creates release event.
///
/// Album release event names will be updated as well if the name changed.
/// </summary>
/// <param name="contract">Updated contract. Cannot be null.</param>
/// <returns>Updated release event data. Cannot be null.</returns>
public ReleaseEventContract Update(ReleaseEventDetailsContract contract)
{
ParamIs.NotNull(() => contract);
PermissionContext.VerifyManageDatabase();
return(repository.HandleTransaction(session => {
ReleaseEvent ev;
if (contract.Id == 0)
{
if (contract.Series != null)
{
var series = session.OfType <ReleaseEventSeries>().Load(contract.Series.Id);
ev = new ReleaseEvent(contract.Description, contract.Date, series, contract.SeriesNumber, contract.SeriesSuffix);
series.Events.Add(ev);
}
else
{
ev = new ReleaseEvent(contract.Description, contract.Date, contract.Name);
}
session.Save(ev);
Archive(session, ev, new ReleaseEventDiff(), EntryEditEvent.Created);
session.AuditLogger.AuditLog("created " + ev);
}
else
{
ev = session.Load(contract.Id);
var diff = new ReleaseEventDiff();
if (ev.Date != contract.Date)
{
diff.Date = true;
}
if (ev.Description != contract.Description)
{
diff.Description = true;
}
if (ev.Name != contract.Name)
{
diff.Name = true;
}
if (ev.SeriesNumber != contract.SeriesNumber)
{
diff.SeriesNumber = true;
}
if (ev.SeriesSuffix != contract.SeriesSuffix)
{
diff.SeriesSuffix = true;
}
var oldName = ev.Name;
ev.Date = contract.Date;
ev.Description = contract.Description;
ev.Name = contract.Name;
ev.SeriesNumber = contract.SeriesNumber;
ev.SeriesSuffix = contract.SeriesSuffix;
ev.UpdateNameFromSeries();
UpdateAllReleaseEventNames(session, oldName, ev.Name);
session.Update(ev);
Archive(session, ev, diff, EntryEditEvent.Updated);
var logStr = string.Format("updated properties for {0} ({1})", entryLinkFactory.CreateEntryLink(ev), diff.ChangedFieldsString);
session.AuditLogger.AuditLog(logStr);
}
return new ReleaseEventContract(ev);
}));
}