public async Task <string> AdvancedSearch([Bind("SaleID,MovieID,Quantity")] MovieSale searchMovieSale)
{
var result = _context.MovieSale.AsQueryable();
if (searchMovieSale != null)
{
if (searchMovieSale.SaleID != null)
{
result = result.Where(movieSale => movieSale.SaleID == searchMovieSale.SaleID);
}
if (searchMovieSale.MovieID != null)
{
result = result.Where(movieSale => movieSale.MovieID == searchMovieSale.MovieID);
}
if (searchMovieSale.Quantity != 0)
{
result = result.Where(movieSale => movieSale.Quantity == searchMovieSale.Quantity);
}
}
var list = await result.ToListAsync();
var listJason = Newtonsoft.Json.JsonConvert.SerializeObject(list);
return(listJason);
}
public async Task <IActionResult> Edit(string SaleID, string MovieID, [Bind("SaleID,MovieID,Quantity")] MovieSale movieSale)
{
if (MovieID != movieSale.MovieID || SaleID != movieSale.SaleID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(movieSale);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MovieSaleExists(movieSale.SaleID, movieSale.MovieID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(movieSale));
}
//// GET: MovieSales/Create
//public IActionResult Create()
//{
// ViewData["MovieID"] = new SelectList(_context.Movie, "MovieID", "MovieID");
// ViewData["SaleID"] = new SelectList(_context.Set<Sale>(), "SaleID", "SaleID");
// return View();
//}
// POST: MovieSales/Create
// To protect from overposting attacks, please enable the specific properties you want to bind to, for
// more details see http://go.microsoft.com/fwlink/?LinkId=317598.
//[HttpPost]
//[ValidateAntiForgeryToken]
public async Task <IActionResult> Create(string SaleID, string MovieID, [Bind("SaleID,MovieID,Quantity")] MovieSale movieSale)
{
if (SaleID == null || MovieID == null)
{
return(NotFound());
}
if (ModelState.IsValid)
{
if (!MovieSaleExists(SaleID, MovieID))
{
if (movieSale.Quantity == 0)
{
movieSale.Quantity = 1;
}
var sale = await _context.Sale.FirstOrDefaultAsync(s => s.SaleID == SaleID);
var movie = await _context.Movie.FirstOrDefaultAsync(s => s.MovieID == MovieID);
sale.TotalPrice += (int)movie.Retail;
_context.Add(movieSale);
await _context.SaveChangesAsync();
}
else
{
try
{
_context.Update(movieSale);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MovieSaleExists(movieSale.SaleID, movieSale.MovieID))
{
return(NotFound());
}
else
{
throw;
}
}
}
return(RedirectToAction("Details", "Sales", new
{
id = SaleID
}));
}
return(View(movieSale));
}