public bool Delete(ItemMedia m)
{
using (var db = DBConnection.GetConnection())
{
return(ItemMedia.Delete <ItemMedia>(db, m));
}
}
public bool Post(ItemMedia i)
{
using (var db = DBConnection.GetConnection())
{
return(ItemMedia.Persist <ItemMedia>(db, i));
}
}
public IEnumerable <ItemMedia> GetByParentId(int id)
{
using (var db = DBConnection.GetConnection())
{
return(ItemMedia.GetByItemId(db, id));
}
}
public ItemMedia Get(int id)
{
using (var db = DBConnection.GetConnection())
{
return(ItemMedia.GetById <ItemMedia>(db, id));
}
}
public IEnumerable <ItemMedia> Get()
{
using (var db = DBConnection.GetConnection())
{
return(ItemMedia.GetAll <ItemMedia>(db));
}
}
// GET: Items/Details/5
public async Task <IActionResult> Details(int?id)
{
if (id == null)
{
return(NotFound());
}
//get the item
var item = await _context.Items.Include(i => i.Auction).SingleOrDefaultAsync(m => m.ItemId == id);
//get the items media
var media = await _context.Media.Where(x => x.ItemId == item.ItemId).ToListAsync();
ItemMedia model = new ItemMedia
{
Item = item,
Media = media
};
// im.Add(modelItem);
if (item == null)
{
return(NotFound());
}
return(View(item));
}
// GET: Items
public async Task <IActionResult> Index()
{
//var auctionContext = _context.Items.Include(i => i.Auction);
//return View(await auctionContext.ToListAsync());
List <ItemMedia> im = new List <ItemMedia>();
var items = await _context.Items.ToListAsync();
foreach (var item in items)
{
var media = await _context.Media.Where(x => x.ItemId == item.ItemId).ToListAsync();
ItemMedia modelItem = new ItemMedia
{
Item = item,
Media = media
};
im.Add(modelItem);
}
return(View(im));
}
public async Task <IActionResult> Upload(int itemId, ICollection <IFormFile> files)
{
foreach (var file in files)
{
var size = (int)file.Length;
if (size <= 0)
{
continue;
}
var content = ReadAllBytes(file);
var media = new Media
{
FileName = file.FileName,
Type = file.ContentType,
Content = content
};
_context.Media.Add(media);
var itemMedia = new ItemMedia
{
ItemId = itemId,
Media = media
};
_context.ItemMedia.Add(itemMedia);
}
await _context.SaveChangesAsync();
TempData["SuccessMessage"] = $"Added {files.Count} images to the item.";
return(RedirectToAction(nameof(Edit), routeValues: new { id = itemId }));
}
// GET: BidHistories
public async Task <IActionResult> Index(int?id, string sortOrder, string searchString)
{
if (id == null)
{
return(RedirectToAction("ViewActiveAuctions"));
// return NotFound();
}
ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewBag.BidSortParm = sortOrder == "hBid" ? "hBid_desc" : "hBid";
List <ItemMedia> im = new List <ItemMedia>();
// var history = await _context.BidHistory.ToListAsync();
var auction = await _context.Auctions.Where(x => x.AuctionId == id).SingleOrDefaultAsync();
var items = await _context.Items.Where(x => x.AuctionId == id).ToListAsync();
var carousel = await _context.Media.Where(x => x.ItemId == 0).ToListAsync();
foreach (var item in items)
{
var media = await _context.Media.Where(x => x.ItemId == item.ItemId).ToListAsync();
var highestBid = await _context.BidHistory.Where(x => x.ItemId == item.ItemId).MaxAsync(y => y.BidAmount);
ItemMedia modelItem = new ItemMedia()
{
Item = item,
Media = media,
highestBid = highestBid
};
im.Add(modelItem);
}
AuctionItem model = new AuctionItem
{
Auction = auction,
Carousel = carousel,
Items = im
};
if (!String.IsNullOrEmpty(searchString))
{
model.Items = model.Items.Where(s => s.Item.ItemName.Contains(searchString) ||
s.highestBid.ToString() == searchString);
}
switch (sortOrder)
{
case "name_desc":
model.Items = model.Items.OrderByDescending(s => s.Item.ItemName);
break;
case "hBid":
model.Items = model.Items.OrderBy(s => s.highestBid);
break;
case "hBid_desc":
model.Items = model.Items.OrderByDescending(s => s.highestBid);
break;
default:
model.Items = model.Items.OrderBy(s => s.Item.ItemName);
break;
}
return(View(model));
}
