public IActionResult updatSP(int id, [FromBody] SanPham sp)
{
if (sp.MaSP != id)
{
return(BadRequest("không phù hợp"));
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
using (var db = new CarShopDbContext())
{
db.Entry(sp).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException duxEx)
{
bool exists = db.SanPhams.Count(x => x.MaSP == id) > 0;
if (!exists)
{
return(NotFound());
}
else
{
throw duxEx;
}
}
return(Ok(sp));
}
}
public UsersService(
CarShopDbContext db,
IPasswordHasher passwordHasher)
{
this.db = db;
this.passwordHasher = passwordHasher;
}
public ShoppingCartController(
IShoppingCartManager shoppingCartManager,
CarShopDbContext db,
UserManager <User> userManager)
{
this.shoppingCartManager = shoppingCartManager;
this.db = db;
this.userManager = userManager;
}
public IssuesController(
IUserService users,
IValidator validator,
CarShopDbContext data)
{
this.users = users;
this.validator = validator;
this.data = data;
}
public CarsController(
IValidator validator,
IUserService userService,
CarShopDbContext data)
{
this.validator = validator;
this.userService = userService;
this.data = data;
}
public UsersController(
IValidator validator,
IPasswordHasher passwordHasher,
CarShopDbContext data)
{
this.validator = validator;
this.passwordHasher = passwordHasher;
this.data = data;
}
public IActionResult listLoaiSP()
{
using (var db = new CarShopDbContext())
{
List <LoaiSP> dsloai = db.LoaiSPs.ToList();
if (dsloai == null)
{
return(null);
}
return(Ok(dsloai));
}
}
public IActionResult listLoaiSP()
{
using (var db = new CarShopDbContext())
{
List <NhaCC> dsNCC = db.NhaCCs.ToList();
if (dsNCC == null)
{
return(null);
}
return(Ok(dsNCC));
}
}
public IActionResult XoaSP(int id)
{
using (var db = new CarShopDbContext())
{
SanPham sp = db.SanPhams.SingleOrDefault(x => x.MaSP == id);
if (sp == null)
{
return(null);
}
db.SanPhams.Remove(sp);
db.SaveChanges();
return(Ok(sp));
}
}
public IActionResult SuaSP(int id)
{
using (var db = new CarShopDbContext())
{
SanPham sp = db.SanPhams.SingleOrDefault(x => x.MaSP == id);
if (sp == null)
{
return(null);
}
NhaCC ncc = db.NhaCCs.SingleOrDefault(x => x.MaNCC == sp.MaNCC);
LoaiSP lsp = db.LoaiSPs.SingleOrDefault(x => x.MaLoaiSP == sp.MaLoaiSP);
sp.LoaiSP = lsp;
sp.NhaCC = ncc;
return(Ok(sp));
}
}
public IActionResult dsSP()
{
using (var db = new CarShopDbContext())
{
List <SanPham> lstSanPham = db.SanPhams.ToList();
if (lstSanPham == null)
{
return(null);
}
lstSanPham.ForEach(sp =>
{
NhaCC ncc = db.NhaCCs.SingleOrDefault(x => x.MaNCC == sp.MaNCC);
LoaiSP lsp = db.LoaiSPs.SingleOrDefault(x => x.MaLoaiSP == sp.MaLoaiSP);
sp.NhaCC = ncc;
sp.LoaiSP = lsp;
});
return(Ok(lstSanPham));
}
}
public IActionResult timKiem(string tensp)
{
using (var db = new CarShopDbContext())
{
List <SanPham> lstsp = db.SanPhams.Where(x => x.TenSP.Contains(tensp)).ToList();
lstsp.ForEach(sp =>
{
NhaCC ncc = db.NhaCCs.SingleOrDefault(x => x.MaNCC == sp.MaNCC);
LoaiSP lsp = db.LoaiSPs.SingleOrDefault(x => x.MaLoaiSP == sp.MaLoaiSP);
sp.NhaCC = ncc;
sp.LoaiSP = lsp;
});
if (lstsp == null)
{
return(null);
}
return(Ok(lstsp));
}
}
public IActionResult ThemSP([FromBody] SanPham sp)
{
using (var db = new CarShopDbContext())
{
if (sp == null)
{
return(null);
}
if (sp.MaSP != 0)
{
sp.MaSP = 0;
}
sp.LoaiSP = null;
sp.NhaCC = null;
db.SanPhams.Add(sp);
db.SaveChanges();
return(Ok(sp));
}
}
public UserService(CarShopDbContext data) => this.data = data;
public IssueService(CarShopDbContext db)
{
this.db = db;
}
public SaleRepo(CarShopDbContext carShopDbContext)
{
this._carShopDbContext = carShopDbContext;
}
public BrandService(CarShopDbContext db)
{
this.db = db;
}
public UserService(CarShopDbContext data, IPasswordHasher passwordHasher)
{
this.data = data;
this.passwordHasher = passwordHasher;
}
public ExtraService(CarShopDbContext db)
{
this.db = db;
}
public DealerService(CarShopDbContext db)
{
this.db = db;
}
public CarRepository(CarShopDbContext context)
{
_context = context ?? throw new ArgumentNullException(nameof(context));
}
public UserService(CarShopDbContext db, IPasswordService passwordService)
{
this.db = db;
this.passwordService = passwordService;
}
private readonly CarShopDbContext carShopDbContext;//DI
public DatabaseCarRepo(CarShopDbContext carShopDbContext)
{
this.carShopDbContext = carShopDbContext;
}
public InsuranceRepo(CarShopDbContext carShopDbContext)
{
_carShopDbContext = carShopDbContext;
}
public IssuesController(IUserService userService, CarShopDbContext data)
{
this.userService = userService;
this.data = data;
}
public CarsService(CarShopDbContext db)
{
this.db = db;
}
public Validator(CarShopDbContext db)
{
this.db = db;
}
public CarController(CarShopDbContext context)
{
_context = context;
}
public CarService(CarShopDbContext data, IUserService userService)
{
this.data = data;
this.userService = userService;
}
public CarBrandRepo(CarShopDbContext carShopDbContext)
{
this._carShopDbContext = carShopDbContext;
}
