forgot to let you know: I changed the sql server collation to "SQL_Latin1_General_CP1_CI_AI" and now everything is ok
<a class="postlink" href="https://msdn.microsoft.com/en-us/library/ms179254.aspx">https://msdn.microsoft.com/en-us/library/ms179254.aspx</a>
thank you
Hi! sure
// GET: FileUploader
public async virtual Task<JsonResult> Index()
{
string output;
try
{
int teste = Request.Files.Count;
CreateUpdateImovelByPortfolioInput dto = new CreateUpdateImovelByPortfolioInput();
dto.PortfolioId = Convert.ToInt16(Request.Params.Get("portfolioId"));
using (ZipArchive archive = ZipFile.OpenRead(@"C:\sd.zip"))
{
foreach (ZipArchiveEntry entry in archive.Entries)
{
if (entry.FullName.EndsWith(".pdf", StringComparison.OrdinalIgnoreCase))
{
using (MemoryStream ms = new MemoryStream())
{
entry.Open().CopyTo(ms);
//etc
}
}
}
}
output= await _service.Create(dto);
}
catch(Exception o)
{
throw new UserFriendlyException(o.ToString());
}
return Json(new { Data = output });
}
I'm having the same problem, is this resolved?
tried your tip but didn't work.
exec sp_executesql N'INSERT [dbo].[Imovel]([Id], [TenantId], [PortfolioId], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId])
VALUES (@0, @1, @2, @3, NULL, NULL, NULL, NULL, @4, @5)
',N'@0 nvarchar(128),@1 int,@2 int,@3 bit,@4 datetime2(7),@5 bigint',@0=N'6',@1=1,@2=2,@3=0,@4='2016-01-14 20:34:49.4314465',@5=2
I copied this from sql profiler and tried to execute it in sql server and it takes ages....sometimes works sometimes doesn't. any ideia?
I'm really sorry, the problem was getting the permissions for the user because i wasn't filtering by isgranted = true. thank very much for your help, and thank you for the excellent work
I disabled AbpDataFilters.MayHaveTenant because I'm trying to centralize things in just one tenant.
SetGrantedPermissionsAsync its not prohibiting other permissions, i dont know why! That's why I tried to use ResetAllPermissionsAsync, to reset all user permissions