public ActionResult Create([Bind(Include = "OrderDetailId,ProductId,Quantity,Total")] OrderDetail orderDetail)
{
if (ModelState.IsValid)
{
db.OrderDetails.Add(orderDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(orderDetail));
}
public ActionResult Create([Bind(Include = "ProductId,Name,Description,Price,Stock,Picture,Type,Featured")] Product product)
{
if (ModelState.IsValid)
{
product.DateCreated = DateTime.Now;
product.Purchases = 0;
product.DiscountedPrice = product.Price;
db.Products.Add(product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(product));
}
public ActionResult onhold(int id)
{
Database1 m = new Database1();
request r = m.requests.Where(i => i.reqid == id).FirstOrDefault();
r.status = "onhold";
m.SaveChanges();
return(Redirect("/request/dashboard"));
}
public ActionResult edit(int qid, int tn, int room)
{
Database1 m = new Database1();
request r = m.requests.Where(i => i.reqid == qid).FirstOrDefault();
r.tid = tn;
r.room = room;
r.status = "Submitted";
m.SaveChanges();
return(RedirectToAction("dashboard", "request"));
}
public ActionResult projm(string req, string dom, DateTime sd, DateTime edn)
{
Database1 m = new Database1();
request r = new request();
r.domain = dom;
r.reqname = req;
r.sdate = sd;
r.edate = edn;
r.status = "Requested";
r.pmid = (int)Session["pm"];
m.requests.Add(r);
m.SaveChanges();
return(RedirectToAction("dashboard"));
}
public ActionResult UpdateQuantity(int orderID, int orderDetailID, int amount)
{
string email = User.Identity.GetUserName();
//Get the order detail
OrderDetail orderDetail = db.OrderDetails
.Where(j => j.OrderDetailId == orderDetailID)
.FirstOrDefault();
//Get the product information
Product product = db.Products
.Where(i => i.ProductId == orderDetail.ProductId)
.FirstOrDefault();
//Update the quantity and the total
int previousQuantity = orderDetail.Quantity;
orderDetail.Quantity = orderDetail.Quantity + amount;
orderDetail.Quantity = ((orderDetail.Quantity <= 0) ? 1 : orderDetail.Quantity); //Dont let the quantity go below 1
int newQuantity = orderDetail.Quantity;
orderDetail.Quantity = ((orderDetail.Quantity > product.Stock) ? previousQuantity : newQuantity); //Dont let the quantity go above the stock of the product
orderDetail.Total = product.DiscountedPrice * orderDetail.Quantity;
db.Entry(orderDetail).State = EntityState.Modified;
//Cart. Go through and update the cart total
Order cart = db.Orders.FirstOrDefault(i => i.Email == email);
db.Entry(cart).State = EntityState.Modified;
if (previousQuantity != newQuantity)
{
if (amount < 0)
{
cart.Total -= (product.DiscountedPrice * Math.Abs(amount));
}
else
{
cart.Total += (product.DiscountedPrice * Math.Abs(amount));
}
}
db.SaveChanges();
return(Redirect("/Orders/Details/" + orderID));
}
public ActionResult confirm(int id)
{
try
{
Database1 m = new Database1();
request r = m.requests.Where(i => i.reqid == id).FirstOrDefault();
r.status = "Confirmed";
m.SaveChanges();
return(Redirect("dashboard"));
}
catch (Exception)
{
return(Redirect("/main/Login"));
}
}
