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