public virtual JsonResult JournalDetailsList(int?IdJournal = null, Universal.Pagination.PrimeUiDataTableSourceRequest requestOptions = null)
{
if (!IdJournal.HasValue)
{
throw new Exception("Не указан идентификатор журнала.");
}
else if (!ModelState.IsValid)
{
throw new Exception("Некорректные параметры запроса.");
}
try
{
using (var scope = new TransactionScope(TransactionScopeOption.Suppress, new TransactionOptions()
{
IsolationLevel = IsolationLevel.ReadUncommitted
}))
{
var result = IdJournal.Value != -1 ? AppCore.Get <JournalingManager>().GetJournal(IdJournal.Value) : new ExecutionResult <Journaling.Model.JournalInfo>();
if (IdJournal.Value != -1 && !result.IsSuccess)
{
throw new Exception(result.Message);
}
var dbAccessor = AppCore.Get <JournalingDB.JournalingManagerDatabaseAccessor>();
using (var db = new JournalingDB.DataContext())
{
var sorted = false;
var query = dbAccessor.CreateQueryJournalData(db);
if (IdJournal.Value != -1)
{
query = query.Where(x => x.JournalData.IdJournal == IdJournal.Value);
}
if (requestOptions != null)
{
if (requestOptions.FilterFields != null)
{
foreach (var filter in requestOptions.FilterFields)
{
switch (filter.FieldName)
{
case nameof(JournalingDB.QueryJournalData.JournalData.IdJournalData):
if (!int.TryParse(filter.Value, out var idJournalData))
{
throw new HandledException($"Некорректное значение фильтра для поля '{filter.FieldName}'.");
}
switch (filter.MatchType)
{
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.Contains:
query = query.Where(x => Convert.ToString(x.JournalData.IdJournalData).Contains(idJournalData.ToString()));
break;
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.StartsWith:
query = query.Where(x => Convert.ToString(x.JournalData.IdJournalData).StartsWith(idJournalData.ToString()));
break;
}
break;
case nameof(JournalingDB.QueryJournalData.JournalData.EventCode):
if (!int.TryParse(filter.Value, out var eventCode))
{
throw new HandledException($"Некорректное значение фильтра для поля '{filter.FieldName}'.");
}
switch (filter.MatchType)
{
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.Contains:
query = query.Where(x => Convert.ToString(x.JournalData.EventCode).Contains(eventCode.ToString()));
break;
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.StartsWith:
query = query.Where(x => Convert.ToString(x.JournalData.EventCode).StartsWith(eventCode.ToString()));
break;
}
break;
case nameof(JournalingDB.QueryJournalData.JournalData.EventType):
if (!Enum.TryParse <EventType>(filter.Value, out var eventType))
{
throw new HandledException($"Некорректное значение фильтра для поля '{filter.FieldName}'.");
}
switch (filter.MatchType)
{
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.Contains:
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.StartsWith:
query = query.Where(x => x.JournalData.EventType == eventType);
break;
}
break;
case nameof(JournalingDB.QueryJournalData.JournalData.EventInfo):
switch (filter.MatchType)
{
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.Contains:
query = query.Where(x => x.JournalData.EventInfo.Contains(filter.Value));
break;
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.StartsWith:
query = query.Where(x => x.JournalData.EventInfo.StartsWith(filter.Value));
break;
}
break;
case nameof(JournalingDB.QueryJournalData.JournalData.EventInfoDetailed):
switch (filter.MatchType)
{
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.Contains:
query = query.Where(x => x.JournalData.EventInfoDetailed.Contains(filter.Value));
break;
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.StartsWith:
query = query.Where(x => x.JournalData.EventInfoDetailed.StartsWith(filter.Value));
break;
}
break;
case nameof(JournalingDB.QueryJournalData.JournalData.ExceptionDetailed):
switch (filter.MatchType)
{
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.Contains:
query = query.Where(x => x.JournalData.ExceptionDetailed.Contains(filter.Value));
break;
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.StartsWith:
query = query.Where(x => x.JournalData.ExceptionDetailed.StartsWith(filter.Value));
break;
}
break;
case "EventInfoFull":
switch (filter.MatchType)
{
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.Contains:
query = query.Where(x => x.JournalData.EventInfoDetailed.Contains(filter.Value) || x.JournalData.ExceptionDetailed.Contains(filter.Value));
break;
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.StartsWith:
query = query.Where(x => x.JournalData.EventInfoDetailed.StartsWith(filter.Value) || x.JournalData.ExceptionDetailed.StartsWith(filter.Value));
break;
}
break;
case "JournalName":
switch (filter.MatchType)
{
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.Contains:
query = query.Where(x => x.JournalName.Name.Contains(filter.Value));
break;
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.StartsWith:
query = query.Where(x => x.JournalName.Name.StartsWith(filter.Value));
break;
}
break;
default:
throw new HandledException($"Фильтр по полю '{filter.FieldName}' не поддерживается.");
}
}
}
if (!string.IsNullOrEmpty(requestOptions.SortByFieldName))
{
switch (requestOptions.SortByFieldName)
{
case nameof(JournalingDB.QueryJournalData.JournalData.IdJournalData):
sorted = true;
query = requestOptions.SortByAcsending ? query.OrderBy(x => x.JournalData.IdJournalData) : query.OrderByDescending(x => x.JournalData.IdJournalData);
break;
case nameof(JournalingDB.QueryJournalData.JournalData.DateEvent):
sorted = true;
query = requestOptions.SortByAcsending ? query.OrderBy(x => x.JournalData.DateEvent) : query.OrderByDescending(x => x.JournalData.DateEvent);
break;
case nameof(JournalingDB.QueryJournalData.JournalData.EventType):
sorted = true;
query = requestOptions.SortByAcsending ? query.OrderBy(x => x.JournalData.EventType) : query.OrderByDescending(x => x.JournalData.EventType);
break;
case nameof(JournalingDB.QueryJournalData.JournalData.EventCode):
sorted = true;
query = requestOptions.SortByAcsending ? query.OrderBy(x => x.JournalData.EventCode) : query.OrderByDescending(x => x.JournalData.EventCode);
break;
case nameof(JournalingDB.QueryJournalData.JournalData.EventInfo):
sorted = true;
query = requestOptions.SortByAcsending ? query.OrderBy(x => x.JournalData.EventInfo) : query.OrderByDescending(x => x.JournalData.EventInfo);
break;
case nameof(JournalingDB.QueryJournalData.JournalData.EventInfoDetailed):
sorted = true;
query = requestOptions.SortByAcsending ?
query.OrderBy(x => x.JournalData.EventInfoDetailed) :
query.OrderByDescending(x => x.JournalData.EventInfoDetailed);
break;
case nameof(JournalingDB.QueryJournalData.JournalData.ExceptionDetailed):
sorted = true;
query = requestOptions.SortByAcsending ?
query.OrderBy(x => x.JournalData.ExceptionDetailed) :
query.OrderByDescending(x => x.JournalData.ExceptionDetailed);
break;
case "EventInfoFull":
sorted = true;
query = requestOptions.SortByAcsending ?
query.OrderBy(x => x.JournalData.EventInfoDetailed).ThenBy(x => x.JournalData.ExceptionDetailed) :
query.OrderByDescending(x => x.JournalData.EventInfoDetailed).ThenByDescending(x => x.JournalData.ExceptionDetailed);
break;
case "JournalName":
sorted = true;
query = requestOptions.SortByAcsending ?
query.OrderBy(x => x.JournalName.Name) :
query.OrderByDescending(x => x.JournalName.Name);
break;
}
}
}
var dataAllCount = query.Count();
if (requestOptions != null)
{
if (!sorted)
{
query = query.OrderByDescending(x => x.JournalData.IdJournalData);
}
if (requestOptions.FirstRow > 0)
{
query = query.Skip((int)requestOptions.FirstRow);
}
if (requestOptions.RowsLimit > 0)
{
query = query.Take((int)requestOptions.RowsLimit);
}
}
var data = dbAccessor.FetchQueryJournalData(query);
return(ReturnJson(true, null, new ViewModels.JournalDetails()
{
JournalDataCountAll = dataAllCount,
JournalData = data
}));
}
}
}
catch (HandledException ex)
{
RegisterEventWithCode(HttpStatusCode.InternalServerError, "Ошибка при загрузке данных журнала", $"Журнал №{IdJournal}. {ex.Message}");
return(ReturnJson(false, $"Ошибка при загрузке данных журнала. {ex.Message}"));
}
catch (Exception ex)
{
RegisterEventWithCode(HttpStatusCode.InternalServerError, "Неожиданная ошибка при загрузке данных журнала", $"Журнал №{IdJournal}.", ex);
return(ReturnJson(false, "Неожиданная ошибка при загрузке данных журнала"));
}
}
public virtual JsonResult UsersList(UserState?state = null, Universal.Pagination.PrimeUiDataTableSourceRequest requestOptions = null)
{
if (!ModelState.IsValid)
{
throw new Exception("Некорректные параметры запроса.");
}
try
{
using (var scope = new TransactionScope(TransactionScopeOption.Suppress, new TransactionOptions()
{
IsolationLevel = IsolationLevel.ReadUncommitted
}))
{
using (var db = new CoreContext())
{
var query = state.HasValue ?
db.Users.Where(x => x.State == state.Value) :
db.Users;
var sorted = false;
if (requestOptions != null)
{
if (requestOptions.FilterFields != null)
{
foreach (var filter in requestOptions.FilterFields)
{
switch (filter.FieldName)
{
case nameof(Core.Db.User.IdUser):
if (!int.TryParse(filter.Value, out var idUser))
{
throw new HandledException($"Некорректное значение фильтра для поля '{filter.FieldName}'.");
}
switch (filter.MatchType)
{
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.Contains:
query = query.Where(x => Convert.ToString(x.IdUser).Contains(idUser.ToString()));
break;
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.StartsWith:
query = query.Where(x => Convert.ToString(x.IdUser).StartsWith(idUser.ToString()));
break;
}
break;
case nameof(Core.Db.User.Superuser):
if (!int.TryParse(filter.Value, out var superuser))
{
throw new HandledException($"Некорректное значение фильтра для поля '{filter.FieldName}'.");
}
query = query.Where(x => x.Superuser == superuser);
break;
case "Requisites":
switch (filter.MatchType)
{
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.Contains:
query = query.Where(x => ((x.name ?? "") + "." + (x.email ?? "") + "." + (x.phone ?? "")).Contains(filter.Value));
break;
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.StartsWith:
query = query.Where(x => ((x.name ?? "") + "." + (x.email ?? "") + "." + (x.phone ?? "")).StartsWith(filter.Value));
break;
}
break;
case nameof(Core.Db.User.email):
switch (filter.MatchType)
{
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.Contains:
query = query.Where(x => x.email.Contains(filter.Value));
break;
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.StartsWith:
query = query.Where(x => x.email.StartsWith(filter.Value));
break;
}
break;
case nameof(Core.Db.User.phone):
switch (filter.MatchType)
{
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.Contains:
query = query.Where(x => x.phone.Contains(filter.Value));
break;
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.StartsWith:
query = query.Where(x => x.phone.StartsWith(filter.Value));
break;
}
break;
case nameof(Core.Db.User.name):
switch (filter.MatchType)
{
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.Contains:
query = query.Where(x => x.name.Contains(filter.Value));
break;
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.StartsWith:
query = query.Where(x => x.name.StartsWith(filter.Value));
break;
}
break;
case nameof(Core.Db.User.CommentAdmin):
switch (filter.MatchType)
{
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.Contains:
query = query.Where(x => x.CommentAdmin.Contains(filter.Value));
break;
case Universal.Pagination.PrimeUiDataTableFieldFilterMatchMode.StartsWith:
query = query.Where(x => x.CommentAdmin.StartsWith(filter.Value));
break;
}
break;
default:
throw new HandledException($"Фильтр по полю '{filter.FieldName}' не поддерживается.");
}
}
}
if (!string.IsNullOrEmpty(requestOptions.SortByFieldName))
{
switch (requestOptions.SortByFieldName)
{
case nameof(Core.Db.User.IdUser):
sorted = true;
query = requestOptions.SortByAcsending ? query.OrderBy(x => x.IdUser) : query.OrderByDescending(x => x.IdUser);
break;
case "Requisites":
sorted = true;
query = requestOptions.SortByAcsending ?
query.OrderBy(x => x.name).ThenBy(x => x.email).ThenBy(x => x.phone) :
query.OrderByDescending(x => x.name).ThenByDescending(x => x.email).ThenByDescending(x => x.phone);
break;
case nameof(Core.Db.User.email):
sorted = true;
query = requestOptions.SortByAcsending ? query.OrderBy(x => x.email) : query.OrderByDescending(x => x.email);
break;
case nameof(Core.Db.User.phone):
sorted = true;
query = requestOptions.SortByAcsending ? query.OrderBy(x => x.phone) : query.OrderByDescending(x => x.phone);
break;
case nameof(Core.Db.User.name):
sorted = true;
query = requestOptions.SortByAcsending ? query.OrderBy(x => x.name) : query.OrderByDescending(x => x.name);
break;
case nameof(Core.Db.User.State):
sorted = true;
query = requestOptions.SortByAcsending ? query.OrderBy(x => x.State) : query.OrderByDescending(x => x.State);
break;
case nameof(Core.Db.User.Superuser):
sorted = true;
query = requestOptions.SortByAcsending ? query.OrderBy(x => x.Superuser) : query.OrderByDescending(x => x.Superuser);
break;
case nameof(Core.Db.User.CommentAdmin):
sorted = true;
query = requestOptions.SortByAcsending ? query.OrderBy(x => x.CommentAdmin) : query.OrderByDescending(x => x.CommentAdmin);
break;
}
}
}
var dataAllCount = query.Count();
if (requestOptions != null)
{
if (!sorted)
{
query = query.OrderBy(x => x.IdUser);
}
if (requestOptions.FirstRow > 0)
{
query = query.Skip((int)requestOptions.FirstRow);
}
if (requestOptions.RowsLimit > 0)
{
query = query.Take((int)requestOptions.RowsLimit);
}
}
var data = query.ToList();
return(ReturnJson(true, null, new Design.Model.AdminUsersManage()
{
RequestedState = state,
DataCountAll = dataAllCount,
DataList = data
}));
}
}
}
catch (HandledException ex)
{
RegisterEventWithCode(HttpStatusCode.InternalServerError, "Ошибка при загрузке списка пользователей", null, ex);
return(ReturnJson(false, $"Ошибка при загрузке списка пользователей. {ex.Message}"));
}
catch (Exception ex)
{
RegisterEventWithCode(HttpStatusCode.InternalServerError, "Неожиданная ошибка при загрузке списка пользователей", null, ex);
return(ReturnJson(false, "Неожиданная ошибка при загрузке списка пользователей"));
}
}
