private void BindCustomer()
{
CustomerController controller = new CustomerController();
CustomerCollections collection = controller.GetCustomerList();
ddlCustomer.DisplayMember = "CustomerName";
ddlCustomer.ValueMember = "CustomerID";
ddlCustomer.DataSource = collection;
ddlCustomer.SelectedIndex = 0;
}
private void ddlCustomer_DropDown(object sender, EventArgs e)
{
CustomerController controller = new CustomerController();
CustomerCollections collection = controller.GetCustomerList();
ddlCustomer.DisplayMember = "CustomerName";
ddlCustomer.ValueMember = "CustomerID";
ddlCustomer.DataSource = collection;
ddlCustomer.SelectedIndex = 0;
}
public ActionResult GetAllCompanyCustomers()
{
using (var context = new DataContext())
{
try
{
base.GetLoginAccount();
IList <CollectionOption> options = CustomerCollections.GetAllCustomers(context, Customer.TYPE_COMPANY, CollectionOption.WITH_ANY);
return(Json(options));
}
catch (Exception e)
{
base.HandleException("GetAllCompanyCustomers", e);
return(null);
}
}
}
public CustomerCollections GetCustomerList()
{
CustomerCollections collection = new CustomerCollections();
IDataReader reader = DataAccess.SelectList();
Customer cust = new Customer();
cust.CustomerID = 0;
cust.CustomerName = "Select Customer";
collection.Add(cust);
while (reader.Read())
{
Customer customer = new Customer();
customer.CustomerID = Convert.ToInt32(reader["customer_id"]);
customer.CustomerName = Convert.ToString(reader["customer_name"]);
customer.CustomerPhone = Convert.ToString(reader["customer_phone"]);
customer.CustomerAddress = Convert.ToString(reader["customer_address"]);
collection.Add(customer);
}
return(collection);
}
