public async Task <IActionResult> ThemPhienBan([Bind("ID,IDSP,MaPhienBan,TenPhienBan,MauSac,DungLuong,KichThuoc,ManHinh,GiaNhap,GiaXuat,DinhMucToiThieu,DinhMucToiDa,ThoiGianDoiTra")] tb_WMS_SanPhamPhienBan tb_WMS_SanPhamPhienBan)
{
if (ModelState.IsValid)
{
var idend = (from u in _context.tb_WMS_SanPhamPhienBan
orderby u.ID descending
select u.ID).Take(1).FirstOrDefault();
tb_WMS_SanPhamPhienBan.ID = idend + 1;
var SP = (from N in _context.tb_WMS_SanPham
where N.ID == tb_WMS_SanPhamPhienBan.IDSP
select N).FirstOrDefault();
var MSP = SP.MaSanPham;
tb_WMS_SanPhamPhienBan.MaPhienBan = MSP + "_S" + (idend + 1);
var TSP = SP.TenSanPham;
tb_WMS_SanPhamPhienBan.TenPhienBan = TSP + " " + tb_WMS_SanPhamPhienBan.MauSac + " " + tb_WMS_SanPhamPhienBan.DungLuong;
_context.Add(tb_WMS_SanPhamPhienBan);
TempData["success"] = "success";
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(PhienBan)));
}
ViewData["IDSP"] = new SelectList(_context.tb_WMS_SanPham, "ID", "ID", tb_WMS_SanPhamPhienBan.IDSP);
return(View(tb_WMS_SanPhamPhienBan));
}
public async Task <IActionResult> ThemPhienBan([Bind("ID,IDSP,MaPhienBan,TenPhienBan,MauSac,DungLuong,KichThuoc,ManHinh,GiaNhap,GiaXuat,DinhMucToiThieu,DinhMucToiDa,ThoiGianDoiTra,HinhAnh")] tb_WMS_SanPhamPhienBan tb_WMS_SanPhamPhienBan, IFormFile file)
{
if (ModelState.IsValid)
{
var idend = (from u in _context.tb_WMS_SanPhamPhienBan
orderby u.ID descending
select u.ID).Take(1).FirstOrDefault();
tb_WMS_SanPhamPhienBan.ID = idend + 1;
var SP = (from N in _context.tb_WMS_SanPham
where N.ID == tb_WMS_SanPhamPhienBan.IDSP
select N).FirstOrDefault();
var MSP = SP.MaSanPham;
tb_WMS_SanPhamPhienBan.MaPhienBan = MSP + "_S" + (idend + 1);
var TSP = SP.TenSanPham;
tb_WMS_SanPhamPhienBan.TenPhienBan = TSP + " " + tb_WMS_SanPhamPhienBan.MauSac + " " + tb_WMS_SanPhamPhienBan.DungLuong;
_context.Add(tb_WMS_SanPhamPhienBan);
TempData["success"] = "success";
await _context.SaveChangesAsync();
if (file != null || file.Length != 0)
{
FileInfo fi = new FileInfo(file.FileName);
var newFilename = tb_WMS_SanPhamPhienBan.IDSP + "_" + String.Format("{0:d}", (DateTime.Now.Ticks / 10) % 100000000) + fi.Extension;
var webPath = hostingEnvironment.WebRootPath;
var path = Path.Combine("", webPath + @"\ImageFiles\" + newFilename);
var pathToSave = @"/ImageFiles/" + newFilename;
using (var stream = new FileStream(path, FileMode.Create))
{
await file.CopyToAsync(stream);
}
tb_WMS_SanPhamPhienBan.HinhAnh = pathToSave;
_context.Update(tb_WMS_SanPhamPhienBan);
await _context.SaveChangesAsync();
}
return(RedirectToAction(nameof(PhienBan)));
}
ViewData["IDSP"] = new SelectList(_context.tb_WMS_SanPham, "ID", "ID", tb_WMS_SanPhamPhienBan.IDSP);
return(View(tb_WMS_SanPhamPhienBan));
}
public async Task <IActionResult> SuaPhienBan(int id, [Bind("ID,IDSP,MaPhienBan,TenPhienBan,MauSac,DungLuong,KichThuoc,ManHinh,GiaNhap,GiaXuat,DinhMucToiThieu,DinhMucToiDa,ThoiGianDoiTra")] tb_WMS_SanPhamPhienBan tb_WMS_SanPhamPhienBan)
{
if (id != tb_WMS_SanPhamPhienBan.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
var SP = (from N in _context.tb_WMS_SanPham
where N.ID == tb_WMS_SanPhamPhienBan.IDSP
select N).FirstOrDefault();
var TSP = SP.TenSanPham;
tb_WMS_SanPhamPhienBan.TenPhienBan = TSP + " " + tb_WMS_SanPhamPhienBan.MauSac + " " + tb_WMS_SanPhamPhienBan.DungLuong;
_context.Update(tb_WMS_SanPhamPhienBan);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!tb_WMS_SanPhamPhienBanExists(tb_WMS_SanPhamPhienBan.ID))
{
return(NotFound());
}
else
{
throw;
}
}
TempData["success"] = "success";
return(RedirectToAction(nameof(PhienBan)));
}
ViewData["IDSP"] = new SelectList(_context.tb_WMS_SanPham, "ID", "ID", tb_WMS_SanPhamPhienBan.IDSP);
return(View(tb_WMS_SanPhamPhienBan));
}
