public async Task <HoaDonDichVu> UpdateById(string id, HoaDonDichVuForUpdateDto hoaDonDichVu) { var oldRecord = await _context.DanhSachHoaDonDichVu.AsNoTracking().FirstOrDefaultAsync(x => x.SoHDDV == id); var tinhTrang = ""; if (hoaDonDichVu.DaThanhToan == 0) { tinhTrang = "Chưa thanh toán"; } else if (hoaDonDichVu.DaThanhToan != hoaDonDichVu.ThanhTien && hoaDonDichVu.DaThanhToan > 0) { tinhTrang = "Đã thanh toán một phần"; } else { tinhTrang = "Đã thanh toán"; } var hoaDonDichVuToUpdate = new HoaDonDichVu { SoHDDV = id, MaKhachHang = hoaDonDichVu.MaKhachHang, MaNhanVien = hoaDonDichVu.MaNhanVien, NgayLap = hoaDonDichVu.NgayLap, NgaySuDung = hoaDonDichVu.NgaySuDung, ThanhTien = hoaDonDichVu.ThanhTien, DaThanhToan = hoaDonDichVu.DaThanhToan, TinhTrang = tinhTrang, TrangThai = hoaDonDichVu.TrangThai, ThoiGianTao = oldRecord.ThoiGianTao, ThoiGianCapNhat = DateTime.Now }; _context.DanhSachHoaDonDichVu.Update(hoaDonDichVuToUpdate); await _context.SaveChangesAsync(); return(hoaDonDichVuToUpdate); }
public async Task <HoaDonDichVu> Create(HoaDonDichVuForCreateDto hoaDonDichVu) { var tinhTrang = ""; if (hoaDonDichVu.DaThanhToan == 0) { tinhTrang = "Chưa thanh toán"; } else if (hoaDonDichVu.DaThanhToan != hoaDonDichVu.ThanhTien && hoaDonDichVu.DaThanhToan > 0) { tinhTrang = "Đã thanh toán một phần"; } else { tinhTrang = "Đã thanh toán"; } var newHoaDonDichVu = new HoaDonDichVu { SoHDDV = GenerateId(), NgayLap = hoaDonDichVu.NgayLap, NgaySuDung = hoaDonDichVu.NgaySuDung, ThanhTien = hoaDonDichVu.ThanhTien, DaThanhToan = hoaDonDichVu.DaThanhToan, TinhTrang = tinhTrang, GhiChu = hoaDonDichVu.GhiChu, MaKhachHang = hoaDonDichVu.MaKhachHang, MaNhanVien = hoaDonDichVu.MaNhanVien, ThoiGianTao = DateTime.Now, ThoiGianCapNhat = DateTime.Now, TrangThai = 1 }; await _context.DanhSachHoaDonDichVu.AddAsync(newHoaDonDichVu); await _context.SaveChangesAsync(); return(newHoaDonDichVu); }
public string gemaHD_BymaThue_maPhong(string mathue, string maphong) { HoaDonDichVu nv = db.HoaDonDichVus.Where(x => x.maThue.Equals(mathue) && x.maPhong.Equals(maphong)).SingleOrDefault(); return(nv.maHDDV.Trim()); }
public DateTime getNgay_byMaThue(string maThue) { HoaDonDichVu hddv = db.HoaDonDichVus.Where(x => x.maThue.Equals(maThue)).FirstOrDefault(); return(Convert.ToDateTime(hddv.ngayLap)); }