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();