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));
}
