public ActionResult Edit(string masp, SANPHAM collection, FormCollection c, HttpPostedFileBase fileupload) { // TODO: Add update logic here SANPHAM sp = db.SANPHAMs.Where(s => s.MASANPHAM == masp).Single(); sp.TENSANPHAM = c["TENSANPHAM"]; sp.MALOAI = c["MALOAI"]; sp.MATHUONGHIEU = c["THUONGHIEU.MATHUONGHIEU"]; sp.GIAGOC = double.Parse(c["GIAGOC"]); string now = DateTime.Now.ToShortDateString(); sp.NGAYTAO = Convert.ToDateTime(now); sp.MOI = Convert.ToInt16(c["MOI"]); sp.GIAM = double.Parse(c["GIAM"]); sp.SLTON = Convert.ToInt32(c["SLTON"]); if (fileupload != null) { string filename = Path.GetFileNameWithoutExtension(fileupload.FileName); string extension = Path.GetExtension(fileupload.FileName); filename = filename + extension; sp.HINHMINHHOA = filename; fileupload.SaveAs(Server.MapPath("~/Content/img/products/" + filename.ToString())); } //Insert kichthuoc List <string> kichthuoc = new List <string>(); if (c["size1"] != null) { kichthuoc.Add(c["size1"].ToString()); } if (c["size2"] != null) { kichthuoc.Add(c["size2"].ToString()); } if (c["size3"] != null) { kichthuoc.Add(c["size3"].ToString()); } if (c["size4"] != null) { kichthuoc.Add(c["size4"].ToString()); } List <NEM_KICHTHUOC> kt = db.NEM_KICHTHUOCs.Where(kk => kk.MASANPHAM == masp).ToList(); foreach (NEM_KICHTHUOC nkt in kt) { db.NEM_KICHTHUOCs.DeleteOnSubmit(nkt); db.SubmitChanges(); } foreach (string k in kichthuoc) { NEM_KICHTHUOC nktt = new NEM_KICHTHUOC(); nktt.MASANPHAM = masp.Trim(new Char[] { ' ', ',', '*', '.' }); nktt.KICHTHUOC = k; db.NEM_KICHTHUOCs.InsertOnSubmit(nktt); db.SubmitChanges(); } db.SubmitChanges(); return(RedirectToAction("Index", "AdminMenu")); }
public ActionResult Create(FormCollection c, HttpPostedFileBase fileupload) { if (ModelState.IsValid) { // TODO: Add insert logic here SANPHAM s = new SANPHAM(); //Insert sanpham s.MASANPHAM = c["MASANPHAM"].Trim(new Char[] { ' ', ',', '*', '.' }); s.TENSANPHAM = c["TENSANPHAM"]; s.MALOAI = c["MALOAI"]; s.MATHUONGHIEU = c["THUONGHIEU"]; s.GIAGOC = double.Parse(c["GIAGOC"]); string now = DateTime.Now.ToShortDateString(); s.NGAYTAO = Convert.ToDateTime(now); s.MOI = Convert.ToInt16(c["MOI"]); s.GIAM = double.Parse(c["GIAM"]); s.SLTON = Convert.ToInt32(c["SLTON"]); string filename = Path.GetFileNameWithoutExtension(fileupload.FileName); string extension = Path.GetExtension(fileupload.FileName); filename = filename + extension; s.HINHMINHHOA = filename; fileupload.SaveAs(Server.MapPath("~/Content/img/products/" + filename.ToString())); db.SANPHAMs.InsertOnSubmit(s); db.SubmitChanges(); //Insert kichthuoc List <string> kichthuoc = new List <string>(); if (c["size1"] != null) { kichthuoc.Add(c["size1"].ToString()); } if (c["size2"] != null) { kichthuoc.Add(c["size2"].ToString()); } if (c["size3"] != null) { kichthuoc.Add(c["size3"].ToString()); } if (c["size4"] != null) { kichthuoc.Add(c["size4"].ToString()); } foreach (string k in kichthuoc) { NEM_KICHTHUOC kt = new NEM_KICHTHUOC(); kt.MASANPHAM = c["MASANPHAM"].Trim(new Char[] { ' ', ',', '*', '.' }); kt.KICHTHUOC = k; db.NEM_KICHTHUOCs.InsertOnSubmit(kt); db.SubmitChanges(); } return(RedirectToAction("Index")); } return(View()); }
public ActionResult AddOrEdit(string masp, FormCollection c, HttpPostedFileBase fileupload) { /*if (fileupload != null) * { * if (masp == null) * { * SANPHAM s = new SANPHAM(); * //Insert sanpham * s.MASANPHAM = c["MASANPHAM"].Trim(new Char[] { ' ', ',', '*', '.' }); * s.TENSANPHAM = c["TENSANPHAM"]; * s.MALOAI = c["MALOAI"]; * s.MATHUONGHIEU = c["THUONGHIEU"]; * s.GIAGOC = double.Parse(c["GIAGOC"]); * string now = DateTime.Now.ToShortDateString(); * s.NGAYTAO = Convert.ToDateTime(now); * s.MOI = Convert.ToInt16(c["MOI"]); * s.GIAM = double.Parse(c["GIAM"]); * string filename = Path.GetFileNameWithoutExtension(fileupload.FileName); * string extension = Path.GetExtension(fileupload.FileName); * filename = filename + extension; * s.HINHMINHHOA = filename; * fileupload.SaveAs(Server.MapPath("~/Content/img/products/" + filename.ToString())); * db.SANPHAMs.InsertOnSubmit(s); * db.SubmitChanges(); * //Insert kichthuoc * List<string> kichthuoc = new List<string>(); * if (c["size1"] != null) * { * kichthuoc.Add(c["size1"].ToString()); * } * if (c["size2"] != null) * { * kichthuoc.Add(c["size2"].ToString()); * } * if (c["size3"] != null) * { * kichthuoc.Add(c["size3"].ToString()); * } * if (c["size4"] != null) * { * kichthuoc.Add(c["size4"].ToString()); * } * foreach (string k in kichthuoc) * { * NEM_KICHTHUOC kt = new NEM_KICHTHUOC(); * kt.MASANPHAM = c["MASANPHAM"].Trim(new Char[] { ' ', ',', '*', '.' }); * kt.KICHTHUOC = k; * db.NEM_KICHTHUOCs.InsertOnSubmit(kt); * db.SubmitChanges(); * } * } * else * { * string ma = masp.Trim(new Char[] { ' ', ',', '*', '.' }); * SANPHAM sp = db.SANPHAMs.Where(sq=>sq.MASANPHAM == ma).SingleOrDefault(); * sp.TENSANPHAM = c["TENSANPHAM"]; * db.SubmitChanges(); * } * } * else { * if (masp != null) { * string ma = masp.Trim(new Char[] { ' ', ',', '*', '.' }); * SANPHAM ssp = db.SANPHAMs.Where(sw => sw.MASANPHAM == ma).SingleOrDefault(); * ssp.TENSANPHAM = c["TENSANPHAM"]; * ssp.MALOAI = c["MALOAI"]; * ssp.MATHUONGHIEU = c["THUONGHIEU"]; * ssp.GIAGOC = double.Parse(c["GIAGOC"]); * string now = DateTime.Now.ToShortDateString(); * ssp.NGAYTAO = Convert.ToDateTime(now); * ssp.MOI = Convert.ToInt16(c["MOI"]); * ssp.GIAM = double.Parse(c["GIAM"]); * db.SubmitChanges(); * * } * } * * return RedirectToAction("Product", "Admin", new { success = true, message = "Success" }); * */ if (masp != null) { string ma = masp.Trim(new Char[] { ' ', ',', '*', '.' }); SANPHAM ssp = db.SANPHAMs.Where(sw => sw.MASANPHAM == ma).SingleOrDefault(); ssp.TENSANPHAM = c["TENSANPHAM"]; db.SubmitChanges(); } else { SANPHAM s = new SANPHAM(); //Insert sanpham s.MASANPHAM = c["MASANPHAM"].Trim(new Char[] { ' ', ',', '*', '.' }); s.TENSANPHAM = c["TENSANPHAM"]; s.MALOAI = c["MALOAI"]; s.MATHUONGHIEU = c["THUONGHIEU"]; s.GIAGOC = double.Parse(c["GIAGOC"]); string now = DateTime.Now.ToShortDateString(); s.NGAYTAO = Convert.ToDateTime(now); s.MOI = Convert.ToInt16(c["MOI"]); s.GIAM = double.Parse(c["GIAM"]); string filename = Path.GetFileNameWithoutExtension(fileupload.FileName); string extension = Path.GetExtension(fileupload.FileName); filename = filename + extension; s.HINHMINHHOA = filename; fileupload.SaveAs(Server.MapPath("~/Content/img/products/" + filename.ToString())); db.SANPHAMs.InsertOnSubmit(s); db.SubmitChanges(); //Insert kichthuoc List <string> kichthuoc = new List <string>(); if (c["size1"] != null) { kichthuoc.Add(c["size1"].ToString()); } if (c["size2"] != null) { kichthuoc.Add(c["size2"].ToString()); } if (c["size3"] != null) { kichthuoc.Add(c["size3"].ToString()); } if (c["size4"] != null) { kichthuoc.Add(c["size4"].ToString()); } foreach (string k in kichthuoc) { NEM_KICHTHUOC kt = new NEM_KICHTHUOC(); kt.MASANPHAM = c["MASANPHAM"].Trim(new Char[] { ' ', ',', '*', '.' }); kt.KICHTHUOC = k; db.NEM_KICHTHUOCs.InsertOnSubmit(kt); db.SubmitChanges(); } } return(RedirectToAction("Product", "Admin")); }