public ActionResult Update(tbl_SanPham sanPham, HttpPostedFileBase hinhAnh)
{
bool result = false;
using (HutechMartDbContext db = new HutechMartDbContext())
{
var _sanPham = db.tbl_SanPham.FirstOrDefault(x => x.id == sanPham.id);
if (hinhAnh != null)
{
Random rd = new Random();
var thayAnh = sanPham.tensanpham + rd.Next(1, 10);
sanPham.hinhanh = GetImage(hinhAnh, thayAnh);
}
else
{
sanPham.hinhanh = _sanPham.hinhanh;
}
using (var trans = db.Database.BeginTransaction())
{
try
{
_sanPham.hinhanh = sanPham.hinhanh;
_sanPham.id_phanloai = sanPham.id_phanloai;
_sanPham.id_xuatxu = sanPham.id_xuatxu;
_sanPham.id_donvitinh = sanPham.id_donvitinh;
_sanPham.id_khuyenmai = sanPham.id_khuyenmai;
_sanPham.tensanpham = sanPham.tensanpham;
_sanPham.soluong = sanPham.soluong;
_sanPham.giaban = sanPham.giaban;
_sanPham.gianhap = sanPham.gianhap;
_sanPham.id_nguoicapnhat = sanPham.id_nguoicapnhat;
_sanPham.ngaycapnhat = DatetimeLocation.GetDate();
_sanPham.ghichu = sanPham.ghichu;
db.SaveChanges();
trans.Commit();
result = true;
}
catch
{
trans.Rollback();
}
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult GetDataTargetSupllyByYear(int year)
{
using (HutechMartDbContext db = new HutechMartDbContext())
{
var result = db.tbl_PhieuNhap
.Include(x => x.tbl_NhaCungCap)
.Where(x => x.ngaylap.Year == year)
.GroupBy(x => x.id_nhacungcap)
.Select(x => new
{
tennhacungcap = x.FirstOrDefault(s => s.tbl_NhaCungCap.id == x.Key).tbl_NhaCungCap.tennhacungcap,
sotien = x.Sum(s => s.tongtien)
})
.OrderByDescending(x => x.sotien)
.Take(10).ToList();
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetDataTargetCustomerByYear(int year)
{
using (HutechMartDbContext db = new HutechMartDbContext())
{
var result = db.tbl_HoaDon
.Include(x => x.tbl_KhachHang)
.Where(x => x.ngaylap.Year == year)
.GroupBy(x => x.id_khachhang)
.Select(x => new
{
tenkhachhang = x.FirstOrDefault(s => s.tbl_KhachHang.id == x.Key).tbl_KhachHang.tenkhachhang,
sotien = x.Sum(s => s.tongtien)
})
.OrderByDescending(x => x.sotien)
.Take(10).ToList();
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetDataQuantityProductBadSale(int year, int month)
{
using (HutechMartDbContext db = new HutechMartDbContext())
{
var result = db.tbl_HoaDon_SanPham
.Include(x => x.tbl_SanPham)
.Where(x => x.tbl_HoaDon.ngaylap.Year == year && x.tbl_HoaDon.ngaylap.Month == month)
.GroupBy(x => x.id_sanpham)
.Select(x => new
{
sanpham = x.FirstOrDefault(s => s.tbl_SanPham.id == x.Key).tbl_SanPham.tensanpham,
soluong = x.Sum(s => s.soluong)
})
.OrderBy(x => x.soluong)
.Take(10).ToList();
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
public JsonResult DetailShiping(long id)
{
using (HutechMartDbContext db = new HutechMartDbContext())
{
var info = from a in db.tbl_DoiTacGiaoHang
join b in db.tbl_PhanLoai_GiaoHang on a.id_phanloai equals b.id
where a.id == id
select new
{
MaDT = a.madoitac,
DiaChi = a.diachi_sonha + ", " + a.diachi_tenphuong + ", " + a.diachi_tenquan + ", " + a.diachi_tentinh,
TenDT = a.tendoitac,
SDT = a.sodienthoai,
Email = a.email,
GhiChu = a.ghichu,
TinhTrang = a.tinhtrang == true ? "Hoạt động" : "Không hoạt động",
NgayTao = a.ngaytao,
PhanLoai = b.tenphanloai
};
return(Json(info.ToList(), JsonRequestBehavior.AllowGet));
}
}
public ActionResult Update(tbl_KhachHang khachHang)
{
bool result = false;
using (HutechMartDbContext db = new HutechMartDbContext())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
var _khachHang = db.tbl_KhachHang.Find(khachHang.id);
_khachHang.id_phanloai = khachHang.id_phanloai;
_khachHang.tenkhachhang = khachHang.tenkhachhang;
_khachHang.gioitinh = khachHang.gioitinh;
_khachHang.ngaysinh = khachHang.ngaysinh;
_khachHang.sochungminh = khachHang.sochungminh;
_khachHang.sodienthoai = khachHang.sodienthoai;
_khachHang.diachi_tentinh = khachHang.diachi_tentinh;
_khachHang.diachi_tenquan = khachHang.diachi_tenquan;
_khachHang.diachi_tenphuong = khachHang.diachi_tenphuong;
_khachHang.diachi_sonha = khachHang.diachi_sonha;
_khachHang.email = khachHang.email;
_khachHang.facebook = khachHang.facebook;
_khachHang.ghichu = khachHang.ghichu;
_khachHang.id_nguoicapnhat = khachHang.id_nguoicapnhat;
_khachHang.ngaycapnhat = DatetimeLocation.GetDate();
db.SaveChanges();
trans.Commit();
result = true;
}
catch
{
trans.Rollback();
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Login(string taiKhoan, string matKhau)
{
bool result = false;
using (HutechMartDbContext db = new HutechMartDbContext())
{
var dangNhap = db.tbl_DangNhap.FirstOrDefault(x => x.taikhoan == taiKhoan);
if (dangNhap != null)
{
if (dangNhap.matkhau == matKhau)
{
var nguoiDung = db.tbl_NhanVien
.Include(x => x.tbl_ChucVu)
.Include(x => x.tbl_CuaHang)
.Include(x => x.tbl_DangNhap)
.FirstOrDefault(x => x.id == dangNhap.id_nhanvien);
Session["NguoiDung"] = nguoiDung;
result = true;
}
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult DetailSupply(long id)
{
using (HutechMartDbContext db = new HutechMartDbContext())
{
var info = from a in db.tbl_NhaCungCap
join b in db.tbl_PhanLoai_NhaCungCap on a.id_phanloai equals b.id
where a.id == id
select new
{
MaNCC = a.manhacungcap,
DiaChi = a.diachi_sonha + ", " + a.diachi_tenphuong + ", " + a.diachi_tenquan + ", " + a.diachi_tentinh,
TenNCC = a.tennhacungcap,
MaSoThue = a.masothue,
SDT = a.sodienthoai,
Email = a.email,
GhiChu = a.ghichu,
TinhTrang = a.tinhtrang == true ? "Hoạt động" : "Không hoạt động",
NgayTao = a.ngaytao,
PhanLoai = b.tenphanloai
};
return(Json(info.ToList(), JsonRequestBehavior.AllowGet));
}
}
public ActionResult Delete(int id)
{
bool result = false;
using (HutechMartDbContext db = new HutechMartDbContext())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
var giaoHang = db.tbl_DoiTacGiaoHang.FirstOrDefault(x => x.id == id);
db.tbl_DoiTacGiaoHang.Remove(giaoHang);
db.SaveChanges();
trans.Commit();
result = true;
}
catch
{
trans.Rollback();
}
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult ChiTietNV(long id)
{
HutechMartDbContext db = new HutechMartDbContext();
var detail = from a in db.tbl_NhanVien
join b in db.tbl_ChucVu on a.id_chucvu equals b.id
where a.id == id
select new
{
HinhANh = a.hinhanh,
MaNV = a.manhanvien,
TenNV = a.tennhanvien,
GT = a.gioitinh,
NgaySinh = a.ngaysinh,
SDT = a.sodienthoai,
ChucVu = b.chucvu,
CMND = a.sochungminh,
DiaChi = a.diachi_sonha + " " + a.diachi_tenphuong + " " + a.diachi_tenquan + " " + a.diachi_tentinh,
Email = a.email,
Fb = a.facebook,
TinhTrang = a.tinhtrang == true ? "Hoạt động" : "Không hoạt động"
};
return(Json(detail, JsonRequestBehavior.AllowGet));
}
