How to get entity by specific field (not primary key)?

Question

I have done get data by Id (primary key) with success. But if I call Get by another field, why is it always Id that is used?

search with id(primary key)

Search with id_kategori(not_primary_key

Here is my code:

ITempatAppService.cs

public interface ITempatAppService:IApplicationService
{
    GetTempatOutput GetTempatById(GetTempatInput input);

    GetTempatOutput GetTempatByIdKategori(GetTempatKategori input);
}

GetTempatInput.cs

public class GetTempatInput
{
    public int Id { get; set; }
}

GetTempatOutput.cs

public class GetTempatKategori
{
    public int IdKategori { get; set; }
}

TempatAppService.cs

public class TempatAppService:ApplicationService,ITempatAppService
{
    private readonly ITempatManager _tempatManager;
    public TempatAppService(ITempatManager tempatManager)
    {
        _tempatManager = tempatManager;
    }

    public GetTempatOutput GetTempatById(GetTempatInput input)
    {
        var getTempat = _tempatManager.GetTempatById(input.Id);
        GetTempatOutput output = Mapper.Map<MasterTempat, GetTempatOutput>(getTempat);
        return output;
    }

    public GetTempatOutput GetTempatByIdKategori(GetTempatKategori input)
    {
        var getTempat = _tempatManager.GetTempatByIdKategori(input.IdKategori);
        GetTempatOutput output = Mapper.Map<MasterTempat, GetTempatOutput>(getTempat);
        return output;
    }
}

Here is my TempatManager.cs:

public class TempatManager : DomainService, ITempatManager
{
    private readonly IRepository<MasterTempat> _repositoryTempat;
    public TempatManager(IRepository<MasterTempat> repositoryTempat)
    {
        _repositoryTempat = repositoryTempat;
    }

    public MasterTempat GetTempatById(int Id)
    {
        return _repositoryTempat.Get(Id);
    }

    public MasterTempat GetTempatByIdKategori(int IdKategori)
    {
        return _repositoryTempat.Get(IdKategori);
    }
}

by default it takes Id as a parameter, You can make a call something like `(x => x.IdKategori = input.IdKategori )` — Vivek Nuna, Feb 28 '18 at 08:49
Wherever you are calling `GetAll` or similar method in your code — Vivek Nuna, Feb 28 '18 at 09:15
post `_tempatManager.GetTempatByIdKategori` method implementation — Vivek Nuna, Feb 28 '18 at 09:16
you have a problem in TempatManager . Show your TempatManager and I'll point you the problem. — Alper Ebicoglu, Mar 01 '18 at 06:35
I want to ask again . I'm success to get data with id kategori , but only one data can show , how can i show all data with same id kategori? @AlperEbicoglu — Yogi Chandra, Mar 02 '18 at 07:53

score 0 · Accepted Answer · answered Mar 01 '18 at 14:14

0

Naming the parameter IdKategori doesn't make it search by that column. Do this:

public MasterTempat GetTempatByIdKategori(int IdKategori)
{
    return _repositoryTempat.GetAll().First(t => t.IdKategori == IdKategori);
}

answered Mar 01 '18 at 14:14

aaron

39,695
6
46
102

Thanks aaron you save my life twice :) – Yogi Chandra Mar 01 '18 at 14:43

Alper Ebicoglu · Answer 2 · 2018-03-02T08:27:26.713

0

To take the list of the selected kategori.

public List<MasterTempat> GetTempatByIdKategori(int IdKategori)
{
    return _repositoryTempat.GetAll().Where(t => t.IdKategori == IdKategori).ToList();
}

edited Mar 02 '18 at 08:27

answered Mar 02 '18 at 08:12

Alper Ebicoglu

8,884
1
49
55

yeah you need to return List :) See my updated answer – Alper Ebicoglu Mar 02 '18 at 08:27
Done sir , my reputation less than 15 – Yogi Chandra Mar 02 '18 at 10:53

How to get entity by specific field (not primary key)?

2 Answers2