public int Insert(Models.User user, Models.File file)
{
try
{
using (var transactionContext = db.Database.BeginTransaction())
{
tblUser newUser = new tblUser
{
FirstName = user.FirstName,
LastName = user.LastName,
Email = user.Email,
JoinDate = DateTime.Now,
UserName = user.UserName,
CommissionActive = user.CommissionActive,
Password = GetHash(user.Password)
};
db.Users.Add(newUser);
db.SaveChanges();
tblArtwork newArtwork = new tblArtwork
{
//GalleryId = newArtwork.GalleryId,
Title = file.FileName,
Price = 0,
IsCommission = false,
DateCreated = DateTime.Now
};
db.Artworks.Add(newArtwork);
db.SaveChanges();
tblFiles newFile = new tblFiles()
{
FileName = file.FileName,
ContentType = file.ContentType,
Content = file.Content,
UserId = newUser.Id,
User = newUser,
FileType = (Net.Data1.tblFileType)file.FileType,
ArtworkId = newArtwork.Id,
Artwork = newArtwork
};
db.Files.Add(newFile);
db.SaveChanges();
transactionContext.Commit();
return(newUser.Id);
}
}
catch (Exception ex)
{
var inner = ex.InnerException;
throw;
}
}
public int Insert(Models.Artwork artwork, Models.File file)
{
tblCollection newCollection = new tblCollection {
MessageTypeId = 3
};
db.Collections.Add(newCollection);
db.SaveChanges();
tblArtwork tblArtwork = new tblArtwork {
GalleryId = artwork.GalleryId,
Title = artwork.Title,
Price = artwork.Price,
IsCommission = artwork.IsCommission,
TagId = artwork.TagId,
CollectionMessageId = newCollection.Id,
DateCreated = DateTime.Now
};
db.Artworks.Add(tblArtwork);
db.SaveChanges();
tblFiles tblFiles = new tblFiles
{
FileName = file.FileName,
ContentType = file.ContentType,
Content = file.Content,
FileType = tblFileType.Photo,
ArtworkId = artwork.Id,
UserId = file.UserId,
Artwork = tblArtwork
};
db.Files.Add(tblFiles);
db.SaveChanges();
return(tblArtwork.Id);
}
