// Could just have a set of static helper methods rather than a singleton! public List <Customer> getCustomers() { List <Customer> customers = new List <Customer>(); DbConection con = DbFactory.instance(); if (con.OpenConnection()) { DbDataReader dr = con.Select("SELECT CUST_ID, cust_name, cust_address, cust_city FROM customers;"); //Read the data and store them in the list while (dr.Read()) { Customer customer = new Customer(); customer.ID = dr.GetInt32(0); customer.Name = dr.GetString(1); customer.Address = dr.GetString(2); customer.City = dr.GetString(3); // etc..... customers.Add(customer); } //close Data Reader dr.Close(); con.CloseConnection(); } return(customers); }
private void btnTest_Click(object sender, EventArgs e) { btnTest.Enabled = false; BusinessMetaLayer ml = BusinessMetaLayer.instance(); m_customers = ml.getCustomers(); m_bs.DataSource = m_customers; m_bs.ResetBindings(false); // Fill data grid DbConection con = DbFactory.instance(); con.OpenConnection(); dataSet = con.getDataSet("Select * from customers"); DataTable table = dataSet.Tables[0]; //FillInTextFields(table, 1); //set up the data grid view this.dataGridView1.DataSource = table; }
public int[] farmLogin(String txtUsername, String txtPassword) { int [] retv = new int[2]; if (con.OpenConnection()) { String sql = "SELECT employeeId, accessPrivilage FROM Employees WHERE userName = '******' AND password = '******'"; DbDataReader reader = con.Select(sql); Employee info = new Employee(); //Read the data while (reader.Read()) { info.Id = reader.GetInt32(0); info.Privilage = reader.GetString(1); } if (info.Privilage == "Yes") { retv[0] = 0; retv[1] = info.Id; } else if (info.Privilage == "No") { retv[0] = 1; retv[1] = info.Id; } else { retv[0] = 2; retv[1] = info.Id; } //close Data Reader reader.Close(); con.CloseConnection(); } return(retv); }