public void insertSP(SANPHAM SP)
{
var db = new QLTHONGTINMAYTINHEntities1();
db.SANPHAMs.Add(SP);
db.SaveChanges();
}
public ActionResult SuaSP(int id, HttpPostedFileBase fileupload)
{
if (ModelState.IsValid)
{
SANPHAM sanpham = db.SANPHAMs.SingleOrDefault(a => a.MaSP == id);
if (fileupload != null && fileupload.ContentLength > 0)
{
var fileName = Path.GetFileName(fileupload.FileName);
var path = Path.Combine(Server.MapPath("~/img/sanpham"), fileName);
if (System.IO.File.Exists(path))
{
ViewBag.ThongBao = "Hình ảnh bị trùng tên !";
}
else
{
fileupload.SaveAs(path);
}
sanpham.HinhAnh = fileName;
}
UpdateModel(sanpham);
db.SubmitChanges();
}
return(RedirectToAction("QLsanpham"));
}
public void XoaSanPham(string MaSP)
{
SANPHAM sp = qldg.SANPHAMs.Where(t => t.MASP == MaSP).FirstOrDefault();
qldg.SANPHAMs.DeleteOnSubmit(sp);
qldg.SubmitChanges();
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (dgvSanPham.SelectedRows.Count > 0)
{
if (rowselect == -1 || rowselect >= dsSP.Count)
{
return;
}
int vt = 0;
for (int i = 0; i < dsSP.Count; i++)
{
if (dsSP[i].MaSP == (int)(dgvSanPham.Rows[rowselect].Cells[0].Value))
{
vt = i;
break;
}
}
DataGridViewRow row = dgvSanPham.Rows[vt];
int Ma = int.Parse(row.Cells[0].Value.ToString());
SANPHAM sp = dsSP.Find(x => x.MaSP == Ma);
DetailProduct detail = new DetailProduct(sp);
var result = detail.ShowDialog();
LoadData();
}
}
public ActionResult ChinhSua(SANPHAM sp, HttpPostedFileBase fileImg)
{
if (ModelState.IsValid)
{
if (fileImg != null)
{
var fileName = Path.GetFileName(fileImg.FileName);
var path = Path.Combine(Server.MapPath("~/ImageClothes"), fileName);
if (System.IO.File.Exists(path))
{
}
else
{
fileImg.SaveAs(path);
}
sp.ANHSP = fileImg.FileName;
}
else
{
sp.ANHSP = (string)TempData["fileimg"];
}
db.Entry(sp).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
ViewBag.MaLSP = new SelectList(db.LOAISANPHAMs.ToList(), "MALSP", "TENLSP");
ViewBag.MaGioiTinh = new SelectList(db.GioiTinhs.ToList(), "MaGT", "GT");
return(RedirectToAction("QuanLySanPham"));
}
public ActionResult Create(SANPHAM sp, HttpPostedFileBase fileanh)
{
ViewBag.MADM = new SelectList(db.DANHMUCs.ToList().OrderBy(n => n.TENDM), "MADM", "TENDM");
ViewBag.MANCC = new SelectList(db.NHACCs.ToList().OrderBy(n => n.TENNCC), "MANCC", "TENNCC");
if (fileanh == null)
{
ViewBag.ThongBao = "Chọn ảnh!";
return(View());
}
if (ModelState.IsValid)
{
//lưu tên file
var filename = Path.GetFileName(fileanh.FileName);
//lưu đường dẫn của file
var path = Path.Combine(Server.MapPath("~/Content/img/product-img"), filename);
//kiểm tra hình ảnh dã tồn tại chưa
if (System.IO.File.Exists(path))
{
ViewBag.ThongBao = "Đã tồn tại hình ảnh";
}
else
{
fileanh.SaveAs(path);
}
sp.HINHANH = fileanh.FileName;
db.SANPHAMs.Add(sp);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public RedirectToRouteResult ThemSoSanh(string SP_ID)
{
if (Session["sosanh"] == null) // Nếu sản phẩm chưa được khởi tạo
{
Session["sosanh"] = new List <SoSanhSP>(); // Khởi tạo Session là 1 List<SoSanh>
}
List <SoSanhSP> sosanh = Session["sosanh"] as List <SoSanhSP>; // Gán qua biến sosanh dễ code
// Kiểm tra xem sản phẩm khách đang chọn đã có trong giỏ hàng chưa
if (sosanh.FirstOrDefault(m => m.SP_ID == SP_ID) == null) // ko co sp nay trong gio hang
{
if (sosanh.Count >= 2)
{
sosanh.Remove(sosanh.LastOrDefault());
}
SANPHAM sp = db.SANPHAMs.Find(SP_ID); // tim sp theo id
SoSanhSP ss = new SoSanhSP()
{
SP_ID = SP_ID,
}; // Tạo ra 1 CartItem mới
sosanh.Add(ss); // Thêm CartItem vào giỏ
}
// Action này sẽ chuyển hướng về trang chi tiết sp khi khách hàng đặt vào giỏ thành công. Bạn có thể chuyển về chính trang khách hàng vừa đứng bằng lệnh return Redirect(Request.UrlReferrer.ToString()); nếu muốn.
return(RedirectToAction("SearchSP"));
}
public static void sua(SANPHAM sp)
{
var v = db.SANPHAMs.Find(sp.ID);
db.Entry(v).CurrentValues.SetValues(sp);
db.SaveChanges();
}
public ActionResult Create([Bind(Include = "MaSP,TenSP,Gia,NgaySX,TinhTrang,Photo,MaLH,MaHSX")] SANPHAM sANPHAM, HttpPostedFileBase UploadImage)
{
if (ModelState.IsValid)
{
if (UploadImage != null)
{
if (UploadImage.ContentType == "image/jpg" || UploadImage.ContentType == "image/png" || UploadImage.ContentType == "image/jpeg")
{
UploadImage.SaveAs(Server.MapPath("/") + "/Content/" + UploadImage.FileName);
sANPHAM.Photo = UploadImage.FileName;
}
else
{
return(View());
}
}
else
{
return(View());
}
db.SANPHAMs.Add(sANPHAM);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaSP = new SelectList(db.GIOHANGs, "MaSP", "MaSP", sANPHAM.MaSP);
ViewBag.MaHSX = new SelectList(db.HANG_SX, "MaHSX", "TenHSX", sANPHAM.MaHSX);
ViewBag.MaLH = new SelectList(db.LOAIHANGs, "MaLH", "TenLH", sANPHAM.MaLH);
return(View(sANPHAM));
}
public ActionResult Create(SANPHAM sp)
{
if (ModelState.IsValid)
{
var dao = new SanPhamDAO();
var tk = dao.GetByTitle(sp.TEN_SANPHAM);
if (tk != null)
{
SetAlert("Sản phẩm đã tồn tại", "fail");
return(RedirectToAction("Index", "Product"));
}
//string txtContent = ViewBag.GhiChu;
var txtContent = Request.Unvalidated.Form.Get("txtContent");
// encode the data
// decode the data
sp.CREATEBY = ((UserLogin)Session[CommonStants.USER_SESSION]).userName;
sp.CREATEDATE = DateTime.Now;
sp.LUOTXEM = 0;
sp.NOIDUNG = txtContent;
decimal id = dao.Insert(sp);
if (id > 0)
{
//long LastId = dao.getIDLastChild();
//var namenew = dao.getIDLastChild();
////string exePath = System.AppContext.BaseDirectory + "\\Data\\Content\\" + namenew + ".html";
//string exePath = Server.MapPath("\\Data\\Product\\" + "pro" + namenew + ".cshtml");
//FileStream fs = new FileStream(exePath, FileMode.Create);
//using (StreamWriter sw = new StreamWriter(fs))
//{
// foreach (var s in txtContent)
// {
// sw.Write(s);
// }
// sw.Flush();
//}
//fs.Close();
//sp.GHICHU_SANPHAM = "/Data/Product/" + namenew + ".html";
//dao.updatenoidung(sp);
SetAlert("Thêm Thành công", "success");
return(RedirectToAction("Index", "Product"));
}
else
{
ModelState.AddModelError("", "Thêm không thành công!");
}
}
return(View("Index"));
}
//Sản phẩm liên quan của sản phẩm
public ActionResult SanPhamLienQuanPartial(int MaSP)
{
SANPHAM SP = db.SANPHAMs.SingleOrDefault(n => n.MaSP == MaSP);
List <SANPHAM> listSanPhamLienQuan = new List <SANPHAM>();
listSanPhamLienQuan = db.SANPHAMs.Where(n => n.MaLoaiSP == SP.MaLoaiSP).Take(3).ToList();
return(View(listSanPhamLienQuan));
}
public ActionResult DeleteConfirmed(int id)
{
SANPHAM sanpham = db.SANPHAMs.Find(id);
db.SANPHAMs.Remove(sanpham);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public double GetGiaSP(string ten)
{
double gia;
SANPHAM k = context.SANPHAMs.FirstOrDefault(m => m.TenSP == ten);
gia = Convert.ToDouble(k.Gia);
return(gia);
}
public int GetMaSP(string ten)
{
int ma;
SANPHAM k = context.SANPHAMs.FirstOrDefault(m => m.TenSP == ten);
ma = Convert.ToInt32(k.MaSP);
return(ma);
}
public static SANPHAM LoadDetailProduct(int Id)
{
SANPHAM res = null;
BANDONGHOEntities db = new BANDONGHOEntities();
res = db.SANPHAMs.Find(Id);
return(res);
}
public ActionResult Sua(int Mabalo)
{
ViewBag.Machude = new SelectList(db.CHUDEs.ToList().OrderBy(n => n.tenchude), "machude", "tenchude");
ViewBag.MaNSX = new SelectList(db.NHASANXUATs.ToList().OrderBy(n => n.tenNSX), "maNSX", "tenNSX");
SANPHAM sp = db.SANPHAMs.SingleOrDefault(n => n.Mabalo == Mabalo);
return(View(sp));
}
public ActionResult Xoa(int Mabalo)
{
SANPHAM sp = db.SANPHAMs.SingleOrDefault(n => n.Mabalo == Mabalo);
db.SANPHAMs.Remove(sp);
db.SaveChanges();
return(RedirectToAction("ADquanlysanpham"));
}
public void add(SANPHAMModel sx)
{
Mapper.CreateMap <SANPHAMModel, SANPHAM>();
SANPHAM _sx = Mapper.Map <SANPHAMModel, SANPHAM>(sx);
db.SANPHAMs.Add(_sx);
db.SaveChanges();
}
public ActionResult slideimage(string ma)
{
SANPHAM sp = dulieu.SANPHAMs.FirstOrDefault(s => s.MASP == ma);
List <string> lstImage = GetAllImageName(sp.ANHSP);
ViewBag.tenFolder = sp.ANHSP;
return(PartialView(lstImage));
}
public ActionResult Add(SANPHAM model)
{
var SanPham = db.SANPHAMs.Find(model.MaSanPham);
db.SANPHAMs.Add(model);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public int Add(SANPHAM p)
{
int result = 0;
context.SANPHAMs.Add(p);
result = context.SaveChanges();
return(result);
}
public List <CHITIETNHAPHANG> GetListCTNhapHang(CHITIETDONHANG CTDH)
{
SANPHAM sp = cn.GetObject <SANPHAM>("api/SANPHAM/" + CTDH.SANPHAM_ID);
List <CHITIETNHAPHANG> lstNH = cn.GetObject <List <CHITIETNHAPHANG> >("api/CHITIETNHAPHANG")
.Where(x => x.SANPHAM_ID == sp.ID && x.SOLUONGCONLAI > 0).ToList();
return(lstNH);
}
public ActionResult DeleteConfirmed(string MASP, string MALO)
{
SANPHAM sANPHAM = db.SANPHAMs.Where(x => (x.MASP == MASP) && (x.MALO == MALO)).FirstOrDefault();
db.SANPHAMs.Remove(sANPHAM);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult hienthichitiet(string ms)
{
List <SANPHAM> lst = db.SANPHAMs.ToList();
SANPHAM s = lst.FirstOrDefault(t => t.MASANPHAM == ms);
return(View(s));
}
public JsonResult DeleteSP(string id)
{
SANPHAM sp = sanphambusiness.getSP(id);
db.SANPHAMs.DeleteAllOnSubmit(db.SANPHAMs.Where(n => n.MaSP == id));
db.SubmitChanges();
return(Json(JsonRequestBehavior.AllowGet));
}
public bool update(SANPHAM entity)
{
if (validate(entity))
{
return(sanphamrepository.Attach(entity));
}
return(false);
}
public IHttpActionResult DeleteProduct([FromUri] string Ma)
{
SANPHAM sanpham = db.SANPHAMs.Where(sp => sp.DAXOA == false && sp.MA == Ma).SingleOrDefault();
db.SANPHAMs.Remove(sanpham);
db.SaveChanges();
return(Ok());
}
public ActionResult Them(SANPHAM sp)
{
ViewBag.Machude = new SelectList(db.CHUDEs.ToList().OrderBy(n => n.tenchude), "machude", "tenchude");
ViewBag.MaNSX = new SelectList(db.NHASANXUATs.ToList().OrderBy(n => n.tenNSX), "maNSX", "tenNSX");
db.SANPHAMs.Add(sp);
db.SaveChanges();
return(RedirectToAction("ADquanlysanpham"));
}
public ActionResult DeleteConfirmed(string id)
{
SANPHAM sANPHAM = db.SANPHAMs.Find(id);
db.SANPHAMs.Remove(sANPHAM);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void updatesp(string ma, int so)
{
SANPHAM sp = new SANPHAM();
sp = BH.SANPHAMs.Where(s => s.MASP == ma).Single();
sp.SOLUONG = so;
BH.SubmitChanges();
}
public DetailProduct()
{
detailProduct = new SANPHAM();
detailProductPromotion = 0;
manufactoryName = "";
typeProduct = "";
relativeList = new List<SANPHAM>();
relativeListPromotion = new List<float>();
subjectDescription = new List<string>();
contentDescription = new List<string>();
}
