public ActionResult delete(NhanVien useEmployesID, KhachHang useCustomerID, long id)
{
// Kiểm tra xem user cần xóa có năm trong user id của nhân viên hay không
if (useEmployesID.UserID == id)
{
// Xóa nhân viên ra khỏi danh sách
var employes = db.NhanVien.Single(x => x.UserID == id);
db.NhanVien.Remove(employes);
db.SaveChanges();
}
else
{
if (useCustomerID.UserID == id)
{
// Xóa khách hàng ra khỏi danh sách
var customer = db.KhachHang.Single(x => x.UserID == id);
db.KhachHang.Remove(customer);
db.SaveChanges();
}
}
// Xóa user ra khỏi danh sách
new UserDao().Delete(id);
return(RedirectToAction("index"));
}
public ActionResult create([Bind(Include = "MaBP,TenBP")] BoPhan boPhan)
{
if (ModelState.IsValid)
{
db.BoPhan.Add(boPhan);
db.SaveChanges();
return(RedirectToAction("index"));
}
return(View(boPhan));
}
public ActionResult create([Bind(Include = "Id,Name,MetaTitle,ParentID,CreateBy")] DanhMucSanPham danhMucSanPham)
{
if (ModelState.IsValid)
{
db.DanhMucSanPham.Add(danhMucSanPham);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(danhMucSanPham));
}
public ActionResult create([Bind(Include = "MaKho,TenKho")] KhoHang khoHang)
{
if (ModelState.IsValid)
{
khoHang.MaKho = LayMaKho();
db.KhoHang.Add(khoHang);
db.SaveChanges();
return(RedirectToAction("index"));
}
return(View(khoHang));
}
public ActionResult create([Bind(Include = "MaNCC,TenNCC,DiaChi,SoDienThoai")] NhaCungCap nhaCungCap)
{
if (ModelState.IsValid)
{
nhaCungCap.MaNCC = LayMaNCC();
db.NhaCungCap.Add(nhaCungCap);
db.SaveChanges();
return(RedirectToAction("index"));
}
return(View(nhaCungCap));
}
public ActionResult create([Bind(Include = "Id,Text,Link,Target,TypeID")] Menu menu)
{
if (ModelState.IsValid)
{
long maMax = db.Menu.ToList().Select(n => n.Id).Max();
menu.Id = maMax + 1;
db.Menu.Add(menu);
db.SaveChanges();
return(RedirectToAction("index"));
}
ViewBag.TypeID = new SelectList(db.MenuType, "Id", "Name", menu.TypeID);
return(View(menu));
}
public ActionResult edit([Bind(Include = "MaKH,HoTenKH,GioiTinh,DiaChi,SDT,Email,UserID")] KhachHang khachHang)
{
if (ModelState.IsValid)
{
db.Entry(khachHang).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("index"));
}
ViewBag.UserID = new SelectList(db.QuanTri, "Id", "UserName", khachHang.UserID);
return(View(khachHang));
}
public ActionResult edit([Bind(Include = "MaDon,NgayDat,TenNguoiDat,DiaChiGiaoHang,SoDienThoai,Email,MaNV,MaKH,TrangThai")] DonDatHang donDatHang)
{
if (ModelState.IsValid)
{
db.Entry(donDatHang).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaKH = new SelectList(db.KhachHang, "MaKH", "HoTenKH", donDatHang.MaKH);
ViewBag.MaNV = new SelectList(db.NhanVien, "MaNV", "HoNV", donDatHang.MaNV);
return(View(donDatHang));
}
public bool Insert(ChiTietDatHang orderDetail)
{
try
{
db.ChiTietDatHang.Add(orderDetail);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public ActionResult create([Bind(Include = "MaNV,HoNV,TenNV,GioiTinh,NgaySinh,Luong,AnhNV,SDT,DiaChi,Email,MaBP,UserID")] NhanVien nhanVien)
{
//System.Web.HttpPostedFileBase Avatar;
var imgNV = Request.Files["Avatar"];
//Lấy thông tin từ input type=file có tên Avatar
string postedFileName = System.IO.Path.GetFileName(imgNV.FileName);
//Lưu hình đại diện về Server
var path = Server.MapPath("/assets/admin/images/" + postedFileName);
imgNV.SaveAs(path);
if (ModelState.IsValid)
{
nhanVien.MaNV = LayMaNV();
nhanVien.AnhNV = postedFileName;
db.NhanVien.Add(nhanVien);
db.SaveChanges();
return(RedirectToAction("index"));
}
ViewBag.MaBP = new SelectList(db.BoPhan, "MaBP", "TenBP", nhanVien.MaBP);
return(View(nhanVien));
}
public ActionResult create([Bind(Include = "MaSP,TenSP,MetaTitle,SoLuong,DonGia,GiaKhuyenMai,HinhAnh,MoTa,ChiTiet,ThoiHanBaoHanh,NgaySanXuat,TrangThai,NgayTao,TaoBoi,DanhMucSanPhamID,MaNCC")] SanPham sanPham)
{
//System.Web.HttpPostedFileBase Avatar;
var images = Request.Files["Images"];
//Lấy thông tin từ input type=file có tên Avatar
string postedFileName = System.IO.Path.GetFileName(images.FileName);
//Lưu hình đại diện về Server
var path = Server.MapPath("/assets/client/images/" + postedFileName);
images.SaveAs(path);
if (ModelState.IsValid)
{
sanPham.HinhAnh = postedFileName;
sanPham.NgayTao = DateTime.Now;
db.SanPham.Add(sanPham);
db.SaveChanges();
return(RedirectToAction("index"));
}
ViewBag.DanhMucSanPhamID = new SelectList(db.DanhMucSanPham, "Id", "Name", sanPham.DanhMucSanPhamID);
ViewBag.MaNCC = new SelectList(db.NhaCungCap, "MaNCC", "TenNCC", sanPham.MaNCC);
return(View(sanPham));
}
public bool DeleteEmployees(string id)
{
try
{
var employees = db.NhanVien.Find(id);
db.NhanVien.Remove(employees);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public string Insert(KhachHang entity)
{
db.KhachHang.Add(entity);
db.SaveChanges();
return(entity.MaKH);
}
public long Insert(DonDatHang order)
{
db.DonDatHang.Add(order);
db.SaveChanges();
return(order.MaDon);
}
public string Insert(NhanVien entity)
{
db.NhanVien.Add(entity);
db.SaveChanges();
return(entity.MaNV);
}
//Thêm sản phẩm vào database
public long Insert(SanPham entity)
{
db.SanPham.Add(entity);
db.SaveChanges();
return(entity.MaSP);
}
public long Insert(QuanTri entity)
{
db.QuanTri.Add(entity);
db.SaveChanges();
return(entity.Id);
}
