// GET: SanPhams
public ActionResult Index(string search, int page = 1, int pageSize = 11)
{
var dao = new SanPhamDao();
var model = dao.ListAllPaging(search, page, pageSize);
return(View(model));
}
public ActionResult LoaiSanPham(string idlsp)
{
var sp = new SanPhamDao().ListSPtheoDMSPCha(idlsp).Where(x => x.MaLSP == idlsp).ToList();
ViewBag.TenLSP = new SanPhamDao().LayTenLSP(idlsp);
return(View(sp));
}
public ActionResult CapNhatSP(string masp)
{
var sp = new SanPhamDao().SanPham(masp);
GetListDMSP();
return(View(sp));
}
public ActionResult CapNhatDMSP(string iddmsp)
{
var dmsp = new SanPhamDao().ChiTietDMSP(iddmsp);
GetListDMSP(dmsp.ID);
return(View(dmsp));
}
public ActionResult Search(string keyword)
{
var model = new SanPhamDao().Search(keyword);
ViewBag.Keyword = keyword;
return(View(model));
}
public LogicResult updateProduct(FormAddProductObj frmObj)
{
SanPhamDao dao = new SanPhamDao();
dao.updateSanPhamChiTiet(createSanPhamChiTietDto(frmObj));
return(new LogicResult(Contanst.MSG_INFO, AppUtils.getAppConfig("MSGINFO003"), null));
}
public ActionResult GetProduct(string id, string keyword)
{
var listProduct = new SanPhamDao().getListSanPham();
var model = new List <ProductModel>();
var ctCTKM = new SanPhamDao().getListctCTKM(id);
foreach (var item in listProduct)
{
var check = false;
var temp = ctCTKM.Where(x => x.MASANPHAM == item.MASANPHAM).FirstOrDefault();
if (temp != null)
{
check = true;
}
model.Add(new ProductModel()
{
MaSanPham = item.MASANPHAM,
TenSanPham = item.TENSANPHAM,
select = check
});
}
if (string.IsNullOrEmpty(keyword))
{
return(Json(model, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(model.Where(x => x.TenSanPham.Contains(keyword) || x.MaSanPham.Contains(keyword)), JsonRequestBehavior.AllowGet));
}
}
public ActionResult SaveProductSave(string idCTKM, List <string> data)
{
var message = 0;
message = new SanPhamDao().ChangeProductSale(idCTKM, data);
return(Json(message, JsonRequestBehavior.AllowGet));
}
public ActionResult GetListCart()
{
var cart = (List <CartModel>)Session[CartSession.CartSesstion];
var list = new List <CartItemViewModel>();
if (cart != null)
{
foreach (var item in cart)
{
string chuongtrinhkhuyenmai = new SanPhamDao().getChuongTrinhKhuyenMai(item.SANPHAM.MASANPHAM);
list.Add(new CartItemViewModel
{
MASANPHAM = item.SANPHAM.MASANPHAM,
TENSANPHAM = item.SANPHAM.TENSANPHAM,
LOAIMATHANG = item.SANPHAM.LOAIMATHANG,
GIABAN = item.SANPHAM.GIABAN,
MAUSAC = item.SANPHAM.MAUSAC,
LINKHINHANH = item.SANPHAM.LINKHINHANH,
SOLUONGMUA = item.SOLUONG,
SOLUONGTON = item.SANPHAM.SOLUONG,
TACGIA = item.SANPHAM.TACGIA,
DONGIA = item.SANPHAM.DONGIA,
CHUONGTRINHKHUYENMAI = chuongtrinhkhuyenmai,
PhanTram = item.SANPHAM.PhanTram
});
}
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
public ActionResult delete(string MASP)
{
SanPhamDao dao = new SanPhamDao();
dao.delete(MASP);
return(Redirect("~/ADmin/sp"));
}
public ActionResult GetDataTreeView()
{
var list = new SanPhamDao().getDataPhanLoai();
//var model = FillAll(list, "SACH");
List <PhanLoaiModel> items = new List <PhanLoaiModel>();
foreach (var i in list)
{
items.Add(new PhanLoaiModel
{
id = i.MAPHANLOAI,
text = i.TENPHANLOAI,
parentId = i.MAPHANLOAICHA
});
}
Action <PhanLoaiModel> SetChildren = null;
SetChildren = parent =>
{
parent.items = items.Where(childItem => childItem.parentId == parent.id).ToList();
//Recursively call the SetChildren method for each child.
parent.items.ForEach(SetChildren);
};
List <PhanLoaiModel> hierarchicalItems = items.Where(rootItem => rootItem.parentId == null).ToList();
hierarchicalItems.ForEach(SetChildren);
return(Json(hierarchicalItems, JsonRequestBehavior.AllowGet));
}
public ActionResult detail(string MASP)
{
SanPhamDao dao = new SanPhamDao();
SanPham sp = dao.detail(MASP);
return(View(sp));
}
public ActionResult ThongKeSPBanRaTheoThang()
{
int Thang = DateTime.Now.Month;
int Nam = DateTime.Now.Year;
var list = new List <SPBanRaViewModel>();
var spBanRa = new SanPhamDao().SPBanRa(Thang, Nam);
foreach (var item in spBanRa)
{
if (item.SoLuong != 0)
{
list.Add(new SPBanRaViewModel
{
MaSP = item.MaSP,
MaDL = item.MaDL,
MaTT = item.MaTT,
MaMau = item.MaMau,
Thang = Thang,
Nam = Nam,
TenSP = item.TenSP,
SoLuong = item.SoLuong
});
}
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
public ActionResult SaveUpdatePrice(string id, decimal gia)
{
var session = (UserLogin)Session[QLNhaSachFahasa.Common.CommonConstants.USER_SEESION];
var message = new SanPhamDao().UpdateGiaBan(id, gia, session.UserID);
return(Json(message, JsonRequestBehavior.AllowGet));
}
public ActionResult Index()
{
var sanPhamDao = new SanPhamDao();
ViewBag.Product = sanPhamDao.ListAll();
return(View());
}
public ActionResult DanhMucSanPham(string iddmsp)
{
var listsptheodm = new SanPhamDao().ListSPtheoDMSPCon(iddmsp).ToList();
ViewBag.TenDMSP = new SanPhamDao().LayTenDMSP(iddmsp);
return(View(listsptheodm));
}
private void txtSoTo_ValueChanged(object sender, EventArgs e)
{
try
{
int idSanPhamCha = (int)cbbLoaiSanPham.SelectedValue;
String size = cbbSize.Text;
String loaiBia = cbbLoaiBia.Text;
String loaiGiay = cbbLoaiGiay.Text;
DataTable dt = SanPhamDao.getChiTietSanPham(idSanPhamCha, size, loaiBia, loaiGiay);
if (dt.Rows.Count == 1)
{
DataRow row = dt.Rows[0];
int numPageDefault = int.Parse(row["NUM_PAGE_DEFAULT"].ToString());
double donGiaDefault = double.Parse(row["DON_GIA"].ToString());
int soTo = (int)txtSoTo.Value;
double costPageAdd = double.Parse(row["ADDITIONAL_PAGES_COST"].ToString());
double donGia = AppUtils.cashProduct(numPageDefault, donGiaDefault, soTo, costPageAdd);
txtDonGia.Text = donGia.ToString();
txtThanhTien.Text = (donGia * (double)txtSoLuong.Value).ToString();
}
}
catch (Exception ex) {
//MessageBox.Show(ex.Message, "ERROR");
}
}
private void updateDataChanged()
{
try
{
if (this.initData == false)
{
return;
}
txtSoTo.Value = 10;
txtDonGia.Text = "";
txtSoLuong.Value = txtSoLuong.Minimum;
txtChietKhau.Value = txtChietKhau.Minimum;
txtThanhTien.Text = "";
int idSanPhamCha = (int)cbbLoaiSanPham.SelectedValue;
String size = cbbSize.Text;
String loaiBia = cbbLoaiBia.Text;
String loaiGiay = cbbLoaiGiay.Text;
DataTable dt = SanPhamDao.getChiTietSanPham(idSanPhamCha, size, loaiBia, loaiGiay);
if (dt.Rows.Count == 1)
{
DataRow row = dt.Rows[0];
int numPageDefault = int.Parse(row["NUM_PAGE_DEFAULT"].ToString());
double donGiaDefault = double.Parse(row["DON_GIA"].ToString());
int soTo = (int)txtSoTo.Value;
double costPageAdd = double.Parse(row["ADDITIONAL_PAGES_COST"].ToString());
double donGia = AppUtils.cashProduct(numPageDefault, donGiaDefault, soTo, costPageAdd);
txtDonGia.Text = donGia.ToString();
txtThanhTien.Text = (donGia * (double)txtSoLuong.Value).ToString("#,###");
}
}
catch (Exception) { }
}
// GET: Admin/LoaiSp
public ActionResult Index(string search, int page = 1, int pageSize = 10)
{
var dao = new SanPhamDao();
var model = dao.ListAllPaging3(search, page, pageSize);
ViewBag.Search = search; // giu thong tin tren khung tim kiem
return(View(model));
}
public ActionResult edit(string MASP)
{
SanPhamDao dao = new SanPhamDao();
SanPham sp = new SanPham();
sp = dao.getMASP(MASP);
return(View(sp));
}
public ActionResult Index()
{
var sanPhamDao = new SanPhamDao();
ViewBag.NewProducts = sanPhamDao.ListNewProduct(4);
ViewBag.ListHotProducts = sanPhamDao.ListHotProduct(4);
return(View());
}
public ActionResult ShopDetails(int id = 1)
{
var sp = new SanPhamDao();
var model = sp.SanPhamDetail(id);
ViewBag.theloai = sp.TenTheLoai(id);
return(View(model));
}
// GET: Home
public ActionResult Index()
{
var sanphamDao = new SanPhamDao();
ViewBag.SanPhamMoi = sanphamDao.ListSanPhamMoi(5);
ViewBag.SanPhamGiam = sanphamDao.ListSanPhamGiam(5);
return(View());
}
// GET: Admin/SanPham
public ActionResult Index(string searchString, int page = 1, int pageSize = 10)
{
var sanphamdao = new SanPhamDao();
var model = sanphamdao.ListAllPaging(searchString, page, pageSize);
ViewBag.SearchString = searchString;
return(View(model));
}
public ActionResult Detail(int id)
{
var sanpham = new SanPhamDao().ViewDetail(id);
ViewBag.DanhMuc = new DanhMucDao().ViewDetail(sanpham.IDdanhmuc.Value);
ViewBag.Splienquan = new SanPhamDao().ListSanPhamLienQuan(id);
return(View(sanpham));
}
public void CmbStype()
{
DataTable cmbStype = new SanPhamDao().getStype();
cmb_Stype.DataSource = cmbStype;
cmb_Stype.ValueMember = "id";
cmb_Stype.DisplayMember = "name";
}
public ActionResult Edit(int masanpham)
{
ViewBag.danhmucsanpham = dmDao.li();
ViewBag.loaisanpham = loaiSPDao.dsLoaiSP();
SanPhamDao spDao = new SanPhamDao();
return(View(spDao.searchProduct(masanpham)));
}
public void CmbBrand()
{
DataTable cmbBrand = new SanPhamDao().getBrand();
cmb_Brand.DataSource = cmbBrand;
cmb_Brand.ValueMember = "id";
cmb_Brand.DisplayMember = "name";
}
public void CmbColor()
{
DataTable cmbColor = new SanPhamDao().getColor();
cmb_Color.DataSource = cmbColor;
cmb_Color.ValueMember = "id";
cmb_Color.DisplayMember = "name";
}
// GET: Home
public ActionResult Index()
{
var sanpham = new SanPhamDao();
ViewBag.SanPham = sanpham.ListSpDauGia();
ViewBag.DanhMuc = new DanhMucSanPhamDao().ListSpDauGia();
return(View());
}
