public async Task <int> Count(MerchantAddressFilter filter)
{
IQueryable <MerchantAddressDAO> MerchantAddressDAOs = DataContext.MerchantAddress;
MerchantAddressDAOs = DynamicFilter(MerchantAddressDAOs, filter);
return(await MerchantAddressDAOs.CountAsync());
}
public MerchantAddressFilter ConvertFilterDTOToFilterEntity(MerchantAddressMaster_MerchantAddressFilterDTO MerchantAddressMaster_MerchantAddressFilterDTO)
{
MerchantAddressFilter MerchantAddressFilter = new MerchantAddressFilter();
MerchantAddressFilter.Selects = MerchantAddressSelect.ALL;
MerchantAddressFilter.Id = new LongFilter {
Equal = MerchantAddressMaster_MerchantAddressFilterDTO.Id
};
MerchantAddressFilter.MerchantId = new LongFilter {
Equal = MerchantAddressMaster_MerchantAddressFilterDTO.MerchantId
};
MerchantAddressFilter.Code = new StringFilter {
StartsWith = MerchantAddressMaster_MerchantAddressFilterDTO.Code
};
MerchantAddressFilter.Address = new StringFilter {
StartsWith = MerchantAddressMaster_MerchantAddressFilterDTO.Address
};
MerchantAddressFilter.Contact = new StringFilter {
StartsWith = MerchantAddressMaster_MerchantAddressFilterDTO.Contact
};
MerchantAddressFilter.Phone = new StringFilter {
StartsWith = MerchantAddressMaster_MerchantAddressFilterDTO.Phone
};
return(MerchantAddressFilter);
}
public async Task <int> Count([FromBody] MerchantAddressMaster_MerchantAddressFilterDTO MerchantAddressMaster_MerchantAddressFilterDTO)
{
if (!ModelState.IsValid)
{
throw new MessageException(ModelState);
}
MerchantAddressFilter MerchantAddressFilter = ConvertFilterDTOToFilterEntity(MerchantAddressMaster_MerchantAddressFilterDTO);
return(await MerchantAddressService.Count(MerchantAddressFilter));
}
public async Task <List <MerchantAddressMaster_MerchantAddressDTO> > List([FromBody] MerchantAddressMaster_MerchantAddressFilterDTO MerchantAddressMaster_MerchantAddressFilterDTO)
{
if (!ModelState.IsValid)
{
throw new MessageException(ModelState);
}
MerchantAddressFilter MerchantAddressFilter = ConvertFilterDTOToFilterEntity(MerchantAddressMaster_MerchantAddressFilterDTO);
List <MerchantAddress> MerchantAddresss = await MerchantAddressService.List(MerchantAddressFilter);
return(MerchantAddresss.Select(c => new MerchantAddressMaster_MerchantAddressDTO(c)).ToList());
}
public async Task <List <MerchantAddress> > List(MerchantAddressFilter filter)
{
if (filter == null)
{
return(new List <MerchantAddress>());
}
IQueryable <MerchantAddressDAO> MerchantAddressDAOs = DataContext.MerchantAddress;
MerchantAddressDAOs = DynamicFilter(MerchantAddressDAOs, filter);
MerchantAddressDAOs = DynamicOrder(MerchantAddressDAOs, filter);
var MerchantAddresss = await DynamicSelect(MerchantAddressDAOs, filter);
return(MerchantAddresss);
}
public async Task <bool> ValidateId(MerchantAddress MerchantAddress)
{
MerchantAddressFilter MerchantAddressFilter = new MerchantAddressFilter
{
Skip = 0,
Take = 10,
Id = new LongFilter {
Equal = MerchantAddress.Id
},
Selects = MerchantAddressSelect.Id
};
int count = await UOW.MerchantAddressRepository.Count(MerchantAddressFilter);
if (count == 0)
{
MerchantAddress.AddError(nameof(MerchantAddressValidator), nameof(MerchantAddress.Id), ErrorCode.IdNotExisted);
}
return(count == 1);
}
public async Task <List <MerchantAddress> > List(MerchantAddressFilter MerchantAddressFilter)
{
List <MerchantAddress> MerchantAddresss = await UOW.MerchantAddressRepository.List(MerchantAddressFilter);
return(MerchantAddresss);
}
public async Task <int> Count(MerchantAddressFilter MerchantAddressFilter)
{
int result = await UOW.MerchantAddressRepository.Count(MerchantAddressFilter);
return(result);
}
private IQueryable <MerchantAddressDAO> DynamicOrder(IQueryable <MerchantAddressDAO> query, MerchantAddressFilter filter)
{
switch (filter.OrderType)
{
case OrderType.ASC:
switch (filter.OrderBy)
{
case MerchantAddressOrder.Id:
query = query.OrderBy(q => q.Id);
break;
case MerchantAddressOrder.Merchant:
query = query.OrderBy(q => q.Merchant.Id);
break;
case MerchantAddressOrder.Code:
query = query.OrderBy(q => q.Code);
break;
case MerchantAddressOrder.Address:
query = query.OrderBy(q => q.Address);
break;
case MerchantAddressOrder.Contact:
query = query.OrderBy(q => q.Contact);
break;
case MerchantAddressOrder.Phone:
query = query.OrderBy(q => q.Phone);
break;
}
break;
case OrderType.DESC:
switch (filter.OrderBy)
{
case MerchantAddressOrder.Id:
query = query.OrderByDescending(q => q.Id);
break;
case MerchantAddressOrder.Merchant:
query = query.OrderByDescending(q => q.Merchant.Id);
break;
case MerchantAddressOrder.Code:
query = query.OrderByDescending(q => q.Code);
break;
case MerchantAddressOrder.Address:
query = query.OrderByDescending(q => q.Address);
break;
case MerchantAddressOrder.Contact:
query = query.OrderByDescending(q => q.Contact);
break;
case MerchantAddressOrder.Phone:
query = query.OrderByDescending(q => q.Phone);
break;
}
break;
}
query = query.Skip(filter.Skip).Take(filter.Take);
return(query);
}
private IQueryable <MerchantAddressDAO> DynamicFilter(IQueryable <MerchantAddressDAO> query, MerchantAddressFilter filter)
{
if (filter == null)
{
return(query.Where(q => false));
}
if (filter.Id != null)
{
query = query.Where(q => q.Id, filter.Id);
}
if (filter.MerchantId != null)
{
query = query.Where(q => q.MerchantId, filter.MerchantId);
}
if (filter.Code != null)
{
query = query.Where(q => q.Code, filter.Code);
}
if (filter.Address != null)
{
query = query.Where(q => q.Address, filter.Address);
}
if (filter.Contact != null)
{
query = query.Where(q => q.Contact, filter.Contact);
}
if (filter.Phone != null)
{
query = query.Where(q => q.Phone, filter.Phone);
}
if (filter.Ids != null)
{
query = query.Where(q => filter.Ids.Contains(q.Id));
}
if (filter.ExceptIds != null)
{
query = query.Where(q => !filter.ExceptIds.Contains(q.Id));
}
return(query);
}
private async Task <List <MerchantAddress> > DynamicSelect(IQueryable <MerchantAddressDAO> query, MerchantAddressFilter filter)
{
List <MerchantAddress> MerchantAddresss = await query.Select(q => new MerchantAddress()
{
Id = filter.Selects.Contains(MerchantAddressSelect.Id) ? q.Id : default(long),
MerchantId = filter.Selects.Contains(MerchantAddressSelect.Merchant) ? q.MerchantId : default(long),
Code = filter.Selects.Contains(MerchantAddressSelect.Code) ? q.Code : default(string),
Address = filter.Selects.Contains(MerchantAddressSelect.Address) ? q.Address : default(string),
Contact = filter.Selects.Contains(MerchantAddressSelect.Contact) ? q.Contact : default(string),
Phone = filter.Selects.Contains(MerchantAddressSelect.Phone) ? q.Phone : default(string),
Merchant = filter.Selects.Contains(MerchantAddressSelect.Merchant) && q.Merchant != null ? new Merchant
{
Id = q.Merchant.Id,
Name = q.Merchant.Name,
Phone = q.Merchant.Phone,
ContactPerson = q.Merchant.ContactPerson,
Address = q.Merchant.Address,
} : null,
}).ToListAsync();
return(MerchantAddresss);
}
