// 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"));
}
