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); }