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());
}
