import { Injectable } from '@nestjs/common';
import { InjectRepository } from '@nestjs/typeorm';
import { PartnershipEntity } from 'src/database/entity/partnership-entity/partnership-entity';
import { ExceptionErrorMessage } from 'src/validation/exception-error';
import { Repository } from 'typeorm';

@Injectable()
export class PartnershipService {
    constructor(@InjectRepository(PartnershipEntity)
        private readonly partnershipRp:Repository<PartnershipEntity>){
    }

    //Guardar Parthnership
    async savePartnership(partnership:any){
        try {
            return await this.partnershipRp.save(partnership);
        } catch (error) {
            ExceptionErrorMessage(error);            
        }
    }

    //Actualizar Parthnership
    async updatePartnership(id:number, partnership:any){
        try {
            await this.partnershipRp.update(id,partnership);
            return await this.partnershipRp.findOneBy({id:id});
        } catch (error) {
            ExceptionErrorMessage(error);            
        }        
    }

    //Listar Partnerships
    async findAllPartnerships(){
        try {
            return await this.partnershipRp.find({order:{sort:'ASC'}});
        } catch (error) {
            ExceptionErrorMessage(error);            
        }
    }

    //Obtener el numero total de Filas
    async getTotalRows(){
        try {
            return await this.partnershipRp.count();
        } catch (error) {
            ExceptionErrorMessage(error);            
        }
    }

    //Obtener 3 registros aleatorios
    async getFourRandomRows(id){
        try {
            return await this.partnershipRp.find({where:[
                {id:id[0]},
                {id:id[1]},
                {id:id[2]},
                {id:id[3]},
            ]})
        } catch (error) {
            ExceptionErrorMessage(error);            
        }
    }

    //Listar Partnerships
    async findPartnershipsByIdorSlug(param:any){
        try {
            if(param.name=="slug")
                return await this.partnershipRp.findOneBy({slug:param.value});
            return await this.partnershipRp.findOneBy({id:param.value});
        } catch (error) {
            ExceptionErrorMessage(error);            
        }
    }

    //Borrar Partnership
    async deletePartNership(id:any){
        try {
            await this.partnershipRp.delete({id:id})
            return { message:"El registro seleccionado ha sido eliminado" };
        }
        catch(error){
            ExceptionErrorMessage(error);            
        }
    }
}