public long Insert(User entity)
{
entity.CreatedDate = DateTime.Now;
db.User.Add(entity);
db.SaveChanges();
return(entity.ID);
}
public JsonResult CreateProduct(Product pr)
{
FashionShopDbContext db = new FashionShopDbContext();
Product temp = db.Product.Find(pr.maSanPham);
if (temp == null)
{
Product pro = new Product();
pro.maSanPham = pr.maSanPham;
pro.moTa = pr.moTa;
pro.giaSanPham = pr.giaSanPham;
pro.chatLieu = pr.chatLieu;
pro.loaiSanPhamMa = pr.loaiSanPhamMa;
pro.soLuongDatMua = 0;
pro.mauSac = pr.mauSac;
pro.urlAnh = pr.urlAnh;
pro.tenSanPham = pr.tenSanPham;
db.Product.Add(pro);
db.SaveChanges();
return(Json(new
{
status = true
}));
}
return(Json(new
{
status = false
}));
}
public long Insert(OrderViewModel Order)
{
HoaDon hd = new HoaDon();
hd.CreatedDate = Order.CreatedDate;
hd.ID_User = Order.UserID;
hd.Status = false;
db.HoaDon.Add(hd);
db.SaveChanges();
//Order.ID=hd.ID;
return(hd.ID);
}
public IActionResult SignUp(Register register)
{
User user = new User();
user.Email = register.Email;
user.Password = Crypto.HashPassword(register.Password);
user.CreationDate = DateTime.UtcNow;
user.role = 0;
_context.User.Add(user);
int success = _context.SaveChanges();
if (success == 0)
{
ViewBag.Message = "Failed to Register";
}
else
{
ViewBag.Message = "Register Sucessful!";
}
return(View());
}
public bool Insert(OrderDetail detail)
{
try
{
db.OrderDetails.Add(detail);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool Delete(int id)
{
try
{
var feedback = db.Feedbacks.Find(id);
db.Feedbacks.Remove(feedback);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public ActionResult Register(User us)
{
FashionShopDbContext db = new FashionShopDbContext();
if (ModelState.IsValid)
{
//Thêm dữ liệu vào bảng User
db.User.Add(us);
//Lưu vào CSDL
db.SaveChanges();
ViewBag.ThongBao = "Đăng kí thành công";
}
return(View());
}
public JsonResult DeleteGroupDetail(string id)
{
FashionShopDbContext db = new FashionShopDbContext();
GroupDetail grDetail = db.GroupDetail.Find(id);
if (grDetail != null)
{
db.GroupDetail.Remove(grDetail);
db.SaveChanges();
}
return(Json(new
{
status = true
}));
}
public JsonResult DeleteProduct(string maSanPham)
{
FashionShopDbContext db = new FashionShopDbContext();
Product pr = db.Product.Find(maSanPham);
if (pr != null)
{
db.Product.Remove(pr);
db.SaveChanges();
}
return(Json(new
{
status = true
}));
}
public JsonResult UpdateGroupPr(string maNhom, string tenNhom, string tittle)
{
FashionShopDbContext db = new FashionShopDbContext();
GroupPr gr = db.GroupPr.Find(maNhom);
if (gr != null)
{
gr.tenNhom = tenNhom;
gr.meta_tittle = tittle;
db.SaveChanges();
}
return(Json(new
{
status = true
}));
}
public JsonResult UpdateGroupDetail(string maLoai, string tenLoai, string tittle, string maNhom)
{
FashionShopDbContext db = new FashionShopDbContext();
GroupDetail grDetail = db.GroupDetail.Find(maLoai);
if (grDetail != null)
{
grDetail.tenLoaiSanPham = tenLoai;
grDetail.meta_tittle = tittle;
grDetail.nhomMa = maNhom;
db.SaveChanges();
}
return(Json(new
{
status = true
}));
}
public bool Insert(OrderDetailViewModel orderDetail)
{
try
{
ChiTietHoaDon Chitiet = new ChiTietHoaDon();
Chitiet.ID_HoaDon = orderDetail.OrderID;
Chitiet.ID_SanPham = orderDetail.ProductID;
Chitiet.ID_Size = 3;
Chitiet.Quantity = orderDetail.Quantity;
Chitiet.Price = orderDetail.Price * orderDetail.Quantity;
db.ChiTietHoaDon.Add(Chitiet);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public JsonResult UpdateProduct(Product product)
{
FashionShopDbContext db = new FashionShopDbContext();
Product pr = db.Product.Find(product.maSanPham);
if (pr != null)
{
pr.tenSanPham = product.tenSanPham;
pr.soLuongDatMua = product.soLuongDatMua;
pr.moTa = product.moTa;
pr.mauSac = product.mauSac;
pr.loaiSanPhamMa = product.loaiSanPhamMa;
pr.giaSanPham = product.giaSanPham;
pr.chatLieu = product.chatLieu;
db.SaveChanges();
}
return(Json(new
{
status = true
}));
}
public JsonResult CreateGroupDetail(string maLoai, string tenLoai, string tittle, string manhom)
{
FashionShopDbContext db = new FashionShopDbContext();
GroupDetail temp = db.GroupDetail.Find(maLoai);
if (temp == null)
{
var list = db.GroupDetail.Where(x => x.meta_tittle == tittle).ToList();
if (list.Count() == 0)
{
GroupDetail grDetail = new GroupDetail();
grDetail.maLoaiSanPham = maLoai;
grDetail.tenLoaiSanPham = tenLoai;
grDetail.meta_tittle = tittle;
grDetail.nhomMa = manhom;
db.GroupDetail.Add(grDetail);
db.SaveChanges();
return(Json(new
{
status = 1
}));
}
else
{
return(Json(new
{
status = 3
}));
}
}
else
{
return(Json(new
{
status = 2
}));
}
}
public JsonResult DeleteGroupPr(string id)
{
FashionShopDbContext db = new FashionShopDbContext();
GroupPr gr = db.GroupPr.Find(id);
int st = 1;
if (gr != null)
{
try
{
db.GroupPr.Remove(gr);
db.SaveChanges();
}
catch
{
st = 2;
}
}
return(Json(new
{
status = st
}));
}
public JsonResult CreateGroupPr(string maNhom, string tenNhom, string tittle)
{
FashionShopDbContext db = new FashionShopDbContext();
GroupPr temp = db.GroupPr.Find(maNhom);
if (temp == null)
{
var list = db.GroupPr.Where(x => x.meta_tittle == tittle).ToList();
if (list.Count() == 0)
{
GroupPr gr = new GroupPr();
gr.maNhom = maNhom;
gr.tenNhom = tenNhom;
gr.meta_tittle = tittle;
db.GroupPr.Add(gr);
db.SaveChanges();
return(Json(new
{
status = 1
}));
}
else
{
return(Json(new
{
status = 3
}));
}
}
else
{
return(Json(new
{
status = 2
}));
}
}
public long Insert(ProductCategory entity)
{
db.ProductCategories.Add(entity);
db.SaveChanges();
return(entity.ID);
}
public long Insert(Admin entity)
{
db.Admin.Add(entity);
db.SaveChanges();
return(entity.ID);
}
public IActionResult DeleteUser(int UserId)
{
_context.User.Remove(_context.User.Find(UserId));
_context.SaveChanges();
return(RedirectToAction("Dashboard"));
}
public long Insert(Product entity)
{
db.Products.Add(entity);
db.SaveChanges();
return(entity.ID);
}
public long Insert(User entity)
{
db.Users.Add(entity);
db.SaveChanges();
return(entity.ID);
}
public long Insert(Order order)
{
db.Orders.Add(order);
db.SaveChanges();
return(order.ID);
}
public int Insert(Receipt re)
{
db.Receipt.Add(re);
db.SaveChanges();
return(re.maHoaDon);
}