Hi BigCDogCrew,
The method AddError throws an exception and the code doesn't carry-on. Sorry, maybe that is not so clear.
I've resolved my issue creating a transaction and committing that manually using the methods:
using (var transaction = UnitOfWorkManager.Begin(TransactionScopeOption.RequiresNew)) { transaction.Complete(); }
Hi ismcagdas,
I have just 1 cookie for anti forgery. I can reproduce in other machines as well!
Hi @ismcagdas, I have sent you and email. Sorry, I haven't noticed your answer before!
Hi,
Unfortunately, the same error even removing the line above.
@ismcagdas,
New issue created as requested:
https://github.com/aspnetzero/aspnet-zero-core/issues/3633
Hi @ismcagdas
Yes, I can, see below:
JS (Just the dataTable creation):
var dataTable = _$apiariesTable.DataTable({
scrollY: "calc(100vh - 505px)",
scrollCollapse: false,
paging: true,
serverSide: true,
processing: true,
listAction: {
ajaxFunction: _apiariesService.getAll,
inputFilter: function () {
return {
filter: $('#ApiariesTableFilter').val(),
apiaryNameFilter: $('#ApiaryNameFilterId').val(),
minNumberOfBoxesFilter: $('#MinNumberOfBoxesFilterId').val(),
maxNumberOfBoxesFilter: $('#MaxNumberOfBoxesFilterId').val(),
apiaryStatusStatusTextFilter: $('#ApiaryStatusStatusTextFilterId').val(),
apiaryTypeTextFilter: $('#ApiaryTypeTextFilterId').val(),
geolocationGeocodedAddressFilter: $('#GeolocationGeocodedAddressFilterId').val(),
landOwnerNameFilter: $('#LandOwnerNameFilterId').val()
};
}
},
columnDefs: [
{
width: 120,
targets: 0,
data: null,
orderable: false,
autoWidth: false,
defaultContent: '',
rowAction: {
cssClass: 'btn btn-brand dropdown-toggle',
text: '<i class="fa fa-cog"></i> ' + app.localize('Actions') + ' <span class="caret"></span>',
items: [
{
text: app.localize('View'),
action: function (data) {
_viewApiariesModal.open({ data: data.record });
}
},
{
text: app.localize('Edit'),
visible: function () {
return _permissions.edit;
},
action: function (data) {
_createApiaryModalManager.open({ id: data.record.apiaries.id });
//_createOrEditModal.open({ id: data.record.apiaries.id });
}
},
{
text: app.localize('Delete'),
visible: function () {
return _permissions.delete;
},
action: function (data) {
deleteApiaries(data.record.apiaries);
}
}]
}
},
{
targets: 1,
data: "apiaries.apiaryName",
name: "apiaryName"
},
{
targets: 2,
data: "apiaries.estimatedNoOfHives",
name: "estimatedNoOfHives"
},
{
targets: 3,
data: "apiaryStatusStatusText",
name: "apiaryStatus.StatusText"
},
{
targets: 4,
data: "apiaryTypeText",
name: "apiaryType.Type"
},
{
targets: 5,
data: "geolocationGeocodedAddress",
name: "geolocation.GeocodedAddress"
},
{
targets: 6,
data: "landOwnerName",
name: "landOwner.Name"
},
{
targets: 7,
data: "apiaries.creationTime",
name: "creationTime",
render: function (creationTime) {
console.log('creationTime', creationTime);
return app.utils.date.getUTCtoLocalDateTime(creationTime, 'ddd DD-MMM-YYYY HH:mm');
}
},
{
targets: 8,
data: "createdBy",
name: "CreatorUser.UserName"
}
]
});
CSHTML (All):
@using ASL.iAPIS.Authorization
@using ASL.iAPIS.Web.Areas.iAPIS.Models.Apiaries
@using ASL.iAPIS.Web.Areas.iAPIS.Startup
@model ApiariesViewModel
@{
ViewBag.CurrentPageName = iAPISPageNames.Tenant.ApiariesMaint;
}
@section Scripts
{
<link rel="stylesheet" href="/leaflet_files/screen.css" />
<link href="~/leaflet_files/leaflet.css" rel="stylesheet" />
<script src="~/leaflet_files/leaflet.js"></script>
<script src="~/leaflet_files/bundle.min.js"></script>
<script src="~/leaflet_files/dist/esri-leaflet.js"></script>
<link href="~/leaflet_files/dist/esri-leaflet-geocoder.css" rel="stylesheet" />
<script src="~/leaflet_files/dist/esri-leaflet-geocoder.js"></script>
<script src="~/lib/kendo-ui/js/jszip.min.js" asp-append-version="true"></script>
<script src="~/lib/kendo-ui/js/kendo.all.min.js" asp-append-version="true"></script>
<script src="~/lib/kendo-ui/js/kendo.aspnetmvc.min.js" asp-append-version="true"></script>
@*<script src="~/lib/fileuploader/file-upload-with-preview.min.js" asp-append-version="true"></script>
<link href="~/lib/fileuploader/file-upload-with-preview.min.css" rel="stylesheet" asp-append-version="true"/>*@
<link href="/leaflet_files/extramarkers/leaflet.extra-markers.min.css" rel="stylesheet" />
<script src="~/leaflet_files/extramarkers/leaflet.extra-markers.js"></script>
<script src="/leaflet_files/Leaflet.Control.Custom.js"></script>
<script src="~/leaflet_files/leaflet-omnivore.min.js"></script>
@*<script src='//api.tiles.mapbox.com/mapbox.js/plugins/leaflet-omnivore/v0.3.1/leaflet-omnivore.min.js'></script>*@
<script abp-src="/view-resources/Areas/iAPIS/Views/Apiaries/Index.js" asp-append-version="true"></script>
}
<div class="content d-flex flex-column flex-column-fluid" id="kt_content">
<div class="subheader py-2 py-lg-4 subheader-solid" id="kt_subheader" kt-hidden-height="54" style="">
<div class="container-fluid d-flex align-items-center justify-content-between flex-wrap flex-sm-nowrap">
<!--begin::Info-->
<div class="col-md-6">
<div class="d-flex align-items-center flex-wrap mr-1">
<!--begin::Page Title-->
<h5 class="text-dark font-weight-bolder mt-2 mb-2 mr-5 font-size-h3">
@L("Apiaries")
</h5>
<!--end::Page Title-->
<div class="subheader-separator subheader-separator-ver mt-2 mb-2 mr-5 bg-gray-200"></div>
<span class="text-dark font-weight-normal font-sub-title mr-4">@L("ApiariesHeaderInfo")</span>
</div>
</div>
<div class="col-md-6 text-right">
<button id="ExportToExcelButton" class="btn btn-outline-success"><i class="fa fa-file-excel-o"></i> @L("ExportToExcel")</button>
@if (IsGranted(AppPermissions.Pages_Apiaries_Create))
{
<button id="CreateNewApiariesButton" class="btn btn-primary blue"><i class="fa fa-plus"></i> @L("CreateNewApiaries")</button>
}
</div>
<!--end::Info-->
</div>
</div>
<div class="container-fluid">
<div class="card card-custom gutter-b">
<div class="card-body">
<div class="m-content">
<div class="m-portlet m-portlet--mobile">
<div class="m-portlet__body portlet-body-pd">
<div class="m-form m-form--label-align-right">
<div class="row align-items-center m--margin-bottom-10">
<div class="col-xl-12 pd-0">
<div class="form-group m-form__group align-items-center">
<div class="input-group">
<input type="text" id="ApiariesTableFilter" class="form-control m-input" placeholder="@L("SearchWithThreeDot")" value="@Model.FilterText">
<span class="input-group-btn">
<button id="GetApiariesButton" class="btn btn-primary" type="submit"><i class="flaticon-search-1"></i></button>
</span>
</div>
</div>
</div>
</div>
</div>
<div id="AdvacedAuditFiltersArea" style="display: none" class="row m--margin-bottom-10">
<div class="col-md-12">
<div class="m-separator m-separator--dashed"></div>
</div>
<div class="col-md-3">
<div class="form-group">
<label for="ApiaryNameFilterId">@L("ApiaryName")</label>
<input type="text" class="form-control" name="apiaryNameFilter" id="ApiaryNameFilterId">
</div>
</div>
<div class="col-md-3">
<div class="form-group">
<label for="MinNumberOfBoxesFilterId">@L("MinMax") @L("NumberOfBoxes")</label>
<div class="input-group">
<input type="number" class="form-control m-input" placeholder="@L("MinValue")" name="minNumberOfBoxesFilter" id="MinNumberOfBoxesFilterId" />
<input type="number" class="form-control m-input" placeholder="@L("MaxValue")" name="maxNumberOfBoxesFilter" id="MaxNumberOfBoxesFilterId" />
</div>
</div>
</div>
<div class="col-md-3">
<div class="form-group">
<label for="ApiaryStatusStatusTextFilterId">(@L("ApiaryStatus")) @L("StatusText")</label>
<input type="text" class="form-control" name="apiaryStatusStatusTextFilter" id="ApiaryStatusStatusTextFilterId">
</div>
</div>
<div class="col-md-3">
<div class="form-group">
<label for="ApiaryTypeTextFilterId">@L("Type")</label>
<input type="text" class="form-control" name="apiaryTypeTextFilter" id="ApiaryTypeTextFilterId">
</div>
</div>
<div class="col-md-3">
<div class="form-group">
<label for="GeolocationGeocodedAddressFilterId">(@L("Geolocation")) @L("GeocodedAddress")</label>
<input type="text" class="form-control" name="geolocationGeocodedAddressFilter" id="GeolocationGeocodedAddressFilterId">
</div>
</div>
<div class="col-md-3">
<div class="form-group">
<label for="LandOwnerNameFilterId">(@L("LandOwner")) @L("Name")</label>
<input type="text" class="form-control" name="landOwnerNameFilter" id="LandOwnerNameFilterId">
</div>
</div>
</div>
<div class="row m--margin-bottom-10">
<div class="col-xl-12">
<span id="ShowAdvancedFiltersSpan" class="text-muted clickable-item"><i class="fa fa-angle-down"></i> @L("ShowAdvancedFilters")</span>
<span id="HideAdvancedFiltersSpan" class="text-muted clickable-item" style="display: none"><i class="fa fa-angle-up"></i> @L("HideAdvancedFilters")</span>
</div>
</div>
<div class="row align-items-center">
<table id="ApiariesTable" class="display table table-striped table-bordered table-hover dt-responsive nowrap">
<thead>
<tr>
<th>@L("Actions")</th>
<th>@L("ApiaryName")</th>
<th>@L("NumberOfHives")</th>
<th>@L("Status")</th>
<th>@L("Type")</th>
<th>@L("Location")</th>
<th>@L("LandOwnerName")</th>
<th>@L("CreationTime")</th>
<th>@L("CreatedBy")</th>
</tr>
</thead>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
Here is were is the issue, when clicking on "Selected permission (0)" it will open the permission tree. Selecting too many permission, it create that url request too long.
Hi. He is the url:
/api/services/app/Role/GetRoles?permissions[0]=Pages.Administration.TaskVistsGroup&permissions[1]=Pages.Administration.iAPIS.Settings&permissions[2]=Pages&permissions[3]=Pages.Administration.Hazards&permissions[4]=Pages.Administration.Hazards.Create&permissions[5]=Pages.Administration.Hazards.Delete&permissions[6]=Pages.Administration.Hazards.Edit&permissions[7]=Pages.Administration.Materials&permissions[8]=Pages.Administration.Materials.Create&permissions[9]=Pages.Administration.Materials.Delete&permissions[10]=Pages.Administration.Materials.Edit&permissions[11]=Pages.Administration.VisitObservationQuestionTemplates&permissions[12]=Pages.Administration.VisitObservationQuestionTemplates.Create&permissions[13]=Pages.Administration.VisitObservationQuestionTemplates.Delete&permissions[14]=Pages.Administration.VisitObservationQuestionTemplates.Edit&permissions[15]=Pages.TaskGroups&permissions[16]=Pages.TaskGroups.Create&permissions[17]=Pages.TaskGroups.Delete&permissions[18]=Pages.TaskGroups.Edit&permissions[19]=Pages.TaskStatus&permissions[20]=Pages.TaskStatus.Create&permissions[21]=Pages.TaskStatus.Delete&permissions[22]=Pages.TaskStatus.Edit&permissions[23]=Pages.Tasks&permissions[24]=Pages.Tasks.Create&permissions[25]=Pages.Tasks.Delete&permissions[26]=Pages.Tasks.Edit&permissions[27]=Pages.Administration.VisitStatus&permissions[28]=Pages.Administration.VisitStatus.Create&permissions[29]=Pages.Administration.VisitStatus.Delete&permissions[30]=Pages.Administration.VisitStatus.Edit&permissions[31]=Pages.Administration.VisitTemplates&permissions[32]=Pages.Administration.VisitTemplates.Create&permissions[33]=Pages.Administration.VisitTemplates.Delete&permissions[34]=Pages.Administration.VisitTemplates.Edit&permissions[35]=Pages.Administration.WorkerCrews&permissions[36]=Pages.Administration.WorkerCrews.Create&permissions[37]=Pages.Administration.WorkerCrews.Delete&permissions[38]=Pages.Administration.WorkerCrews.Edit&permissions[39]=Pages.Administration.WorkerMPE&permissions[40]=Pages.Administration.WorkerVehicles&permissions[41]=Pages.Administration.WorkerVehicles.Create&permissions[42]=Pages.Administration.WorkerVehicles.Delete&permissions[43]=Pages.Administration.WorkerVehicles.Edit
Hi @ismcagdas,
I am aware about that. But, the point is that I don't want to commit my changes into the database yet. If something is wrong next, I want to rollback my transaction (raising an exception in this case). If I call SaveChanges, it will be persisted straightaway in the database and there is no way to revert that, only doing it manually by delete command instead of using the rollback on the transaction created by the CurrentUnitOfWork.
Any other solution for that?
The most strange thing is, in another routine where I am importing a record from a spreadsheet, I have a loop that create the entity, assign the fields and insert the new entity and get the ID for that. In the begin, I have a validation to check if the name already exist in the database just to avoid duplicated records. And in this method it is working like I wish. Has the function InsertAndGetId() a different behaviour?
e.g.:
name = spreadsheet[row, colName];
While (name != '')
{
var person = _personRepository.GetAll().Where(p => p.name == name).FirstOrDefault();
if (person != null)
{
AddError("Person already exists: " + name);
}
var record = new person();
record.name = name;
record.Id = _personRepository.InsertAndGetId(person);
row++;
name = spreadsheet[row, colName];
}
So, in this example above, it seems to be reading the person insert previously, even though I haven't used SaveChanges to commit the records inserted.
Thank you in advanced!
I have copy System.Data.SqlClient.dll from MVC project (folder Bin/Release) and it is still crashing.
If you said it is should use version 4.8.1, why is it looking for version 4.6.1.0:
Could not load file or assembly 'System.Data.SqlClient, Version=4.6.1.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. The system cannot find the file specified.
The file that I've copied from MVC\Bin has a different version as well:
