public ActionResult Edit([Bind(Include = "PriceAndDiscountID,Name,Amount")] PriceAndDiscount priceAndDiscount)
{
if (ModelState.IsValid)
{
db.Entry(priceAndDiscount).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(priceAndDiscount));
}
public void SeedPrices(AppDbContext db)
{
PriceAndDiscount p1 = new PriceAndDiscount();
p1.Amount = 5;
p1.Name = "Matinee";
db.PriceAndDiscounts.AddOrUpdate(p => p.Name, p1);
db.SaveChanges();
PriceAndDiscount p2 = new PriceAndDiscount();
p2.Amount = 8;
p2.Name = "Tuesday Discount";
db.PriceAndDiscounts.AddOrUpdate(p => p.Name, p2);
db.SaveChanges();
PriceAndDiscount p3 = new PriceAndDiscount();
p3.Amount = -2;
p3.Name = "Senior Citizen";
db.PriceAndDiscounts.AddOrUpdate(p => p.Name, p3);
db.SaveChanges();
PriceAndDiscount p4 = new PriceAndDiscount();
p4.Amount = 10;
p4.Name = "Post Matinee MTWTh";
db.PriceAndDiscounts.AddOrUpdate(p => p.Name, p4);
db.SaveChanges();
PriceAndDiscount p5 = new PriceAndDiscount();
p5.Amount = 12;
p5.Name = "Post Matinee Friday";
db.PriceAndDiscounts.AddOrUpdate(p => p.Name, p5);
db.SaveChanges();
PriceAndDiscount p6 = new PriceAndDiscount();
p6.Amount = 12;
p6.Name = "Weekends";
db.PriceAndDiscounts.AddOrUpdate(p => p.Name, p6);
db.SaveChanges();
PriceAndDiscount p7 = new PriceAndDiscount();
p7.Amount = -1;
p7.Name = "48 Hours Prior";
db.PriceAndDiscounts.AddOrUpdate(p => p.Name, p7);
db.SaveChanges();
}
// GET: PriceAndDiscounts/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PriceAndDiscount priceAndDiscount = db.PriceAndDiscounts.Find(id);
if (priceAndDiscount == null)
{
return(HttpNotFound());
}
return(View(priceAndDiscount));
}
public static List <String> GetTicketPrice(Order ordi, AppUser curruseri)
{
AppDbContext db = new AppDbContext();
Order ord = db.Orders.Find(ordi.OrderID);
ord.Subtotal = 0;
AppUser curruser = db.Users.Find(curruseri.Id);
foreach (Ticket tick in ord.Tickets)
{
if (tick.Showtime.StartTime.DayOfWeek >= DayOfWeek.Monday && tick.Showtime.StartTime.DayOfWeek <= DayOfWeek.Friday && tick.Showtime.StartTime.Hour < 12)
{
var query = from pd in db.PriceAndDiscounts
select pd;
query = query.Where(pd => pd.Name == "Matinee");
List <PriceAndDiscount> Thisdiscountlist = query.ToList();
PriceAndDiscount thisdiscount = Thisdiscountlist.First();
tick.PriceAtPayment = thisdiscount.Amount;
ord.DiscountNames.Add(thisdiscount.Name);
db.Entry(ord).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
else if (tick.Showtime.StartTime.DayOfWeek == DayOfWeek.Tuesday && tick.Showtime.StartTime.Hour < 17)
{
var query = from pd in db.PriceAndDiscounts
select pd;
query = query.Where(pd => pd.Name == "Tuesday Discount");
List <PriceAndDiscount> Thisdiscountlist = query.ToList();
PriceAndDiscount thisdiscount = Thisdiscountlist.First();
tick.PriceAtPayment = thisdiscount.Amount;
ord.DiscountNames.Add(thisdiscount.Name + ", ");
db.Entry(ord).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
else if (tick.Showtime.StartTime.DayOfWeek >= DayOfWeek.Monday && tick.Showtime.StartTime.DayOfWeek < DayOfWeek.Friday)
{
var query = from pd in db.PriceAndDiscounts
select pd;
query = query.Where(pd => pd.Name == "Post Matinee MTWTh");
List <PriceAndDiscount> Thisdiscountlist = query.ToList();
PriceAndDiscount thisdiscount = Thisdiscountlist.First();
tick.PriceAtPayment = thisdiscount.Amount;
ord.DiscountNames.Add("");
db.Entry(ord).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
else if (tick.Showtime.StartTime.DayOfWeek == DayOfWeek.Friday || tick.Showtime.StartTime.DayOfWeek == DayOfWeek.Saturday || tick.Showtime.StartTime.DayOfWeek == DayOfWeek.Sunday)
{
var query = from pd in db.PriceAndDiscounts
select pd;
query = query.Where(pd => pd.Name == "Weekends");
List <PriceAndDiscount> Thisdiscountlist = query.ToList();
PriceAndDiscount thisdiscount = Thisdiscountlist.First();
tick.PriceAtPayment = thisdiscount.Amount;
ord.DiscountNames.Add("");
db.Entry(ord).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
if (tick.Showtime.SpecialEvent == false)
{
if (DateTime.Now < tick.Showtime.StartTime.AddDays(-2))
{
var query = from pd in db.PriceAndDiscounts
select pd;
query = query.Where(pd => pd.Name == "48 Hours Prior");
List <PriceAndDiscount> Thisdiscountlist = query.ToList();
PriceAndDiscount thisdiscount = Thisdiscountlist.First();
tick.PriceAtPayment += thisdiscount.Amount;
ord.DiscountNames.Add(thisdiscount.Name + ", ");
db.Entry(ord).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
if (curruser.Birthday.AddYears(60) < DateTime.Today)
{
var query = from pd in db.PriceAndDiscounts
select pd;
query = query.Where(pd => pd.Name == "Senior Citizen");
List <PriceAndDiscount> Thisnewdiscountlist = query.ToList();
PriceAndDiscount Thisnewdiscount = Thisnewdiscountlist.First();
tick.PriceAtPayment += Thisnewdiscount.Amount;
ord.DiscountNames.Add(Thisnewdiscount.Name + ", ");
db.Entry(ord).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
ord.Subtotal += tick.PriceAtPayment;
db.Entry(tick).State = System.Data.Entity.EntityState.Modified;
}
db.Entry(ord).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(ord.DiscountNames);
}
