public IHttpActionResult GetJoinSanPhamsMatHangs(string id) { var joinSanPhams = new List <SanPhamMatHang>(); using (var db = new BanHangDBContext()) { var sp = db.sanPhams.ToList(); var mh = db.matHangs.ToList(); joinSanPhams = sp.Join( // outer sequence mh, // inner sequence sanpham => sanpham.IDMH, // outerKeySelector mathang => mathang.IDMH, // innerKeySelector (sanpham, mathang) => new SanPhamMatHang() // result selector { IDSP = sanpham.IDSP, TenSP = sanpham.TenSP, IDHSX = sanpham.IDHSX, DonGia = sanpham.DonGia, NgayCapNhat = sanpham.NgayCapNhat, IDMH = mathang.IDMH, TenMH = mathang.TenMH }) .Where(x => x.IDSP == id) .ToList(); //sanPhamMatHang = joinSanPhams.Find(x => x.IDSP == id); } return(Ok(joinSanPhams)); }
public string GetIdentity() { string ID = ""; using (var entity = new BanHangDBContext()) { var list = entity.nhapKhos.ToList(); if (list.Count == 0) { ID = "NK000"; } else { int temp; ID = "NK"; temp = Convert.ToInt32(list[list.Count - 1].IDNK.ToString().Substring(2, 3)); temp = temp + 1; if (temp < 10) { ID = ID + "00"; } else if (temp < 100) { ID = ID + "0"; } ID = ID + temp.ToString(); } return(ID); } }
public IHttpActionResult PostHoaDonGetIdentity(HoaDon hoaDon) { using (var entity = new BanHangDBContext()) { hoaDon.IDHD = GetIdentity(); entity.hoaDons.Add(hoaDon); entity.SaveChanges(); } return(Ok(hoaDon)); }
public IHttpActionResult PostKhachHangGetIdentity(KhachHang khachHang) { using (var entity = new BanHangDBContext()) { khachHang.IDKH = GetIdentity(); entity.khachHangs.Add(khachHang); entity.SaveChanges(); } return(Ok(khachHang)); }
public IHttpActionResult PostNhapHoaDonGetIdentity(NhapHoaDon nhapHoaDon) { using (var entity = new BanHangDBContext()) { nhapHoaDon.IDNHD = GetIdentity(); entity.nhapHoaDons.Add(nhapHoaDon); entity.SaveChanges(); } return(Ok(nhapHoaDon)); }
public IHttpActionResult PostPhieuNhapGetIdentity(PhieuNhap phieuNhap) { using (var entity = new BanHangDBContext()) { phieuNhap.IDPN = GetIdentity(); entity.phieuNhaps.Add(phieuNhap); entity.SaveChanges(); } return(Ok(phieuNhap)); }
public IHttpActionResult PostListNhapKho(NhapKho[] nhapKhos) { if (nhapKhos != null) { for (int i = 0; i < nhapKhos.Length; i++) { using (var entity = new BanHangDBContext()) { nhapKhos[i].IDNK = GetIdentity(); entity.nhapKhos.Add(nhapKhos[i]); entity.SaveChanges(); } } return(Ok(nhapKhos)); } return(NotFound()); }