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)); } }