public ActionResult Index(int?page)
{
int pageSize = 10;
int pageNumber = (page ?? 1);
var model = new List <KhuyenMaiModel>();
var list = db.KhuyenMais.ToList();
var i = 0;
foreach (var item in list)
{
i++;
var khuyenmai = new KhuyenMaiModel();
khuyenmai.STT = i;
khuyenmai.Id = item.Id;
khuyenmai.Ten = item.TenKhuyenMai;
var lkm = (LoaiKhuyenMai)db.LoaiKhuyenMais.Where(x => x.Id == item.MaLoaiKhuyenMai).FirstOrDefault();
khuyenmai.TenLoaiKhuyenMai = lkm.TenLoaiKhuyenMai;
khuyenmai.PhanTram = item.PhanTram;
khuyenmai.NgayBatDau = item.NgayBatDau;
khuyenmai.NgayKetThuc = item.NgayKetThuc;
khuyenmai.Status = item.Status;
model.Add(khuyenmai);
}
return(View(model.ToPagedList(pageNumber, pageSize)));
}
// GET: KhuyenMai
public ActionResult Index()
{
KhuyenMaiModel model = new KhuyenMaiModel();
DataTable dt = model.getAllKhuyenMai();
return(View("Index", dt));
}
public ActionResult ThemSP1KhuyenMai([Bind(Include = "MaKM,MaSP,MoTa,GiamGia")] SanPhamKhuyenMai spkm)
{
KhuyenMaiModel spm = new KhuyenMaiModel();
spm.ThemSPKhuyenMai(spkm);
return(RedirectToAction("DSSanPham", new { makm = spkm.MaKM }));
}
public ActionResult Edit(int ma)
{
KhuyenMaiModel model = new KhuyenMaiModel();
DataTable dt = model.getKhuyenMai(ma);
return(View("Edit", dt));
}
public ActionResult ThemSP1KhuyenMai([Bind(Include = "Id,Id,MoTa,GiamGia")] SanPhamKhuyenMai spkm)
{
var spm = new KhuyenMaiModel();
spm.ThemSPKhuyenMai(spkm);
return(RedirectToAction("DSSanPham", new { makm = spkm.KhuyenMaiId }));
}
public ActionResult Delete(int ma)
{
KhuyenMaiModel model = new KhuyenMaiModel();
model.Delete(ma);
return(RedirectToAction("Index"));
}
public int AddKhuyenMai(KhuyenMaiModel km)
{
var khuyenmai = new DoAn.Models.EF.KhuyenMai();
khuyenmai.NgayBatDau = km.NgayBatDau;
khuyenmai.NgayKetThuc = km.NgayKetThuc;
khuyenmai.TenKhuyenMai = km.Ten;
khuyenmai.MoTa = km.MoTa;
khuyenmai.PhanTram = km.PhanTram;
db.KhuyenMais.Add(khuyenmai);
var motamodel = km.MoTa;
string[] lstloaisp = motamodel.Split(',');
foreach (var itemlsp in lstloaisp)
{
var maloaisp = Convert.ToInt32(itemlsp);
var lstsanpham = db.SanPhams.Where(x => x.MaLoaiSanPham == maloaisp).ToList();
foreach (var item in lstsanpham)
{
var sanpham = db.SanPhams.Find(item.Id);
sanpham.KhuyenMai = sanpham.GiaBan - sanpham.GiaBan * khuyenmai.PhanTram / 100;
db.SaveChanges();
}
}
db.SaveChanges();
return(khuyenmai.Id);
}
public ActionResult DeleteKhuyenMai(string id)
{
KhuyenMaiModel spm = new KhuyenMaiModel();
DeleteAnh(spm.FindById(id).AnhCT);
spm.DeleteKhuyenMai(id);
return(TimKhuyenMai(null, null, null, null));
}
public ActionResult DeleteSPKhuyenMai(string makm, string masp)
{
KhuyenMaiModel spm = new KhuyenMaiModel();
spm.DeleteSPKhuyenMai(makm, masp);
return(RedirectToAction("DSSanPham", new { makm = makm }));
}
public ActionResult CreateKhuyenMai()
{
var model = new KhuyenMaiModel();
model.ListLoaiSanPham = db.LoaiSanPhams.Where(x => x.Id == 1 || x.SanPhamChinh == 1).ToList();
model.SelectLoaiKM = new SelectList(db.LoaiKhuyenMais, "Id", "TenLoaiKhuyenMai", 0);
return(View(model));
}
public ActionResult TimKhuyenMai(string key, DateTime?start, DateTime?end, int?page)
{
KhuyenMaiModel spm = new KhuyenMaiModel();
ViewBag.key = key;
ViewBag.start = start;
ViewBag.end = end;
return(PhanTrangKhuyenMai(spm.TimKhuyenMai(key, start, end), page, null));
}
public JsonResult List(string txtSearch, int?page)
{
var list = db.KhuyenMais.OrderByDescending(x => x.Id).ToList();
int pageSize = 10;
if (!String.IsNullOrEmpty(txtSearch))
{
ViewBag.txtSearch = txtSearch;
list = list.Where(x => x.TenKhuyenMai.Contains(txtSearch)).OrderByDescending(x => x.Id).ToList();
}
var data = new List <KhuyenMaiModel>();
int i = 0;
foreach (var item in list)
{
i++;
var itemmodel = new KhuyenMaiModel();
itemmodel.STT = i;
itemmodel.Id = item.Id;
itemmodel.Ten = item.TenKhuyenMai;
itemmodel.NgayBDShow = String.Format("{0:dd/MM/yyyy}", item.NgayBatDau);
itemmodel.NgayKTShow = String.Format("{0:dd/MM/yyyy}", item.NgayKetThuc);
itemmodel.PhanTram = item.PhanTram;
var motasql = item.MoTa;
string[] lstloaisp = motasql.Split(',');
string lstloaisanpham = "";
foreach (var itemlsp in lstloaisp)
{
var maloaisp = Convert.ToInt32(itemlsp);
lstloaisanpham += db.LoaiSanPhams.FirstOrDefault(x => x.Id == maloaisp).TenLoaiSanPham + ", ";
}
itemmodel.MoTa = lstloaisanpham;
itemmodel.Status = item.Status;
data.Add(itemmodel);
}
if (page > 0)
{
page = page;
}
else
{
page = 1;
}
int start = (int)(page - 1) * pageSize;
ViewBag.pageCurrent = page;
int totalPage = data.Count();
float totalNumsize = (totalPage / (float)pageSize);
int numSize = (int)Math.Ceiling(totalNumsize);
ViewBag.numSize = numSize;
var datamodel = data.Skip(start).Take(pageSize);
return(Json(new { data = datamodel, pageCurrent = page, numSize = numSize }, JsonRequestBehavior.AllowGet));
}
public ActionResult kiemtra(string key)
{
KhuyenMaiModel spm = new KhuyenMaiModel();
if (spm.KiemTraTen(key))
{
return(Json(true, JsonRequestBehavior.AllowGet));
}
return(Json(false, JsonRequestBehavior.AllowGet));
}
public ActionResult CTKhuyenMai(string id)
{
KhuyenMaiModel km = new KhuyenMaiModel();
var lst = km.CTKhuyenMai(id);
if (lst.Any())
{
return(PartialView("KhuyenMaiDetail", lst));
}
return(null);
}
public ActionResult ThemKhuyenMai([Bind(Include = "TENCT,NGAYBATDAU,NGAYKETTHUC,NOIDUNG")] KMAI loai, HttpPostedFileBase ad)
{
KhuyenMaiModel spm = new KhuyenMaiModel();
if (ModelState.IsValid && spm.KiemTraTen(loai.TENCT))
{
string makm = spm.ThemKhuyenMai(loai);
UploadAnh(ad, makm + "1");
}
return(View("Index", loai));
}
public ActionResult EditKhuyenMai([Bind(Include = "MaKM,TenCT,NgayBatDau,NgayKetThuc,NoiDung")] KhuyenMai loai, HttpPostedFileBase ad)
{
KhuyenMaiModel spm = new KhuyenMaiModel();
if (ModelState.IsValid)
{
spm.EditKhuyenMai(loai);
UploadAnh(ad, loai.MaKM + "1");
return(RedirectToAction("Index"));
}
return(View(loai));
}
public ActionResult EditKhuyenMai([Bind(Include = "MAKM,TENCT,NGAYBATDAU,NGAYKETTHUC,NOIDUNG")] KMAI loai, HttpPostedFileBase ad)
{
KhuyenMaiModel spm = new KhuyenMaiModel();
if (ModelState.IsValid)
{
spm.EditKhuyenMai(loai);
UploadAnh(ad, loai.MAKM + "1");
return(RedirectToAction("Index"));
}
return(View(loai));
}
public ActionResult ThemKhuyenMai([Bind(Include = "TenCT,NgayBatDau,NgayKetThuc,NoiDung")] KhuyenMai loai, HttpPostedFileBase ad)
{
KhuyenMaiModel spm = new KhuyenMaiModel();
if (ModelState.IsValid && spm.KiemTraTen(loai.TenCT))
{
string makm = spm.ThemKhuyenMai(loai);
UploadAnh(ad, makm + "1");
return(RedirectToAction("SuaCTKhuyenMai", new { MaKM = makm }));
}
return(View("Index", loai));
}
public ActionResult MultibleDel(List <string> lstdel)
{
if (lstdel == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
foreach (var item in lstdel)
{
KhuyenMaiModel spm = new KhuyenMaiModel();
DeleteAnh(spm.FindById(item).AnhCT);
spm.DeleteKhuyenMai(item);
}
return(TimKhuyenMai(null, null, null, null));
}
public ActionResult DSSanPhamKhuyenMai(string key, string maloai, string makm, int?page)
{
ViewBag.key = key;
ViewBag.maloai = maloai;
ViewBag.makm = makm;
KhuyenMaiModel km = new KhuyenMaiModel();
IQueryable <SanPham> lst = km.DSSanPhamKhuyenMai(key, maloai, makm);
if (lst.Any())
{
return(PhanTrangSP(lst, "DSSanPhamKhuyenMai", page, null));
}
return(null);
}
public ActionResult DSSanPhamKhuyenMai(string keyTenSp, int maloai, int makm, int?page)
{
ViewBag.key = keyTenSp;
ViewBag.maloai = maloai;
ViewBag.makm = makm;
var km = new KhuyenMaiModel();
var lst = km.DSSanPhamKhuyenMai(keyTenSp, maloai, makm);
if (lst.Any())
{
return(PhanTrangSP(lst, "DSSanPhamKhuyenMai", page, null));
}
return(null);
}
public ActionResult EditKhuyenMai(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
KhuyenMaiModel lm = new KhuyenMaiModel();
KhuyenMai sp = lm.FindById(id);
if (sp == null)
{
return(HttpNotFound());
}
return(View(sp));
}
public ActionResult ThemSPKhuyenMai(List <SanPhamKhuyenMai> lstkt)
{
if (lstkt.Count == 0)
{
return(RedirectToAction("Index"));
}
var spm = new KhuyenMaiModel();
foreach (var item in lstkt)
{
if (item.SanPhamId > 0 && item.KhuyenMaiId > 0)
{
spm.ThemSPKhuyenMai(item);
}
}
return(RedirectToAction("Index"));
}
public ActionResult ThemSPKhuyenMai(List <SanPhamKhuyenMai> lstkt)
{
if (lstkt.Count == 0)
{
return(RedirectToAction("Index"));
}
KhuyenMaiModel spm = new KhuyenMaiModel();
foreach (var item in lstkt)
{
if (!string.IsNullOrEmpty(item.MaSP) && !string.IsNullOrEmpty(item.MaKM))
{
spm.ThemSPKhuyenMai(item);
}
}
return(RedirectToAction("Index"));
}
public ActionResult CreateKhuyenMai(KhuyenMaiModel model)
{
var khuyenmai = new KhuyenMai();
var makhuyenmai = new RandomId().MaNgauNhien_SoChu(5);
khuyenmai.Id = makhuyenmai;
khuyenmai.TenKhuyenMai = model.Ten;
khuyenmai.PhanTram = model.PhanTram;
khuyenmai.MaLoaiKhuyenMai = model.MaLoaiKhuyenMai;
khuyenmai.NgayBatDau = model.NgayBatDau;
khuyenmai.NgayKetThuc = model.NgayKetThuc;
khuyenmai.Status = 1;
var listloaisanpham = Request.Form["listlspdc"];
if (listloaisanpham != "")
{
string[] listlsp = listloaisanpham.Split(',');
foreach (var item in listlsp)
{
var maloaisp = int.Parse(item);
var listsp = db.SanPhams.Where(x => x.MaLoaiSanPham == maloaisp).ToList();
foreach (var itemsp in listsp)
{
var product = db.SanPhams.Find(itemsp.Id);
product.KhuyenMai = product.GiaBan - (product.GiaBan * model.PhanTram / 100);
db.SaveChanges();
}
}
}
else
{
}
khuyenmai.MoTa = listloaisanpham;
db.KhuyenMais.Add(khuyenmai);
db.SaveChanges();
return(RedirectToAction("Index", "KhuyenMaiAdmin"));
}
public ActionResult UpdateRecord(FormCollection form, string action)
{
if (action == "Submit")
{
KhuyenMaiModel model = new KhuyenMaiModel();
int ma = Convert.ToInt32(form["ma"]);
string loai = form["loai"];
string ten = form["ten"];
string thoiGianBatDau = form["thoiGianBatDau"];
string thoiGianKetThuc = form["thoiGianKetThuc"];
int giaTri = Convert.ToInt32(form["giaTri"]);
int tongTienThapNhat = Convert.ToInt32(form["tongTienThapNhat"]);
int status = model.Update(ma, ten, loai, thoiGianBatDau, thoiGianKetThuc, giaTri, tongTienThapNhat);
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("Index"));
}
}
// GET: KhuyenMai
public ActionResult Index()
{
var model = new KhuyenMaiModel();
return(View(model));
}
public JsonResult Add(KhuyenMaiModel khuyenmai)
{
return(Json(dao.AddKhuyenMai(khuyenmai), JsonRequestBehavior.AllowGet));
}
public ActionResult KhuyenMaiPost(string id)
{
KhuyenMaiModel km = new KhuyenMaiModel();
return(View("KhuyenMaiPostView", km.FindById(id)));
}
public ActionResult KhuyenMaiPost()
{
KhuyenMaiModel km = new KhuyenMaiModel();
return(PartialView("_KhuyenMaiPost", km.TimKhuyenMai(null, null, null).Where(m => m.NgayBatDau <= DateTime.Today && m.NgayKetThuc >= DateTime.Today)));
}
