public ActionResult Create(tbl_NhanVien nhanVien, HttpPostedFileBase hinhAnh)
{
bool result = false;
if (hinhAnh == null)
{
nhanVien.hinhanh = "NguoiDung.jpg";
}
else
{
nhanVien.hinhanh = GetImage(hinhAnh, nhanVien.tennhanvien);
}
nhanVien.tinhtrang = true;
nhanVien.ngaytao = DatetimeLocation.GetDate();
using (HutechMartDbContext db = new HutechMartDbContext())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
db.tbl_NhanVien.Add(nhanVien);
db.SaveChanges();
var dangNhap = new tbl_DangNhap();
dangNhap.id_nhanvien = nhanVien.id;
dangNhap.taikhoan = nhanVien.sodienthoai;
dangNhap.matkhau = nhanVien.sodienthoai;
if (nhanVien.id_chucvu != 1)
{
dangNhap.loaitaikhoan = true;
}
else
{
dangNhap.loaitaikhoan = false;
}
db.tbl_DangNhap.Add(dangNhap);
db.SaveChanges();
trans.Commit();
result = true;
}
catch
{
trans.Rollback();
}
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult Create(tbl_DoiTacGiaoHang giaoHang)
{
bool result = false;
using (HutechMartDbContext db = new HutechMartDbContext())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
giaoHang.ngaytao = DatetimeLocation.GetDate();
giaoHang.tinhtrang = true;
db.tbl_DoiTacGiaoHang.Add(giaoHang);
db.SaveChanges();
trans.Commit();
result = true;
}
catch
{
trans.Rollback();
}
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult CreateGroupShiping(string tenphanloai, string ghichu)
{
bool result = false;
using (HutechMartDbContext db = new HutechMartDbContext())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
tbl_PhanLoai_GiaoHang phanloai = new tbl_PhanLoai_GiaoHang();
phanloai.tenphanloai = tenphanloai;
phanloai.ghichu = ghichu;
db.tbl_PhanLoai_GiaoHang.Add(phanloai);
db.SaveChanges();
trans.Commit();
result = true;
}
catch
{
trans.Rollback();
}
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult CreateOriginProduct(string diadiem)
{
bool result = false;
using (HutechMartDbContext db = new HutechMartDbContext())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
tbl_XuatXu xuatxu = new tbl_XuatXu();
xuatxu.xuatxu = diadiem;
db.tbl_XuatXu.Add(xuatxu);
db.SaveChanges();
trans.Commit();
result = true;
}
catch
{
trans.Rollback();
}
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult CreateSaleProduct(int giamgia)
{
bool result = false;
using (HutechMartDbContext db = new HutechMartDbContext())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
tbl_KhuyenMai khuyenmai = new tbl_KhuyenMai();
khuyenmai.giamgia = giamgia;
db.tbl_KhuyenMai.Add(khuyenmai);
db.SaveChanges();
trans.Commit();
result = true;
}
catch
{
trans.Rollback();
}
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult Create(tbl_SanPham sanPham, HttpPostedFileBase hinhAnh)
{
bool result = false;
if (hinhAnh == null)
{
sanPham.hinhanh = "SanPham.png";
}
else
{
sanPham.hinhanh = GetImage(hinhAnh, sanPham.tensanpham);
}
sanPham.tinhtrang = true;
sanPham.ngaytao = DatetimeLocation.GetDate();
using (HutechMartDbContext db = new HutechMartDbContext())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
db.tbl_SanPham.Add(sanPham);
db.SaveChanges();
trans.Commit();
result = true;
}
catch
{
trans.Rollback();
}
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult CreateGroupEmployees(string chucVu)
{
bool result = false;
using (HutechMartDbContext db = new HutechMartDbContext())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
tbl_ChucVu _chucVu = new tbl_ChucVu();
_chucVu.chucvu = chucVu;
db.tbl_ChucVu.Add(_chucVu);
db.SaveChanges();
trans.Commit();
result = true;
}
catch
{
trans.Rollback();
}
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult ChangePassword(int id, string MatKhauCu, string MatKhauMoi)
{
bool result = false;
using (HutechMartDbContext db = new HutechMartDbContext())
{
using (var trans = db.Database.BeginTransaction())
{
var thongTin = db.tbl_DangNhap.FirstOrDefault(x => x.id_nhanvien == id);
if (thongTin.matkhau == MatKhauCu)
{
try
{
thongTin.matkhau = MatKhauMoi;
db.SaveChanges();
trans.Commit();
result = true;
}
catch
{
trans.Rollback();
}
}
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult InfoUpdate(tbl_NhanVien nhanVien)
{
bool result = false;
using (HutechMartDbContext db = new HutechMartDbContext())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
var _nhanVien = db.tbl_NhanVien.Find(nhanVien.id);
_nhanVien.sodienthoai = nhanVien.sodienthoai;
_nhanVien.facebook = nhanVien.facebook;
_nhanVien.email = nhanVien.email;
db.SaveChanges();
trans.Commit();
result = true;
}
catch
{
trans.Rollback();
}
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult Update(tbl_NhaCungCap cungCap)
{
bool result = false;
using (HutechMartDbContext db = new HutechMartDbContext())
{
var _cungCap = db.tbl_NhaCungCap.Find(cungCap.id);
using (var trans = db.Database.BeginTransaction())
{
try
{
_cungCap.id_phanloai = cungCap.id_phanloai;
_cungCap.diachi_tentinh = cungCap.diachi_tentinh;
_cungCap.diachi_tenquan = cungCap.diachi_tenquan;
_cungCap.diachi_tenphuong = cungCap.diachi_tenphuong;
_cungCap.diachi_sonha = cungCap.diachi_sonha;
_cungCap.tennhacungcap = cungCap.tennhacungcap;
_cungCap.sodienthoai = cungCap.sodienthoai;
_cungCap.email = cungCap.email;
_cungCap.masothue = cungCap.masothue;
_cungCap.id_nguoicapnhat = cungCap.id_nguoicapnhat;
_cungCap.ngaycapnhat = DatetimeLocation.GetDate();
_cungCap.ghichu = cungCap.ghichu;
db.SaveChanges();
trans.Commit();
result = true;
}
catch
{
trans.Rollback();
}
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult Update(tbl_NhanVien nhanVien, HttpPostedFileBase hinhAnh)
{
bool result = false;
using (HutechMartDbContext db = new HutechMartDbContext())
{
var _nhanVien = db.tbl_NhanVien.FirstOrDefault(x => x.id == nhanVien.id);
if (hinhAnh != null)
{
Random rd = new Random();
var thayAnh = nhanVien.tennhanvien + rd.Next(1, 10);
nhanVien.hinhanh = GetImage(hinhAnh, thayAnh);
}
else
{
nhanVien.hinhanh = _nhanVien.hinhanh;
}
using (var trans = db.Database.BeginTransaction())
{
try
{
_nhanVien.hinhanh = nhanVien.hinhanh;
_nhanVien.id_cuahang = nhanVien.id_cuahang;
_nhanVien.id_chucvu = nhanVien.id_chucvu;
_nhanVien.tennhanvien = nhanVien.tennhanvien;
_nhanVien.gioitinh = nhanVien.gioitinh;
_nhanVien.ngaysinh = nhanVien.ngaysinh;
_nhanVien.sochungminh = nhanVien.sochungminh;
_nhanVien.sodienthoai = nhanVien.sodienthoai;
_nhanVien.email = nhanVien.email;
_nhanVien.facebook = nhanVien.facebook;
_nhanVien.diachi_tentinh = nhanVien.diachi_tentinh;
_nhanVien.diachi_tenquan = nhanVien.diachi_tenquan;
_nhanVien.diachi_tenphuong = nhanVien.diachi_tenphuong;
_nhanVien.diachi_sonha = nhanVien.diachi_sonha;
_nhanVien.ghichu = nhanVien.ghichu;
_nhanVien.id_nguoicapnhat = nhanVien.id_nguoicapnhat;
_nhanVien.ngaycapnhat = DateTime.Now;
db.SaveChanges();
trans.Commit();
result = true;
}
catch
{
trans.Rollback();
}
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult XoaHoaDon(long MaHD)
{
var hd_sp = from a in db.tbl_HoaDon
join b in db.tbl_HoaDon_SanPham on a.id equals b.id_hoadon
where a.id == MaHD
select new { a, b };
foreach (var hd in hd_sp)
{
db.tbl_HoaDon_SanPham.Remove(hd.b);
db.tbl_HoaDon.Remove(hd.a);
}
db.SaveChanges();
return(Json(null, JsonRequestBehavior.AllowGet));
}
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 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 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));
}
