public IActionResult Get([FromQuery] CustomerParameters customerParameters) { try { var customers = _service.GetAllCustomers(customerParameters); var metadata = new { customers.TotalCount, customers.PageSize, customers.CurrentPage, customers.TotalPages, customers.HasNext, customers.HasPrevious }; if (Response != null) { Response.Headers.Add("X-Pagination", JsonConvert.SerializeObject(metadata)); } return(customers.Count() > 0 ? (IActionResult)Ok(customers) : (IActionResult)NotFound()); } catch (Exception e) { _logger.LogError(e, "Exception on Get All"); return(StatusCode(StatusCodes.Status500InternalServerError)); } }
public async Task <IActionResult> GetAllCustomers([FromQuery] CustomerParameters customerParameters) { if (!customerParameters.ValidYearRange) { return(BadRequest("Max year of signup cannot be less than min year of signup")); } var customers = await _repository.Customer.GetAllCustomersAsync(customerParameters); var metadata = new { customers.TotalCount, customers.PageSize, customers.CurrentPage, customers.TotalPages, customers.HasNext, customers.HasPrevious }; Response.Headers.Add("X-Pagination", JsonConvert.SerializeObject(metadata)); var customersResult = _mapper.Map <IEnumerable <CustomerDto> >(customers); return(Ok(customersResult)); }
public ActionResult Get(CustomerParameters parameters) { int rc; Customer[] customers = Customer.GetAutoCustomers(parameters, out rc); // ViewBag.customers = customers; return(Content(JsonConvert.SerializeObject(customers))); }
private void Search() { CustomerParameters pmtCustomer = new CustomerParameters(); pmtCustomer.Name = "%" + this.frmCustomer.txtSchName.Text + "%"; DataTable dtCustomers = srvCustomer.SearchByParameters(pmtCustomer); this.frmCustomer.grdSchSearch.DataSource = null; this.frmCustomer.grdSchSearch.DataSource = dtCustomers; }
public override void Search() { CustomerParameters pmtCustomer = new CustomerParameters(); pmtCustomer.Name = "%" + this.frmCustomer.txtSchName.Text + "%"; pmtCustomer.ComercialName = "%" + this.frmCustomer.txtSchComercialName.Text + "%"; DataTable dtCustomers = srvCustomer.SearchByParameters(pmtCustomer); this.frmCustomer.grdPrincipal.DataSource = null; this.frmCustomer.grdPrincipal.DataSource = dtCustomers; }
public async Task <PagedList <Customer> > GetAllCustomersAsync(CustomerParameters customerParameters) { var customers = FindAll(); SearchBySignupDate(ref customers, customerParameters.MinSignupDate, customerParameters.MaxSignupDate); SearchByName(ref customers, customerParameters.name); SearchByLastName(ref customers, customerParameters.lastName); SearchByEmail(ref customers, customerParameters.email); SearchByArchive(ref customers, customerParameters.archive); return(await PagedList <Customer> .ToPagedList(customers, customerParameters.PageNumber, customerParameters.PageSize)); }
//http://localhost:5000/api/customers?email=k public async Task <ActionResult <List <CustomerDto> > > GetCustomers([FromQuery] CustomerParameters customerParameters) { _orm.OpenConn(); var customersFromDB = await _orm.GetAllCustomers(customerParameters); if (customersFromDB == null) { return(NotFound()); } var customersDto = _mapper.Map <List <CustomerDto> >(customersFromDB); await _orm.CloseConn(); return(Ok(customersDto)); }
public PagedList <Customer> GetAllCustomers(CustomerParameters customerParameters) { try { Db.Connection.Open(); using var cmd = Db.Connection.CreateCommand(); cmd.CommandText = @"SELECT `id`, `first_name`, `last_name`, `date_created`, `date_last_updated` FROM `customers`"; var result = ReadAll(cmd.ExecuteReader()); return(PagedList <Customer> .ToPagedList(result.AsQueryable().OrderBy(on => on.Id), customerParameters.PageNumber, customerParameters.PageSize)); } catch (Exception e) { throw e; } finally { Db.Connection.Close(); } }
public async Task <List <Customer> > GetAllCustomers([FromQuery] CustomerParameters parameters) { IQueryable <Customer> customers = _context.Customers; if (!string.IsNullOrEmpty(parameters.Country)) { customers = customers.Where( c => c.Country == parameters.Country); } if (!string.IsNullOrEmpty(parameters.CompanyName)) { customers = customers.Where( c => c.CompanyName.ToLower().Contains(parameters.CompanyName.ToLower())); } if (!string.IsNullOrEmpty(parameters.SortBy)) { if (typeof(Customer).GetProperty(parameters.SortBy) != null) { customers = customers.OrderByCustom(parameters.SortBy, parameters.SortOrder); } } // Page should not exceed count divided by page; // otherwise, set page to max possible pages if ((parameters.Page > 0) && (parameters.Size > 0)) { if (customers.Count() % parameters.Size < parameters.Page) { parameters.Page = (customers.Count() % parameters.Size) + 1; } customers = customers .Skip(parameters.Size * (parameters.Page - 1)) .Take(parameters.Size); } return(await customers.ToListAsync()); }
public static Customer[] GetCustomers(CustomerParameters parameters, out int rowsCount) { List <Customer> l = new List <Customer>(); using (SqlCommand cmd = new SqlCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = new SqlConnection(cstr.con); cmd.Connection.Open(); cmd.CommandText = "GetCustomers"; /*cmd.Parameters.AddWithValue("status", parameters.Status); * cmd.Parameters.AddWithValue("page", parameters.CurrentPage); * cmd.Parameters.AddWithValue("pageLength", parameters.PageLength); * SqlParameter rowsCountParam = cmd.Parameters.Add("rowsCount", SqlDbType.Int); * rowsCountParam.Direction = ParameterDirection.InputOutput;*/ SqlDataReader r = cmd.ExecuteReader(); if (r.HasRows) { while (r.Read()) { Customer c = new Customer(); if (r["id"] != DBNull.Value) { c.Id = Convert.ToInt32(r["id"]); } if (r["username"] != DBNull.Value) { c.Username = Convert.ToString(r["username"]); } if (r["meter_id"] != DBNull.Value) { c.MeterId = Convert.ToInt32(r["meter_id"]); } if (r["card_id"] != DBNull.Value) { c.CardId = Convert.ToInt32(r["card_id"]); } if (r["telephone"] != DBNull.Value) { c.Telephone = Convert.ToString(r["telephone"]); } if (r["country_id"] != DBNull.Value) { c.CountryId = Convert.ToInt32(r["country_id"]); } if (r["city_id"] != DBNull.Value) { c.CityId = Convert.ToInt32(r["city_id"]); } if (r["area"] != DBNull.Value) { c.Area = Convert.ToString(r["area"]); } if (r["street"] != DBNull.Value) { c.Street = Convert.ToString(r["street"]); } if (r["password"] != DBNull.Value) { c.Password = Convert.ToString(r["password"]); } l.Add(c); } } r.Close(); cmd.Connection.Close(); //rowsCount = Convert.ToInt32(rowsCountParam.Value); rowsCount = l.Count; } return(l.ToArray()); }
public PagedList <Customer> GetAllCustomers(CustomerParameters customerParameters) { return(PagedList <Customer> .ToPagedList(_customers.AsQueryable().OrderBy(on => on.Id), customerParameters.PageNumber, customerParameters.PageSize)); }
public async Task <IActionResult> GetAllCustomers([FromQuery] CustomerParameters parameters) { var customers = await _customerRepository.GetAllCustomers(parameters); return(Ok(customers)); }