public async Task <ActionResult> Create([Bind(Include = "ID,TEN,GIA,MOTA,RANKID,USERNAME,PASSWORD")] LOLACC lolacc, IEnumerable <HttpPostedFileBase> ANHTUONG, IEnumerable <HttpPostedFileBase> ANHSKIN)
{
if (ModelState.IsValid)
{
lolacc.ID = Guid.NewGuid().ToString();
#region Xử lý add ảnh
if (ANHSKIN != null)
{
List <string> lstFilePath = new List <string>();
foreach (var file in ANHSKIN)
{
// Some browsers send file names with full path. This needs to be stripped.
var fileName = Path.GetFileName(file.FileName);
fileName = Guid.NewGuid().ToString() + file.FileName;
var physicalPath = Path.Combine(Server.MapPath("~/Upload"), fileName);
// The files are not actually saved in this demo
file.SaveAs(physicalPath);
lstFilePath.Add("~/Upload/" + fileName);
//Add vào db
ANH img = new ANH();
img.ID = Guid.NewGuid().ToString();
img.ACCID = lolacc.ID;
img.LINK = "Upload/" + fileName;
img.LOAI = 2;
db.ANHs.Add(img);
}
}
if (ANHTUONG != null)
{
List <string> lstFilePath = new List <string>();
foreach (var file in ANHTUONG)
{
// Some browsers send file names with full path. This needs to be stripped.
var fileName = Path.GetFileName(file.FileName);
fileName = Guid.NewGuid().ToString() + file.FileName;
var physicalPath = Path.Combine(Server.MapPath("~/Upload"), fileName);
// The files are not actually saved in this demo
file.SaveAs(physicalPath);
lstFilePath.Add("~/Upload/" + fileName);
//Add vào db
ANH img = new ANH();
img.ID = Guid.NewGuid().ToString();
img.ACCID = lolacc.ID;
img.LINK = "~/Upload/" + fileName;
img.LOAI = 1;
db.ANHs.Add(img);
}
}
#endregion
db.LOLACCs.Add(lolacc);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.RANKID = new SelectList(db.RANKs, "ID", "TEN", lolacc.RANKID);
return(View(lolacc));
}
public ActionResult Edit(ANH model)
{
var obj = db.ANHs.Find(model.MaAnh);
obj.MaAnh = model.MaAnh;
obj.MaSanPham = model.MaSanPham;
obj.LinkAnh = model.LinkAnh;
db.SaveChanges();
return(RedirectToAction("AdminAnh", model));
}
public void ThemAnh(ANH AH)
{
kn.MoKetNoi();
SqlCommand cmd = new SqlCommand("ThemAnh", KetNoi.sqlCon); // gọi thủ tục trong csdl lên
cmd.CommandType = CommandType.StoredProcedure; //xác nhận kiểu store
cmd.Parameters.Add(new SqlParameter("@TenAnh", AH.TenAnh.Trim())); // tạo ra 1 biến có tên @manv và gtri nhận vào là manv
cmd.Parameters.Add(new SqlParameter("@Anh", AH.FileAnh.Trim()));
cmd.ExecuteNonQuery(); //truy vấn
kn.DongKetNoi(); //đóng kn lại
}
public void ThemAnh(ANH AH)
{
dal.ThemAnh(AH);
}
public async Task <ActionResult> Edit([Bind(Include = "ID,TEN,GIA,MOTA,RANKID,USERNAME,PASSWORD")] LOLACC lolacc, IEnumerable <HttpPostedFileBase> ANHTUONG, IEnumerable <HttpPostedFileBase> ANHSKIN)
{
if (ModelState.IsValid)
{
string SKINId = Request["SKINID"];
List <string> lstSKINID = SKINId.Split(',').ToList();
db.ACC_SKIN.RemoveRange(db.ACC_SKIN.Where(p => p.ACCID == lolacc.ID));
foreach (string item in lstSKINID)
{
ACC_SKIN obj = new ACC_SKIN();
obj.ID = Guid.NewGuid().ToString();
obj.ACCID = lolacc.ID;
obj.SKINID = item;
db.ACC_SKIN.Add(obj);
}
#region Xử lý add ảnh
if (ANHSKIN != null)
{
List <string> lstFilePath = new List <string>();
foreach (var file in ANHSKIN)
{
// Some browsers send file names with full path. This needs to be stripped.
var fileName = Path.GetFileName(file.FileName);
fileName = Guid.NewGuid().ToString() + file.FileName;
var physicalPath = Path.Combine(Server.MapPath("~/Upload"), fileName);
// The files are not actually saved in this demo
file.SaveAs(physicalPath);
lstFilePath.Add("~/Upload/" + fileName);
//Add vào db
ANH img = new ANH();
img.ID = Guid.NewGuid().ToString();
img.ACCID = lolacc.ID;
img.LINK = "Upload/" + fileName;
img.LOAI = 2;
db.ANHs.Add(img);
}
}
if (ANHTUONG != null)
{
List <string> lstFilePath = new List <string>();
foreach (var file in ANHTUONG)
{
// Some browsers send file names with full path. This needs to be stripped.
var fileName = Path.GetFileName(file.FileName);
fileName = Guid.NewGuid().ToString() + file.FileName;
var physicalPath = Path.Combine(Server.MapPath("~/Upload"), fileName);
// The files are not actually saved in this demo
file.SaveAs(physicalPath);
lstFilePath.Add("~/Upload/" + fileName);
//Add vào db
ANH img = new ANH();
img.ID = Guid.NewGuid().ToString();
img.ACCID = lolacc.ID;
img.LINK = "Upload/" + fileName;
img.LOAI = 1;
db.ANHs.Add(img);
}
}
#endregion
db.Entry(lolacc).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.RANKID = new SelectList(db.RANKs, "ID", "TEN", lolacc.RANKID);
return(View(lolacc));
}
public ActionResult Add(ANH model)
{
return(View());
}
