// PUT
public IHttpActionResult PutKhachHang(KhachHangViewModel khachhang)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data"));
}
using (var ctx = new BANHANGONLINEEntities5())
{
var existingKhachHang = ctx.KHACHHANGs.Where(s => s.MAKH == khachhang.MAKH).FirstOrDefault <KHACHHANG>();
if (existingKhachHang != null)
{
ctx.sp_SuaKhachHang(khachhang.HOTEN, khachhang.NGAYSINH, khachhang.GIOITINH, khachhang.DIENTHOAI, khachhang.MAIL, khachhang.DIACHI, khachhang.NGAYDK, khachhang.MAKH);
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
// POST:
public IHttpActionResult PostNewDonDatHang(DonDatHangViewModel dondh)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invaild data"));
}
using (var ctx = new BANHANGONLINEEntities5())
{
ctx.sp_ThemDonDatHang(dondh.MASP, dondh.MAKH, dondh.MANV, dondh.SLD, dondh.THANHTIEN, dondh.NGAYDH);
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult PostNewNhaSanXuat(NhaSanXuatViewModel nhasx)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invaild data"));
}
using (var ctx = new BANHANGONLINEEntities5())
{
ctx.sp_ThemNhaSanXuat(nhasx.TENSX, nhasx.QUOCGIA);
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult PostNewPhieuXuat(PhieuXuatViewModel phieuxuat)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data"));
}
using (var ctx = new BANHANGONLINEEntities5())
{
ctx.sp_ThemPhieuXuat(phieuxuat.MAKH, phieuxuat.MASP, phieuxuat.MANV, phieuxuat.MADH, phieuxuat.SLX, phieuxuat.THANHTIEN, phieuxuat.NGAYXUAT);
ctx.SaveChanges();
}
return(Ok());
}
// POST
public IHttpActionResult PostNewKhachHang(KhachHangViewModel khachhang)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invaild data"));
}
using (var ctx = new BANHANGONLINEEntities5())
{
ctx.sp_ThemKhachHang(khachhang.HOTEN, khachhang.NGAYSINH, khachhang.GIOITINH, khachhang.DIENTHOAI, khachhang.MAIL, khachhang.DIACHI, khachhang.NGAYDK);
ctx.SaveChanges();
}
return(Ok());
}
//
public IHttpActionResult PostNewSanPham(SanPhamViewModel sanpham)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data"));
}
using (var ctx = new BANHANGONLINEEntities5())
{
ctx.sp_ThemSanPham(sanpham.TENSP, sanpham.GIA, sanpham.CHITIET, sanpham.IMAGES, sanpham.TRANGTHAI, sanpham.GIAMGIA, sanpham.SL, sanpham.MASX, sanpham.MALOAI);
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult PostNewLoaiSanPham(LoaiSanPhamViewModel loaisp)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invaild data"));
}
using (var ctx = new BANHANGONLINEEntities5())
{
ctx.sp_ThemLoaiSanPham(loaisp.TENLOAI, loaisp.DVT);
ctx.SaveChanges();
}
return(Ok());
}
//POST
public IHttpActionResult PostNewNhanVien(NhanVienViewModel nhanvien)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invaild data"));
}
using (var ctx = new BANHANGONLINEEntities5())
{
ctx.sp_ThemNhanVien(nhanvien.HOTEN, nhanvien.NGAYLAM, nhanvien.GIOITINH, nhanvien.DIENTHOAI, nhanvien.MAIL, nhanvien.DIACHI, nhanvien.NGAYLAM, nhanvien.LUONG, nhanvien.USERNAMES, nhanvien.PASSWORDS, nhanvien.TRANGTHAI);
ctx.SaveChanges();
}
return(Ok());
}
// PUT:
public IHttpActionResult PutDonDatHang(DonDatHangViewModel dondh)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data"));
}
using (var ctx = new BANHANGONLINEEntities5())
{
var existingDonDatHang = ctx.DONDHs.Where(s => s.MADH == dondh.MADH).FirstOrDefault <DONDH>();
if (existingDonDatHang != null)
{
ctx.sp_SuaDonDathang(dondh.MASP, dondh.MAKH, dondh.MANV, dondh.SLD, dondh.THANHTIEN, dondh.NGAYDH, dondh.MADH);
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
// PUT
public IHttpActionResult PutNhaSanXuat(NhaSanXuatViewModel nhasx)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invaild data"));
}
using (var ctx = new BANHANGONLINEEntities5())
{
var exitstingNhaSx = ctx.NHASANXUATs.Where(s => s.MASX == nhasx.MASX).FirstOrDefault <NHASANXUAT>();
if (exitstingNhaSx != null)
{
ctx.sp_SuaNhaSanXuat(nhasx.TENSX, nhasx.QUOCGIA, nhasx.MASX);
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
// PUT:
// PUT
public IHttpActionResult PutSaanPham(SanPhamViewModel sanpham)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data"));
}
using (var ctx = new BANHANGONLINEEntities5())
{
var existingSanPham = ctx.SANPHAMs.Where(s => s.MASP == sanpham.MASP).FirstOrDefault <SANPHAM>();
if (existingSanPham != null)
{
ctx.sp_SuaSanPham(sanpham.TENSP, sanpham.GIA, sanpham.CHITIET, sanpham.IMAGES, sanpham.TRANGTHAI, sanpham.GIAMGIA, sanpham.SL, sanpham.MALOAI, sanpham.MASP);
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
// PUT
public IHttpActionResult PutLoaiSanPham(LoaiSanPhamViewModel loaisp)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data"));
}
using (var ctx = new BANHANGONLINEEntities5())
{
var existingLoaiSanPham = ctx.LOAISPs.Where(s => s.MALOAI == loaisp.MALOAI).FirstOrDefault <LOAISP>();
if (existingLoaiSanPham != null)
{
ctx.sp_SuaLoaiSanPham(loaisp.TENLOAI, loaisp.DVT, loaisp.MALOAI);
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
// PUT:
public IHttpActionResult PutPhieuXuat(PhieuXuatViewModel phieuxuat)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data"));
}
using (var ctx = new BANHANGONLINEEntities5())
{
var existingPhieuXuat = ctx.PHIEUXUATs.Where(s => s.MAPX == phieuxuat.MAPX).FirstOrDefault <PHIEUXUAT>();
if (existingPhieuXuat != null)
{
ctx.sp_SuaPhieuXuat(phieuxuat.MASP, phieuxuat.MAKH, phieuxuat.MANV, phieuxuat.MADH, phieuxuat.SLX, phieuxuat.THANHTIEN, phieuxuat.NGAYXUAT, phieuxuat.MAPX);
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
// PUT
public IHttpActionResult PutNhanVien(NhanVienViewModel nhanvien)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invaild data"));
}
using (var ctx = new BANHANGONLINEEntities5())
{
var exitstingNhanvien = ctx.NHANVIENs.Where(sv => sv.MANV == nhanvien.MANV).FirstOrDefault <NHANVIEN>();
if (exitstingNhanvien != null)
{
ctx.sp_SuaNhanVien(nhanvien.HOTEN, nhanvien.NGAYSINH, nhanvien.GIOITINH, nhanvien.DIENTHOAI, nhanvien.MAIL, nhanvien.DIACHI, nhanvien.NGAYLAM, nhanvien.LUONG, nhanvien.USERNAMES, nhanvien.PASSWORDS, nhanvien.TRANGTHAI, nhanvien.MANV);
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
