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