public List <LinhKiens> DeleteLinhKien(Users admin, LinhKiens lk)
{
if (admin.chucNang == "admin")
{
model.LinhKiens.Remove(GetLinhKien(lk.MaLinhKien));
model.SaveChanges();
}
return(GetListLinhKien());
}
public List <LinhKiens> GetListLinhKiensBanChay()
{
List <LinhKiens> list = new List <LinhKiens>();
DataTable data = DataProvider.Instance.ExecuteQuery("select LinhKien.maLinhKien,maLoaiLinhKien,maNhaCungCap,maLoaiMay,tenLinhKien,thongSoKyThuat,moTa,giaBan,thoiGianBaoHanh from LinhKien, (select top(8) count(PhieuXuat.maPhieuXuat) as stt, ChiTietPhieuXuat.maLinhKien from ChiTietPhieuXuat, LinhKien,PhieuXuat where ChiTietPhieuXuat.maLinhKien = LinhKien.maLinhKien and PhieuXuat.maPhieuXuat=ChiTietPhieuXuat.maPhieuXuat group by ChiTietPhieuXuat.maLinhKien order by count(ChiTietPhieuXuat.maPhieuXuat) desc) as s where LinhKien.maLinhKien = s.maLinhKien");
foreach (DataRow item in data.Rows)
{
LinhKiens obj = new LinhKiens(item);
list.Add(obj);
}
return(list);
}
public List <LinhKiens> GetListLinhKiens()
{
List <LinhKiens> list = new List <LinhKiens>();
DataTable data = DataProvider.Instance.ExecuteQuery("SELECT * FROM LinhKien");
foreach (DataRow item in data.Rows)
{
LinhKiens obj = new LinhKiens(item);
list.Add(obj);
}
return(list);
}
public List <LinhKiens> EditLinhKien(Users admin, LinhKiens lk)
{
if (admin.chucNang == "admin")
{
var linhKien = GetLinhKien(lk.MaLinhKien);
linhKien.maLoaiLinhKien = lk.MaLoaiLinhKien;
linhKien.maNhaCungCap = lk.MaNhaCungCap;
linhKien.maLoaiMay = lk.MaLoaiMay;
linhKien.tenLinhKien = lk.TenLinhKien;
linhKien.thongSoKyThuat = lk.ThongSoKyThuat;
linhKien.thoiGianBaoHanh = lk.ThoiGianBaoHanh;
linhKien.moTa = lk.MoTa;
linhKien.giaBan = lk.GiaBan;
model.SaveChanges();
}
return(GetListLinhKien());
}
public IHttpActionResult Delete([FromBody] Users x, LinhKiens lk)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid model"));
}
var listUser = db.DeleteLinhKien(x, lk);
if (listUser.Count == 0)
{
return(NotFound());
}
return(Ok(listUser));
}
catch (Exception e)
{
return(BadRequest(e.ToString()));
}
}
