public IActionResult Index()
{
TempData["user"] = HttpContext.Session.GetString("user");
ViewBag.TopProduct = _db.SanPham.OrderByDescending(x => x.SoLuongCon).Take(4).ToList();
KhuyenMai x = _db.KhuyenMai.FirstOrDefault();
ChuongTrinhKhuyenMai ctkm = new ChuongTrinhKhuyenMai()
{
Id = "2",
khuyenMai = x,
Phantram = 10,
SanPham = _db.SanPham.FirstOrDefault()
};
//_db.ChuongTrinhKhuyenMai.Add(ctkm);
//_db.SaveChanges();
List <SanPhamKMVM> sales = _db.ChuongTrinhKhuyenMai
.Where(x => x.khuyenMai.NgayKt >= DateTime.Now).Select(x => new SanPhamKMVM()
{
DonGia = x.SanPham.DonGia.GetValueOrDefault(),
GiaGiam = x.Phantram,
HinhAnh = x.SanPham.HinhAnh,
LoaiSp = x.SanPham.LoaiSp,
MaSp = x.SanPham.MaSp,
TenSp = x.SanPham.TenSp
}).ToList();
ViewBag.Sale = sales;
return(View());
}
protected void btnNhap_Click(object sender, EventArgs e)
{
//Response.Write("<script language='javascript' > if ( confirm('Are you sure to delete?') ){} else { return false } </script>");
if (kiemtra() != false)
{
KhuyenMai khuyenmai = new KhuyenMai();
khuyenmai.TenKhuyenMai = txtTenKhuyenMai.Text;
khuyenmai.NoiDungKhuyenMai = txtNoiDungKhuyenMai.Text;
khuyenmai.NgayTao = DateTime.Now.ToShortDateString();
if (txtNgayBatDau.Text != "")
{
khuyenmai.NgayBatDau = txtNgayBatDau.Text;
}
if (txtNgayKetThuc.Text != "")
{
khuyenmai.NgayKetThuc = txtNgayKetThuc.Text;
}
if (txtGiaCanGiam.Text != "")
{
khuyenmai.GiaCanGiam = txtGiaCanGiam.Text;
}
db.KhuyenMais.InsertOnSubmit(khuyenmai);
luucheck(khuyenmai);
db.SubmitChanges();
// KhuyenMai khuyenmai1 = db.KhuyenMais.SingleOrDefault(p => p.MaKhuyenMai == khuyenmai.MaKhuyenMai);
lammoi();
LoadTrang();
clearcheck();
CheckBox chkhd = (CheckBox)GridView3.HeaderRow.FindControl("chkApDunghd");
chkhd.Checked = false;
Response.Write("<script> alert('Nhập thành công') </script>");
}
}
public ActionResult ThemGioHang(int iIDSanPham, string strURL)
{
List <GioHang> lstGiohang = LayGioHang();
GioHang sanpham = lstGiohang.Find(n => n.iIDSanPham == iIDSanPham);
if (sanpham == null)
{
sanpham = new GioHang(iIDSanPham);
KhuyenMai km = data.KhuyenMais.FirstOrDefault(x => x.IDSanPham == sanpham.iIDSanPham);
if (km != null)
{
sanpham.dDonGia = (double)(Convert.ToDouble(sanpham.dDonGia) * (1 - km.GiamGia / 100));
}
lstGiohang.Add(sanpham);
return(Redirect(strURL));
}
else
{
sanpham.iSoLuong++;
return(Redirect(strURL));
}
}
public IHttpActionResult PutKhuyenMai(int id, KhuyenMai khuyenMai)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != khuyenMai.MaKM)
{
return(BadRequest());
}
db.Entry(khuyenMai).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!KhuyenMaiExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Index()
{
KhuyenMai tintuc = db.KhuyenMais.Find(db.KhuyenMais.ToList()[db.KhuyenMais.ToList().Count - 1].MaKhuyenMai);
ViewBag.listKM = db.KhuyenMais.ToList();
return(View(tintuc));
}
public bool InsertKMtestcase(KhuyenMai km, long id)
{
try
{
if (db.KhuyenMais.Any(i => i.IdKhuyenMai == id) == true)
{
return(false);
}
KhuyenMai newKM = new KhuyenMai();
newKM.TenKhuyenMai = km.TenKhuyenMai;
newKM.PhanTram = km.PhanTram;
newKM.NgayBD = km.NgayBD;
newKM.NgayKT = km.NgayKT;
newKM.flag = true;
newKM.HinhKhuyenMai = null;
if (newKM.NgayBD >= newKM.NgayKT)
{
return(false);
}
else
{
db.KhuyenMais.Add(newKM);
//db.SaveChanges();
return(true);
}
}
catch
{ return(false); }
}
public async Task <IActionResult> Edit(int id, [Bind("ID,TieuDeKhuyenMai,HinhAnh,NoiDung")] KhuyenMai khuyenMai)
{
if (id != khuyenMai.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(khuyenMai);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!KhuyenMaiExists(khuyenMai.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Index"));
}
return(View(khuyenMai));
}
public ActionResult Delete(FormCollection form)
{
int id = Convert.ToInt32(form["id"]);
KhuyenMai khuyenMai = data.KhuyenMais.SingleOrDefault(i => i.IDSanPham == id);
//Nếu nhóm tồn tại
if (khuyenMai != null)
{
//Xóa nhóm
data.KhuyenMais.DeleteOnSubmit(khuyenMai);
try
{
data.SubmitChanges();
}
catch (Exception ex)
{
//int countSanPham = data.SanPhams.Count(i => i.IDMonAn == id);
//ViewBag.IsError = true;
//if (ex.Message.Contains("The DELETE statement conflicted with the REFERENCE constraint"))
//{
// ViewBag.ErrorBody = string.Format("Không thể xóa món ăn [{0}] do có {1} sản phẩm trong món ăn này.", monAn.TenMonAn, countSanPham);
//}
//else
//{
ViewBag.ErrorBody = ex.ToString();
//}
List <KhuyenMai> all = data.KhuyenMais.ToList();
return(View("Index", all));
}
}
//Xóa thành công hoặc nhóm k tồn tại thì trở về Index
return(RedirectToAction("Index", "AdminKhuyenMai"));
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (txtMaKM.Text == "" || txtTen.Text == "" || txtTyLe.Text == "")
{
MessageBox.Show("Vui lòng nhập đầy đủ thông tin!");
}
else
{
KhuyenMai KM = model.KhuyenMai.FirstOrDefault(x => x.maKhyenMai.ToUpper() == txtMaKM.Text.ToUpper());
if (KM == null)
{
KhuyenMai khuyenMai = new KhuyenMai();
khuyenMai.ten = txtTen.Text;
khuyenMai.maKhyenMai = txtMaKM.Text.ToUpper();
khuyenMai.tyLe = Int32.Parse(txtTyLe.Text);
khuyenMai.trangThai = true;
model.KhuyenMai.Add(khuyenMai);
}
else
{
KM.ten = txtTen.Text;
KM.maKhyenMai = txtMaKM.Text.ToUpper();
KM.tyLe = Int32.Parse(txtTyLe.Text);
KM.trangThai = true;
}
model.SaveChanges();
}
BilingListToDataGridView(model.KhuyenMai.Where(x => x.trangThai == true).ToList());
ButtonLock(false);
TB_CBLock(false);
TB_CBNull();
}
//
// GET: /KhuyenMai/Details/5
public ViewResult Details(int id)
{
KhuyenMai khuyenmai = db.KhuyenMais.Find(id);
ViewBag.listKM = db.KhuyenMais.ToList();
return(View(khuyenmai));
}
//[ValidateInput(false)]
public ActionResult Edit(KhuyenMai km)
{
if (km.NgayKT < km.NgayBD)
{
SetAlert("Mời chọn lại ngày", "error");
return(RedirectToAction("Edit", "KhuyenMai"));
}
else
{
// lấy mã người dùng
var lathongtin = Session[CommonConstants.MaND_SESSTION];
var mand = Convert.ToString(lathongtin);
km.MaNguoiDung = mand;
// láy ngày hiện tại
km.NgayTao = DateTime.Now;
var dao = new KhuyenMaiDao();
var id = dao.ChinhSua(km);
if (id == true)
{
SetAlert("Cập nhật thành công", "success");
return(RedirectToAction("DanhSachKhuyenMai", "KhuyenMai"));
}
else
{
return(RedirectToAction("Edit", "KhuyenMai"));
}
}
}
public ActionResult ThemMoi(KhuyenMai quyenhan)
{
if (quyenhan.TenKhuyenMai != null)
{
// lấy mã người dùng
var lathongtin = Session[CommonConstants.MaND_SESSTION];
var mand = Convert.ToString(lathongtin);
quyenhan.MaNguoiDung = mand;
// láy ngày hiện tại
quyenhan.NgayTao = DateTime.Now;
var dao = new KhuyenMaiDao();
int id = dao.ThemMoi(quyenhan);
if (id > 0)
{
SetAlert("Thêm thành công", "success");
return(RedirectToAction("DanhSachKhuyenMai", "KhuyenMai"));
}
else
{
return(RedirectToAction("ThemMoi", "KhuyenMai"));
}
}
return(View());
}
public IHttpActionResult PutKhuyenMai(KhuyenMai khuyenMai)
{
var khuyenMaiCurrent = db.KhuyenMais.SingleOrDefault(v => v.MaKhuyenMai == khuyenMai.MaKhuyenMai);
if (khuyenMaiCurrent != null)
{
db.Entry(khuyenMaiCurrent).State = EntityState.Detached;
db.Entry(khuyenMai).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
throw;
}
}
else
{
return(NotFound());
}
return(StatusCode(HttpStatusCode.NoContent));
}
public BLLResult Insert(string TenKM, string MaVL, decimal SoLuongToiThieu, decimal SoLuongKM, decimal TienKM, string DonViTinh)
{
try
{
if (ExistNoiDungKhuyenMai(TenKM, MaVL, SoLuongToiThieu, SoLuongKM, TienKM, DonViTinh)) // Đã tồn tại
{
return(new BLLResult("Khuyến mãi này đã tồn tại!"));
}
else // K tồn tại thì thêm vào
{
KhuyenMai tmp = new KhuyenMai();
tmp.MaKM = NewMaKM();
if (tmp.MaKM == null)
{
return(new BLLResult(8000418));
}
tmp.TenKM = TenKM;
tmp.MaVL = MaVL;
tmp.SoLuongToiThieu = SoLuongToiThieu;
tmp.SoLuongKM = SoLuongKM;
tmp.TienKM = TienKM;
tmp.DonViTinh = DonViTinh;
tmp.Live = "True";
DB.KhuyenMais.InsertOnSubmit(tmp);
DB.SubmitChanges();
return(new BLLResult((int)BLLResultType.S_ADD));
}
}
catch (Exception)
{
return(new BLLResult(8000541));
}
}
public async Task <ActionResult <User> > PostKM(KhuyenMai khuyenmai)
{
dbContext.KhuyenMais.Add(khuyenmai);
await dbContext.SaveChangesAsync();
return(CreatedAtAction(nameof(Get), new { ID_KM = khuyenmai.ID_KM }, khuyenmai));
}
protected void GridView2_SelectedIndexChanged(object sender, EventArgs e)
{
KhuyenMai khuyenmai = db.KhuyenMais.SingleOrDefault(p => p.MaKhuyenMai.ToString() == GridView2.Rows[GridView2.SelectedIndex].Cells[0].Text);
if (khuyenmai != null)
{
txtTenKhuyenMai.Text = khuyenmai.TenKhuyenMai;
txtNoiDungKhuyenMai.Text = khuyenmai.NoiDungKhuyenMai;
txtMaKhuyenMai.Text = khuyenmai.MaKhuyenMai.ToString();
if (khuyenmai.GiaCanGiam != "")
{
txtGiaCanGiam.Text = khuyenmai.GiaCanGiam;
}
if (khuyenmai.NgayBatDau != "")
{
txtNgayBatDau.Text = khuyenmai.NgayBatDau;
}
if (khuyenmai.NgayKetThuc != "")
{
txtNgayKetThuc.Text = khuyenmai.NgayKetThuc;
}
}
loadcheck(khuyenmai);
btnNhap.Enabled = false;
}
public ActionResult ThemMoi(KhuyenMai km, HttpPostedFileBase fileUpload)
{
if (fileUpload == null)
{
ViewBag.thongbao = "Chọn hình ảnh";
return(View());
}
if (ModelState.IsValid)
{
//Lưu tên file
var fileName = Path.GetFileName(fileUpload.FileName);
//Lưu đường dẫn của file
var path = Path.Combine(Server.MapPath("~/Content/image"), fileName);
if (System.IO.File.Exists(path))
{
ViewBag.thongbao = "Hình ảnh đã tồn tại";
}
else
{
fileUpload.SaveAs(path);
}
km.hinhKM = fileUpload.FileName;
db.KhuyenMai.Add(km);
db.SaveChanges();
return(RedirectToAction("Index", "QuanLyThongTinKhuyenMai"));
}
return(View());
}
public ActionResult ThemKM(KhuyenMai km, HttpPostedFileBase fileupload)
{
if (ModelState.IsValid)
{
var fileName = Path.GetFileName(fileupload.FileName);
var path = Path.Combine(Server.MapPath("~/image/KhuyenMai"), fileName);
if (System.IO.File.Exists(path))
{
ViewBag.ThongBao = "Hình ảnh đã tồn tại...";
SetAlert("Hình ảnh đã tồn tại", "warning");
}
else
{
fileupload.SaveAs(path);
KhuyenMai km1 = new KhuyenMai();
km1.TenKM = km.TenKM;
km1.NgayBatDau = km.NgayBatDau;
km1.NgayKetThuc = km.NgayKetThuc;
km1.AnhKM = fileName;
km1.NoiDung = km.NoiDung;
cn.KhuyenMais.Add(km1);
cn.SaveChanges();
SetAlert("Thêm thành công!", "success");
}
}
return(RedirectToAction("KhuyenMai"));
}
public async Task <IActionResult> Edit(string id, [Bind("MaKm,NgayBd,NgayKt")] KhuyenMai khuyenMai)
{
if (id != khuyenMai.MaKm)
{
return(NotFound());
}
if (ModelState.IsValid)
{
if (khuyenMai.NgayBd >= khuyenMai.NgayKt)
{
ModelState.AddModelError("NgayBd", @"Ngày bắt đầu phải nhỏ hơn ngày kết thúc");
return(View(khuyenMai));
}
try
{
_context.Update(khuyenMai);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!KhuyenMaiExists(khuyenMai.MaKm))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(khuyenMai));
}
public ActionResult Detail(int id)
{
KhuyenMai tintuc = db.KhuyenMais.Find(id);
ViewBag.listKM = db.KhuyenMais.ToList();
return(View(tintuc));
}
public ActionResult Create([Bind(Include = "makm,ngaybatdau,ngayketthuc,giatri,tinhtrang")] KhuyenMai khuyenMai)
{
try
{
if (ModelState.IsValid)
{
//db.KhuyenMais.Add(khuyenMai);
if (khuyenMai.ngayketthuc < DateTime.Today)
{
ViewBag.LoiNgay = "Ngày kết thúc phải lớn hơn hoặc bằng hôm nay!";
return(View("Create"));
}
else
{
db.Database.SqlQuery <KhuyenMai>("exec sp_addKhuyenMai {0},{1},{2},{3}", khuyenMai.ngaybatdau, khuyenMai.ngayketthuc, khuyenMai.giatri, false).ToList();
return(RedirectToAction("Index"));
}
}
}
catch (EntityCommandExecutionException ex)
{
return(RedirectToAction("Index"));
}
return(View(khuyenMai));
}
public int UpdateKM(long idKM, KhuyenMai km, HttpPostedFileBase hinhAnh, double phanTram)
{
if (km.NgayKT <= km.NgayBD)
{
return(0);
}
else
{
KhuyenMai newKM = db.KhuyenMais.Find(idKM);
newKM.TenKhuyenMai = km.TenKhuyenMai;
newKM.PhanTram = phanTram;
newKM.NgayKT = km.NgayKT;
newKM.flag = true;
string path = "";
if (hinhAnh != null)
{
if (hinhAnh.ContentLength > 0)
{
string fileName = Path.GetFileName(hinhAnh.FileName);
path = Path.Combine(HttpContext.Current.Server.MapPath("~/UploadedFiles"), fileName);
hinhAnh.SaveAs(path);
//path= path.Replace("\","/");
newKM.HinhKhuyenMai = fileName;
}
}
db.SaveChanges();
return(2);
}
}
protected void btnXoa_Click(object sender, EventArgs e)
{
KhuyenMai khuyenmai = db.KhuyenMais.SingleOrDefault(p => p.MaKhuyenMai.ToString() == txtMaKhuyenMai.Text);
if (khuyenmai != null)
{
db.KhuyenMais.DeleteOnSubmit(khuyenmai);
db.SubmitChanges();
LoadTrang();
lammoi();
btnNhap.Enabled = true;
txtMaKhuyenMai.Text = "";
CheckBox chkhd = (CheckBox)GridView3.HeaderRow.FindControl("chkApDunghd");
chkhd.Checked = false;
clearcheck();
Response.Write("<script> alert('Xóa thành công') </script>");
}
else
{
CustomValidator1.ErrorMessage = "Bạn hãy chọn một khuyến mại để xóa";
CustomValidator1.IsValid = false;
}
}
public KhuyenMai GetKMByKMCT(KhuyenMaiCT k)
{
PBL3 db = new PBL3();
KhuyenMai km = db.KhuyenMai.Find(k.MaKM);
return(km);
}
protected void dl1_ItemDataBound(object sender, DataListItemEventArgs e)
{
DataListItem item = e.Item;
Label lbGiaMoi = (Label)item.FindControl("GiaBanMoiLabel");
Label lbGiaBan = (Label)item.FindControl("GiaBanLabel");
lbGiaBan.Text = "Giá: " + HienThiGia(Convert.ToDouble(lbGiaBan.Text));
LinkButton linkbutton = (LinkButton)item.FindControl("lbtTenSP");
SanPhams sanpham = db.SanPhams.SingleOrDefault(p => p.TenSP == linkbutton.Text);
Label tenkhuyenmai = (Label)item.FindControl("TenKhuyenMai");
SanPham_KhuyenMai sanphamkhuyenmai = db.SanPham_KhuyenMais.SingleOrDefault(p => p.MaSanPham == sanpham.MaSanPham);
if (sanphamkhuyenmai != null)
{
KhuyenMai khuyenmai = db.KhuyenMais.SingleOrDefault(p => p.MaKhuyenMai == sanphamkhuyenmai.MaKhuyenMai);
tenkhuyenmai.Text = khuyenmai.NoiDungKhuyenMai;
if (khuyenmai.NoiDungKhuyenMai.ToString().Length > 30)
{
tenkhuyenmai.Text = khuyenmai.NoiDungKhuyenMai.Substring(0, 30) + "...";
}
lbGiaBan.Font.Strikeout = true;
lbGiaMoi.ForeColor = System.Drawing.Color.Red;
lbGiaMoi.Text = "Giá bán: " + HienThiGia(Convert.ToDouble(TinhGiamGia(khuyenmai.GiaCanGiam, sanpham.GiaBan).ToString()));
}
else
{
lbGiaBan.Font.Size = 11;
lbGiaBan.Font.Bold = true;
}
}
public ActionResult ThemMoi(
int maSach,
double giamGia,
DateTime ngayBatDau,
DateTime ngayKetThuc,
string tenSuKien)
{
var kM = context.KhuyenMai.FirstOrDefault(c => c.MaS == maSach);
if (kM != null)
{
context.KhuyenMai.Remove(kM);
context.SaveChanges();
}
var khuyenMai = new KhuyenMai()
{
MaS = maSach,
KhuyenMai1 = giamGia,
BatDau = ngayBatDau,
KetThuc = ngayKetThuc,
TenSuKien = tenSuKien
};
context.KhuyenMai.Add(khuyenMai);
context.SaveChanges();
return(Redirect("/Administrator/KhuyenMai/Index"));
}
public void FindTest()// so sanh ten
{
KhuyenMai test = new KhuyenMai();
test.TenKhuyenMai = "KMtest25";
Assert.AreEqual(test.TenKhuyenMai, dao.Find(5).TenKhuyenMai);
}
public void DeleteKMTest()
{
KhuyenMai test = new KhuyenMai();
test.IdKhuyenMai = 5;
Assert.AreEqual(false, dao.DeleteKMTestCase(test.IdKhuyenMai));
}
public int AddKM(int idTK, string tenKM, string phanTram, DateTime ngayBD, DateTime ngayKT, HttpPostedFileBase anh)
{
if (db.KhuyenMais.Any(i => i.Flag == true && i.TenKM == tenKM))
{
return(1);
}
else if (ngayBD >= ngayKT)
{
return(2);
}
else if (ngayKT <= DateTime.Now)
{
return(3);
}
else if (Convert.ToDouble(phanTram) >= 100 || Convert.ToDouble(phanTram) <= 0)
{
return(4);
}
else
{
Log log = new Log();
log.Ngay = DateTime.Now;
log.HanhDong = "TKhuyenMai";
log.KHId = idTK;
log.KhachHang = db.KhachHangs.Find(idTK);
log.ChiTiet = "Đã THÊM Chương Trình Khuyến Mãi với 'TÊN': " + tenKM + "; Thời Gian Khuyến Mãi: " + ngayBD.ToShortDateString() + "-" + ngayKT.ToShortDateString() + "; " + "Phần Trăm Khuyến Mãi: " + phanTram + "%";
KhuyenMai km = new KhuyenMai();
km.Flag = true;
km.TenKM = tenKM;
km.PhanTram = Convert.ToDouble(phanTram);
km.NgayBD = ngayBD;
km.NgayKT = ngayKT;
string path = "";
if (anh != null)
{
if (anh.ContentLength > 0)
{
string fileName = Path.GetFileName(anh.FileName);
path = Path.Combine(HttpContext.Current.Server.MapPath("~/UploadedFiles"), fileName);
anh.SaveAs(path);
km.AnhKM = fileName;
}
else
{
km.AnhKM = "img";
}
}
else
{
km.AnhKM = "img";
}
db.Logs.Add(log);
db.KhuyenMais.Add(km);
db.SaveChanges();
return(5);
}
}
public void DeleteKM(int makm)
{
PBL3 db = new PBL3();
KhuyenMai k = db.KhuyenMai.Find(makm);
db.KhuyenMai.Remove(k);
db.SaveChanges();
}
protected override void Render(HtmlTextWriter writer)
{
var sb = new StringBuilder();
var cs = this.Page.ClientScript;
var c = HttpContext.Current;
#region Variables
var ID = c.Request["ID"];
var Ten = c.Request["Ten"];
var MoTa = c.Request["MoTa"];
var Ma = c.Request["Ma"];
var NoiDung = c.Request["NoiDung"];
var TuNgay = c.Request["TuNgay"];
var DenNgay = c.Request["DenNgay"];
var SoLuong = c.Request["SoLuong"];
var ChietKhau = c.Request["ChietKhau"];
var TienChietKhau = c.Request["TienChietKhau"];
var Active = c.Request["Active"];
var ThuTu = c.Request["ThuTu"];
var NgayTao = c.Request["NgayTao"];
var NgayCapNhat = c.Request["NgayCapNhat"];
var NguoiTao = c.Request["NguoiTao"];
var NguoiCapNhat = c.Request["NguoiCapNhat"];
if(!Security.IsAuthenticated())
{
Response.Clear();
Response.End();
}
var _q = c.Request["q"];
#endregion
List<jgridRow> ListRow = new List<jgridRow>();
switch (subAct)
{
case "get":
#region get
var pagerGet = KhuyenMaiDal.pagerNormal("", false, "KM_" + jgrsidx + " " + jgrsord, _q, Convert.ToInt32(jgRows));
foreach (var item in pagerGet.List)
{
ListRow.Add(new jgridRow(item.ID.ToString(), new string[] {
item.ID.ToString()
, item.Ma
, item.Ten
, item.SoLuong.ToString()
, string.Format("{0:dd-MM-yy}-{1:dd-MM-yy}",item.TuNgay,item.DenNgay)
, Lib.TienVietNam(item.TienChietKhau)
, item.ChietKhau.ToString()
, item.Active.ToString()
, item.ThuTu.ToString()
, string.Format("{0:dd/MM/yy}",item.NgayCapNhat
)
}));
}
jgrid gridSPAdm = new jgrid(string.IsNullOrEmpty(jgrpage) ? "1" : jgrpage
, pagerGet.TotalPages.ToString()
, pagerGet.Total.ToString()
, ListRow);
sb.Append(JavaScriptConvert.SerializeObject(gridSPAdm));
break;
#endregion
case "search":
#region search
var pagerSearch = KhuyenMaiDal.pagerNormal("", false, "KM_NgayTao desc", _q, 20);
sb.Append(JavaScriptConvert.SerializeObject(pagerSearch.List));
break;
#endregion
case "save":
#region chỉnh sửa
if (Security.IsAuthenticated())
{
var item = new KhuyenMai();
if (!string.IsNullOrEmpty(ID))
{
item = KhuyenMaiDal.SelectById(new Guid(ID));
}
item.Active = Convert.ToBoolean(Active);
item.ChietKhau = Convert.ToDouble(ChietKhau);
item.DenNgay = Convert.ToDateTime(DenNgay, new CultureInfo("vi-Vn"));
item.Ma = Ma;
item.MoTa = MoTa;
item.NgayCapNhat = DateTime.Now;
item.NguoiCapNhat = Security.Username;
item.NoiDung = NoiDung;
item.SoLuong = Convert.ToInt32(SoLuong);
item.Ten = Ten;
item.ThuTu = Convert.ToInt32(ThuTu);
item.TienChietKhau = Convert.ToDouble(TienChietKhau);
item.TuNgay = Convert.ToDateTime(TuNgay, new CultureInfo("vi-Vn"));
if (!string.IsNullOrEmpty(ID))
{
item = KhuyenMaiDal.Update(item);
}
else
{
item.ID = Guid.NewGuid();
item.NgayTao = DateTime.Now;
item.NguoiTao = Security.Username;
item = KhuyenMaiDal.Insert(item);
}
sb.Append("1");
}
break;
#endregion
case "edit":
#region chỉnh sửa
if (!string.IsNullOrEmpty(ID))
{
sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(KhuyenMaiDal.SelectById(new Guid(ID))));
}
break;
#endregion
case "del":
#region chỉnh sửa
if (!string.IsNullOrEmpty(ID))
{
KhuyenMaiDal.DeleteById(new Guid(ID));
}
break;
#endregion
case "scpt":
#region Nạp js
sb.AppendFormat(@"{0}"
, cs.GetWebResourceUrl(typeof(Class1), "appStore.pmSpa.khuyenMaiMgr.JScript1.js"));
break;
#endregion
default:
#region default
{
var ListFn = FunctionDal.SelectByUserAndFNID(Security.Username, fnId);
sb.Append(Lib.GetResource(Assembly.GetExecutingAssembly(), "mdl.htm"));
sb.AppendFormat(@"<script>$.getScript('{0}',function(){1});</script>"
, cs.GetWebResourceUrl(typeof(Class1), "appStore.pmSpa.khuyenMaiMgr.JScript1.js")
, "{KhuyenMaiMgrFn.loadgrid();}");
sb.AppendFormat("<script>adm.validFn('{0}');</script>", JavaScriptConvert.SerializeObject(ListFn));
break;
}
#endregion
}
writer.Write(sb.ToString());
base.Render(writer);
}
