public async Task <List <DoanhNghiepDto> > GetAllDoanhNghiepSearch(GetDoanhNghiepInput input)
{
var data = new List <DoanhNghiepDto>();
var query = (from dn in _doanhNghiepRepos.GetAll()
where (string.IsNullOrEmpty(input.MaSoThue) || dn.MaSoThue.ToLower().Contains(input.MaSoThue))
select new DoanhNghiepDto
{
Id = dn.Id,
TenDoanhNghiep = dn.TenDoanhNghiep,
TinhId = dn.TinhId,
LoaiHinhDoanhNghiepId = dn.LoaiHinhDoanhNghiepId,
DiaChi = dn.DiaChi,
MaSoThue = dn.MaSoThue,
SoDienThoai = dn.SoDienThoai
})
.WhereIf(input.TinhId != null, u => u.TinhId == input.TinhId)
.WhereIf(input.LoaiHinhDoanhNghiepId != null, u => u.LoaiHinhDoanhNghiepId == input.LoaiHinhDoanhNghiepId);
data = await query.ToListAsync();
//if (!string.IsNullOrEmpty(input.MaSoThue))
//{
// var lowerInput = RemoveUnicode(input.MaSoThue.Trim().ToLower());
// data.Where(p => RemoveUnicode(p.MaSoThue.Trim().ToLower()).Contains(lowerInput) || RemoveUnicode(p.TenDoanhNghiep.Trim().ToLower()).Contains(lowerInput));
//}
return(data);
}
public async Task <PagedResultDto <DoanhNghiepDto> > DataConDauDoanhNghiep(GetDoanhNghiepInput input)
{
var query = (from a in _doanhNghiepRepos.GetAll()
join c in _chuKyRepos.GetAll() on a.Id equals c.PId
where c.LoaiChuKy == (int)CommonENum.LOAI_CHU_KY.CHU_KY
orderby c.IsDaXuLy, c.LastModificationTime descending
select new DoanhNghiepDto()
{
Id = a.Id,
MaSoThue = a.MaSoThue,
TenDoanhNghiep = a.TenDoanhNghiep,
DiaChi = a.DiaChi,
IsDaXuLy = a.IsDaXuLy,
chuKy = new ChuKyDto()
{
Id = c.Id,
IsActive = c.IsActive,
LoaiChuKy = c.LoaiChuKy,
MoTa = c.MoTa,
MaChuKy = c.MaChuKy,
TenChuKy = c.TenChuKy,
UrlImage = c.UrlImage,
DataImage = c.DataImage,
ChanChuKy = c.ChanChuKy,
ChieuCao = c.ChieuCao,
ChieuRong = c.ChieuRong,
IsDaXuLy = c.IsDaXuLy
}
}).WhereIf(!string.IsNullOrEmpty(input.Filter), u => u.MaSoThue.LocDauLowerCaseDB().Contains(input.Filter.Trim().LocDauLowerCaseDB()) || u.MaSoThue.LocDauLowerCaseDB().Contains(input.Filter.Replace("_", "-").LocDauLowerCaseDB()) || u.TenDoanhNghiep.LocDauLowerCaseDB().Contains(input.Filter.Trim().LocDauLowerCaseDB()) || u.TenLoaiHinh.LocDauLowerCaseDB().Contains(input.Filter.Trim().LocDauLowerCaseDB()) || u.TenNguoiDaiDien.LocDauLowerCaseDB().Contains(input.Filter.Trim().LocDauLowerCaseDB()))
.WhereIf(input.TinhId != null, u => u.TinhId == input.TinhId)
.WhereIf(input.LoaiHinhDoanhNghiepId != null, u => u.LoaiHinhDoanhNghiepId == input.LoaiHinhDoanhNghiepId);
if (input.FormCase == (int)CommonENum.FORM_CASE_DOANH_NGHIEP.DOANH_NGHIEP_CHUA_DUOC_DUYET)
{
query = query.Where(x => x.chuKy.IsDaXuLy != true);
}
else if (input.FormCase == (int)CommonENum.FORM_CASE_DOANH_NGHIEP.DUOC_DUYET_CHAP_NHAN)
{
query = query.Where(x => x.chuKy.IsDaXuLy == true);
}
var dataGrids = await query.PageBy(input).ToListAsync();
var doanhNghiepCount = await query.CountAsync();
return(new PagedResultDto <DoanhNghiepDto>(doanhNghiepCount, dataGrids));
}
public async Task <PagedResultDto <DoanhNghiepDto> > GetDoanhNghiepFilter(GetDoanhNghiepInput input)
{
input.Filter = Utility.StringExtensions.FomatFilterText(input.Filter);
var query = (from doanhnghiep in _doanhNghiepRepos.GetAll()
select new DoanhNghiepDto
{
TenDoanhNghiep = doanhnghiep.TenDoanhNghiep,
DiaChi = doanhnghiep.DiaChi,
})
.WhereIf(!string.IsNullOrEmpty(input.Filter), u => !string.IsNullOrEmpty(u.TenDoanhNghiep) && u.TenDoanhNghiep.ToLower().Contains(input.Filter));
var doanhNghiepCount = await query.CountAsync();
var dataGrids = await query
.OrderBy(p => p.TenDoanhNghiep)
.PageBy(input)
.ToListAsync();
var DoanhNghiepListDtos = dataGrids.MapTo <List <DoanhNghiepDto> >();
return(new PagedResultDto <DoanhNghiepDto>(doanhNghiepCount, DoanhNghiepListDtos));
}
public async Task <PagedResultDto <DoanhNghiepDto> > GetAllDoanhNghiepServerPagingAsync(GetDoanhNghiepInput input)
{
var doanhNghiepCount = 0;
var dataGrids = new List <DoanhNghiepDto>();
using (CurrentUnitOfWork.DisableFilter(AbpDataFilters.MayHaveTenant))
{
input.MaSoThue = Utility.StringExtensions.FomatAndKhongDau(input.MaSoThue);
var query = (from doanhnghiep in _doanhNghiepRepos.GetAll()
join user_r in _userRepos.GetAll() on doanhnghiep.Id equals user_r.DoanhNghiepId into userJoined
from user in userJoined.DefaultIfEmpty()
join chucvu_r in _chucVuRepos.GetAll() on doanhnghiep.ChucVuNguoiDaiDienID equals chucvu_r.Id into chucvuJoined
from chucvu in chucvuJoined.DefaultIfEmpty()
where (string.IsNullOrEmpty(input.MaSoThue) || doanhnghiep.MaSoThue.ToLower().Contains(input.MaSoThue))
select new DoanhNghiepDto
{
Id = doanhnghiep.Id,
MaSoThue = doanhnghiep.MaSoThue,
TenDoanhNghiep = doanhnghiep.TenDoanhNghiep,
DiaChi = doanhnghiep.DiaChi,
LoaiHinhDoanhNghiepId = doanhnghiep.LoaiHinhDoanhNghiepId,
TenLoaiHinh = doanhnghiep.TenLoaiHinh,
TenTiengAnh = doanhnghiep.TenTiengAnh,
TenVietTat = doanhnghiep.TenVietTat,
SoDienThoai = doanhnghiep.SoDienThoai,
Fax = doanhnghiep.Fax,
Website = doanhnghiep.Website,
TinhId = doanhnghiep.TinhId,
Tinh = doanhnghiep.Tinh,
EmailDoanhNghiep = doanhnghiep.EmailDoanhNghiep,
EmailXacNhan = doanhnghiep.EmailXacNhan,
HuyenId = doanhnghiep.HuyenId,
Huyen = doanhnghiep.Huyen,
XaId = doanhnghiep.XaId,
Xa = doanhnghiep.Xa,
TenNguoiDaiDien = doanhnghiep.TenNguoiDaiDien,
ChucVuNguoiDaiDienID = doanhnghiep.ChucVuNguoiDaiDienID,
DienThoaiNguoiDaiDien = doanhnghiep.DienThoaiNguoiDaiDien,
IsDaXuLy = doanhnghiep.IsDaXuLy,
CreationTime = doanhnghiep.CreationTime,
UserActive = user.IsActive,
UserId = user.Id,
TenChucVuNguoiDaiDien = chucvu.TenChucVu,
})
.WhereIf(!string.IsNullOrEmpty(input.Filter), u => u.MaSoThue.LocDauLowerCaseDB().Contains(input.Filter.Trim().LocDauLowerCaseDB()) || u.MaSoThue.LocDauLowerCaseDB().Contains(input.Filter.Replace("_", "-").LocDauLowerCaseDB()) || u.TenDoanhNghiep.LocDauLowerCaseDB().Contains(input.Filter.Trim().LocDauLowerCaseDB()) || u.TenLoaiHinh.LocDauLowerCaseDB().Contains(input.Filter.Trim().LocDauLowerCaseDB()) || u.TenNguoiDaiDien.LocDauLowerCaseDB().Contains(input.Filter.Trim().LocDauLowerCaseDB()))
.WhereIf(input.TinhId != null, u => u.TinhId == input.TinhId)
.WhereIf(input.LoaiHinhDoanhNghiepId != null, u => u.LoaiHinhDoanhNghiepId == input.LoaiHinhDoanhNghiepId);
if (_session.TenantId.HasValue)
{
var tenant = await _tenantManager.GetByIdAsync(_session.TenantId.Value);
if (tenant != null && tenant.TenancyName != "Default")
{
query = query.Where(x => x.TinhId == tenant.TinhId);
}
}
if (input.FormCase == (int)CommonENum.FORM_CASE_DOANH_NGHIEP.DOANH_NGHIEP_CHUA_DUOC_DUYET)
{
query = query.Where(x => x.IsDaXuLy != true);
}
else if (input.FormCase == (int)CommonENum.FORM_CASE_DOANH_NGHIEP.DUOC_DUYET_CHAP_NHAN)
{
query = query.Where(x => x.IsDaXuLy == true && x.UserId != null);
}
else if (input.FormCase == (int)CommonENum.FORM_CASE_DOANH_NGHIEP.DUOC_DUYET_KHONG_CHAP_NHAN)
{
query = query.Where(x => x.IsDaXuLy == true && x.UserId == null);
}
doanhNghiepCount = await query.CountAsync();
dataGrids = await query
.OrderByDescending(p => p.CreationTime)
.PageBy(input)
.ToListAsync();
foreach (var item in dataGrids)
{
item.ThongTinPhapLy = _giayPhepPhapLyRepos.GetAll().Where(x => x.DoanhNghiepId == item.Id).ToList();
}
}
return(new PagedResultDto <DoanhNghiepDto>(doanhNghiepCount, dataGrids));
}
