public Models.File LoadByArtworkId(int id)
{
if (id != null)
{
List <Models.File> files = new List <Models.File>();
BL.Artwork artwork = new BL.Artwork();
var file = db.Files.FirstOrDefault(f => f.ArtworkId == id);
if (file != null)
{
Models.File f = new Models.File
{
Id = file.Id,
ArtworkId = file.ArtworkId,
UserId = file.UserId,
Content = file.Content,
ContentType = file.ContentType,
FileName = file.FileName,
Artwork = artwork.LoadById(file.ArtworkId)
};
return(f);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
public List <Models.File> LoadByUserId(int id)
{
if (id != null)
{
List <Models.File> files = new List <Models.File>();
BL.Artwork artwork = new BL.Artwork();
Models.FileType fileType = new Models.FileType();
db.Files.Where(f => f.UserId == id)
.ToList()
.ForEach(f => files
.Add(new Models.File
{
Id = f.Id,
ArtworkId = f.ArtworkId,
UserId = f.UserId,
FileName = f.FileName,
FileType = (Models.FileType)f.FileType,
ContentType = f.ContentType,
Content = f.Content,
Artwork = artwork.LoadById(f.ArtworkId)
}));
return(files);
}
else
{
return(null);
}
}
public bool Delete(int id)
{
BL.Artwork artwork = new BL.Artwork();
Net.Models.Artwork _artwork = new Net.Models.Artwork();
Net.Models.Message _message = new Net.Models.Message();
_artwork = artwork.LoadById(id);
var existArt = db.Artworks.SingleOrDefault(x => x.Id == id);
var existFile = db.Files.SingleOrDefault(f => f.ArtworkId == id);
var existCol = db.Collections.SingleOrDefault(f => f.Id == _artwork.CollectionMessageId);
var existMsg = db.Messages.Where(a => a.CollectionId == _artwork.CollectionMessageId).ToList();
if (existArt != null || existFile != null || existCol != null)
{
db.Artworks.Remove(existArt);
db.Files.Remove(existFile);
db.Collections.Remove(existCol);
existMsg.ForEach(x => db.Messages.Remove(x));
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public List <Models.File> Load()
{
List <Models.File> files = new List <Models.File>();
BL.Artwork artwork = new BL.Artwork();
db.Files.ToList().ForEach(f => files
.Add(new Models.File
{
Id = f.Id,
FileName = f.FileName,
ContentType = f.ContentType,
Content = f.Content,
UserId = f.UserId,
ArtworkId = f.ArtworkId,
Artwork = artwork.LoadById(f.ArtworkId)
}));
return(files);
}
public List <Models.File> LoadByUserGalleryId(int userId, int galleryId)
{
if (userId != null && galleryId != null)
{
List <Models.File> files = new List <Models.File>();
BL.Artwork artwork = new BL.Artwork();
var results = (from f in db.Files
join a in db.Artworks on f.ArtworkId equals a.Id
where (a.GalleryId == galleryId && f.UserId == userId)
select new
{
f.Id,
f.ArtworkId,
f.UserId,
f.FileName,
f.ContentType,
f.Content,
f.FileType
}).ToList();
foreach (var r in results)
{
files.Add(new Models.File
{
Id = r.Id,
ArtworkId = r.ArtworkId,
UserId = r.UserId,
FileName = r.FileName,
ContentType = r.ContentType,
Content = r.Content,
FileType = (Models.FileType)r.FileType,
Artwork = artwork.LoadById(r.ArtworkId)
});;
}
return(files);
}
else
{
return(null);
}
}
public List <Models.File> LoadByUserFileTypeId(int userId, Net.Models.FileType fileType)
{
if (fileType != null)
{
List <Models.File> files = new List <Models.File>();
BL.Artwork artwork = new BL.Artwork();
var results = (from f in db.Files
where (f.FileType == (tblFileType)fileType && f.UserId == userId)
select new
{
f.Id,
f.ArtworkId,
f.UserId,
f.FileName,
f.ContentType,
f.Content,
f.FileType
}).ToList();
foreach (var r in results)
{
files.Add(new Models.File
{
Id = r.Id,
ArtworkId = r.ArtworkId,
UserId = r.UserId,
FileName = r.FileName,
ContentType = r.ContentType,
Content = r.Content,
FileType = (Models.FileType)r.FileType,
Artwork = artwork.LoadById(r.ArtworkId)
});
}
return(files);
}
else
{
return(null);
}
}
public ActionResult Edit(UserGalleryArtworkFile ugaf, Net.Models.File file, HttpPostedFileBase upload)
{
if (ModelState.IsValid)
{
//ugaf.User = (Net.Models.User)Session["user"];
Net.Models.User user = (Net.Models.User)Session["user"];
BL.User userHelper = new BL.User();
BL.File fileHelper = new BL.File();
BL.Artwork artworkHelper = new BL.Artwork();
var oldFile = fileHelper.LoadByUserId(user.Id);
Net.Models.File existingFile = new Net.Models.File();
Net.Models.User newUser = userHelper.LoadById(user.Id);
using (userHelper = new BL.User())
{
newUser.FirstName = ugaf.User.FirstName;
newUser.LastName = ugaf.User.LastName;
newUser.Password = ugaf.User.Password;
newUser.CommissionActive = ugaf.User.CommissionActive;
}
foreach (var f in oldFile)
{
existingFile.ArtworkId = f.ArtworkId;
existingFile.Content = f.Content;
existingFile.ContentType = f.ContentType;
existingFile.FileName = f.FileName;
existingFile.FileType = f.FileType;
existingFile.Id = f.Id;
existingFile.UserId = f.UserId;
existingFile.Artwork = artworkHelper.LoadById(f.ArtworkId);
existingFile.User = newUser;
}
try
{
if (upload != null && upload.ContentLength > 0)
{
file = new Net.Models.File
{
Id = existingFile.Id,
FileName = System.IO.Path.GetFileName(upload.FileName),
FileType = FileType.Avatar,
ContentType = upload.ContentType,
Content = existingFile.Content,
Artwork = existingFile.Artwork,
User = existingFile.User,
UserId = existingFile.UserId,
ArtworkId = existingFile.ArtworkId
};
using (var reader = new System.IO.BinaryReader(upload.InputStream))
{
file.Content = reader.ReadBytes(upload.ContentLength);
}
System.Diagnostics.Debug.WriteLine(newUser.Id);
System.Diagnostics.Debug.WriteLine(file.FileName);
ugaf.User.Files = new List<Net.Models.File> { file };
userHelper.Update(newUser, file);
}
else
{
ugaf.User = newUser;
userHelper.Update(newUser, existingFile);
}
return RedirectToAction("Index");
}
catch (Exception ex)
{
ViewBag.Message = ex.Message;
return View(ugaf);
}
}
return View();
}