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"));
}
