public IHttpActionResult GetAllKhachHang()
{
IList <KhachHangViewModel> khachhang = null;
using (var ctx = new QLBANHANGEntities())
{
khachhang = ctx.KHACHHANGs.Select(s => new KhachHangViewModel()
{
MAKH = s.MAKH,
TENKH = s.TENKH,
NGAYSINH = s.NGAYSINH,
GT = s.GT,
SDT = s.SDT,
MAIL = s.MAIL,
DIACHI = s.DIACHI,
NGAYDK = s.NGAYDK
}).ToList <KhachHangViewModel>();
}
if (khachhang.Count == 0)
{
return(NotFound());
}
return(Ok(khachhang));
}
public IHttpActionResult PostNewNhanVien(NhanVienViewModel nhanvien)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invaild data"));
}
using (var ctx = new QLBANHANGEntities())
{
//ctx.NHANVIENs.Add(new NHANVIEN()
//{
// MANV = nhanvien.MANV,
// HOTEN = nhanvien.HOTEN,
// NGAYSINH = nhanvien.NGAYSINH,
// GT = nhanvien.GT,
// SDT = nhanvien.SDT,
// MAIL = nhanvien.MAIL,
//}
ctx.sp_Insert_NhanVien(nhanvien.HOTEN, nhanvien.NGAYSINH, nhanvien.GT, nhanvien.SDT, nhanvien.MAIL, nhanvien.DIACHI, nhanvien.NGAYSINH);
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult GetAllNhanVien()
{
IList <NhanVienViewModel> nhanvien = null;
using (var ctx = new QLBANHANGEntities())
{
nhanvien = ctx.NHANVIENs.Select(s => new NhanVienViewModel()
{
MANV = s.MANV,
HOTEN = s.HOTEN,
NGAYSINH = s.NGAYSINH,
GT = s.GT,
SDT = s.SDT,
MAIL = s.MAIL,
DIACHI = s.DIACHI,
NGAYLAM = s.NGAYLAM
}).ToList <NhanVienViewModel>();
}
if (nhanvien.Count == 0)
{
return(NotFound());
}
return(Ok(nhanvien));
}
public IHttpActionResult GetAllNhaSanXuat()
{
IList <NhaSanXuatViewModel> nhasx = null;
using (var ctx = new QLBANHANGEntities())
{
nhasx = ctx.NHASXes.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 QLBANHANGEntities())
{
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));
}
public IHttpActionResult GetAllNhaCungCap()
{
IList <NhaCungCapViewModel> nhacc = null;
using (var ctx = new QLBANHANGEntities())
{
nhacc = ctx.NHACCs.Select(s => new NhaCungCapViewModel()
{
MACC = s.MACC,
TENCC = s.TENCC,
DIACHI = s.DIACHI,
SDT = s.SDT
}).ToList <NhaCungCapViewModel>();
}
if (nhacc.Count == 0)
{
return(NotFound());
}
return(Ok(nhacc));
}
