public ActionResult Update(tbl_DoiTacGiaoHang giaoHang)
{
bool result = false;
using (HutechMartDbContext db = new HutechMartDbContext())
{
var _giaoHang = db.tbl_DoiTacGiaoHang.Find(giaoHang.id);
using (var trans = db.Database.BeginTransaction())
{
try
{
_giaoHang.id_phanloai = giaoHang.id_phanloai;
_giaoHang.diachi_tentinh = giaoHang.diachi_tentinh;
_giaoHang.diachi_tenquan = giaoHang.diachi_tenquan;
_giaoHang.diachi_tenphuong = giaoHang.diachi_tenphuong;
_giaoHang.diachi_sonha = giaoHang.diachi_sonha;
_giaoHang.tendoitac = giaoHang.tendoitac;
_giaoHang.sodienthoai = giaoHang.sodienthoai;
_giaoHang.email = giaoHang.email;
_giaoHang.id_nguoicapnhat = giaoHang.id_nguoicapnhat;
_giaoHang.ngaycapnhat = DatetimeLocation.GetDate();
_giaoHang.ghichu = giaoHang.ghichu;
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 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 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 GetDataReportTargetByYear(int year)
{
using (HutechMartDbContext db = new HutechMartDbContext())
{
var datetime = DatetimeLocation.GetDate();
var result = db.tbl_HoaDon
.Where(x => x.ngaylap.Year == year)
.Select(x => new { value = x.tongtien, date = x.ngaylap }).ToList();
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
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 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));
}
}
