public static ActionResult Tag(BaseController controller, int id, int?personId = null, int?showId = null)
{
if (id == Photo.NoPic)
{
controller.RollbackTransactionFast();
return(new HttpBadRequestResult("Cannot tag this photo."));
}
if (personId.HasValue && !controller.DatabaseSession.Query <PersonPhoto>().Any(x => x.Photo.PhotoId == id && x.Person.PersonId == personId.Value))
{
var personPhoto = new PersonPhoto();
personPhoto.Person = controller.DatabaseSession.Load <Person>(personId.Value);
personPhoto.Photo = controller.DatabaseSession.Load <Photo>(id);
personPhoto.InsertedDateTime = DateTime.UtcNow;
controller.DatabaseSession.Save(personPhoto);
}
if (showId.HasValue && !controller.DatabaseSession.Query <ShowPhoto>().Any(x => x.Photo.PhotoId == id && x.Show.ShowId == showId.Value))
{
var showPhoto = new ShowPhoto();
showPhoto.Show = controller.DatabaseSession.Load <Show>(showId.Value);
showPhoto.Photo = controller.DatabaseSession.Load <Photo>(id);
showPhoto.InsertedDateTime = DateTime.UtcNow;
controller.DatabaseSession.Save(showPhoto);
}
return(null);
}
public ActionResult Upload(int showId, PhotosController.UploadPOSTParameters param)
{
var validationResult = param.Validate();
if (validationResult != null)
{
return(validationResult);
}
var photo = PhotosController.Upload(this, param);
var showPhoto = new ShowPhoto();
showPhoto.Show = DatabaseSession.Load <Show>(showId);
showPhoto.Photo = photo;
showPhoto.InsertedDateTime = DateTime.UtcNow;
DatabaseSession.Save(showPhoto);
return(Redirect(Url.GetUrl(ListShowPhotos, showId, (int?)photo.PhotoId)));
}
private static void ImportShowPhotos()
{
var media = oldDatabaseConnection.Query("SELECT * FROM media").ToList();
Log("Importing " + media.Count + " show media");
using (var session = sessionFactory.OpenSession())
{
session.Transaction.Begin();
session.CreateSQLQuery("SET IDENTITY_INSERT [dbo].ShowPhoto ON;").ExecuteUpdate();
var maxId = 0;
foreach (var _row in media)
{
if (_row.IDtype.ToLower() != "shows")
{
continue;
}
var entity = new ShowPhoto();
entity.ShowPhotoId = _row.ID;
entity.Show = session.Load <Show>(_row.assocID);
entity.Photo = session.Load <Photo>(_row.item_id);
entity.InsertedDateTime = DateTime.MinValue;
if (_row.last_mod != null)
{
entity.InsertedDateTime = TimeZoneInfo.ConvertTimeToUtc(_row.last_mod, TimeZoneCode.Eastern.ToTimeZoneInfo());
}
session.Save(entity, entity.ShowPhotoId);
if (entity.ShowPhotoId > maxId)
{
maxId = entity.ShowPhotoId;
}
}
session.Flush();
session.CreateSQLQuery("SET IDENTITY_INSERT [dbo].ShowPhoto OFF;").ExecuteUpdate();
session.CreateSQLQuery("DBCC CHECKIDENT ('dbo.ShowPhoto', RESEED, " + (maxId + 1) + ")").ExecuteUpdate();
session.Transaction.Commit();
session.Close();
}
}
public static ActionResult Tag(BaseController controller, int id, int? personId = null, int? showId = null)
{
if (id == Photo.NoPic)
{
controller.RollbackTransactionFast();
return new HttpBadRequestResult("Cannot tag this photo.");
}
if (personId.HasValue && !controller.DatabaseSession.Query<PersonPhoto>().Any(x => x.Photo.PhotoId == id && x.Person.PersonId == personId.Value))
{
var personPhoto = new PersonPhoto();
personPhoto.Person = controller.DatabaseSession.Load<Person>(personId.Value);
personPhoto.Photo = controller.DatabaseSession.Load<Photo>(id);
personPhoto.InsertedDateTime = DateTime.UtcNow;
controller.DatabaseSession.Save(personPhoto);
}
if (showId.HasValue && !controller.DatabaseSession.Query<ShowPhoto>().Any(x => x.Photo.PhotoId == id && x.Show.ShowId == showId.Value))
{
var showPhoto = new ShowPhoto();
showPhoto.Show = controller.DatabaseSession.Load<Show>(showId.Value);
showPhoto.Photo = controller.DatabaseSession.Load<Photo>(id);
showPhoto.InsertedDateTime = DateTime.UtcNow;
controller.DatabaseSession.Save(showPhoto);
}
return null;
}
public ActionResult Upload(int showId, PhotosController.UploadPOSTParameters param)
{
var validationResult = param.Validate();
if (validationResult != null)
{
return validationResult;
}
var photo = PhotosController.Upload(this, param);
var showPhoto = new ShowPhoto();
showPhoto.Show = DatabaseSession.Load<Show>(showId);
showPhoto.Photo = photo;
showPhoto.InsertedDateTime = DateTime.UtcNow;
DatabaseSession.Save(showPhoto);
return Redirect(Url.GetUrl(ListShowPhotos, showId, (int?)photo.PhotoId));
}
private void buttonShow_Click(object sender, RoutedEventArgs e)
{
ShowPhoto showPhoto = new ShowPhoto(Visit.file);
showPhoto.ShowDialog();
}
