public ActionResult Details_Ingredient(int id) { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { return(View(db.product_ingresients.Include(a => a.product).Include(b => b.ingredient).Where(x => x.productID == id).ToList())); } }
// GET: CurrentOrderDetail public ActionResult Index(int orderID, int recieved_code) { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { order order = db.orders.Where(x => x.id == orderID && x.receive_code == recieved_code).FirstOrDefault(); ViewBag.orderID = orderID; ViewBag.code = order.receive_code; ViewBag.takeDate = order.take_date; var time = ""; if (order.take_time == 1) { time = "6h - 9h"; } else if (order.take_time == 2) { time = "9h - 13h"; } else { time = "16h - 19h"; } ViewBag.takeTime = time; ViewBag.total = db.order_detail.Where(t => t.orderID == orderID).Select(i => i.total_price).Sum(); ViewBag.complete = "http://localhost:51293/CurrentOrderDetail/OrderCompeleted?oID=" + order.id; ViewBag.cancel = "http://localhost:51293/CancelCurrentOrder/Index?oID=" + order.id; List <order_detail> _Details = new List <order_detail>(); _Details = db.order_detail.Include(o => o.order).Include(a => a.product).Where(x => x.orderID == orderID).ToList(); //UpdateOrderStatus(order.id); return(View(_Details)); } }
// GET: Ingredient/Delete/5 public ActionResult Delete(int id) { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { return(View(db.ingredients.Where(x => x.id == id).FirstOrDefault())); } }
public ActionResult Cancel(int oID, int otp, string reason) { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { otp_table _otp = db.otp_table.Where(x => x.otp == otp).FirstOrDefault(); if (_otp == null) { ViewBag.error = "Mã xác thực sai, vui lòng kiểm tra lại!"; return(View()); } else { var otp_time = _otp.create_time; var now = DateTime.Now; if ((now - otp_time).TotalMinutes > 2) { ViewBag.error = "Mã xác thực đã hết hạn, vui lòng kiểm tra lại"; return(View()); } else { UpdateCancel(oID, reason); return(RedirectToAction("Index", "QRScanner")); } } } }
// GET: Feedback public ActionResult Index() { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { return(View(db.feed_back.Include(c => c.user).Include(d => d.order).ToList())); } }
// GET: OrderDetail public ActionResult Index(int oID) { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { order order = db.orders.Where(x => x.id == oID).FirstOrDefault(); ViewBag.orderID = oID; ViewBag.code = order.receive_code; ViewBag.takeDate = order.take_date; var time = ""; if (order.take_time == 1) { time = "6h - 9h"; } else if (order.take_time == 2) { time = "9h - 13h"; } else { time = "16h - 19h"; } ViewBag.takeTime = time; ViewBag.total = db.order_detail.Where(t => t.orderID == oID).Select(i => i.total_price).Sum(); List <order_detail> _Details = new List <order_detail>(); _Details = db.order_detail.Include(o => o.order).Include(a => a.product).Where(x => x.orderID == oID).ToList(); return(View(_Details)); } }
// GET: ConfirmAction public ActionResult Index() { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { int uID = (Int32)(Session["id"]); Random rnd = new Random(); int otp = rnd.Next(1000, 10000); otp_table exist_otp = db.otp_table.Where(x => x.uId == uID).FirstOrDefault(); if (exist_otp != null) { exist_otp.otp = otp; exist_otp.create_time = DateTime.Now; db.SaveChanges(); } else { otp_table otp_ = new otp_table() { uId = uID, create_time = DateTime.Now, otp = otp }; db.otp_table.Add(otp_); db.SaveChanges(); } ViewBag.code = otp; return(View()); } }
public ActionResult Index() { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { return(View(db.users.Where(x => x.role == 2).Where(x => x.is_active == true).ToList())); } }
public ActionResult Create(user user, FormCollection collection) { try { // TODO: Add insert logic here OrderSystemEntities2 db = new OrderSystemEntities2(); user u = new user(); u.name = user.name; u.username = user.username; u.password = EncodePassword(user.password); u.address = user.address; u.phone_num = user.phone_num; u.email = user.email; u.role = 2; u.avt_img = "123"; u.is_active = true; u.email_verified = true; db.users.Add(u); db.SaveChanges(); return(RedirectToAction("Index")); } catch { return(View()); } }
// GET: Menu/Delete/5 public ActionResult Delete(int id) { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { return(View(db.menus.Include(m => m.user).Where(x => x.id == id).FirstOrDefault())); } }
public ActionResult Create(topup_card topup_Card) { try { for (int i = 0; i < topup_Card.amount; i++) { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { //count current index of total rơ in table, +1 for new record int countNum = db.topup_card.Count() + 1; int uID = (Int32)(Session["id"]); string seri = Get8CharacterRandomString(); string code = Get8CharacterRandomString(); topup_Card.serial_number = countNum + seri; topup_Card.code = countNum + code; topup_Card.create_time = DateTime.Now; topup_Card.creator = uID; db.topup_card.Add(topup_Card); db.SaveChanges(); } } return(RedirectToAction("Index")); } catch { return(View()); } }
// GET: Product/Details/5 public ActionResult Details(int id) { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { return(View(db.products.Where(x => x.id == id).FirstOrDefault())); } }
// GET: MenuDaily/Details/5 public ActionResult Details(DateTime date_service) { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { return(View(db.time_menu.SqlQuery("select * from time_menu where date_service ='" + date_service.Date + "'").FirstOrDefault())); } }
public ActionResult Product_By_Name_Search(string pname) { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { return(View(db.products.SqlQuery("SELECT * FROM PRODUCT WHERE NAME LIKE '%" + pname + "%'" + "or description like '%" + pname + "%' or price like '%" + pname + "%'").ToList())); } }
public ActionResult Product_By_Category(int categoryID) { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { return(View(db.products.Include(c => c.category).Where(a => a.categoryID == categoryID).ToList())); } }
public ActionResult Edit(int id) { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { return(View(db.categories.Where(x => x.id == id).FirstOrDefault())); } }
// GET: Product/Edit/5 public ActionResult Edit(int id) { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { SetViewBag(); return(View(db.products.Where(x => x.id == id).FirstOrDefault())); } }
// GET: Menu/Details/5 public ActionResult Details(int id) { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { SetViewBag(); return(View(db.menu_detail.Include(c => c.product).Include(a => a.menu).Where(x => x.menuId == id).ToList())); } }
public ActionResult CreateOrder() { int uID = (Int32)(Session["id"]); int oID = 0; using (OrderSystemEntities2 db = new OrderSystemEntities2()) { user u = db.users.Where(x => x.id == uID).FirstOrDefault(); List <CartItem> items = (List <CartItem>)Session["cart"]; DateTime date = items[0].Date; int service_time = items[0].ServiceTime; float total_price = (float)items.Sum(x => x.Product.price * x.Quantity); if (total_price > u.balance) { ViewBag.BalanceError = 1; return(RedirectToAction("CheckOut", "CreateOrder")); } else { order order = new order() { userID = (Int32)(Session["id"]), create_time = DateTime.Now, take_date = date, take_time = service_time, is_cancle = false, total_price = total_price, reviewed = false, receive_code = RandReceiveCode() }; db.orders.Add(order); db.SaveChanges(); int orderID = order.id; oID = orderID; foreach (CartItem item in items) { order_detail order_Detail = new order_detail() { orderID = orderID, productID = item.Product.id, quantity = item.Quantity, price = item.Product.price, total_price = item.Quantity * item.Product.price }; db.order_detail.Add(order_Detail); } db.SaveChanges(); AddOrderToTransaction(order); ViewBag.BalanceError = 0; SendActivationEmail(u, order); Session.Remove("cart"); } } return(RedirectToAction("Index", "OrderDetail", new { oID = oID })); }
// GET: Order/Details/5 public ActionResult Details(int id) { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { ViewBag.total = db.order_detail.Where(t => t.orderID == id).Select(i => i.total_price).Sum(); return(View(db.order_detail.Include(c => c.order).Include(d => d.product).Where(x => x.orderID == id).ToList())); } }
//[HttpPost] //public ActionResult Edit(user user1, HttpPostedFileBase picture) //{ // string path = UpLoadImage(picture); // try // { // int uid = (Int32)Session["id"]; // var user = od.users.Find(uid); // user.name = user1.name; // user.address = user1.address; // user.phone_num = user1.phone_num; // user.role = user1.role; // user.email = user1.email; // user.avt_img = path; // user.is_active = user1.is_active; // od.SaveChanges(); // return RedirectToAction("Index", "Home"); // } // catch (Exception ex) // { // ModelState.AddModelError("", "Update has fail !"); // } // return View(); //} public ActionResult Index() { int uID = (Int32)Session["id"]; using (OrderSystemEntities2 db = new OrderSystemEntities2()) { return(View(db.users.Where(x => x.id == uID).FirstOrDefault())); } }
public ActionResult Index() { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { DateTime date = DateTime.Now.Date; ViewBag.total = db.orders.Where(x => x.take_date == date).Select(i => i.total_price).Sum(); return(View(db.orders.Include(a => a.user).Include(b => b.service_time).Where(x => x.take_date == date).ToList())); } }
// GET: Order/Edit/5 public ActionResult Edit(int id) { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { SetViewBagUserID(); SetViewBagTime(); SetViewBagStaff(); return(View(db.orders.Where(x => x.id == id).FirstOrDefault())); } }
// GET: Feedback public ActionResult Feedback(int oID) { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { var feedback = db.orders.Where(x => x.id == oID).FirstOrDefault(); return(View(feedback)); } }
private void UpdateOrderStatus(int oID) { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { order order = db.orders.Where(x => x.id == oID).FirstOrDefault(); order.actual_time = DateTime.Now; int uID = (Int32)(Session["id"]); order.staffID = uID; db.SaveChanges(); } }
// GET: TopUp public ActionResult TopUp(String code) { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { var card = (topup_card)db.topup_card.Where(x => x.code == code).FirstOrDefault(); if (card != null) { if (card.used_by != null) { ViewBag.IsUsed = 1; } else { card.used_by = (Int32)(Session["id"]); card.used_time = DateTime.Now; db.SaveChanges(); transaction trans = new transaction() { userID = (Int32)(Session["id"]), type = "Top up", amount = card.value, description = "Top up " + card.value + " using card with serial: " + card.serial_number, time = DateTime.Now }; db.transactions.Add(trans); db.SaveChanges(); ViewBag.success = 1; ViewBag.cardValue = card.value; int userId = (Int32)(Session["id"]); user u = db.users.Where(x => x.id == userId).FirstOrDefault(); Session["user"] = u; SendActivationEmail(u, card); } return(View()); } else { return(View()); } } }
private void AddOrderToTransaction(order order) { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { transaction trans = new transaction() { userID = (Int32)(Session["id"]), type = "Order Pay", amount = order.total_price * -1, description = "Pay " + order.total_price + " for order number: " + order.id }; db.transactions.Add(trans); db.SaveChanges(); } }
// GET: CancelOrder public ActionResult Index(order o) { int uID = (Int32)(Session["id"]); using (OrderSystemEntities2 db = new OrderSystemEntities2()) { o.is_cancle = true; db.SaveChanges(); CreateCancelOrderTransaction(o.total_price, o.id); ViewBag.notice = "Order no: " + o.id + "cancle successed"; return(View()); } }
// GET: Product/Create public ActionResult Create() { try { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { SetViewBag(); } } catch { return(RedirectToAction("Error", "Error")); } return(View()); }
public ActionResult Create_Ingredient() { try { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { SetViewBagProduct(); SetViewBagIngredient(); } } catch { } return(View()); }