public ActionResult Customers()
{
CustomerDb dbCustomer = new CustomerDb();
ModelState.Clear();
return(View(dbCustomer.GetCustomers()));
}
public static IEnumerable <Customer> GetCustomers(string id = "%", string name = "", string contactInfo = "",
string nic = "", string dues = "")
{
var dataReader = CustomerDb.GetCustomers(id, name, nic, contactInfo, dues).CreateDataReader();
while (dataReader.Read())
{
yield return(new Customer(
int.Parse(dataReader["Customer_ID"].ToString()),
dataReader["Name"].ToString(),
dataReader["ContactInfo"].ToString(),
dataReader["Nic"].ToString(),
decimal.Parse(dataReader["Dues"].ToString())
));
}
}
public void Fill() => customers = CustomerDb.GetCustomers();
