public JsonResult Log4NetLogLog4NetLogListQuery(DataTablesModel.DataTableAjaxPostModel model, string date)
{
try
{
var data = Log4NetLogService.GetAllForDatatables(model, date);
return(Json(data));
}
catch (Exception e)
{
Logger.Error("Error Occured! - " + new StackTrace().GetFrame(0).GetMethod().Name, e);
return(Json(""));
}
}
public JsonResult UserListQuery(DataTablesModel.DataTableAjaxPostModel model)
{
try
{
var data = UserService.GetAllForDatatables(model);
return(Json(data));
}
catch (Exception e)
{
Logger.Error("Hata oluştu - " + new StackTrace().GetFrame(0).GetMethod().Name, e);
return(Json(""));
}
}
public JsonResult StudentListQuery(DataTablesModel.DataTableAjaxPostModel model)
{
try
{
var data = _studentService.GetAllForDatatables(model);
if (data.IsSucceeded)
{
return(Json(data.Result));
}
return(Json(data.ErrorMessage));
}
catch (Exception e)
{
return(Json(""));
}
}
public DataTablesModel.DataTableReturnModel GetAllForDatatables(DataTablesModel.DataTableAjaxPostModel model, string date)
{
var searchBy = model.search?.value;
var take = model.length;
var skip = model.start;
var sortBy = "Id";
var sortDir = "asc";
if (model.order != null)
{
sortBy = model.columns[model.order[0].column].data;
sortDir = model.order[0].dir.ToLower();
}
var data = GetAll().Where(r => !r.IsDeleted && (string.IsNullOrEmpty(date) || r.CreationDate.ToString("dd.MM.yyyy") == date)).Select(x => new
{
IsActive = x.IsActive,
Id = x.Id,
CreationDate = x.CreationDate,
Message = x.Message
});
var totalResultsCount = data.Count();
var filteredResultsCount = data.Count();
if (!string.IsNullOrEmpty(searchBy))
{
data = data.Where(r => r.CreationDate.ToString().Contains(searchBy) || r.Message.ToLower().ToString().Contains(searchBy.ToLower()));
filteredResultsCount = data.Count();
}
data = data.OrderBy($"{sortBy} {sortDir}").Skip(skip).Take(take);
return(new DataTablesModel.DataTableReturnModel
{
draw = model.draw,
recordsTotal = totalResultsCount,
recordsFiltered = filteredResultsCount,
data = data.ToList()
});
}
public DataTablesModel.DataTableReturnModel GetAllForDatatables(DataTablesModel.DataTableAjaxPostModel model)
{
var searchBy = model.search?.value;
var take = model.length;
var skip = model.start;
var sortBy = "Id";
var sortDir = "asc";
if (model.order != null)
{
sortBy = model.columns[model.order[0].column].data;
sortDir = model.order[0].dir.ToLower();
}
var data = UserRepository.GetAll().Where(r => r.IsActive && r.IsTestUser == false && !r.IsDeleted).Select(x => new
{
Id = x.Id,
FullName = x.FullName,
Email = x.Email,
CreationDate = x.CreationDate,
AuthorizationCount = x.UserRoles.Count(r => r.RoleId != null && !r.IsDeleted),
ModuleCount = x.UserRoles.Count(r => r.ModuleId != null && !r.IsDeleted)
});
var totalResultsCount = data.Count();
var filteredResultsCount = data.Count();
if (!string.IsNullOrEmpty(searchBy))
{
data = data.Where(r => r.FullName.Contains(searchBy));
filteredResultsCount = data.Count();
}
data = data.OrderBy($"{sortBy} {sortDir}").Skip(skip).Take(take);
return(new DataTablesModel.DataTableReturnModel
{
draw = model.draw,
recordsTotal = totalResultsCount,
recordsFiltered = filteredResultsCount,
data = data.ToList()
});
}
public ServiceResponse <DataTablesModel.DataTableReturnModel> GetAllForDatatables(DataTablesModel.DataTableAjaxPostModel model)
{
var searchBy = model.search?.value;
var take = model.length;
var skip = model.start;
var sortBy = "Id";
var sortDir = "desc";
if (model.order != null)
{
sortBy = model.columns[model.order[0].column].data;
sortDir = model.order[0].dir.ToLower();
}
var response = new ServiceResponse <DataTablesModel.DataTableReturnModel>();
var repoResponse = AnswerRepository.AllListQueryable(r => !r.IsDelete).Select(x => new
{
Id = x.Id,
IsActive = x.IsActive,
Responce = x.Responce
});
var totalResultsCount = repoResponse.Count();
var filteredResultsCount = repoResponse.Count();
if (!string.IsNullOrEmpty(searchBy))
{
repoResponse = repoResponse.Where(r => r.Responce.Contains(searchBy));
filteredResultsCount = repoResponse.Count();
}
repoResponse = repoResponse.OrderBy($"{sortBy} {sortDir}").Skip(skip).Take(take);
if (repoResponse != null)
{
response.Result = new DataTablesModel.DataTableReturnModel
{
draw = model.draw,
recordsTotal = totalResultsCount,
recordsFiltered = filteredResultsCount,
data = repoResponse.ToList()
};
}
else
{
response.SetError("Kayıt bulunamadı");
}
return(response);
}
