public ActionResult AddPromotion(string tenKhuyenMai, string ngayBatDau, string ngayKetThuc, string phanTramKhuyenMai, List <string> dsTL) { if (Session["userPrio"] != null && Session["userPrio"].ToString() == "Admin") { using (var db = new Models.QLPhone()) { Models.KHUYENMAI km = new Models.KHUYENMAI(); int slKM = db.KHUYENMAIs.ToList().Count() + 1; var maKM = "KM" + slKM.ToString().PadLeft(8, '0'); km.MaKhuyenMai = maKM; km.TenKhuyenMai = tenKhuyenMai; km.NgayBatDau = DateTime.Parse(ngayBatDau); km.NgayKetThuc = DateTime.Parse(ngayKetThuc); km.PhanTramKhuyenMai = byte.Parse(phanTramKhuyenMai); km.HienThiKM = true; db.KHUYENMAIs.Add(km); db.SaveChanges(); UpdateBookPromotion(maKM, dsTL); return(RedirectToAction("PromotionManage", "Promotion")); } } return(RedirectToAction("Home", "Home")); }
public ActionResult Index() { if (Session["userID"] == null) { return(RedirectToAction("Login", "Login")); } using (var db = new Models.QLPhone()) { ViewBag.DsSachDeal = db.DIENTHOAIs.Where(t => t.KHUYENMAI.NgayKetThuc > DateTime.Now && t.HienThiDT == true).Take(5).ToList(); ViewBag.DsTL = db.HANGSANXUATs.ToList(); List <Models.CTGIOHANG> ct = new List <Models.CTGIOHANG>(); string temp = Session["userID"].ToString(); var query = from gh in db.CTGIOHANGs join s in db.DIENTHOAIs on gh.MaDienThoai equals s.MaDienThoai where gh.TenTaiKhoan == temp select new { s.HinhDienThoai, s.TenDienThoai, gh.SoLuongGioHang, s.MaDienThoai, s.MaKhuyenMai, s.GiaBan }; List <Models.Temp.CTGIOHANGViewModel> ctgh = new List <Models.Temp.CTGIOHANGViewModel>(); Models.KHUYENMAI km = new Models.KHUYENMAI(); foreach (var item in query) { Models.Temp.CTGIOHANGViewModel cttemp = new Models.Temp.CTGIOHANGViewModel(); cttemp.HinhDienThoai = item.HinhDienThoai; cttemp.TenDienThoai = item.TenDienThoai; cttemp.SoLuongGioHang = item.SoLuongGioHang; cttemp.MaDienThoai = item.MaDienThoai; using (var dbtemp = new Models.QLPhone()) { km = dbtemp.KHUYENMAIs.Where(t => t.MaKhuyenMai == item.MaKhuyenMai).FirstOrDefault(); if (km != null) { cttemp.GiaBan = item.GiaBan * item.SoLuongGioHang * ((100 - km.PhanTramKhuyenMai) * 0.01); cttemp.TietKiem = item.GiaBan * item.SoLuongGioHang * (km.PhanTramKhuyenMai * 0.01); } else { cttemp.GiaBan = item.GiaBan * item.SoLuongGioHang; cttemp.TietKiem = item.GiaBan * item.SoLuongGioHang; } } ctgh.Add(cttemp); } ViewBag.DsCTGH = ctgh; } return(View()); }
public ActionResult Detail(string id) { if (Session["bookEdit"] != null && Session["bookID"].ToString() != id) { Session["bookEdit"] = null; } try { using (var db = new Models.QLPhone()) { ViewBag.DsTL = db.HANGSANXUATs.ToList(); Session["bookID"] = id; ViewBag.id = id; Models.DIENTHOAI s = db.DIENTHOAIs.Where(t => t.MaDienThoai == id).FirstOrDefault(); ViewBag.DienThoai = s; if (s.HienThiDT == false) { return(RedirectToAction("Index", "Home")); } Models.KHUYENMAI km = db.KHUYENMAIs.Where(t => t.MaKhuyenMai == s.MaKhuyenMai).FirstOrDefault(); if (km != null) { ViewBag.KhuyenMai = km; ViewBag.TietKiem = s.GiaBan * (km.PhanTramKhuyenMai * 0.01); ViewBag.GiaBanHienTai = s.GiaBan * ((100 - km.PhanTramKhuyenMai) * 0.01); } if (Session["userID"] != null) { db.CTXEMs.Add(new Models.CTXEM() { MaDienThoai = id, TenTaiKhoan = Session["userID"].ToString(), NgayXem = DateTime.Now }); db.SaveChanges(); } s.SoLanTruyCap += 1; db.SaveChanges(); } } catch { } return(View()); }
public ActionResult DeletePromotion(string id) { if (Session["userPrio"] != null && Session["userPrio"].ToString() == "Admin") { using (var db = new Models.QLPhone()) { Models.KHUYENMAI km = db.KHUYENMAIs.Find(id); km.HienThiKM = false; List <Models.DIENTHOAI> listS = db.DIENTHOAIs.Where(s => s.MaKhuyenMai == id).ToList(); foreach (var item in listS) { item.MaKhuyenMai = null; db.Entry(item).State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); } return(RedirectToAction("PromotionManage", "Promotion")); } return(RedirectToAction("Home", "Home")); }
public ActionResult UpdatePromotion(string tenKhuyenMai, string ngayBatDau, string ngayKetThuc, string phanTramKhuyenMai, List <string> dsTL) { if (Session["userPrio"] != null && Session["userPrio"].ToString() == "Admin") { using (var db = new Models.QLPhone()) { Models.KHUYENMAI km = db.KHUYENMAIs.Find(Session["promotionID"]); km.TenKhuyenMai = tenKhuyenMai; km.NgayBatDau = DateTime.Parse(ngayBatDau); km.NgayKetThuc = DateTime.Parse(ngayKetThuc); km.PhanTramKhuyenMai = byte.Parse(phanTramKhuyenMai); km.HienThiKM = true; db.Entry(km).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); UpdateBookPromotion(km.MaKhuyenMai, dsTL); } return(RedirectToAction("PromotionManage", "Promotion")); } return(RedirectToAction("Home", "Home")); }
public ActionResult UpdatePromotion(string id = "") { if (Session["userPrio"] != null && Session["userPrio"].ToString() == "Admin") { using (var db = new Models.QLPhone()) { ViewBag.DsTL = db.HANGSANXUATs.ToList(); Session["promotionID"] = id; ViewBag.id = id; Models.KHUYENMAI km = db.KHUYENMAIs.Where(t => t.MaKhuyenMai == id).FirstOrDefault(); ViewBag.KhuyenMai = km; ViewBag.DsTL = db.HANGSANXUATs.ToList(); if (km.HienThiKM == false) { return(RedirectToAction("Home", "Home")); } } } return(View()); }