private ResultModelList <Notes> List(string user_id, string args)
{
var result = new ResultModelList <Notes>();
try
{
if (args == "Hepsi")
{
result.resultItem = _dbContext.Notes.Where(x => x.User_Id == user_id).OrderByDescending(x => x.CreatedDate)
.ToList();
}
else
{
result.resultItem = _dbContext.Notes.Where(x => x.User_Id == user_id).OrderByDescending(x => x.CreatedDate)
.Take(Convert.ToInt32(args))
.ToList();
}
}
catch (Exception ex)
{
Log.Error(ex);
result.exceptionMessage = ex.Message;
}
return(result);
}
private ResultModelList <WorkDefinition> List(string user_id, string args)
{
var result = new ResultModelList <WorkDefinition>();
try
{
if (args == "Hepsi")
{
result.resultItem = _dbContext.WorkDefinition
.Include("Projects").Where(x => x.User_Id == user_id).OrderByDescending(x => x.Rank).ToList();
}
else
{
result.resultItem = _dbContext.WorkDefinition
.Include("Projects").Where(x => x.User_Id == user_id).OrderByDescending(x => x.Rank)
.Take(Convert.ToInt32(args)).ToList();
}
}
catch (Exception ex)
{
Log.Error(ex);
result.exceptionMessage = ex.Message;
}
return(result);
}
internal void ClearResultGrid()
{
ResultModelList.Clear();
WrapperModel model = WrapperModel.Instance;
model.DetectionElapsedTime = "";
}
/// <summary>
/// Parametre Listeleme
/// </summary>
private ResultModelList <ServerInfo> List(string count)
{
var result = new ResultModelList <ServerInfo>();
try
{
if (count == "Hepsi")
{
result.resultItem = _dbContext.ServerInfo
.OrderBy(x => x.key_str).ToList();
}
else
{
result.resultItem = _dbContext.ServerInfo
.OrderBy(x => x.key_str).Take(Convert.ToInt32(count))
.ToList();
}
}
catch (Exception ex)
{
Log.Error(ex);
result.exceptionMessage = ex.Message;
}
return(result);
}
public async Task <ActionResult> GetBook()
{
ResultModelList <Book> resultModel = new ResultModelList <Book>();
var allBooks = await _uof.BookRepository.GetAsync();
resultModel.Models = new List <Book>(allBooks);
return(Ok(resultModel));
}
/// <summary>
/// Menülerin Hepsini Getirme
/// Menülerin Hepsini Getirip Kaç Adet Alt Menüsü Var Gibi Veriler İşleniyor.
/// </summary>
private ResultModelList <Menu> ListMainMenu()
{
var result = new ResultModelList <Menu>();
try
{
result.resultItem = _dbContext.Menu.OrderBy(x => x.Rank).ToList();
}
catch (Exception ex)
{
Log.Error(ex);
result.exceptionMessage = ex.Message;
}
return(result);
}
private ResultModelList <RoleMenu> ListByRoleWithMenu()
{
var result = new ResultModelList <RoleMenu>();
try
{
result.resultItem = _dbContext.RoleMenu.Include("AspNetRoles").Include("Menu").OrderBy(x => x.Menu.Rank).ToList();
}
catch (Exception ex)
{
Log.Error(ex);
result.exceptionMessage = ex.Message;
}
return(result);
}
private ResultModelList <Projects> List(string user_id)
{
var result = new ResultModelList <Projects>();
try
{
result.resultItem = _dbContext.Projects.Where(x => x.User_Id == user_id).OrderBy(x => x.Name).ToList();
}
catch (Exception ex)
{
Log.Error(ex);
result.exceptionMessage = ex.Message;
}
return(result);
}
/// <summary>
/// Alt Menüleri Getirir.
/// </summary>
/// <param name="id">Ana Menü Id</param>
/// <returns></returns>
private ResultModelList <Menu> ListSubMenu(string id)
{
var result = new ResultModelList <Menu>();
try
{
result.resultItem = _dbContext.Menu.Where(x => x.Nested == id)
.OrderBy(x => x.Rank).ToList();
}
catch (Exception ex)
{
Log.Error(ex);
result.exceptionMessage = ex.Message;
}
return(result);
}
/// <summary>
/// Yetkiye Göre Kullanıcının Menülerini Getirme
/// </summary>
/// <param name="roleId">Yetki Id</param>
/// <returns></returns>
private ResultModelList <Menu> ListByRoleId(string roleId)
{
var result = new ResultModelList <Menu>();
try
{
result.resultItem = _dbContext.RoleMenu.Include("Menu")
.Where(x => x.Role_Id == roleId).Select(x => x.Menu).OrderBy(x => x.Rank)
.ToList();
}
catch (Exception ex)
{
result.exceptionMessage = ex.Message;
}
return(result);
}
private ResultModelList <WorkDefinition> ListInCompletedAll(DateTime now)
{
var result = new ResultModelList <WorkDefinition>();
try
{
result.resultItem = _dbContext.WorkDefinition.Include("Projects").Include("AspNetUsers").Where(x => x.IsCompleted == false && x.ExpireDate < now)
.ToList();
}
catch (Exception ex)
{
Log.Error(ex);
result.exceptionMessage = ex.Message;
}
return(result);
}
private ResultModelList <AspNetRoles> List()
{
var result = new ResultModelList <AspNetRoles>();
try
{
result.resultItem = _dbContext.AspNetRoles.OrderBy(x => x.Name)
.ToList();
}
catch (Exception ex)
{
Log.Error(ex);
result.exceptionMessage = ex.Message;
}
return(result);
}
private ResultModelList <SP_Action_Result> List()
{
var result = new ResultModelList <SP_Action_Result>();
try
{
result.resultItem = _dbContext.SP_Action()
.OrderBy(x => x.Email).ToList();
}
catch (Exception ex)
{
Log.Error(ex);
result.exceptionMessage = ex.Message;
}
return(result);
}
public IActionResult GetCategories()
{
var prepareList = _uof.CategoriesRepository.Get();
ResultModelList <Categories> resultModel = new ResultModelList <Categories>();
resultModel.Models = prepareList.ToList();
if (resultModel.Models != null)
{
return(Ok(resultModel));
}
else
{
resultModel.ErrorMessage = "Houve erro ao processar sua solicitação";
return(BadRequest(resultModel));
}
}
public async Task <ActionResult> GetTopBooks()
{
ResultModelList <Book> resultModel = new ResultModelList <Book>();
var allBooks = await _uof.BookRepository.GetAsync();
resultModel.Models = new List <Book>(allBooks);
if (resultModel.Models != null)
{
resultModel.SuccessMessage = "Operação concluída com sucesso";
}
else
{
resultModel.ErrorMessage = "Não encontramos nenhum livro";
}
return(Ok(resultModel));
}
/// <summary>
/// Kullanıcıları Listeler
/// </summary>
/// <param name="args">Kullanıcı Sayısı</param>
/// <returns></returns>
private ResultModelList <AspNetUsers> List(string args)
{
var result = new ResultModelList <AspNetUsers>();
try
{
if (args == "Hepsi")
{
result.resultItem = _dbContext.AspNetUsers.Include("AspNetRoles").ToList();
}
else
{
result.resultItem = _dbContext.AspNetUsers.Include("AspNetRoles").Take(Convert.ToInt32(args))
.ToList();
}
}
catch (Exception ex)
{
Log.Error(ex);
result.exceptionMessage = ex.Message;
}
return(result);
}
