public IActionResult AddOrder(string account_id, string fullname, string address, string email, string tel, string city)
{
var gioHang = SessionHelper.Get <List <CartItem> >(HttpContext.Session, "cart");
if (gioHang == null || gioHang.Count() == 0)
{
ViewBag.Success = false;
}
else
{
KhachHang newKh = new KhachHang
{
TenKhachHang = fullname,
DiaChi = address,
Email = email,
SoDt = tel,
MaTinhThanh = int.Parse(city)
};
db.KhachHang.Add(newKh);
db.SaveChanges();
GioHang newOrder = new GioHang
{
MaKhachHang = newKh.MaKhachHang,
NgayDat = DateTime.Now,
TrangThai = 0
};
if (account_id != null)
{
newOrder.MaTaiKhoan = int.Parse(account_id);
}
db.GioHang.Add(newOrder);
db.SaveChanges();
var cart = SessionHelper.Get <List <CartItem> >(HttpContext.Session, "cart");
foreach (var item in cart)
{
ChiTietGioHang newDetail = new ChiTietGioHang
{
MaGioHang = newOrder.MaGioHang,
MaThucDon = item.MaThucDon,
SoLuong = item.SoLuong
};
db.ChiTietGioHang.Add(newDetail);
db.SaveChanges();
}
HttpContext.Session.Remove("cart");
ViewBag.Success = true;
}
ViewBag.City = (from tt in db.TinhThanh select tt);
gioHang = SessionHelper.Get <List <CartItem> >(HttpContext.Session, "cart");
ViewBag.Cart = gioHang;
if (gioHang != null)
{
ViewBag.Total = gioHang.Sum(x => x.SoLuong * x.GiaBan);
}
else
{
ViewBag.Total = 0;
}
return(View("Index"));
}
public ActionResult <IEnumerable <MenuItem> > PutMenuItem([FromBody] MenuItem menuItem)
{
_context.MenuItems.Update(menuItem);
_context.SaveChanges();
return(_context.MenuItems.ToList());
}
public ActionResult Create([Bind(Include = "ID,Name,Description,Quantity,Price")] InventoryCoffee inventoryCoffee)
{
if (ModelState.IsValid)
{
db.InventoryCoffees.Add(inventoryCoffee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(inventoryCoffee));
}
public ActionResult Create([Bind(Include = "Id,FirstName,LastName,Email,Password,ItemId")] User user)
{
if (ModelState.IsValid)
{
db.Users.Add(user);
db.SaveChanges();
return(RedirectToAction($"Details/{user.Id}"));
}
ViewBag.ItemId = new SelectList(db.Items, "Id", "Name", user.ItemId);
return(View(user));
}
public IActionResult Edit(Product product, int id)
{
var productToEdit = _coffeeShopContext.Products.Find(id);
productToEdit.Name = product.Name;
productToEdit.Price = product.Price;
productToEdit.Quantity = product.Quantity;
productToEdit.Description = product.Description;
_coffeeShopContext.SaveChanges();
return(RedirectToAction("Products", "Product"));
}
public void AddItems(string item)
{
// made db context into using statement
using (var db = new CoffeeShopContext())
{
// wrapped our database actions in a transaction
using (var scope = db.Database.BeginTransaction())
{
try
{
var Item = JsonSerializer.Deserialize <Items>(item);
Item.id = 0;
db.Items.Add(Item);
db.SaveChanges();
// run commit to SaveChanges made to the database
scope.Commit();
}
catch (Exception ex)
{
//if we run rollback we can cancel all database actions
scope.Rollback();
}
}
}
}
public void DeleteItem(string itemID)
{
using (var db = new CoffeeShopContext())
{
using (var scope = db.Database.BeginTransaction())
{
try
{
// use a Linq where statement to find the Item you need
//I also call SingleOrDefault this way if there is no match in the DB
//it will return a default object instead
var Item = db.Items
.Where(item => item.id == Convert.ToInt32(itemID))
.SingleOrDefault();
//pass in the object to be removed
db.Items.Remove(Item);
db.SaveChanges();
//call commit to SaveChanges
scope.Commit();
}
catch (Exception ex)
{
//call rollback to cancel all DB actions
scope.Rollback();
}
}
}
}
public void SaveDiscountOrder(DiscountOrder _order)
{
using (CoffeeShopContext db = new CoffeeShopContext())
{
db.DiscountOrders.Add(_order);
db.SaveChanges();
}
}
public IActionResult RemoveReview(int id)
{
var thisRv = db.DanhGia.SingleOrDefault(x => x.MaDanhGia == id);
db.DanhGia.Remove(thisRv);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void SaveCustomer(Customer _customer)
{
using (CoffeeShopContext db = new CoffeeShopContext())
{
db.Customers.Add(_customer);
db.SaveChanges();
}
}
public void SaveProduct(Product _product)
{
using (CoffeeShopContext db = new CoffeeShopContext())
{
db.Products.Add(_product);
db.SaveChanges();
}
}
public ActionResult Register(NewUser newUser)
{
if (ModelState.IsValid)
{
db.NewUsers.Add(newUser);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View("AddUser", newUser));
}
public void UpdateCountInProduct(int _productId, int _amountOfBothProduct)
{
Product _changingProduct = new Product();
using (CoffeeShopContext db = new CoffeeShopContext())
{
_changingProduct = db.Products.Find(_productId);
_changingProduct.Amount = _changingProduct.Amount - _amountOfBothProduct;
db.SaveChanges();
}
}
public IActionResult Registration(User registration)
{
if (!ModelState.IsValid)
{
return(View(registration));
}
_coffeeShopContext.Users.Add(registration);
_coffeeShopContext.SaveChanges();
return(RedirectToAction("Index", "Home", registration));
}
public ActionResult Create([Bind(Include = "Id,Name,Description,Quantity,Price")] Item item)
{
try
{
if (ModelState.IsValid)
{
db.Items.Add(item);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch (DbUpdateException ex)
{
if (ExceptionHelper.IsUniqueConstraintViolation(ex))
{
ModelState.AddModelError("Name", $"The Name '{item.Name}' is already in use, please enter a different name.");
return(View(nameof(Create), item));
}
}
return(View(item));
}
public IActionResult RegistrationConformation(RegisterViewModel model)
{
var newUser = new CoffeeUsersDAL();
newUser.Email = model.Email;
newUser.Password = model.Password;
newUser.UserName = model.UserName;
newUser.FavoriteDrink = model.FavoriteDrink;
_coffeeShopContext.Add(newUser);
_coffeeShopContext.SaveChanges();
return(View(model));
}
public IActionResult AddRating(string product_id, string rating)
{
DanhGia newDg = new DanhGia()
{
MaTaiKhoan = int.Parse(HttpContext.Session.GetString("ACCID_SESSION")),
LoiNhanXet = rating,
MaThucDon = int.Parse(product_id),
NgayDanhGia = DateTime.Now
};
db.DanhGia.Add(newDg);
db.SaveChanges();
return(RedirectToAction("Index", new RouteValueDictionary(
new { controller = "SingleProduct", action = "Index", id = product_id })));
}
public void SaveCustomers(IEnumerable <Customer> customers)
{
using (var c = new CoffeeShopContext())
{
var r = c.CoffeeCustomers;
c.CoffeeCustomers.RemoveRange(r);
c.CoffeeCustomers.AddRange(customers.Select(x => new Customer
{
FirstName = x.FirstName,
LastName = x.LastName,
IsDeveloper = x.IsDeveloper
}));
c.SaveChanges();
}
}
public ActionResult AddUser(RegisterUser newUser)
{
if (ModelState.IsValid)
{
db.RegisterUsers.Add(newUser);
db.SaveChanges();
ViewBag.ConfMessage = "Welcome " + newUser.FirstName;
return(View());
}
else
{
return(View("Error"));
}
}
public IActionResult Welcome(User user, string password2, string password)
{
CoffeeShopContext db = new CoffeeShopContext();
User ValidUser = new User();
if (password != password2)
{
return(ModalAction());
}
else
{
db.Add(user);
db.SaveChanges();
}
return(View());
}
public IActionResult Purchase(decimal?price, User user)
{
CoffeeShopContext db = new CoffeeShopContext();
user = JsonSerializer.Deserialize <User>(HttpContext.Session.GetString("User"));
if (user.CartFunds >= price)
{
user.CartFunds = user.CartFunds - price;
db.Update(user);
db.SaveChanges();
}
//else if (foundUser.CartFunds <= price)
//{
// return View();
//}
return(View("Shop"));
}
public IActionResult SignUp(string username, string password,
string email, IFormFile avatar)
{
var check_exist = db.TaiKhoan.SingleOrDefault(x => x.TenTaiKhoan == username);
if (check_exist == null)
{
TaiKhoan newTk = new TaiKhoan
{
TenTaiKhoan = username,
MatKhau = password,
Email = email,
MaPhanQuyen = "kh"
};
if (avatar != null)
{
string path_to_image = "wwwroot/uploads/employee/" + avatar.FileName;
using (var stream = new FileStream(path_to_image, FileMode.Create))
{
avatar.CopyTo(stream);
}
newTk.AnhDaiDien = avatar.FileName;
}
else
{
newTk.AnhDaiDien = "none-avatar.jpg";
}
db.TaiKhoan.Add(newTk);
db.SaveChanges();
ViewBag.RegisterSucess = true;
return(View("Index"));
}
else
{
ViewBag.AccExist = false;
return(View("SignUp"));
}
}
