// 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 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: 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()); } } }
public ActionResult Index(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 = 1; user.avt_img = "~/Style/avatar/985985854default-avatar.png"; user.email = user1.email; user.email_verified = true; user.is_active = true; od.Entry(user).State = EntityState.Modified; od.SaveChanges(); return(Redirect("UserDetail/UserDetail")); } catch (Exception ex) { ModelState.AddModelError("", "Update has fail !"); } return(View()); }
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()); } }
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()); } }
public ActionResult Create(product product, HttpPostedFileBase picture, product_ingresients product_Ingresients) { OrderSystemEntities2 db1 = new OrderSystemEntities2(); try { product pro = new product(); product_ingresients pro_in = new product_ingresients(); string path = UpLoadImage(picture); pro.name = product.name; pro.categoryID = product.categoryID; pro.description = product.description; pro.price = product.price; pro.img = path; pro.isCombo = product.isCombo; pro.disable = product.disable; db.products.Add(pro); db.SaveChanges(); //int lastProductId = db.products.Max(item => item.id); ////int lastProductId1 = pro.id; //pro_in.productID = lastProductId; //pro_in.ingID = product_Ingresients.ingID; //pro_in.amount = product.amount; //db1.product_ingresients.Add(pro_in); //db1.SaveChanges(); return(RedirectToAction("Index")); } catch { return(RedirectToAction("Error", "Error")); } }
public ActionResult Register(user user, HttpPostedFileBase picture) { var result = (from row in db.users where row.username == user.username select row).ToList(); var custemail = (from row in db.users where row.email == user.email select row).ToList(); user.email_verified = false; if (result.Count() != 0) { user.LoginErrorMsg = "Username này đã được sử dụng"; } if (custemail.Count() != 0) { user.LoginErrorMsg = "Email này đã được sử dụng"; } else { var u = new user(); string path = UpLoadImage(picture); 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 = 1; u.avt_img = "~/Style/avatar/985985854default-avatar.png"; u.is_active = user.is_active; db.users.Add(u); db.SaveChanges(); SendActivationEmail(u); user.LoginErrorMsg = "Đăng kí thành công vui lòng kiểm tra Email để kích hoạt tài khoản !"; } return(View("Index", user)); }
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(); } }
private void UpdateCancel(int oID, string reason) { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { order o = db.orders.Where(x => x.id == oID).FirstOrDefault(); o.is_cancle = true; db.SaveChanges(); transaction trans = new transaction() { userID = (Int32)(Session["id"]), type = "Cancel", amount = o.total_price, description = "Cancel order: " + oID + ": " + reason, time = DateTime.Now }; db.transactions.Add(trans); db.SaveChanges(); } }
public ActionResult Edit(int id, order order, FormCollection collection) { try { // TODO: Add update logic here db.Entry(order).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } catch { return(View()); } }
// GET: CancelCurrentOrder public ActionResult Index(int oID) { ViewBag.oID = oID; using (OrderSystemEntities2 db = new OrderSystemEntities2()) { order o = db.orders.Where(x => x.id == oID).FirstOrDefault(); o.is_cancle = true; db.SaveChanges(); transaction trans = new transaction() { userID = o.userID, type = "Cancel", amount = o.total_price, description = "Cancel order: " + oID, time = DateTime.Now }; db.transactions.Add(trans); db.SaveChanges(); } return(RedirectToAction("Index", "QRScanner")); }
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()); } }
private void CreateCancelOrderTransaction(double amount, int orderID) { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { transaction trans = new transaction() { userID = (Int32)(Session["id"]), type = "CancelOrder", amount = amount, description = "Cancel order number: " + orderID, time = DateTime.Now }; db.transactions.Add(trans); db.SaveChanges(); } }
private void CreateTopUpTransaction(int amount, String serial) { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { transaction trans = new transaction() { userID = (Int32)(Session["id"]), type = "Top up", amount = amount, description = "Top up " + amount + " using card with serial: " + serial, time = DateTime.Now }; db.transactions.Add(trans); db.SaveChanges(); } }
public ActionResult Edit(int id, ingredient ingredient) { try { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { db.Entry(ingredient).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } } catch { return(View()); } }
public ActionResult Delete(int id, FormCollection collection) { try { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { category category = db.categories.Where(x => x.id == id).FirstOrDefault(); db.categories.Remove(category); db.SaveChanges(); return(RedirectToAction("Index")); } } catch { return(View()); } }
public ActionResult Create(order order) { try { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { db.orders.Add(order); db.SaveChanges(); } return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult CreateMenuDetail(menu_detail menu_Detail) { try { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { menu_Detail.price = 30000; db.menu_detail.Add(menu_Detail); db.SaveChanges(); } return(RedirectToAction("Index")); } catch { return(RedirectToAction("Index")); } }
public ActionResult Delete(int id, FormCollection collection) { try { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { product product = db.products.Where(x => x.id == id).FirstOrDefault(); db.products.Remove(product); db.SaveChanges(); } return(RedirectToAction("Index")); } catch { return(RedirectToAction("Error", "Error")); } }
public ActionResult Create_Ingredient(product_ingresients product_Ingresients) { try { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { db.product_ingresients.Add(product_Ingresients); db.SaveChanges(); } return(RedirectToAction("Index")); } catch { ViewBag.dup = 1; return(RedirectToAction("Index")); } }
public ActionResult Edit(int id, category category) { try { // TODO: Add update logic here using (OrderSystemEntities2 db = new OrderSystemEntities2()) { db.Entry(category).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } } catch { return(View()); } }
public ActionResult Create(menu menu) { try { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { int uID = (Int32)(Session["id"]); menu.date_create = DateTime.Now; menu.creator = uID; db.menus.Add(menu); db.SaveChanges(); } return(RedirectToAction("Index")); } catch { 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, time = DateTime.Now }; db.transactions.Add(trans); db.SaveChanges(); int userId = (Int32)(Session["id"]); user us = db.users.Where(x => x.id == userId).FirstOrDefault(); Session["user"] = us; } }
public ActionResult ResetPassword(ChangePasswordViewModels changePasswordViewModels) { int uid = (Int32)(Session["id"]); var userid = od.users.Find(uid); if (userid.password == changePasswordViewModels.OldPassword) { userid.password = changePasswordViewModels.NewPassword; od.Entry(userid).State = EntityState.Modified; od.SaveChanges(); return(RedirectToAction("Home", "Home")); } else if (userid.password != changePasswordViewModels.NewPassword) { changePasswordViewModels.ErrorMsg = "Old Password is not correct !"; return(View("Index", changePasswordViewModels)); } else { return(View("Index", changePasswordViewModels)); } }
public ActionResult Edit(int id, user user) { try { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { user.avt_img = "abc"; user.email = "abc"; user.address = "abc"; user.phone_num = "1"; user.username = "******"; user.name = "abc"; user.password = "******"; user.is_active = false; db.Entry(user).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); } } throw raise; } }
public ActionResult Add_Feedback(int oID, String content) { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { int uid = (Int32)(Session["id"]); var user_check = db.feed_back.Where(a => a.userID == uid).FirstOrDefault(); if (user_check != null) { ViewBag.IsFeedback = "Bạn đã FeedBack"; return(RedirectToAction("Index", "OrderList")); } else { var fb = new feed_back(); fb.orderID = oID; fb.create_time = DateTime.Now; fb.content = content; fb.userID = (Int32)(Session["id"]); db.feed_back.Add(fb); db.SaveChanges(); } } return(RedirectToAction("Index", "OrderList")); }
public ActionResult Create(time_menu time_Menu) { try { using (OrderSystemEntities2 db = new OrderSystemEntities2()) { time_menu tM = new time_menu(); tM.date_service = time_Menu.date_service; tM.breakfast_mId = time_Menu.breakfast_mId; tM.lunch_mId = time_Menu.lunch_mId; tM.dinner_mId = time_Menu.dinner_mId; db.time_menu.Add(tM); db.SaveChanges(); } return(RedirectToAction("Index")); } catch { return(RedirectToAction("Index")); } }
public JsonResult GetInforFromGoogleAccount(string googleUser) { string google = googleUser; JObject googleObject = JObject.Parse(google); string googleInforName = GetJArrayValue(googleObject, "nt"); JObject accountInfor = JObject.Parse(googleInforName); var googleId = GetJArrayValue(googleObject, "Ca"); var userName = GetJArrayValue(accountInfor, "Ad"); var image = GetJArrayValue(accountInfor, "ZJ"); var email = GetJArrayValue(accountInfor, "Wt"); OrderSystemEntities2 db = new OrderSystemEntities2(); string encoded = EncodePassword(googleId); var userFounded = db.users.Where(x => x.email == email && x.password == encoded).FirstOrDefault(); if (userFounded != null) { Session["id"] = userFounded.id; Session["role"] = 1; Session["user"] = userFounded; string url = "http://localhost:3000/get-information/" + userFounded.id; WebRequest myReq = WebRequest.Create(url); myReq.Method = "GET"; myReq.ContentType = "application/json; charset=UTF-8"; myReq.Headers.Add("key", "9849F97A8C5546C9906A059D1DD3EC64"); WebResponse wr = myReq.GetResponse(); Stream receiveStream = wr.GetResponseStream(); StreamReader reader = new StreamReader(receiveStream, Encoding.UTF8); string content = reader.ReadToEnd(); JObject jContent = JObject.Parse(content); var money = Int32.Parse(GetJArrayValue(jContent, "money")); userFounded.balance = money; Session["username"] = userFounded; db.Entry(userFounded).State = EntityState.Modified; db.SaveChanges(); } else { var u = new user(); u.name = userName; u.username = userName; u.password = EncodePassword(googleId); u.address = ""; u.phone_num = ""; u.email = email; u.role = 1; u.avt_img = image; u.is_active = true; db.users.Add(u); db.SaveChanges(); Session["id"] = u.id; Session["username"] = userName; Session["role"] = 1; Session["user"] = u; string url = "http://localhost:3000/get-information/" + u.id; WebRequest myReq = WebRequest.Create(url); myReq.Method = "GET"; myReq.ContentType = "application/json; charset=UTF-8"; myReq.Headers.Add("key", "9849F97A8C5546C9906A059D1DD3EC64"); WebResponse wr = myReq.GetResponse(); Stream receiveStream = wr.GetResponseStream(); StreamReader reader = new StreamReader(receiveStream, Encoding.UTF8); string content = reader.ReadToEnd(); JObject jContent = JObject.Parse(content); var money = Int32.Parse(GetJArrayValue(jContent, "money")); var user = db.users.Find(u.id); user.balance = money; db.Entry(user).State = EntityState.Modified; db.SaveChanges(); } Session["fromGoogle"] = 1; return(Json("Success")); }