public async Task<List<PublicWebUploadJsonDto>> GetPublicWebUploadJsonList(string[] countryList, int[] typeList, DateTime fromDate, DateTime toDate)
        {
            var result = new List<PublicWebUploadJsonDto>();
            using (var dr = await RepositoryDbContext.Database.ExecuteSqlQueryAsync(
            $@"
                select t.title, t.shortdescription, 'PesaUpload', rp.companyid, t.publisheddate, t.addeddate, t.bidsDueDate, c.Name, c.RegistrationNumber, n.Country, t.tenderid,
                ( SELECT distinct convert(nvarchar, lc.cpvid )  + ';'
	                from lotcpv lc
	                inner join lot l on l.lotid = lc.lotid
	                where l.tenderid = t.tenderid and lc.CpvId is not null and lc.source = 'dataentry' FOR XML PATH('')) as cpvId, n.type, n.Source, n.TypeFromSource, t.ProcedureType, n.noticeid, t.sector, rp.Role
                from notice n
                inner join tender t on t.tenderid = n.tenderid
                inner join relatedparty rp on rp.tenderid = t.tenderid
                inner join company c on c.CompanyId = rp.CompanyId
                where n.addeddate >= convert(datetime, '{fromDate.ToString("dd.MM.yyyy")}', 104) and  n.addeddate <= convert(datetime, '{toDate.ToString("dd.MM.yyyy")}', 104) and t.publisheddate is not null and n.country in ('{string.Join("','", countryList)}') and n.type in ({string.Join(",", typeList)}) and ( SELECT distinct convert(nvarchar, lc.cpvid )  + ';'
	                from lotcpv lc
	                inner join lot l on l.lotid = lc.lotid
	                where l.tenderid = t.tenderid and lc.CpvId is not null and lc.source = 'dataentry' FOR XML PATH('')) is not null
                order by t.tenderid desc

                "))
            {
                var reader = dr.DbDataReader;
                while (reader.Read())
                {
                    result.Add(new PublicWebUploadJsonDto()
                    {
                        Title = reader[0] == DBNull.Value ? null : (string)reader[0],
                        Content = reader[1] == DBNull.Value ? null : (string)reader[1],
                        UploaderName = reader[2] == DBNull.Value ? null : (string)reader[2],
                        CompanyId = reader[3] == DBNull.Value ? -1 : (int)reader[3],
                        PublishDate = reader[4] == DBNull.Value ? null : (DateTime?)reader[4],
                        UploadDate = reader[5] == DBNull.Value ? null : (DateTime?)reader[5],
                        BidsDueDate = reader[6] == DBNull.Value ? null : (DateTime?)reader[6],
                        CompanyName = reader[7] == DBNull.Value ? null : (string)reader[7],
                        RegistrationNumber = reader[8] == DBNull.Value ? null : (string)reader[8],
                        Country = reader[9] == DBNull.Value ? null : (string)reader[9],
                        TenderPesaId = reader[10] == DBNull.Value ? -1 : (int)reader[10],
                        CpvId = reader[11] == DBNull.Value ? null : (string)reader[11],
                        Type = reader[12] == DBNull.Value ? -1 : (int)reader[12],
                        Source = reader[13] == DBNull.Value ? -1 : (int)reader[13],
                        TypeFromSource = reader[14] == DBNull.Value ? null : (string)reader[14],
                        ProcedureType = reader[15] == DBNull.Value ? null : (string)reader[15],
                        NoticeId = reader[16] == DBNull.Value ? -1 : (int)reader[16],
                        Sector = reader[17] == DBNull.Value ? null : (string)reader[17],
                        CompanyRole = reader[18] == DBNull.Value ? -1 : (int)reader[18],
                    });
                }
            }

            return result;
        }