//Thêm group public void AddGroup(TBL_GROUP model) { model.ACTIVATE = true; context.TBL_GROUPs.Add(model); context.SaveChanges(); }
public void Add(KhuyenMaiViewModel model) { var khuyenMai = new KHUYENMAI() { TenKhuyenMai = model.TenKhuyenMai, GiaTriKhuyenMai = model.GiaTriKhuyenMai, NgayBatDau = model.NgayBatDau, NgayKetThuc = model.NgayKetThuc, }; context.KHUYENMAIs.Add(khuyenMai); context.SaveChanges(); if (model.SanPhams?.Count > 0) { //foreach (var item in model.SanPhams) //{ // var sanPham = context.SANPHAMs.FirstOrDefault(t => t.Id_SanPham == item && t.TrangThai != false); // if (sanPham == null) continue; // sanPham.Id_KhuyenMai = khuyenMai.Id_KhuyenMai; //} UpdateKhuyenMaiForSanPham(model.SanPhams, khuyenMai.Id_KhuyenMai, true); } context.SaveChanges(); }
public ActionResult fillFormCustomer(string id, bool Accumulated) { List <ProductCart> productCarts = GetProductCarts(); var strimId = id.Trim(','); var listHadCheck = strimId.Split(',').Select(int.Parse).ToList(); //lấy ra sản phẩm trong giỏ hàng từ các sản phẩm đã chọn var products = productCarts.Where(x => listHadCheck.Contains(x.Id_SanPham)); // tổng tiền trong giổ hàng var sumTotal = products.Sum(x => x.soluong * x.giagiam); var customerlogin = SessionUser.GetSession(); var customer = db.KHACHHANGs.Where(x => x.Id_KhachHang == customerlogin.Id).FirstOrDefault(); var address = db.DIACHIs.Where(x => x.Id_KhachHang == customer.Id_KhachHang && x.TrangThai == true).FirstOrDefault(); DATHANG orderForm = new DATHANG { NgayDat = DateTime.Now, TrangThai = 1, DiaChiGiao = address.DiaChi, SoDienThoai = address.SoDienThoai, Id_KhachHang = customer.Id_KhachHang, TenNguoiNhan = address.TenKhachHang, // 50 tiền ship TongTien = sumTotal + 50 }; var aNewOder = db.DATHANGs.Add(orderForm); orderForm.Id_DatHang = aNewOder.Id_DatHang; // nếu nó có check thì lưu thêm cột giảm giá if (Accumulated == true) { orderForm.TongTienSauGiamGia = orderForm.TongTien - (double.Parse(customer.DiemTichLuy.ToString()) * 1000); orderForm.DiemTichLuy = customer.DiemTichLuy; customer.DiemTichLuy = 0; db.Entry(customer).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } foreach (var product in products) { CHITIETDATHANG detailOrder = new CHITIETDATHANG(); detailOrder.Id_DatHang = aNewOder.Id_DatHang; detailOrder.Id_SanPham = product.Id_SanPham; detailOrder.SoLuong = product.soluong; detailOrder.GiaBan = product.giagiam; detailOrder.ThanhTien = product.soluong * product.giagiam; detailOrder.TrangThai = true; db.CHITIETDATHANGs.Add(detailOrder); } db.SaveChanges(); return(RedirectToAction("succesBill", "PayForBill", new { idDatHang = orderForm.Id_DatHang })); }
public bool AddPhieuDatHangNCC(PhieuDatHang_NCCViewModel model) { var tongTien = model.ChiTietPhieuDats.Sum(t => t.SL * t.GiaNhap); var phieuDat = new PHIEUDATHANG_NCC() { MANCC = model.MaNCC, NGAYDAT = DateTime.Now, NGUOIDAT = HttpContext.Current.User.Identity.Name, TONGTIEN = tongTien, TRANGTHAI = 1, }; context.PHIEUDATHANG_NCCs.Add(phieuDat); context.SaveChanges(); foreach (var detail in model.ChiTietPhieuDats) { var chiTiet = new CT_PHIEUDATNCC() { MAPHIEUDAT = phieuDat.MAPHIEUDAT, MASANPHAM = detail.MaSP, SOLUONG = detail.SL, GIANHAP = detail.GiaNhap, THANHTIEN = detail.SL * detail.GiaNhap, TRANGTHAI = 1, }; context.CT_PHIEUDATNCCs.Add(chiTiet); } context.SaveChanges(); return(true); }
public bool Add(TBL_LOGIN model) { model.USERNAME = model.USERNAME.ToLower(); var existUser = context.TBL_LOGINs.Where(t => t.USERNAME.ToLower() == model.USERNAME).FirstOrDefault(); if (existUser != null) { return(false); } model.ACTIVATE = true; model.PASSWORD = Helper.GenHash.GenSHA1(model.PASSWORD); context.TBL_LOGINs.Add(model); context.SaveChanges(); return(true); }
public ActionResult addAdressPartial(DIACHI address) { if (SessionUser.GetSession() != null) { var anewAddress = new DIACHI() { Id_KhachHang = SessionUser.GetSession().Id, TenKhachHang = address.TenKhachHang, DiaChi = address.DiaChi, SoDienThoai = address.SoDienThoai, }; db.DIACHIs.Add(anewAddress); db.SaveChanges(); return(RedirectToAction("renderProductCarts", "Cart")); } return(PartialView()); }
public ActionResult Create(LOAISANPHAM collection) { try { // TODO: Add insert logic here if (ModelState.IsValid) { db.LOAISANPHAMs.Add(collection); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(collection)); } catch { return(View()); } }
public bool Add(PhanNhomNVViewModel model) { var nv = new TBL_LOGIN { USERNAME = model.TenNV, PASSWORD = model.PassWord, EMAIL = model.Email, PHONE = model.SDT, ACTIVATE = true, ISADMIN = false, CREATED_DATE = DateTime.Now, CREATED_BY = HttpContext.Current.User.Identity.Name, }; context.TBL_LOGINs.Add(nv); context.SaveChanges(); return(true); }
public bool Add(int id, PhanQuyenNVViewModel model) { if (model.Quyens?.Count > 0) { foreach (var idrole in model.Quyens) { var grouprole = new TBL_GROUP_ROLE { ID_GROUP = id, ID_ROLE = idrole, ACTIVATE = true }; context.TBL_GROUP_ROLEs.Add(grouprole); } } context.SaveChanges(); return(true); }
public bool Add(CT_PhieuDatHangNCCViewModel model) { try { var dathang = new CT_PHIEUDATNCC { MAPHIEUDAT = model.MaPhieuDat, MASANPHAM = model.MaSP, SOLUONG = model.SL, GIANHAP = model.GiaNhap, THANHTIEN = model.ThanhTien, }; context.CT_PHIEUDATNCCs.Add(dathang); context.SaveChanges(); return(true); } catch (Exception) { return(false); } }
// Lập phiếu nhập hàng từ phiếu đặt public bool AddPhieuNhapHangNCC(int id, PhieuNhapHang_NCCViewModel model) { var tongTien = model.ChiTietPhieuNhaps.Sum(t => t.SL * t.GiaNhap); var phieuDat = new PHIEUNHAP_NCC() { MAPHIEUDAT = id, NGAYNHAP = DateTime.Now, NGUOINHAP = HttpContext.Current.User.Identity.Name, TONGTIEN = tongTien.Value, TRANGTHAI = 2, }; context.PHIEUNHAP_NCCs.Add(phieuDat); context.SaveChanges(); foreach (var detail in model.ChiTietPhieuNhaps) { var chiTiet = new CTPHIEUNHAP_NCC() { MAPHIEUNHAP = phieuDat.MAPHIEUNHAP, MASANPHAM = detail.MaSP, SOLUONGNHAP = detail.SL, GIANHAP = detail.GiaNhap, THANHTIEN = detail.SL * detail.GiaNhap, }; var sp = context.SANPHAMs.Where(t => t.Id_SanPham == detail.MaSP).FirstOrDefault(); var slTon = sp.SoLuongTon ?? 0; // nếu là null thì gán mặc định = 0; sp.SoLuongTon = detail.SL + slTon; context.CTPHIEUNHAP_NCCs.Add(chiTiet); } UpdateTrangThaiDonHang(id); // CapNhatSLTon(nhapHang); context.SaveChanges(); return(true); }
public void Add(DatHangKHViewModel model) { var dathang = new DATHANG { Id_DatHang = model.MaDatHang, Id_KhachHang = model.MaKhachHang, NgayDat = model.NgayDatHang, DiaChiGiao = model.DiaChiGiao, SoDienThoai = model.SoDienThoai, GhiChu = model.GhiChu, TongTien = model.TongTien, TrangThai = ConvertToTrangThaiInt(model.TrangThai) }; context.DATHANGs.Add(dathang); context.SaveChanges(); }
public JsonResult addCommentPartial(int id, string textcomment, int sumstar) { var aNewComment = new DANHGIA(); var user = SessionUser.GetSession(); if (user != null) { aNewComment = new DANHGIA() { Id_KhachHang = user.Id, SoSao = sumstar, Comment = textcomment, NgayDanhGia = DateTime.Parse(DateTime.Now.ToString("dd/MM/yyyy")), Id_SanPham = id }; db.DANHGIAs.Add(aNewComment); db.SaveChanges(); return(Json(new { result = true, comment = aNewComment, name = user.Name }, JsonRequestBehavior.AllowGet)); } return(Json(new { result = false }, JsonRequestBehavior.AllowGet)); }
public IActionResult Register(Customer _user) { if (ModelState.IsValid) { var check = _context.customer.FirstOrDefault(s => s.phone == _user.phone); if (check == null) { _user.password = GetMD5(_user.password); // _context.Configuration.ValidateOnSaveEnabled = false; _context.customer.Add(_user); _context.SaveChanges(); return(RedirectToAction("Index")); } else { ViewBag.error = "Phone already exists"; return(View()); } } return(View()); }
public ActionResult ChangePassword(CustomerLogin KhachHang) { try { // TODO: Add update logic here ModelState.Clear(); if (ModelState.IsValid) { var currentUser = WebSiteBanHang.Helper.SessionUser.GetSession(); var kh = context.KHACHHANGs.Where(t => t.Id_KhachHang == currentUser.Id).FirstOrDefault(); var oldpassword = Helper.GenHash.GenSHA1(KhachHang.OldPassword); if (kh.PassWord != oldpassword) { ModelState.AddModelError("OldPassword", "Mật khẩu cũ không đúng"); } if (KhachHang.NewPassword != KhachHang.ConfirmNewPassword) { ModelState.AddModelError("ConfirmNewPassword", "Mật khẩu xác nhận không đúng"); } if (ModelState.Count == 0) { kh.PassWord = Helper.GenHash.GenSHA1(KhachHang.NewPassword); context.SaveChanges(); return(userControl.Logout()); } } return(View(KhachHang)); } catch (Exception ex) { ModelState.AddModelError("error", "Có lỗi trong quá trình xử lý"); return(View(KhachHang)); } }
public bool Update(Customer KhachHang) { var currentUser = WebSiteBanHang.Helper.SessionUser.GetSession(); if (currentUser == null) { return(false); } KHACHHANG KhachHangExist = context.KHACHHANGs.Find(currentUser.Id); if (KhachHangExist == null) { return(false); } KhachHangExist.TenKhachHang = KhachHang.TenKhachHang; KhachHangExist.DiaChi = KhachHang.DiaChi; KhachHangExist.SoDienThoai = KhachHang.SoDienThoai; KhachHangExist.NgaySinh = KhachHang.NgSinh; KhachHangExist.Email = KhachHang.Email; context.SaveChanges(); return(true); }
public int Add(SanPhamViewModel model) { var sanPham = new SANPHAM { TenSanPham = model.TenSanPham, SoLuongTon = 0, XuatXu = model.XuatXu, VatLieu = model.VatLieu, Mota = model.MoTa, MauSac = model.MauSac, Id_LoaiSanPham = model.MaLoai, KichThuoc = model.KichThuoc, CREATED_DATE = DateTime.Now, CREATED_BY = HttpContext.Current.User.Identity.Name }; //sanPham.HinhAnh = model.HinhAnh; context.SANPHAMs.Add(sanPham); context.SaveChanges(); return(sanPham.Id_SanPham); }
public ActionResult Registor(Customer customer) { KHACHHANG KhachHang = new KHACHHANG(); var CheckEmail = db.KHACHHANGs.Where(x => x.Email == customer.Email).ToList(); var CheckPhone = db.KHACHHANGs.Where(x => x.SoDienThoai == customer.SoDienThoai).ToList(); if (ModelState.IsValid) { if (CheckEmail.Count > 0) { ModelState.AddModelError("Email", "Email của bạn đã tồn tại"); } if (CheckPhone.Count > 0) { ModelState.AddModelError("SoDienThoai", "Số điện thoại của bạn tồn tại"); } if (CheckEmail.Count == 0 && CheckPhone.Count == 0) { var ngay = customer.Ngay.ToString(); var thang = customer.Thang.ToString(); if (customer.Ngay < 10) { ngay = '0' + customer.Ngay.ToString(); } if (customer.Thang < 10) { thang = '0' + customer.Thang.ToString(); } var thoigian = ngay + "/" + thang + "/" + customer.Nam; KhachHang = new KHACHHANG { TenKhachHang = customer.TenKhachHang, DiaChi = customer.DiaChi, SoDienThoai = customer.SoDienThoai, Email = customer.Email, PassWord = Helper.GenHash.GenSHA1(customer.PassWord), Id_LoaiKhachHang = 2 }; if (thoigian != " ") { KhachHang.NgaySinh = DateTime.ParseExact(thoigian, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); } // tổng chi +1, // dfsdfsd var aNewKhachHang = db.KHACHHANGs.Add(KhachHang); KhachHang.Id_KhachHang = aNewKhachHang.Id_KhachHang; DIACHI DiaChi = new DIACHI() { Id_KhachHang = aNewKhachHang.Id_KhachHang, SoDienThoai = aNewKhachHang.SoDienThoai, TenKhachHang = aNewKhachHang.TenKhachHang, DiaChi = aNewKhachHang.DiaChi, TrangThai = true }; db.DIACHIs.Add(DiaChi); db.SaveChanges(); return(RedirectToAction("Index", "Homepage")); } } var Thangs = new SelectList( new List <SelectListItem> { new SelectListItem { Text = "Tháng một", Value = "1" }, new SelectListItem { Text = "Tháng hai", Value = "2" }, new SelectListItem { Text = "Tháng ba", Value = "3" }, new SelectListItem { Text = "Tháng bốn", Value = "4" }, new SelectListItem { Text = "Tháng năm", Value = "5" }, new SelectListItem { Text = "Tháng sáu", Value = "6" }, new SelectListItem { Text = "Tháng bảy", Value = "7" }, new SelectListItem { Text = "Tháng tám", Value = "8" }, new SelectListItem { Text = "Tháng chín", Value = "9" }, new SelectListItem { Text = "Tháng mười", Value = "10" }, new SelectListItem { Text = "Tháng một", Value = "11" }, new SelectListItem { Text = "Tháng hai", Value = "12" } }, "Value", "Text"); ViewBag.Ngay = DayMonthYear.GetNgays(); ViewBag.Thang = Thangs; ViewBag.Nam = DayMonthYear.GetNams(); return(View(customer)); }
public void Add(LOAIPHONG loaiPhong) { context.LOAIPHONGs.Add(loaiPhong); context.SaveChanges(); }
public void Add(NHACUNGCAP NCC) { context.NHACUNGCAPs.Add(NCC); context.SaveChanges(); }