public void SearchCustomer_Success()
{
var c1 = Add_New_Customer_With_DI(Country.GreekCountryCode);
Assert.NotNull(c1);
var c2 = Add_New_Customer_With_DI(Country.CyprusCountryCode);
Assert.NotNull(c2);
var c3 = Add_New_Customer_With_DI(Country.ItalyCountryCode);
Assert.NotNull(c3);
var options = new SearchCustomerOptions()
{
CountryCodes = { Country.GreekCountryCode, Country.CyprusCountryCode }
};
var customersFound = _customer
.Search(options)
.SingleOrDefault();
Assert.NotNull(customersFound);
}
public void CreateCustomer_Success()
{
ICustomerService customerService =
new CustomerService(context_);
var optionsCreate = new CreateCustomerOptions()
{
Email = "*****@*****.**",
FirstName = "Dimitris",
VatNumber = 1234567889
};
var customer = customerService.Create(optionsCreate);
var optionsSearch = new SearchCustomerOptions()
{
Email = optionsCreate.Email,
FirstName = optionsCreate.FirstName,
VatNumber = optionsCreate.VatNumber
};
var customers = customerService.Search(optionsSearch);
Assert.NotNull(customer);
Assert.Equal(optionsSearch.Email, customer.Email);
Assert.Equal(optionsSearch.VatNumber, customer.VatNumber);
Assert.Equal(optionsSearch.FirstName, customer.FirstName);
}
public IQueryable <Customer> SearchCustomers(SearchCustomerOptions options)
{
if (options == null)
{
return(null);
}
var query = context_
.Set <Customer>()
.AsQueryable();
if (!string.IsNullOrWhiteSpace(options.Firstname))
{
query = query.Where(c => c.Firstname == options.Firstname);
}
if (!string.IsNullOrWhiteSpace(options.VatNumber))
{
query = query.Where(c => c.VatNumber == options.VatNumber);
}
if (options.CustomerId != null)
{
query = query.Where(c => c.CustomerId == options.CustomerId.Value);
}
if (options.CreateFrom != null)
{
query = query.Where(c => c.Created >= options.CreateFrom);
}
query = query.Take(500);
return(query);
}
public void SearchCountry_Success()
{
var customer1 = RegisterCustomer_Success(Constants.Country.GreekCountryCode);
Assert.NotNull(customer1);
var customer2 = RegisterCustomer_Success(Constants.Country.CyprusCountryCode);
Assert.NotNull(customer2);
var options = new SearchCustomerOptions()
{
CountryCodes = { Constants.Country.GreekCountryCode, Constants.Country.CyprusCountryCode }
};
var result = _customers.Search(options).ToList();
Assert.NotNull(result);
var res1 = result.Where(r => r.CustomerId == customer1.CustomerId)
.SingleOrDefault();
var res2 = result.Where(r => r.CustomerId == customer2.CustomerId)
.SingleOrDefault();
Assert.NotNull(res1);
Assert.NotNull(res2);
}
/// <summary>
/// Search for a customer according the options
/// </summary>
/// <param name="options"></param>
/// <returns></returns>
public IQueryable <Customer> SearchCustomer(SearchCustomerOptions options)
{
if (options == null)
{
return(null);
}
var query = context_
.Set <Customer>()
.AsQueryable();
if (!string.IsNullOrWhiteSpace(options.Email))
{
query = query.Where(c =>
c.Email == options.Email);
}
if (!string.IsNullOrWhiteSpace(options.VatNumber))
{
query = query.Where(c =>
c.VatNumber == options.VatNumber);
}
if (options.Id != null)
{
query = query.Where(c =>
c.Id == options.Id);
}
return(query.Take(500));
}
public IActionResult Search(SearchCustomerOptions options)
{
var result = customerService_
.SearchCustomers(options)
.ToList();
return(Json(result));
}
public List <Customer> SearchCustomer(SearchCustomerOptions option)
{
var activeCustomerList = new List <Customer>(CustomerList);
activeCustomerList = activeCustomerList
.Where(c => c.Status == true).ToList();
if (option == null)
{
return(null);
}
if (!string.IsNullOrWhiteSpace(option.Id))
{
activeCustomerList = activeCustomerList
.Where(c => c.CustomerId.Equals(option.Id))
.ToList();
}
if (!string.IsNullOrWhiteSpace(option.Phone))
{
activeCustomerList = activeCustomerList
.Where(c => c.Phone.Equals(option.Phone))
.ToList();
}
if (!string.IsNullOrWhiteSpace(option.Email))
{
activeCustomerList = activeCustomerList
.Where(c => c.Email.Equals(option.Email))
.ToList();
}
if (!string.IsNullOrWhiteSpace(option.LastName))
{
activeCustomerList = activeCustomerList
.Where(c => c.LastName.Equals(option.LastName))
.ToList();
}
if (!string.IsNullOrWhiteSpace(option.VatNumber))
{
activeCustomerList = activeCustomerList
.Where(c => c.VatNumber.Equals(option.VatNumber))
.ToList();
}
if (option.DateCreated != null)
{
activeCustomerList = activeCustomerList
.Where(c => c.DateCreated == option.DateCreated)
.ToList();
}
return(activeCustomerList);
}
public IQueryable <Customer> SearchCustomers(
SearchCustomerOptions options)
{
if (options == null)
{
return(null);
}
var query = context_
.Set <Customer>()
.AsQueryable();
if (!string.IsNullOrWhiteSpace(options.FirstName))
{
query = query.Where(c => c.FirstName.Contains(options.FirstName));
}
if (!string.IsNullOrWhiteSpace(options.LastName))
{
query = query.Where(c => c.LastName.Contains(options.LastName));
}
if (!string.IsNullOrWhiteSpace(options.Email))
{
query = query.Where(c => c.LastName.Contains(options.Email));
}
if (!string.IsNullOrWhiteSpace(options.VatNumber))
{
query = query.Where(c => c.VatNumber.Contains(options.VatNumber));
}
if (!string.IsNullOrWhiteSpace(options.Phone))
{
query = query.Where(c => c.Phone.Contains(options.Phone));
}
if (options.CustomerId != null)
{
query = query.Where(c => c.CustomerId == options.CustomerId);
}
if (options.CreateFrom != null)
{
query = query.Where(c => c.Created >= options.CreateFrom);
}
if (options.CreatedTo != null)
{
query = query.Where(c => c.Created <= options.CreatedTo);
}
query = query.Take(500);
return(query);
}
public List <Customer> SearchById(SearchCustomerOptions options)
{
if (options == null)
{
return(null);
}
var result = Search(options);
return(result.ToList());
}
public IQueryable <Customer> Search(SearchCustomerOptions options)
{
if (options == null)
{
throw new ArgumentNullException(nameof(options));
}
// SELECT FROM CUSTOMER
var q = _dbContext.Set <Customer>()
.AsQueryable();
// SELECT FROM CUSTOMER WHERE CustomerId = options.CustomerId
if (options.CustomerId != null)
{
q = q.Where(c => c.CustomerId == options.CustomerId);
}
// SELECT FROM CUSTOMER WHERE CustomerId = options.CustomerId
// AND VatNumber = options.VatNumber
if (!string.IsNullOrWhiteSpace(options.VatNumber))
{
q = q.Where(c => c.VatNumber == options.VatNumber);
}
if (!string.IsNullOrWhiteSpace(options.Firstname))
{
q = q.Where(c => c.Firstname == options.Firstname);
}
if (!string.IsNullOrWhiteSpace(options.Lastname))
{
q = q.Where(c => c.Lastname == options.Lastname);
}
if (options.CountryCodes.Any())
{
q = q.Where(c => options.CountryCodes.Contains(
c.CountryCode));
}
if (options.TrackResults != null &&
!options.TrackResults.Value)
{
q = q.AsNoTracking();
}
if (options.Skip != null)
{
q = q.Skip(options.Skip.Value);
}
q = q.Take(options.MaxResults ?? 500);
return(q);
}
public List <Customer> SearchCustomers(SearchCustomerOptions options)
{
var filteredList = new List <Customer>(CustomerList);
filteredList = filteredList
.Where(c => c.Status == true).ToList();
if (!string.IsNullOrWhiteSpace(options.VatNumber))
{
filteredList = filteredList
.Where(c => c.VatNumber.Equals(options.VatNumber)).ToList();
}
if (!string.IsNullOrWhiteSpace(options.Email))
{
filteredList = filteredList
.Where(c => c.Email.Equals(options.Email)).ToList();
}
if (options.DateTime != null)
{
filteredList = filteredList
.Where(c => c.DateTime.Equals(options.DateTime)).ToList();
}
if (!string.IsNullOrWhiteSpace(options.Phone))
{
filteredList = filteredList
.Where(c => c.Phone.Equals(options.Phone)).ToList();
}
if (!string.IsNullOrWhiteSpace(options.Lastname))
{
filteredList = filteredList
.Where(c => c.Lastname.Equals(options.Lastname)).ToList();
}
if (!string.IsNullOrWhiteSpace(options.Firstname))
{
filteredList = filteredList
.Where(c => c.Firstname.Equals(options.Firstname)).ToList();
}
if (options.Id != null)
{
filteredList = filteredList.Where(c => c.Id == options.Id).ToList();
}
if (options.Status != null)
{
filteredList = filteredList.Where(c => c.Status == options.Status).ToList();
}
return(filteredList);
}
public IActionResult Delete([FromBody] SearchCustomerOptions options)
{
var customerDelete = customerService_.SearchCustomers(options);
if (customerDelete == null)
{
return(BadRequest());
}
customerDelete.Where(c => c.CustomerId == options.CustomerId);
return(Json(customerDelete));
}
public IActionResult Search(SearchCustomerOptions options)
{
if (options == null)
{
return(BadRequest());
}
var query = dbContext_
.Set <Customer>()
.AsQueryable();
if (!string.IsNullOrWhiteSpace(options.Firstname))
{
query = query.Where(c => c.Firstname == options.Firstname);
}
if (!string.IsNullOrWhiteSpace(options.Lastname))
{
query = query.Where(c => c.Lastname == options.Lastname);
}
if (!string.IsNullOrWhiteSpace(options.VatNumber))
{
query = query.Where(c => c.VatNumber == options.VatNumber);
}
if (!string.IsNullOrWhiteSpace(options.Email))
{
query = query.Where(c => c.Email == options.Email);
}
if (options.CustomerId != null)
{
query = query.Where(c => c.CustomerId == options.CustomerId.Value);
}
if (options.CreateFrom != null)
{
query = query.Where(c => c.Created >= options.CreateFrom);
}
if (options.CreateTo != null)
{
query = query.Where(c => c.Created <= options.CreateTo);
}
if (query == null)
{
return(NotFound());
}
return(Json(query.ToList()));
}
public ApiResult <IQueryable <Customer> > getCustomerby(
[FromQuery] int id, [FromQuery] string vat,
[FromQuery] string email, [FromQuery] string name)
{
SearchCustomerOptions options = new SearchCustomerOptions
{
Email = email,
FirstName = name,
VatNumber = vat,
Id = id
};
return(custService.Search(options));
}
public ApiResult <IQueryable <Customer> > Search(
SearchCustomerOptions options)
{
if (options == null)
{
return(ApiResult <IQueryable <Customer> > .CreateUnsuccessful
(StatusCode.BadRequest, "null options"));
}
if (string.IsNullOrWhiteSpace(options.Email) &&
(options.Id == null || options.Id == 0) &&
string.IsNullOrWhiteSpace(options.VatNumber) &&
string.IsNullOrWhiteSpace(options.FirstName)
)
{
return(ApiResult <IQueryable <Customer> > .CreateUnsuccessful
(StatusCode.BadRequest, "null options"));
}
var query = context
.Set <Customer>()
.AsQueryable();
if (options.Id != null && options.Id != 0)
{
query = query.Where(
c => c.Id == options.Id);
}
if (options.VatNumber != null)
{
query = query.Where(
c => c.VatNumber == options.VatNumber);
}
if (options.Email != null)
{
query = query.Where(
c => c.Email.Equals(options.Email));
}
if (!string.IsNullOrWhiteSpace(options.FirstName))
{
query = query
.Where(c => c.FirstName.Contains(options.FirstName));
}
return(ApiResult <IQueryable <Customer> > .CreateSuccessful(query));
}
public void SearchVat_Success()
{
var customer = RegisterCustomer_Success(Constants.Country.GreekCountryCode);
Assert.NotNull(customer);
var options = new SearchCustomerOptions()
{
VatNumber = customer.VatNumber
};
var result = _customers.Search(options).SingleOrDefault();
Assert.NotNull(result);
}
/// <summary>
/// Return the Customer with id id
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Customer GetCustomerById(int?id)
{
if (id == null)
{
return(null);
}
var options = new SearchCustomerOptions()
{
Id = id
};
return(SearchCustomer(options)
.SingleOrDefault());
}
public IQueryable <Customer> SearchCustomers(SearchCustomerOptions options)
{
if (options == null)
{
return(null);
}
var query = context_
.Set <Customer>()
.AsQueryable();
if (options.CustomerId != null)
{
query = query.Where(x => x.CustomerId == options.CustomerId);
}
if (!string.IsNullOrWhiteSpace(options.FirstName))
{
query = query.Where(x => x.FirstName == options.FirstName);
}
if (!string.IsNullOrWhiteSpace(options.LastName))
{
query = query.Where(x => x.LastName == options.LastName);
}
if (!string.IsNullOrWhiteSpace(options.VatNumber))
{
query = query.Where(x => x.VatNumber == options.VatNumber);
}
if (options.CreatedFrom != null)
{
query = query.Where(x => x.Created >= options.CreatedFrom);
}
if (options.CreatedTo != null)
{
query = query.Where(x => x.Created <= options.CreatedTo);
}
if (options.IsActive != null)
{
query = query.Where(x => x.IsActive == options.IsActive);
}
return(query);
}
public IActionResult Index(SearchCustomerOptions options)
{
options = options ?? new SearchCustomerOptions();
options.MaxResults = 100;
var customers = _customers.Search(options)
.OrderByDescending(c => c.AuditInfo.Created)
.ToList();
return(View(
new SearchCustomersViewModel()
{
Customers = customers,
SearchOptions = options
}));
}
public IActionResult SearchCustomers([FromBody] SearchCustomerOptions options)
{
if (options == null)
{
return(BadRequest());
}
var customerList = customerService_
.SearchCustomers(options)
.ToList();
if (customerList == null)
{
return(NotFound());
}
return(Json(customerList));
}
public ICollection <Model.Customer> SearchCustomer(SearchCustomerOptions options)
{
if (options != null)
{
Console.WriteLine(" selecte option");
Console.WriteLine("1: search by vatnumber");
Console.WriteLine("2: search by email");
Console.WriteLine("3: search by ");
Console.WriteLine("4: search by email");
int choice = Convert.ToInt32(Console.ReadLine());
if (choice == 1)
{
var searchcustomer = context.Set <Customer>()
.Where(s => s.VatNumber == options.VatNumber)
.ToList();
return(searchcustomer);
}
else if (choice == 2)
{
var searchcustomer = context.Set <Customer>()
.Where(s => s.Email == options.Email)
.ToList();
return(searchcustomer);
}
else if (choice == 3)
{
var searchcustomer = context.Set <Customer>()
.Where(s => s.Created == options.CreatedFrom)
.ToList();
return(searchcustomer);
}
else if (choice == 4)
{
var searchcustomer = context.Set <Customer>()
.Where(s => s.Created == options.CreatedFrom)
.ToList();
return(searchcustomer);
}
}
return(null);
}
public List <Customer> Search(SearchCustomerOptions options)
{
if (options == null)
{
return(null);
}
var query = context
.Set <Customer>()
.AsQueryable();
if (options.Id != null)
{
query = query.Where(
c => c.Id == options.Id);
}
if (options.VatNumber != 0)
{
query = query.Where(
c => c.VatNumber == options.VatNumber);
}
if (options.Email != null)
{
query = query.Where(
c => c.Email == options.Email);
}
if (options.LastName != null)
{
query = query.Where(c => c.LastName.Contains(options.LastName));
}
if (options.FirstName != null)
{
query = query.Where(c => c.FirstName.Contains(options.FirstName));
}
return(query.ToList());
}
/// <summary>
/// Searches for a customer given a set of search options
/// </summary>
/// <param name="options">Search option</param>
/// <returns>
/// A customer object of IQueryable type
/// </returns>
/// <exception cref="ArgumentNullException">
/// Occurs when no search options are passed
/// </exception>
public IQueryable <Customer> Search(SearchCustomerOptions options)
{
if (options == null)
{
throw new ArgumentNullException(nameof(options));
}
var q = _dbContext.Set <Customer>()
.AsNoTracking()
.AsQueryable();
if (options.CustomerId != null)
{
q = q.Where(c => c.CustomerId == options.CustomerId);
}
if (!string.IsNullOrWhiteSpace(options.VAtNumber))
{
q = q.Where(c => c.VatNumber == options.VAtNumber);
}
if (!string.IsNullOrWhiteSpace(options.CustBankId))
{
q = q.Where(c => c.CustBankID == options.CustBankId);
}
if (options.CountryCodes.Any())
{
q = q.Where(c => options.CountryCodes.Contains(c.CountryCode));
}
if (options.Skip != null)
{
q = q.Skip(options.Skip.Value);
}
q = q.Take(options.MaxResults ?? 500);
return(q);
}
public SearchCustomersViewModel()
{
Customers = new List <Customer>();
SearchOptions = new SearchCustomerOptions();
}
public ApiResult <IQueryable <Customer> > getCustomerby2(
[FromBody] SearchCustomerOptions options)
{
return(custService.Search(options));
}
