public ActionResult FindCustomer()
{
//List<Customer> customers = new List<Customer>();
//Customer c = new Customer();
CustomerModel customerModel = new CustomerModel();
return View(customerModel);
}
public ActionResult FindCustomer(CustomerModel c)
{
List<Customer> customers;
using (NorthwindConnection db = new NorthwindConnection())
{
if (c.Customer.CompanyName != null && c.Customer.City != null)
{
customers =
db.Customers.Where(x => x.CompanyName.Contains(c.Customer.CompanyName) && x.City == c.Customer.City).ToList();
}
else if (c.Customer.CompanyName != null)
{
customers = db.Customers.Where(x => x.CompanyName.Contains(c.Customer.CompanyName)).ToList();
}
else
{
customers = db.Customers.Where(x => x.City == c.Customer.City).ToList();
}
}
CustomerModel cm = new CustomerModel();
cm.Customers = customers;
return View(cm);
}