public void GenerateUpdateStatement_WhenCalled_GeneratesCorrectSqlStatement()
{
var randomCustomerName = TestData.CreateRandomString();
var randomCustomerContact = TestData.CreateRandomString();
var artwork = new ArtWork
{
Id = 1,
UserId = 10,
CustomerName = randomCustomerName,
CustomerContact = randomCustomerContact
};
var sqlStatement = _sut.GenerateUpdateStatement(artwork);
Assert.That(sqlStatement.StartsWith($"UPDATE artwork_table SET "));
Assert.That(sqlStatement.Contains("user_id"));
Assert.That(sqlStatement.Contains("customer_name"));
Assert.That(sqlStatement.Contains("customer_contact"));
Assert.That(sqlStatement.Contains($"{artwork.UserId}"));
Assert.That(sqlStatement.Contains($"{randomCustomerName}"));
Assert.That(sqlStatement.Contains($"{randomCustomerContact}"));
Assert.That(sqlStatement.EndsWith($"WHERE id = {artwork.Id};"));
Assert.That(!sqlStatement.Contains("date_finished"));
Assert.That(!sqlStatement.Contains("sale_price"));
}
public ActionResult Create(ArtWork artwork)
{
string artistId = User.Identity.GetUserId();
ApplicationUser artist = db.Users.SingleOrDefault(i => i.Id == artistId);
DateTime published = DateTime.Now.Date; //
if (artwork.ImageFile == null)
{
artwork.Thumbnail = "no_image.jpg";
}
else
{
string extension = Path.GetExtension(artwork.ImageFile.FileName);
artwork.Thumbnail = Guid.NewGuid().ToString() + extension;
string fileName = Path.Combine(Server.MapPath("~/ArtWorksImages/"), artwork.Thumbnail);
artwork.ImageFile.SaveAs(fileName);
}
if (!ModelState.IsValid)
{
return(View(artwork));
}
_artWorksRepository.AddArtWork(artwork.Name, artwork.Length, artwork.Width, artwork.style, artwork.type,
artwork.media, artwork.surface, artwork.Price, published, artwork.Thumbnail, artist, artwork.TagIds);
return(RedirectToAction("Index", "Profile"));
}
public ActionResult EditArts(EditModel model, HttpPostedFileBase upload, int Id)
{
if (upload != null)
{
string fileName = System.IO.Path.GetFileName(upload.FileName);
upload.SaveAs(Server.MapPath("~/Files/" + fileName));
int photoId;
using (ArtContext db1 = new ArtContext())
{
PhotoArt p1 = new PhotoArt {
PhotoName = fileName, Photo = Server.MapPath("~/ Files / " + fileName)
};
db1.PhotoArts.Add(p1);
db1.SaveChanges();
photoId = p1.Id;
ArtWork artWork = db1.ArtWorks.Where(p => p.Id == Id).FirstOrDefault();
artWork.PhotoArtId = photoId;
db1.SaveChanges();
}
}
else
{
db.Entry(model.ArtWorks).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("ListArts"));
}
public void GenerateInsertStatement_WhenCalledWithValidArtwork_GeneratesEmptySqlStatement()
{
var randomCustomerName = TestData.CreateRandomString();
var randomCustomerContact = TestData.CreateRandomString();
var artwork = new ArtWork
{
Id = 1,
UserId = 10,
CustomerName = randomCustomerName,
CustomerContact = randomCustomerContact
};
var sqlStatement = _sut.GenerateInsertStatement(artwork);
Assert.That(sqlStatement.StartsWith($"INSERT INTO artwork_table ("));
Assert.That(sqlStatement.Contains(") VALUES ("));
Assert.That(sqlStatement.Contains("user_id"));
Assert.That(sqlStatement.Contains("customer_name"));
Assert.That(sqlStatement.Contains("customer_contact"));
Assert.That(sqlStatement.Contains($"{artwork.UserId}"));
Assert.That(sqlStatement.Contains($"{randomCustomerName}"));
Assert.That(sqlStatement.Contains($"{randomCustomerContact}"));
Assert.That(sqlStatement.EndsWith(");"));
Assert.That(!sqlStatement.Contains("date_finished"));
Assert.That(!sqlStatement.Contains("sale_price"));
}
private void CreateArtWorks()
{
if (!_context.Authors.Any())
{
var artwork = new ArtWork
{
Name = "Mona Lisa",
Caption = "The painting is thought to be a portrait of Lisa Gherardini, the wife of Francesco del Giocondo, and is in oil on a white Lombardy poplar panel. It had been believed to have been painted between 1503 and 1506; however, Leonardo may have continued working on it as late as 1517. Recent academic work suggests that it would not have been started before 1513.",
AuthorId = 1,
CategoryId = 1
};
_context.ArtWorks.Add(artwork);
artwork = new ArtWork
{
Name = "The Last Supper",
Caption = "The painting represents the scene of the Last Supper of Jesus with his apostles, as it is told in the Gospel of John, 13:21. Leonardo has depicted the consternation that occurred among the Twelve Disciples when Jesus announced that one of them would betray him.",
AuthorId = 1,
CategoryId = 1
};
_context.ArtWorks.Add(artwork);
artwork = new ArtWork
{
Name = "Vitruvian Man",
Caption = "The drawing is based on the correlations of ideal human proportions with geometry described by the ancient Roman architect Vitruvius in Book III of his treatise De architectura. Vitruvius described the human figure as being the principal source of proportion among the classical orders of architecture. Vitruvius determined that the ideal body should be eight heads high. Leonardo's drawing is traditionally named in honor of the architect.",
AuthorId = 1,
CategoryId = 2
};
_context.ArtWorks.Add(artwork);
_context.SaveChanges();
}
}
public void GenerateInsertStatement_WhenCalledWithEmptyArtwork_GeneratesEmptySqlStatement()
{
var artwork = new ArtWork();
var sqlStatement = _sut.GenerateInsertStatement(artwork);
Assert.That(sqlStatement, Is.EqualTo($"INSERT INTO artwork_table () VALUES ();"));
}
public SerieEpisode(string title, int duration, ArtWork art, string serie, int season, int epNumber)
: base(title, duration, art)
{
this.serie = serie;
this.season = season;
this.epNumber = epNumber;
this.metalabel = "Serie Episode";
}
public ActionResult DeleteConfirmed(long id)
{
ArtWork artWork = db.ArtWorks.Find(id);
db.ArtWorks.Remove(artWork);
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
public string GenerateInsertStatement(ArtWork artWork)
{
var properties = GetSqlProperties(artWork);
var values = GetSqlValues(artWork);
return($"INSERT INTO artwork_table (" +
$"{(properties.Length > 0 ? $"{properties}" : "")}" +
$") VALUES (" +
$"{(values.Length > 0 ? $"{values}" : "")});");
}
public async Task <IActionResult> OnGetAsync(int id)
{
ArtWork = await _db.ArtWorks.FindAsync(id);
if (ArtWork == null)
{
return(RedirectToPage("/Index"));
}
return(Page());
}
public ActionResult DeleteArt(int id)
{
ArtWork b = db.ArtWorks.Find(id);
if (b == null)
{
return(HttpNotFound());
}
return(View(b));
}
public JsonResult getLogInfoDeserialised(string UsedModel, string LogDate, string LogDateTo)
{
DataTable dt = new DataTable();
// For Holding Entity Data
ArtWork artWork = new ArtWork();
return(Json("", JsonRequestBehavior.AllowGet));
}
public async Task <IActionResult> UpdateArtWork(int workId, ArtWork artWork)
{
if (workId != artWork.Id)
{
return(BadRequest());
}
//data.UpdateWork(artWork);
return(NoContent());
}
public async Task AddArtWork(ArtWork awToAdd)
{
var response = await client.PostAsJsonAsync("/api/artworks", awToAdd);
if (!response.IsSuccessStatusCode)
{
var ex = Jeeves.CreateApiException(response);
throw ex;
}
}
public async Task DeleteArtWork(ArtWork awToDelete)
{
var response = await client.DeleteAsync($"/api/artworks/{awToDelete.ID}");
if (!response.IsSuccessStatusCode)
{
var ex = Jeeves.CreateApiException(response);
throw ex;
}
}
public ActionResult Edit(ArtWork artwork)
{
if (!ModelState.IsValid)
{
return(View(artwork));
}
_artWorksRepository.UpdateArtWork(artwork);
return(RedirectToAction("Index"));
}
public void UpdateArtWork(ArtWork artwork)
{
Throw.IfNull(artwork, nameof(artwork));
using (ApplicationDbContext db = new ApplicationDbContext())
{
db.ArtWorks.Attach(artwork);
db.Entry(artwork).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public ActionResult Edit([Bind(Include = "ArtWorkID,Title,ArtistID")] ArtWork artWork)
{
if (ModelState.IsValid)
{
db.Entry(artWork).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ArtistID = new SelectList(db.Artists, "ArtistID", "ArtistName", artWork.ArtistID);
return(View(artWork));
}
public ActionResult DeleteConfirmed(int id)
{
ArtWork b = db.ArtWorks.Find(id);
if (b == null)
{
return(HttpNotFound());
}
db.ArtWorks.Remove(b);
db.SaveChanges();
return(RedirectToAction("ListArts"));
}
public ActionResult Create([Bind(Include = "ArtWorkID,Title,ArtistID")] ArtWork artWork)
{
if (ModelState.IsValid)
{
db.ArtWorks.Add(artWork);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ArtistID = new SelectList(db.Artists, "ArtistID", "ArtistName", artWork.ArtistID);
return(View(artWork));
}
public ActionResult AddArtWork(ArtWorkModel model)
{
ArtWork art = new ArtWork();
art.ArtistId = model.ArtistId;
art.ArtTypeId = model.ArtTypeId;
art.YearId = model.YearId;
dataService.ArtWorkService.AddNew(art);
return View("ThankYou");
}
public ActionResult Edit([Bind(Include = "ArtID,ArtTitle,ArtDescription,ArtistID,CategoryID,ImageURL,PostedDate,MinimumBidAmount,CurrentBidAmount,IsApproved,IsSold")] ArtWork artWork)
{
if (ModelState.IsValid)
{
db.Entry(artWork).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ArtistID = new SelectList(db.UserInformations, "UserID", "FirstName", artWork.ArtistID);
ViewBag.CategoryID = new SelectList(db.Categories, "CategoryID", "CategoryName", artWork.CategoryID);
return(View(artWork));
}
public FileContentResult GetThumbnailImage(int Id)
{
ArtWork art = db.ArtWorks.FirstOrDefault(p => p.Id == Id);
if (art != null && art.ArtworkThumbnail != null && art.ImageMimeType != 0)
{
return(File(art.ArtworkThumbnail, art.ImageMimeType.ToString()));
}
else
{
return(null);
}
}
public FileContentResult GetThumbnailImage(int fileID)
{
ArtWork art = db.ArtWorks.FirstOrDefault(p => p.fileID == fileID);
if (art != null)
{
return(File(art.ArtworkThumbnail, art.ImageMimeType.ToString()));
}
else
{
return(null);
}
}
public ActionResult Create(OwnerInventoryListViewModel ownerInvDetails)
{
var artistId = getNextArtistId(ownerInvDetails.Name);
var artworkId = getNextArtworkId();
var ipId = getNextIpId();
using (Context _context = new Context())
{
if (ModelState.IsValid)
{
Artist artist = new Artist
{
Name = ownerInvDetails.Name,
ArtistId = artistId,
BirthYear = ownerInvDetails.BirthYear
};
_context.Artist.Add(artist); // saves data to the context
_context.SaveChanges(); // saves data to database
}
if (ModelState.IsValid)
{
ArtWork artwork = new ArtWork
{
ArtWorkId = artworkId,
Title = ownerInvDetails.Title,
ArtistId = artistId,
Category = ownerInvDetails.Category
};
_context.ArtWork.Add(artwork); // saves data to the context
_context.SaveChanges(); // saves data to database
}
if (ModelState.IsValid)
{
IndividualPiece ip = new IndividualPiece
{
IndividualPieceId = ipId,
ArtWorkId = artworkId,
Cost = ownerInvDetails.Cost,
Price = ownerInvDetails.Price,
Sold = ownerInvDetails.Sold,
Location = ownerInvDetails.Location,
};
_context.IndividualPiece.Add(ip); // saves data to the context
_context.SaveChanges(); // saves data to database
}
}
return(RedirectToAction("Index"));
}
public ActionResult Index(ArtWork artwork, HttpPostedFileBase image) //public ActionResult Index(ArtWork artwork, HttpPostedFileBase image)
{
if (Request.Files["image"].ContentLength > 0)
{
artwork.ImageMimeType = image.ContentLength;
}
if (ModelState.IsValid)
{
if (image != null)
{
//attach the uploaded image to the object before saving to Database
artwork.ImageMimeType = image.ContentLength;
artwork.ImageData = new byte[image.ContentLength];
image.InputStream.Read(artwork.ImageData, 0, image.ContentLength);
//Save image to file
var filename = image.FileName;
var filePathOriginal = Server.MapPath("/Content/Uploads/Originals");
var filePathThumbnail = Server.MapPath("/Content/Uploads/Thumbnails");
string savedFileName = Path.Combine(filePathOriginal, filename);
image.SaveAs(savedFileName);
artwork.FileName = savedFileName; // save the filename
//Read image back from file and create thumbnail from it
var imageFile = Path.Combine(Server.MapPath("~/Content/Uploads/Originals"), filename);
using (var srcImage = Image.FromFile(imageFile))
using (var newImage = new Bitmap(100, 100))
using (var graphics = Graphics.FromImage(newImage))
using (var stream = new MemoryStream())
{
graphics.SmoothingMode = SmoothingMode.AntiAlias;
graphics.InterpolationMode = InterpolationMode.HighQualityBicubic;
graphics.PixelOffsetMode = PixelOffsetMode.HighQuality;
graphics.DrawImage(srcImage, new Rectangle(0, 0, 100, 100));
newImage.Save(stream, ImageFormat.Png);
var thumbNew = File(stream.ToArray(), "image/png");
artwork.ArtworkThumbnail = thumbNew.FileContents;
}
// Save model object to database
db.ArtWorks.Add(artwork);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
return(View());
}
// GET: ArtWorks/Delete/5
public ActionResult Delete(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ArtWork artWork = db.ArtWorks.Find(id);
if (artWork == null)
{
return(HttpNotFound());
}
return(View(artWork));
}
public ViewResult ViewArt(int?Id)
{
ArtWork artWork = db.ArtWorks
.Include(a => a.Author)
.Include(a => a.Type)
.Include(a => a.Location.TypeLocation)
.Include(a => a.Location.City.Country)
.Include(a => a.PhotoArt)
.Include(a => a.Genre)
.FirstOrDefault(a => a.Id == Id);
//ArtWork artWork = db.ArtWorks.FirstOrDefault(a => a.Id == Id);
return(View(artWork));
}
// GET: ArtWorks/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ArtWork artWork = db.ArtWorks.Find(id);
if (artWork == null)
{
return(HttpNotFound());
}
ViewBag.ArtistID = new SelectList(db.Artists, "ArtistID", "ArtistName", artWork.ArtistID);
return(View(artWork));
}
public bool SetArtWork(ArtWork eartwork)
{
var updated = gc.ArtWorks.Where(c => c.Awid == eartwork.Awid)
.Select(c => c).FirstOrDefault();
updated.Awname = eartwork.Awname;
updated.Awinformation = eartwork.Awinformation;
updated.Awtype = eartwork.Awtype;
updated.Awvalue = eartwork.Awvalue;
updated.Awid = eartwork.Awid;
updated.Aid = eartwork.Aid;
gc.ArtWorks.Update(updated);
gc.SaveChanges();
return(true);
}
public async Task <ArtWork> GetArtWork(int ID)
{
var response = await client.GetAsync($"/api/artworks/{ID}");
if (response.IsSuccessStatusCode)
{
ArtWork ArtWork = await response.Content.ReadAsAsync <ArtWork>();
return(ArtWork);
}
else
{
return(new ArtWork());
}
}
public ActionResult EditArtWork(ArtWorkModel model)
{
ArtWork am = new ArtWork();
am.ArtId = model.ArtWorkId;
//am.YearList = dataService.YearPublishedService.YearList();
am.YearId = model.YearId;
//am.ArtTypeList = dataService.ArtTypeService.ArtTypeList();
am.ArtTypeId = model.ArtTypeId;
//am.ArtistList = dataService.ArtistService.ArtistList();
am.ArtistId = model.ArtistId;
dataService.ArtWorkService.Edit(am);
return View("ThankYou");
}
public ICollection<ArtWork> GetArtworks()
{
RandomGenerator random = RandomGenerator.Create();
List<string> names = File
.ReadAllText(path: "../../Data/ArtWorkNames.txt")
.Split(new char[] { '\n', '\r', '\t' }, StringSplitOptions.RemoveEmptyEntries)
.ToList();
var artWorks = new HashSet<ArtWork>();
for (int i = 0; i < 100; i++)
{
var artwork = new ArtWork
{
Id = i + 1,
Title = names[i],
Type = (ArtWorkType)random.GetIntegerBetween(min: 0, max: 9),
Status = (ArtWorkStatus)random.GetIntegerBetween(min: 0, max: 3),
Value = random.GetIntegerBetween(min: 10000, max: 10000000)
};
if (artwork.Status == ArtWorkStatus.Sold)
{
artwork.DateSold = random
.GetRandomDate(
start: new DateTime(year: 2010, month: 01, day: 01, hour: 00, minute: 00, second: 00),
end: new DateTime(year: 2014, month: 12, day: 31, hour: 23, minute: 59, second: 59));
}
else
{
artwork.DateSold = null;
}
artWorks.Add(artwork);
}
return artWorks;
}
public void AddArtWork(int w, int h, Texture2D tex, ArtData.GalleryData.ArtData artdata)
{
ArtWork artwork = new ArtWork ( w, h, tex);
artwork.SetGalleryData (artdata);
artworks.Add (artwork);
}
