public IHttpActionResult GetNhanVienById(int id)
{
NhanVienViewModel nhanvien = null;
using (var ctx = new BANHANGONLINEEntities5())
{
nhanvien = ctx.NHANVIENs.Where(s => s.MANV == id)
.Select(s => new NhanVienViewModel()
{
MANV = s.MANV,
HOTEN = s.HOTEN,
NGAYSINH = s.NGAYSINH,
GIOITINH = s.GIOITINH,
DIENTHOAI = s.DIENTHOAI,
MAIL = s.MAIL,
DIACHI = s.DIACHI,
NGAYLAM = s.NGAYLAM,
LUONG = s.LUONG,
USERNAMES = s.USERNAMES,
PASSWORDS = s.PASSWORDS,
TRANGTHAI = s.TRANGTHAI
}).FirstOrDefault <NhanVienViewModel>();
}
if (nhanvien == null)
{
return(NotFound());
}
return(Ok(nhanvien));
}
public IHttpActionResult GetAllSanPham()
{
IList <SanPhamViewModel> sanpham = null;
using (var ctx = new BANHANGONLINEEntities5())
{
sanpham = ctx.SANPHAMs.Select(s => new SanPhamViewModel()
{
MASP = s.MASP,
TENSP = s.TENSP,
CHITIET = s.CHITIET,
IMAGES = s.IMAGES,
TRANGTHAI = s.TRANGTHAI,
GIA = s.GIA,
GIAMGIA = s.GIAMGIA,
SL = s.SL,
MASX = s.MASX,
MALOAI = s.MALOAI
}).ToList <SanPhamViewModel>();
}
if (sanpham.Count == 0)
{
return(NotFound());
}
return(Ok(sanpham));
}
public IHttpActionResult GetPhieuXuatById(int id)
{
PhieuXuatViewModel phieuxuat = null;
using (var ctx = new BANHANGONLINEEntities5())
{
phieuxuat = ctx.PHIEUXUATs.Where(s => s.MAPX == id)
.Select(s => new PhieuXuatViewModel()
{
MAPX = s.MAPX,
MAKH = s.MAKH,
MASP = s.MASP,
MANV = s.MANV,
MADH = s.MADH,
SLX = s.SLX,
THANHTIEN = s.THANHTIEN,
NGAYXUAT = s.NGAYXUAT
}).FirstOrDefault <PhieuXuatViewModel>();
}
if (phieuxuat == null)
{
return(NotFound());
}
return(Ok(phieuxuat));
}
public IHttpActionResult GetAllKhachHang()
{
IList <KhachHangViewModel> khachhang = null;
using (var ctx = new BANHANGONLINEEntities5())
{
khachhang = ctx.KHACHHANGs.Select(s => new KhachHangViewModel()
{
MAKH = s.MAKH,
HOTEN = s.HOTEN,
NGAYSINH = s.NGAYSINH,
GIOITINH = s.GIOITINH,
DIENTHOAI = s.DIENTHOAI,
MAIL = s.MAIL,
DIACHI = s.DIACHI,
NGAYDK = s.NGAYDK
}).ToList <KhachHangViewModel>();
}
if (khachhang.Count == 0)
{
return(NotFound());
}
return(Ok(khachhang));
}
public IHttpActionResult GetAllPhieuXuat()
{
IList <PhieuXuatViewModel> phieuxuat = null;
using (var ctx = new BANHANGONLINEEntities5())
{
phieuxuat = ctx.PHIEUXUATs.Select(s => new PhieuXuatViewModel()
{
MAPX = s.MAPX,
MAKH = s.MAKH,
MASP = s.MASP,
MANV = s.MANV,
MADH = s.MADH,
SLX = s.SLX,
THANHTIEN = s.THANHTIEN,
NGAYXUAT = s.NGAYXUAT
}).ToList <PhieuXuatViewModel>();
}
if (phieuxuat.Count == 0)
{
return(NotFound());
}
return(Ok(phieuxuat));
}
public IHttpActionResult GetKhachHangById(int id)
{
KhachHangViewModel khachhang = null;
using (var ctx = new BANHANGONLINEEntities5())
{
khachhang = ctx.KHACHHANGs.Where(s => s.MAKH == id)
.Select(s => new KhachHangViewModel()
{
MAKH = s.MAKH,
HOTEN = s.HOTEN,
NGAYSINH = s.NGAYSINH,
GIOITINH = s.GIOITINH,
DIENTHOAI = s.DIENTHOAI,
MAIL = s.MAIL,
DIACHI = s.DIACHI,
NGAYDK = s.NGAYDK
}).FirstOrDefault <KhachHangViewModel>();
}
if (khachhang == null)
{
return(NotFound());
}
return(Ok(khachhang));
}
// 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());
}
public IHttpActionResult GetAllDonDatHang()
{
IList <DonDatHangViewModel> dondh = null;
using (var ctx = new BANHANGONLINEEntities5())
{
dondh = ctx.DONDHs.Select(s => new DonDatHangViewModel()
{
MADH = s.MADH,
MASP = s.MASP,
MAKH = s.MAKH,
MANV = s.MANV,
SLD = s.SLD,
THANHTIEN = s.THANHTIEN,
NGAYDH = s.NGAYDH
}).ToList <DonDatHangViewModel>();
}
if (dondh.Count == 0)
{
return(NotFound());
}
return(Ok(dondh));
}
public IHttpActionResult GetDonDatHangById(int id)
{
DonDatHangViewModel dondh = null;
using (var ctx = new BANHANGONLINEEntities5())
{
dondh = ctx.DONDHs.Where(s => s.MADH == id)
.Select(s => new DonDatHangViewModel()
{
MADH = s.MADH,
MASP = s.MASP,
MAKH = s.MAKH,
MANV = s.MANV,
SLD = s.SLD,
THANHTIEN = s.THANHTIEN,
NGAYDH = s.NGAYDH
}).FirstOrDefault <DonDatHangViewModel>();
}
if (dondh == null)
{
return(NotFound());
}
return(Ok(dondh));
}
public IHttpActionResult GetSanPhamById(int id)
{
SanPhamViewModel sanpham = null;
using (var ctx = new BANHANGONLINEEntities5())
{
sanpham = ctx.SANPHAMs.Where(s => s.MASP == id)
.Select(s => new SanPhamViewModel()
{
MASP = s.MASP,
TENSP = s.TENSP,
CHITIET = s.CHITIET,
IMAGES = s.IMAGES,
TRANGTHAI = s.TRANGTHAI,
GIA = s.GIA,
GIAMGIA = s.GIAMGIA,
SL = s.SL,
MASX = s.MASX,
MALOAI = s.MALOAI
}).FirstOrDefault <SanPhamViewModel>();
}
if (sanpham == null)
{
return(NotFound());
}
return(Ok(sanpham));
}
// GET:
public IHttpActionResult GetAllNhanVien()
{
IList <NhanVienViewModel> nhanvien = null;
using (var ctx = new BANHANGONLINEEntities5())
{
nhanvien = ctx.NHANVIENs.Select(s => new NhanVienViewModel()
{
MANV = s.MANV,
HOTEN = s.HOTEN,
NGAYSINH = s.NGAYSINH,
GIOITINH = s.GIOITINH,
DIENTHOAI = s.DIENTHOAI,
MAIL = s.MAIL,
DIACHI = s.DIACHI,
NGAYLAM = s.NGAYLAM,
LUONG = s.LUONG,
USERNAMES = s.USERNAMES,
PASSWORDS = s.PASSWORDS,
TRANGTHAI = s.TRANGTHAI
}).ToList <NhanVienViewModel>();
}
if (nhanvien.Count == 0)
{
return(NotFound());
}
return(Ok(nhanvien));
}
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());
}
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());
}
//
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());
}
// 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());
}
// 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());
}
//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());
}
public IHttpActionResult GetAllNhaSanXuat()
{
IList <NhaSanXuatViewModel> nhasx = null;
using (var ctx = new BANHANGONLINEEntities5())
{
nhasx = ctx.NHASANXUATs.Select(s => new NhaSanXuatViewModel()
{
MASX = s.MASX,
TENSX = s.TENSX,
QUOCGIA = s.QUOCGIA
}).ToList <NhaSanXuatViewModel>();
}
if (nhasx.Count == 0)
{
return(NotFound());
}
return(Ok(nhasx));
}
public IHttpActionResult GetAllLoaiSanPham()
{
IList <LoaiSanPhamViewModel> loaisp = null;
using (var ctx = new BANHANGONLINEEntities5())
{
loaisp = ctx.LOAISPs.Select(s => new LoaiSanPhamViewModel()
{
MALOAI = s.MALOAI,
TENLOAI = s.TENLOAI,
DVT = s.DVT
}).ToList <LoaiSanPhamViewModel>();
}
if (loaisp.Count == 0)
{
return(NotFound());
}
return(Ok(loaisp));
}
// 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());
}
public IHttpActionResult GetNhaSanXuatById(int id)
{
NhaSanXuatViewModel nhasx = null;
using (var ctx = new BANHANGONLINEEntities5())
{
nhasx = ctx.NHASANXUATs.Where(s => s.MASX == id)
.Select(s => new NhaSanXuatViewModel()
{
MASX = s.MASX,
TENSX = s.TENSX,
QUOCGIA = s.QUOCGIA
}).FirstOrDefault <NhaSanXuatViewModel>();
}
if (nhasx == null)
{
return(NotFound());
}
return(Ok(nhasx));
}
public IHttpActionResult GetLoaiSanPhamById(int id)
{
LoaiSanPhamViewModel loaisp = null;
using (var ctx = new BANHANGONLINEEntities5())
{
loaisp = ctx.LOAISPs.Where(s => s.MALOAI == id)
.Select(s => new LoaiSanPhamViewModel()
{
MALOAI = s.MALOAI,
TENLOAI = s.TENLOAI,
DVT = s.DVT
}).FirstOrDefault <LoaiSanPhamViewModel>();
}
if (loaisp == null)
{
return(NotFound());
}
return(Ok(loaisp));
}
// 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
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:
// 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 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());
}
// 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());
}
