public JArray Search([FromBody] ApplicationUserSearch data)
{
Dictionary <string, object> commandParams = new Dictionary <string, object>();
commandParams.Add("@p_SortColumn", data.SortColumn);
commandParams.Add("@p_SortOrder", data.SortOrder);
commandParams.Add("@p_PageSize", data.PageSize);
commandParams.Add("@p_PageStart", data.PageStart);
if (data.ApplicationRoleID.HasValue)
{
commandParams.Add("@p_ApplicationRoleID", data.ApplicationRoleID);
}
if (data.ApplicationUserID.HasValue)
{
commandParams.Add("@p_ApplicationUserID", data.ApplicationUserID);
}
commandParams.Add("@p_LoginName", data.LoginName);
DynamicList lst = DynamicList.GetData("[dbo].[spCFM_ApplicationUser_SelectForGrid]", commandParams);
if (lst.Count > 0)
{
var data1 = (JArray)lst[0].GetValue("Data");
return(data1);
}
return(null);
}
private async void btnPrikazi_Click(object sender, EventArgs e)
{
//pozivamo api
//var result = await "https://localhost:44377/api/ApplicationUser".GetJsonAsync<List<Models.ApplicationUser.ApplicationUser>>();
var search = new ApplicationUserSearch()
{
Ime = txtPretraga.Text
};
var result = await _apiService.Get <List <Models.ApplicationUser.ApplicationUser> >(search);
// dgvKorisnici.AutoGenerateColumns = false;//da ne generise samo sve nego samo sto je tamo stavljeno u grid
dgvKorisnici.DataSource = result;
}
List <Models.ApplicationUser.ApplicationUser> IApplicationUser.Get(ApplicationUserSearch search)
{
//var list = _ctx.ApplicationUser
// .Include(a => a.Opcina)
// .ToList();
var querry = _ctx.ApplicationUser.Include(a => a.Opcina).AsQueryable();
if (!string.IsNullOrWhiteSpace(search?.Ime))
{
querry = querry.Where(x => x.Ime.StartsWith(search.Ime));
}
if (!string.IsNullOrWhiteSpace(search?.Prezime))
{
querry = querry.Where(x => x.Prezime.StartsWith(search.Prezime));
}
var list = querry.ToList();
return(_mapper.Map <List <Models.ApplicationUser.ApplicationUser> >(list));
}
public IEnumerable <GetApplicationUserDto> Execute(ApplicationUserSearch request)
{
var query = context.ApplicaitonUsers.AsQueryable();
if (request.FirstNameKeyword != null)
{
query = query
.Where(x =>
x.FirstName.ToLower().Contains(request.FirstNameKeyword.ToLower()));
}
if (request.LastNameKeyword != null)
{
query = query
.Where(x =>
x.LastName.ToLower().Contains(request.LastNameKeyword.ToLower()));
}
if (request.EmailKeyword != null)
{
query = query
.Where(x =>
x.Email.ToLower().Contains(request.EmailKeyword.ToLower()));
}
if (request.RoleId != null)
{
query = query.Where(x => x.RoleId == request.RoleId);
}
if (request.OnlyActive.HasValue)
{
if (request.OnlyActive == true)
{
query = query.Where(x => x.DeletedAt == null);
}
}
query = query.SkipItems(request.Page, request.ItemsPerPage);
return(query.Select(x => _mapper.Map <ApplicationUser, GetApplicationUserDto>(x)).ToList());
}
public override async Task <Tuple <List <Model.Response.ApplicationUser>, int> > GetByParametersAsync(ApplicationUserSearch search, string order, string nameOfColumnOrder, int start, int length)
{
var query = context.Users.AsQueryable();
if (!string.IsNullOrWhiteSpace(search.Username))
{
query = query.Where(x => x.UserName.Contains(search.Username));
}
if (!string.IsNullOrWhiteSpace(search.Email))
{
query = query.Where(x => x.Email.Contains(search.Email));
}
if (search.Active != null)
{
query = query.Where(x => x.Active == search.Active);
}
if (nameOfColumnOrder == nameof(Database.ApplicationUser.UserName))
{
query = query.OrderByAscDesc(x => x.UserName, order);
}
else if (nameOfColumnOrder == nameof(Database.ApplicationUser.Email))
{
query = query.OrderByAscDesc(x => x.Email, order);
}
else if (nameOfColumnOrder == nameof(Database.ApplicationUser.PhoneNumber))
{
query = query.OrderByAscDesc(x => x.PhoneNumber, order);
}
return(new Tuple <List <Model.Response.ApplicationUser>, int>(mapper.Map <List <Model.Response.ApplicationUser> >(await query.Skip(start).Take(length).ToListAsync()), await query.CountAsync()));
}
public ActionResult <List <Models.ApplicationUser.ApplicationUser> > Get([FromQuery] ApplicationUserSearch search)
{
return(_service.Get(search));
}
public IActionResult Get([FromQuery] ApplicationUserSearch search, [FromServices] IGetApplicationUsersQuery query)
{
IEnumerable <GetApplicationUserDto> applicationUsers = _useCaseExecutor.ExecuteQuery(query, search);
return(Ok(applicationUsers));
}