public List <CustomerAndPhoneNumberInformation> GetCustomersByPhone(string phone)
{
List <CustomerAndPhoneNumberInformation> customersToReturn = new List <CustomerAndPhoneNumberInformation>();
List <PhoneNumber> listPhones = Context.PhoneNumbers.Where(c => c.Phone.Contains(phone)).ToList();
List <Customer> customers = new List <Customer>();
foreach (var listPhone in listPhones)
{
var customer = Context.Customers.Where(c => c.Id == listPhone.IdCustomer).FirstOrDefault();
if (!customers.Contains(customer))
{
customers.Add(customer);
}
}
foreach (var customer in customers)
{
if (customer.IsActive)
{
var newCustomer = new CustomerAndPhoneNumberInformation();
newCustomer.Customer = customer;
newCustomer.PhoneNumberAndTypes = GetPhoneNumberAndTypes(customer.Id);
customersToReturn.Add(newCustomer);
}
}
return(customersToReturn.OrderBy(c => c.Customer.LastName + c.Customer.FirstName).ToList());
}
public List <CustomerAndPhoneNumberInformation> GetCustomersByName(string name)
{
List <CustomerAndPhoneNumberInformation> customersToReturn = new List <CustomerAndPhoneNumberInformation>();
List <Customer> customers = Context.Customers.Where(c => c.LastName.Contains(name) ||
c.FirstName.Contains(name) || (c.FirstName + " " + c.LastName).Contains(name)).ToList();
foreach (var customer in customers)
{
if (customer.IsActive)
{
var newCustomer = new CustomerAndPhoneNumberInformation();
newCustomer.Customer = customer;
newCustomer.PhoneNumberAndTypes = GetPhoneNumberAndTypes(customer.Id);
customersToReturn.Add(newCustomer);
}
}
return(customersToReturn.OrderBy(c => c.Customer.LastName + c.Customer.FirstName).ToList());
}
internal ActionResult <List <CustomerAndPhoneNumberInformation> > GetCustomersWithPhone()
{
List <CustomerAndPhoneNumberInformation> customers = new List <CustomerAndPhoneNumberInformation>();
foreach (var customer in Context.Customers)
{
if (customer.IsActive)
{
var newCustomer = new CustomerAndPhoneNumberInformation
{
Customer = customer,
PhoneNumberAndTypes = GetPhoneNumberAndTypes(customer.Id)
};
customers.Add(newCustomer);
}
}
return(customers.OrderBy(c => c.Customer.LastName + c.Customer.FirstName).ToList());
}
